Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3033 | 3033 | 253285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 5981372.0 | 2112274.0 | 37.7788205636315 | -122.50804856364901 | (37.7788205636315, -122.508048563649) | |||
| 3382 | 3382 | 122965 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 09th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993050.799269999 | 2114904.9128799997 | 37.786725565514004 | -122.467838745487 | (37.786725565514, -122.467838745487) | |||
| 23577 | 23577 | 118033 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 89 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5984120.82492 | 2112822.3596099997 | 37.780487786596204 | -122.498579960483 | (37.7804877865962, -122.498579960483) | |||
| 23910 | 23910 | 118018 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 492 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 1ft | 5984413.88926 | 2112528.9426700003 | 37.779699331346 | -122.49754445899099 | (37.779699331346, -122.497544458991) | |||
| 24094 | 24094 | 118130 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3329 Balboa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5985237.75106 | 2111079.5821 | 37.775768059624504 | -122.494587526681 | (37.7757680596245, -122.494587526681) | |||
| 24330 | 24330 | 205383 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 64 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994182.66644 | 2101796.2621 | 37.750797955763396 | -122.46297136414101 | (37.7507979557634, -122.462971364141) | |||
| 24414 | 24414 | 205283 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 6ft | 5994526.48433 | 2100257.0572599997 | 37.7465914866063 | -122.46167083296801 | (37.7465914866063, -122.461670832968) | |||
| 25031 | 25031 | 126107 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2520 Baker St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5999698.94271 | 2117540.8900200003 | 37.794344910846206 | -122.44502739999201 | (37.7943449108462, -122.445027399992) | |||
| 25100 | 25100 | 205364 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 250 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994743.5494800005 | 2100407.30657 | 37.747016525988705 | -122.460931137866 | (37.7470165259887, -122.460931137866) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 33412 | 33412 | 183505 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2542 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988022.2437 | 2097979.1378 | 37.739960371072996 | -122.483994519568 | (37.739960371073, -122.483994519568) | |||
| 33453 | 33453 | 245507 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 107 Valley St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6005153.22882 | 2099293.3169400003 | 37.7445512558411 | -122.424856092128 | (37.7445512558411, -122.424856092128) | |||
| 33607 | 33607 | 182480 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1556 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985001.2277 | 2104598.4851 | 37.7579589491989 | -122.494927727444 | (37.7579589491989, -122.494927727444) | |||
| 33627 | 33627 | 118111 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3501 Balboa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5984683.9307699995 | 2111059.4403 | 37.7756803261768 | -122.49650181498801 | (37.7756803261768, -122.496501814988) | |||
| 33775 | 33775 | 245747 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 180 States St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6001087.3217 | 2106343.25573 | 37.763678192709605 | -122.43942040492901 | (37.7636781927096, -122.439420404929) | |||
| 33907 | 33907 | 141365 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 451 BRODERICK ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 6001152.0558 | 2110284.1153 | 37.77450249679129 | -122.439479025748 | (37.7745024967913, -122.439479025748) | |||
| 33951 | 33951 | 118104 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3619 Balboa St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5984338.24739 | 2111045.35497 | 37.7756213940982 | -122.497696560834 | (37.7756213940982, -122.497696560834) | |||
| 34029 | 34029 | 182428 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1551 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985887.38 | 2104676.4366 | 37.7582248168708 | -122.49186881998699 | (37.7582248168708, -122.491868819987) | |||
| 34068 | 34068 | 118164 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3640 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5984224.54908 | 2111096.5750599997 | 37.77575536408371 | -122.498093648535 | (37.7757553640837, -122.498093648535) | |||
| 34296 | 34296 | 205362 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 380 Santa Clara Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5993121.4753 | 2095431.1387099999 | 37.7332597513404 | -122.466178519236 | (37.7332597513404, -122.466178519236) | |||
| 34446 | 34446 | 245509 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 107 Valley St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6005195.418769999 | 2099296.09974 | 37.7445612796971 | -122.424710405556 | (37.7445612796971, -122.424710405556) | |||
| 34787 | 34787 | 205379 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994382.49687 | 2101822.13039 | 37.7508804919577 | -122.462282213677 | (37.7508804919577, -122.462282213677) | |||
| 35941 | 35941 | 118110 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3501 Balboa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5984695.467999999 | 2111059.8065 | 37.775682007555105 | -122.49646193248199 | (37.7756820075551, -122.496461932482) | |||
| 36842 | 36842 | 205287 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Terrace Dr | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5993689.14699 | 2096660.1046799999 | 37.736666922846105 | -122.46430513247499 | (37.7366669228461, -122.464305132475) | ||||
| 37002 | 37002 | 245722 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002219.32806 | 2105848.6190400003 | 37.7623843983365 | -122.435469765918 | (37.7623843983365, -122.435469765918) | |||
| 37235 | 37235 | 118131 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3329 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5985219.30411 | 2111079.75397 | 37.7757674518404 | -122.494651351064 | (37.7757674518404, -122.494651351064) | |||
| 37683 | 37683 | 182522 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1578 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5985934.3473 | 2104505.9629 | 37.7577594881622 | -122.491693839806 | (37.7577594881622, -122.491693839806) | |||
| 38583 | 38583 | 182218 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2998 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985074.531 | 2104338.5788 | 37.757249609388104 | -122.494655056486 | (37.7572496093881, -122.494655056486) | |||
| 38686 | 38686 | 205369 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 151 Elmwood Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994984.949440001 | 2092707.9800200001 | 37.725889956432205 | -122.459538865037 | (37.7258899564322, -122.459538865037) | |||
| 38815 | 38815 | 118112 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3501 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5984675.14269 | 2111058.24999 | 37.7756765430765 | -122.496532126819 | (37.7756765430765, -122.496532126819) | |||
| 39557 | 39557 | 189319 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1121 Jamestown Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6013379.939590001 | 2090055.2755099998 | 37.71964672878121 | -122.39576240251499 | (37.7196467287812, -122.395762402515) | ||||
| 40427 | 40427 | 182436 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1527 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985262.1586 | 2104804.4482 | 37.7585397378662 | -122.494040510604 | (37.7585397378662, -122.494040510604) | |||
| 40611 | 40611 | 205286 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994515.58905 | 2100325.7209900003 | 37.7467793927483 | -122.461713485112 | (37.7467793927483, -122.461713485112) | |||
| 40876 | 40876 | 117806 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3750 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5983881.663269999 | 2111084.90626 | 37.7757032150917 | -122.499278895594 | (37.7757032150917, -122.499278895594) | |||
| 41425 | 41425 | 245695 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 310 Liberty St | 57 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6003740.43231 | 2103919.2524200003 | 37.757173090583294 | -122.43007119145399 | (37.7571730905833, -122.430071191454) | |||
| 41727 | 41727 | 175985 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 160 Baltimore Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002380.953509999 | 2086206.35478 | 37.7084604350668 | -122.433506993768 | (37.7084604350668, -122.433506993768) | |||
| 42085 | 42085 | 118832 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 650 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981668.99425 | 2111312.2373200003 | 37.7761973421342 | -122.506949801153 | (37.7761973421342, -122.506949801153) | |||
| 42323 | 42323 | 126124 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1055 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6007293.98833 | 2120181.06921 | 37.8020247344007 | -122.418934936917 | (37.8020247344007, -122.418934936917) | |||
| 42557 | 42557 | 205256 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1490 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5991184.504790001 | 2105292.04801 | 37.7602233103899 | -122.473594144473 | (37.7602233103899, -122.473594144473) | |||
| 43565 | 43565 | 182254 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1455 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985244.0401 | 2105313.2398 | 37.7599356780931 | -122.494140671506 | (37.7599356780931, -122.494140671506) | |||
| 43581 | 43581 | 118096 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3635 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5984283.94129 | 2111043.54907 | 37.7756132520576 | -122.49788428266199 | (37.7756132520576, -122.497884282662) | |||
| 43770 | 43770 | 184492 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1834 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5981345.8672 | 2102562.8148 | 37.7521549190758 | -122.50741825242399 | (37.7521549190758, -122.507418252424) | |||
| 44128 | 44128 | 205385 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 145 Castenada Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994547.44113 | 2100964.24695 | 37.7485344574969 | -122.46164963233299 | (37.7485344574969, -122.461649632333) | |||
| 45387 | 45387 | 126106 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2520 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5999701.63117 | 2117520.55551 | 37.7942892311035 | -122.445016635117 | (37.7942892311035, -122.445016635117) | |||
| 45731 | 45731 | 205284 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5994513.21392 | 2100320.50636 | 37.7467649379646 | -122.46172131998999 | (37.7467649379646, -122.46172131999) | |||
| 45927 | 45927 | 205359 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 501 Dewey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5994566.242219999 | 2099806.26711 | 37.7453560186624 | -122.461500679435 | (37.7453560186624, -122.461500679435) | |||
| 46038 | 46038 | 205363 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 250 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994757.66633 | 2100420.78741 | 37.7470543532783 | -122.46088330023501 | (37.7470543532783, -122.460883300235) | |||
| 46654 | 46654 | 182470 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1534 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985927.3891 | 2104764.5727 | 37.7584691526964 | -122.49173694116301 | (37.7584691526964, -122.491736941163) | |||
| 47197 | 47197 | 205259 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1472 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5991180.198030001 | 2105388.78437 | 37.7604886733293 | -122.47361609600401 | (37.7604886733293, -122.473616096004) | |||
| 47573 | 47573 | 182510 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1568 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985005.731000001 | 2104517.4263 | 37.757736647852795 | -122.494906176767 | (37.7577366478528, -122.494906176767) | |||
| 47817 | 47817 | 182530 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1582 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5985937.8263 | 2104476.391 | 37.7576784951981 | -122.491679631304 | (37.7576784951981, -122.491679631304) | |||
| 47943 | 47943 | 205406 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 32 Malta Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5999669.041619999 | 2095969.46691 | 37.735113464498 | -122.443580522123 | (37.735113464498, -122.443580522123) | |||
| 48040 | 48040 | 205281 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 123 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 2ft | 5993520.55231 | 2102533.14677 | 37.7527830913663 | -122.465314516263 | (37.7527830913663, -122.465314516263) | |||
| 48139 | 48139 | 182816 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1800 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5987230.5033 | 2102980.2551 | 37.7536459762525 | -122.48709920226999 | (37.7536459762525, -122.48709920227) | |||
| 49158 | 49158 | 126125 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1055 Lombard St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 5ft | 6007295.75973 | 2120178.5361099998 | 37.8020178788931 | -122.418928627254 | (37.8020178788931, -122.418928627254) | |||
| 49171 | 49171 | 245694 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 310 Liberty St | 51 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003830.82876 | 2103923.03299 | 37.75718859039571 | -122.42975883531099 | (37.7571885903957, -122.429758835311) | |||
| 49411 | 49411 | 183392 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2670 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988981.2632 | 2097175.5852 | 37.7378098101289 | -122.48061985740401 | (37.7378098101289, -122.480619857404) | |||
| 49711 | 49711 | 182344 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3033 Kirkham St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985393.4622 | 2104975.4085 | 37.7590168295025 | -122.493599007268 | (37.7590168295025, -122.493599007268) | |||
| 49779 | 49779 | 182347 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1506 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985921.0109 | 2104939.6851 | 37.7589495902306 | -122.491771890632 | (37.7589495902306, -122.491771890632) | |||
| 50791 | 50791 | 205396 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 5 Sequoia Way | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5998207.87044 | 2097837.56069 | 37.7401593599583 | -122.44876680533899 | (37.7401593599583, -122.448766805339) | |||
| 50916 | 50916 | 205361 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 501 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5994519.57581 | 2099760.56187 | 37.745227837411 | -122.46165872987 | (37.745227837411, -122.46165872987) | |||
| 51599 | 51599 | 118094 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3639 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5984267.418269999 | 2111042.24708 | 37.775608708488 | -122.497941342782 | (37.775608708488, -122.497941342782) | |||
| 52533 | 52533 | 205258 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1490 16th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 5ft | 5991184.09698 | 2105311.0178900003 | 37.76027537302679 | -122.473596938664 | (37.7602753730268, -122.473596938664) | |||
| 52828 | 52828 | 205360 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 501 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5994524.6645599995 | 2099765.7071700003 | 37.7452422580339 | -122.461641506945 | (37.7452422580339, -122.461641506945) | |||
| 53501 | 53501 | 182817 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2199 Noriega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5987254.6144 | 2102991.5069999998 | 37.75367827678971 | -122.487016648105 | (37.7536782767897, -122.487016648105) | |||
| 55128 | 55128 | 118439 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 5201 Anza St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5982517.7720099995 | 2111663.67845 | 37.7772122457156 | -122.504039734844 | (37.7772122457156, -122.504039734844) | |||
| 55209 | 55209 | 182443 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1530 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985305.1982 | 2104772.3112 | 37.7584540168422 | -122.493889294148 | (37.7584540168422, -122.493889294148) | |||
| 55584 | 55584 | 182536 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1580 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5985005.5058 | 2104460.0097 | 37.7575789846205 | -122.494902722195 | (37.7575789846205, -122.494902722195) | |||
| 56332 | 56332 | 245717 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002175.29475 | 2105821.19316 | 37.7623065926062 | -122.43562009838699 | (37.7623065926062, -122.435620098387) | |||
| 56631 | 56631 | 205407 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 32 Malta Dr | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5999569.21905 | 2096036.88845 | 37.7352928945331 | -122.443930486119 | (37.7352928945331, -122.443930486119) | |||
| 56667 | 56667 | 118157 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3600 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5984393.42428 | 2111103.02435 | 37.7757829719186 | -122.497509951992 | (37.7757829719186, -122.497509951992) | |||
| 57572 | 57572 | 175913 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 6003123.75236 | 2086687.83288 | 37.7098245860981 | -122.430974132365 | (37.7098245860981, -122.430974132365) | |||
| 58563 | 58563 | 118124 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3421 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5984939.14905 | 2111066.46877 | 37.7757145729193 | -122.495619483405 | (37.7757145729193, -122.495619483405) | |||
| 58806 | 58806 | 245488 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2648 Bryant St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6009743.69042 | 2101907.26057 | 37.7519867821794 | -122.40916754497201 | (37.7519867821794, -122.409167544972) | |||
| 58871 | 58871 | 182058 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1358 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5986816.6139 | 2106002.3798 | 37.7619197614589 | -122.488752630403 | (37.7619197614589, -122.488752630403) | |||
| 59646 | 59646 | 182407 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1542 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5984998.5258 | 2104706.1132 | 37.7582543079017 | -122.49494500735901 | (37.7582543079017, -122.494945007359) | |||
| 59785 | 59785 | 182382 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1518 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985614.614 | 2104854.4397 | 37.7586976174918 | -122.49282526083799 | (37.7586976174918, -122.492825260838) | |||
| 59803 | 59803 | 205356 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 159 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5993813.329969999 | 2099845.12022 | 37.745419334546 | -122.464106926418 | (37.745419334546, -122.464106926418) | |||
| 59910 | 59910 | 118141 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3338 Balboa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5985127.87528 | 2111128.85384 | 37.775896914237 | -122.49497124294099 | (37.775896914237, -122.494971242941) | |||
| 60941 | 60941 | 183408 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2681 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5989556.2232 | 2097122.9718 | 37.7376987467068 | -122.478628117154 | (37.7376987467068, -122.478628117154) | |||
| 61119 | 61119 | 118495 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5981356.12189 | 2112314.02701 | 37.7789295303469 | -122.50810646292601 | (37.7789295303469, -122.508106462926) | ||||
| 61177 | 61177 | 118116 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3521 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5984641.07876 | 2111057.5325599997 | 37.7756725775058 | -122.49664990764799 | (37.7756725775058, -122.496649907648) |
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");