Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25300 | 25300 | 117795 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3755 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5983918.45231 | 2111030.33934 | 37.7755555482917 | -122.499147602329 | (37.7755555482917, -122.499147602329) | |||
| 25357 | 25357 | 245500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 290 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010408.82405 | 2099965.2209400004 | 37.7466916081328 | -122.406730554867 | (37.7466916081328, -122.406730554867) | |||
| 25446 | 25446 | 122296 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1799 Cabrillo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5990085.59 | 2110638.88168 | 37.7748405619036 | -122.477785590315 | (37.7748405619036, -122.477785590315) | |||
| 25511 | 25511 | 119143 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 625 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5981300.41517 | 2111472.41115 | 37.776615419273895 | -122.508236685403 | (37.7766154192739, -122.508236685403) | |||
| 25592 | 25592 | 69488 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 425 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 20 | Permit Number 33610 | 6002125.08495 | 2093879.83517 | 37.729515582259396 | -122.434939712705 | (37.7295155822594, -122.434939712705) | |
| 25604 | 25604 | 250134 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | ||||
| 25733 | 25733 | 245683 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3678 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6003829.6930599995 | 2103071.3220900004 | 37.7548499295039 | -122.429702017943 | (37.7548499295039, -122.429702017943) | |||
| 25784 | 25784 | 182377 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1511 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985257.4301 | 2104883.1297 | 37.7587554987564 | -122.494062662548 | (37.7587554987564, -122.494062662548) | |||
| 25787 | 25787 | 189282 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 17 | : Yard 23 | Tree 1 | Private 1 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | ||||
| 25903 | 25903 | 123464 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 644 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995356.46788 | 2111146.9174599997 | 37.7765399824879 | -122.459589450648 | (37.7765399824879, -122.459589450648) | |||
| 25938 | 25938 | 249996 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 41 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011497.53106 | 2120284.14207 | 37.8025435461134 | -122.40439586268101 | (37.8025435461134, -122.404395862681) | |||
| 25988 | 25988 | 182516 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1575 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985271.1371 | 2104502.1703 | 37.7577102918866 | -122.493987182038 | (37.7577102918866, -122.493987182038) | |||
| 26058 | 26058 | 205425 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 60 Melrose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999706.93127 | 2095527.57253 | 37.7339022872494 | -122.44341779339399 | (37.7339022872494, -122.443417793394) | ||||
| 26113 | 26113 | 245518 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 71 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998295.5906 | 2106843.1359099997 | 37.7648914644932 | -122.449112105467 | (37.7648914644932, -122.449112105467) | |||
| 26143 | 26143 | 245512 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 106 Chattanooga St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004701.89686 | 2103004.13948 | 37.754714811762206 | -122.42668090920701 | (37.7547148117622, -122.426680909207) | |||
| 26166 | 26166 | 205403 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 920 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5995980.66539 | 2094683.17632 | 37.7313705751845 | -122.456239515042 | (37.7313705751845, -122.456239515042) | |||
| 26353 | 26353 | 182219 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1598 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985010.9097 | 2104360.0371 | 37.7573048039248 | -122.494876662608 | (37.7573048039248, -122.494876662608) | |||
| 26401 | 26401 | 189358 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1100 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017825.61264 | 2096067.48761 | 37.736401402503 | -122.380812873212 | (37.736401402503, -122.380812873212) | |||
| 26448 | 26448 | 245624 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 322 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006476.77935 | 2097220.02712 | 37.738933136141604 | -122.42013240038601 | (37.7389331361416, -122.420132400386) | |||
| 26606 | 26606 | 245480 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 168 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6006062.04873 | 2099258.29752 | 37.7445063913738 | -122.42171108379699 | (37.7445063913738, -122.421711083797) | |||
| 26668 | 26668 | 245605 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 635 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5999820.90849 | 2107684.64891 | 37.7672891703973 | -122.44389690184799 | (37.7672891703973, -122.443896901848) | |||
| 26775 | 26775 | 117796 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3739 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5983953.06795 | 2111029.92822 | 37.7755564500477 | -122.49902782995001 | (37.7755564500477, -122.49902782995) | |||
| 26788 | 26788 | 245731 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 82 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6001964.94974 | 2108129.58047 | 37.76863290861979 | -122.436512831101 | (37.7686329086198, -122.436512831101) | |||
| 26892 | 26892 | 205315 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 147 Judson Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999124.07118 | 2093461.08055 | 37.7281949287511 | -122.44528438218201 | (37.7281949287511, -122.445284382182) | ||||
| 27164 | 27164 | 187561 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 136 Alpha St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010941.11015 | 2088158.68343 | 37.7143031001696 | -122.40405920239401 | (37.7143031001696, -122.404059202394) | ||||
| 27256 | 27256 | 245693 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001782.04143 | 2104305.66684 | 37.758122981497294 | -122.43687171366501 | (37.7581229814973, -122.436871713665) | |||
| 27351 | 27351 | 245675 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 549 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001592.628280001 | 2101435.5909700003 | 37.750231676050895 | -122.43732127666401 | (37.7502316760509, -122.437321276664) | |||
| 27398 | 27398 | 205475 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 5999461.68909 | 2093522.86386 | 37.7283838376284 | -122.444121665807 | (37.7283838376284, -122.444121665807) | ||||
| 27512 | 27512 | 126081 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3651 Baker St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999108.91341 | 2121411.06481 | 37.8049376780854 | -122.447347650898 | (37.8049376780854, -122.447347650898) | |||
| 27539 | 27539 | 245689 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 50 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000846.651319999 | 2104372.11422 | 37.758252222176104 | -122.44011145208599 | (37.7582522221761, -122.440111452086) | |||
| 27628 | 27628 | 126112 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2501 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5999663.694080001 | 2117437.13083 | 37.794058003713005 | -122.445141900785 | (37.794058003713, -122.445141900785) | |||
| 27676 | 27676 | 205347 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2175 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991625.486740001 | 2100618.33125 | 37.7474160345426 | -122.471728402854 | (37.7474160345426, -122.471728402854) | |||
| 27959 | 27959 | 47452 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 5049 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45359 | 5982965.18721 | 2111677.50205 | 37.777276501752894 | -122.502493031756 | (37.7772765017529, -122.502493031756) | |
| 27963 | 27963 | 245573 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4185 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002743.424380001 | 2100624.8977799998 | 37.7480710575441 | -122.433283833306 | (37.7480710575441, -122.433283833306) | |||
| 28115 | 28115 | 205251 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1469 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991133.79898 | 2105423.31404 | 37.760580795391796 | -122.47377908645201 | (37.7605807953918, -122.473779086452) | |||
| 28139 | 28139 | 247240 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 921 Buena Vista Ave West | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000040.78347 | 2108630.8128400003 | 37.7698996387736 | -122.443204350999 | (37.7698996387736, -122.443204350999) | |||
| 28157 | 28157 | 181439 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1395 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981197.3238 | 2105634.1509 | 37.760579181106 | -122.50815986988 | (37.760579181106, -122.50815986988) | |||
| 28367 | 28367 | 126067 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 139 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5997532.4307 | 2115852.71345 | 37.7895857399475 | -122.452401866867 | (37.7895857399475, -122.452401866867) | |||
| 28443 | 28443 | 182222 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2840 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985405.1901 | 2104352.0968 | 37.757306074239104 | -122.49351252094999 | (37.7573060742391, -122.49351252095) | |||
| 28600 | 28600 | 245741 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 25 Temple St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5999967.936869999 | 2105824.43876 | 37.7621898821911 | -122.44325473101699 | (37.7621898821911, -122.443254731017) | |||
| 28613 | 28613 | 184182 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1618 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980983.7076 | 2104008.48 | 37.756102964650104 | -122.508777956978 | (37.7561029646501, -122.508777956978) | |||
| 29075 | 29075 | 126108 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2501 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5999653.99691 | 2117501.26675 | 37.7942335504827 | -122.445180067106 | (37.7942335504827, -122.445180067106) | |||
| 29121 | 29121 | 205270 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1224 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995838.93768 | 2107071.40007 | 37.7653774059583 | -122.45762550612301 | (37.7653774059583, -122.457625506123) | |||
| 29210 | 29210 | 183957 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2170 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989794.5815 | 2100587.2818 | 37.7472246780764 | -122.478057209982 | (37.7472246780764, -122.478057209982) | |||
| 29257 | 29257 | 92418 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1242 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52811 | 5984306.481000001 | 2106711.5777 | 37.763720214535496 | -122.49748642146099 | (37.7637202145355, -122.497486421461) |
| 29306 | 29306 | 245536 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008269.316980001 | 2099343.9975400004 | 37.7448659268119 | -122.414084835556 | (37.7448659268119, -122.414084835556) | |||
| 29308 | 29308 | 189383 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1190 Fairfax Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017772.50724 | 2096612.75637 | 37.7378956710501 | -122.381034380748 | (37.7378956710501, -122.381034380748) | |||
| 29337 | 29337 | 205252 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1489 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991141.67594 | 2105283.7326 | 37.760197998052604 | -122.473741661159 | (37.7601979980526, -122.473741661159) | |||
| 29339 | 29339 | 49418 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 413@ 19th ST Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 5 | Permit Number 46364 | 6014094.43855 | 2105154.43805 | 37.7611456110148 | -122.39434924833799 | (37.7611456110148, -122.394349248338) | ||
| 29536 | 29536 | 184083 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1600 Sunset Blvd | 84 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984945.8447 | 2104060.7868 | 37.756479336636296 | -122.49507961366301 | (37.7564793366363, -122.495079613663) | |||
| 29630 | 29630 | 245636 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008273.01473 | 2099327.11999 | 37.7448197924968 | -122.414070855604 | (37.7448197924968, -122.414070855604) | |||
| 29637 | 29637 | 247866 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 398 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6009543.35492 | 2098406.93767 | 37.7423644418716 | -122.40961330563101 | (37.7423644418716, -122.409613305631) | ||||
| 29672 | 29672 | 92402 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1535 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52802 | 5985244.0 | 2104754.6 | 37.7584018060121 | -122.494099636368 | (37.7584018060121, -122.494099636368) |
| 29731 | 29731 | 205427 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 90 Melrose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5999502.43609 | 2095532.0272 | 37.7339028547262 | -122.444125112901 | (37.7339028547262, -122.444125112901) | |||
| 29748 | 29748 | 118140 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3338 Balboa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5985150.75215 | 2111127.92338 | 37.775895698640596 | -122.494892038494 | (37.7758956986406, -122.494892038494) | |||
| 29771 | 29771 | 249766 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | Width 0ft | 6011007.58004 | 2120722.18976 | 37.80371892584 | -122.40612222558201 | (37.80371892584, -122.406122225582) | |||
| 29837 | 29837 | 35003 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3508 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2013 12:00:00 AM | 3 | Permit Number 768133 | 5984707.64332 | 2111114.1304599997 | 37.775831878815495 | -122.49642382506 | (37.7758318788155, -122.49642382506) | ||
| 29905 | 29905 | 69492 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 61 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 4 | Permit Number 33614 | 6002850.0061800005 | 2094591.87485 | 37.7315118155116 | -122.43248442771099 | (37.7315118155116, -122.432484427711) | |
| 29945 | 29945 | 205329 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996217.253769999 | 2089002.70313 | 37.715786922192294 | -122.455011281241 | (37.7157869221923, -122.455011281241) | |||
| 29991 | 29991 | 205348 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2179 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991626.2491 | 2100612.76808 | 37.7474008036235 | -122.47172536133199 | (37.7474008036235, -122.471725361332) | |||
| 30118 | 30118 | 205434 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 222 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6000590.7976 | 2094973.99964 | 37.732432670014894 | -122.440322320638 | (37.7324326700149, -122.440322320638) | |||
| 30540 | 30540 | 37494 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 30910 | 30910 | 205308 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 312 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5999357.46661 | 2094402.70977 | 37.7307937428201 | -122.444545176343 | (37.7307937428201, -122.444545176343) | ||||
| 30996 | 30996 | 247856 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 80 Bradford St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6009566.847130001 | 2098148.32022 | 37.7416556510973 | -122.409513828008 | (37.7416556510973, -122.409513828008) | ||||
| 31063 | 31063 | 118159 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3608 Balboa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5984357.50103 | 2111102.0038 | 37.7757780641017 | -122.49763414231 | (37.7757780641017, -122.49763414231) | |||
| 31115 | 31115 | 189330 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | ||||
| 31185 | 31185 | 247857 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 80 Bradford St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009575.64001 | 2098128.64759 | 37.7416021270253 | -122.409482036966 | (37.7416021270253, -122.409482036966) | ||||
| 31214 | 31214 | 205302 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 301 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5994373.92191 | 2098940.4961900003 | 37.7429677574573 | -122.46210291221901 | (37.7429677574573, -122.462102912219) | |||
| 31228 | 31228 | 183686 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1319 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984282.0441 | 2106184.7768 | 37.7622723352997 | -122.497532043867 | (37.7622723352997, -122.497532043867) | |||
| 31272 | 31272 | 246733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | |||
| 31330 | 31330 | 182475 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1566 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987172.6159 | 2104623.1628 | 37.758153578438 | -122.487420059761 | (37.758153578438, -122.487420059761) | |||
| 31346 | 31346 | 205349 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1500 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991296.39005 | 2098426.70371 | 37.741379343378796 | -122.472706614323 | (37.7413793433788, -122.472706614323) | |||
| 31486 | 31486 | 245655 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3164 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008635.322430001 | 2101576.74228 | 37.7510170971771 | -122.412977088449 | (37.7510170971771, -122.412977088449) | |||
| 31587 | 31587 | 205311 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 181 Flood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999522.68832 | 2094056.5705400002 | 37.7298527515924 | -122.44394912005801 | (37.7298527515924, -122.443949120058) | |||
| 31697 | 31697 | 126105 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2520 Baker St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5999705.22054 | 2117502.73674 | 37.794240510334 | -122.445002933957 | (37.794240510334, -122.445002933957) | |||
| 31716 | 31716 | 184418 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3717 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981908.8319 | 2100773.9171 | 37.7472762530428 | -122.505338890407 | (37.7472762530428, -122.505338890407) | |||
| 31783 | 31783 | 245510 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 483 Valley St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6002844.07949 | 2099175.98984 | 37.744098404927 | -122.43283227920901 | (37.744098404927, -122.432832279209) | ||||
| 31946 | 31946 | 126123 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2836 Larkin St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006504.36606 | 2120972.74597 | 37.8041539827815 | -122.42172367341001 | (37.8041539827815, -122.42172367341) | ||||
| 31964 | 31964 | 118151 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3450 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5984812.19796 | 2111117.65554 | 37.7758476821806 | -122.49606240946501 | (37.7758476821806, -122.496062409465) | |||
| 32072 | 32072 | 126075 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 280 Euclid Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 5997922.81564 | 2113961.32913 | 37.7844148567072 | -122.450914744323 | (37.7844148567072, -122.450914744323) | |||
| 32087 | 32087 | 205478 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 442 Circular Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5999784.33637 | 2093736.40435 | 37.7289885714569 | -122.44302159167 | (37.7289885714569, -122.44302159167) | ||||
| 32102 | 32102 | 189290 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 23 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014424.75736 | 2105899.2532900004 | 37.7632090676603 | -122.39325892915501 | (37.7632090676603, -122.393258929155) | ||||
| 32190 | 32190 | 182215 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2998 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985108.0649 | 2104343.6089 | 37.757265383354294 | -122.49453945569599 | (37.7572653833543, -122.494539455696) | |||
| 32209 | 32209 | 78576 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 574 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2011 12:00:00 AM | 3 | Permit Number 767978 | 6009888.44286 | 2088699.0602400003 | 37.7157279923247 | -122.40773572982599 | (37.7157279923247, -122.407735729826) | |
| 32242 | 32242 | 126072 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 280 Euclid Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 5997944.17854 | 2113963.60849 | 37.78442233817079 | -122.45084100083099 | (37.7844223381708, -122.450841000831) | |||
| 32298 | 32298 | 205451 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 370 Monterey Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5999656.98493 | 2094723.11119 | 37.731690576464 | -122.44353270427 | (37.731690576464, -122.44353270427) | |||
| 32329 | 32329 | 186320 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1800 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984982.8796 | 2102861.3111 | 37.753188075713204 | -122.494863100231 | (37.7531880757132, -122.494863100231) | |||
| 32340 | 32340 | 205339 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992450.822319999 | 2090054.7824900001 | 37.7184588853561 | -122.468106177376 | (37.7184588853561, -122.468106177376) | |||
| 32398 | 32398 | 245535 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008270.02595 | 2099337.89362 | 37.7448492066234 | -122.414081952318 | (37.7448492066234, -122.414081952318) | |||
| 32454 | 32454 | 245686 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 84 Pond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003174.39941 | 2106002.2203 | 37.7628603465492 | -122.43217750079201 | (37.7628603465492, -122.432177500792) | |||
| 32477 | 32477 | 182479 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1556 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985001.2277 | 2104593.5315 | 37.7579453479887 | -122.494927362203 | (37.7579453479887, -122.494927362203) | |||
| 32507 | 32507 | 182194 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2830 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985446.5605 | 2104353.3136 | 37.7573118352003 | -122.493369537581 | (37.7573118352003, -122.493369537581) | |||
| 32550 | 32550 | 246184 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 789 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999946.1417 | 2108227.6327 | 37.76878721042821 | -122.443502747941 | (37.7687872104282, -122.443502747941) | |||
| 32561 | 32561 | 117656 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4945 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5983252.4812199995 | 2111689.75712 | 37.7773270279447 | -122.501500112185 | (37.7773270279447, -122.501500112185) | |||
| 32592 | 32592 | 205476 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Judson Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999461.7393 | 2093534.4829400002 | 37.7284157437829 | -122.444122326784 | (37.7284157437829, -122.444122326784) | ||||
| 32665 | 32665 | 183711 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3727 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5984132.3296 | 2106974.9206 | 37.7644330705313 | -122.49810819735501 | (37.7644330705313, -122.498108197355) | |||
| 32698 | 32698 | 92457 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2174 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52847 | 5981421.6737 | 2100290.4816 | 37.7459201959872 | -122.506987562585 | (37.7459201959872, -122.506987562585) |
| 32705 | 32705 | 184612 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3550 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982960.1392 | 2102917.9885 | 37.7532250836044 | -122.501862221436 | (37.7532250836044, -122.501862221436) | |||
| 33108 | 33108 | 182216 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2998 Lawton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985077.3255 | 2104340.8144 | 37.757255911289704 | -122.49464555696899 | (37.7572559112897, -122.494645556969) | |||
| 33145 | 33145 | 245548 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1187 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007688.255059999 | 2102766.23628 | 37.7542299692468 | -122.41633639261002 | (37.7542299692468, -122.41633639261) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");