Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68012 | 68012 | 136610 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 4ft | 6002559.08771 | 2121673.9848 | 37.805856133210895 | -122.43542677652 | (37.8058561332109, -122.43542677652) | |||
| 188021 | 188021 | 136609 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 4ft | 6002557.10875 | 2121672.73918 | 37.805852600677795 | -122.435433535844 | (37.8058526006778, -122.435433535844) | |||
| 72627 | 72627 | 136608 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 6002554.72948 | 2121670.19367 | 37.8058454762555 | -122.435441587454 | (37.8058454762555, -122.435441587454) | |||
| 75463 | 75463 | 136607 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 5ft | 6002552.02607 | 2121667.51893 | 37.8058379785924 | -122.435450751546 | (37.8058379785924, -122.435450751546) | |||
| 188746 | 188746 | 136606 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 5ft | 6002550.09467 | 2121664.33857 | 37.8058291364749 | -122.43545720778799 | (37.8058291364749, -122.435457207788) | |||
| 52420 | 52420 | 136605 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 4ft | 6002548.49635 | 2121661.6698 | 37.805821717964605 | -122.43546254797701 | (37.8058217179646, -122.435462547977) | |||
| 37251 | 37251 | 136604 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002548.10466 | 2121650.0452 | 37.8057897776435 | -122.435463071378 | (37.8057897776435, -122.435463071378) | |||
| 187893 | 187893 | 130609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Beach St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6002918.83172 | 2121356.11513 | 37.80500377108171 | -122.43415909039699 | (37.8050037710817, -122.434159090397) | ||||
| 162418 | 162418 | 249770 | Undocumented 2 | Schinus molle :: California Pepper 138 | 102 Pfeiffer St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6010494.56062 | 2121168.81632 | 37.8049165440205 | -122.407929079557 | (37.8049165440205, -122.407929079557) | |||
| 43890 | 43890 | 249771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | |||
| 64938 | 64938 | 249772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.40812137351801 | (37.8049001107042, -122.408121373518) | |||
| 168933 | 168933 | 249774 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010412.38512 | 2121159.3166 | 37.804885859146104 | -122.408212787783 | (37.8048858591461, -122.408212787783) | |||
| 53370 | 53370 | 249773 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.80487103114871 | -122.40814255972602 | (37.8048710311487, -122.408142559726) | |||
| 183252 | 183252 | 249775 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 0ft | 6010401.04426 | 2121152.2311400003 | 37.8048657692012 | -122.40825153418999 | (37.8048657692012, -122.40825153419) | |||
| 136621 | 136621 | 249776 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 102 Pfeiffer St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | Width 0ft | 6010370.54568 | 2121149.36884 | 37.804856202214204 | -122.408356876268 | (37.8048562022142, -122.408356876268) | |||
| 64022 | 64022 | 136289 | Undocumented 2 | Quercus spp :: Oak 297 | 2836 Larkin St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006495.00775 | 2121066.48783 | 37.80441084625 | -122.42176272108101 | (37.80441084625, -122.421762721081) | ||||
| 147910 | 147910 | 136288 | Undocumented 2 | Quercus spp :: Oak 297 | 2836 Larkin St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6006500.63968 | 2121061.90297 | 37.804398574988205 | -122.421742905414 | (37.8043985749882, -122.421742905414) | ||||
| 187806 | 187806 | 132199 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2836 Larkin St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6006498.02761 | 2121046.57665 | 37.8043563455331 | -122.42175085543998 | (37.8043563455331, -122.42175085544) | ||||
| 130652 | 130652 | 132198 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2836 Larkin St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6006512.519719999 | 2121038.28328 | 37.804334391275894 | -122.42170011478301 | (37.8043343912759, -122.421700114783) | ||||
| 184674 | 184674 | 126416 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6006501.512069999 | 2121012.26216 | 37.804262323204895 | -122.421736358356 | (37.8042623232049, -122.421736358356) | ||||
| 59780 | 59780 | 126415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 48 | 6006502.51226 | 2121001.4648 | 37.804232732814704 | -122.421732129727 | (37.8042327328147, -122.421732129727) | ||||
| 35115 | 35115 | 126414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006501.05561 | 2120998.5397099997 | 37.804224619123296 | -122.421736962694 | (37.8042246191233, -122.421736962694) | ||||
| 147259 | 147259 | 132299 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2836 Larkin St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006506.76363 | 2120995.98891 | 37.8042179371566 | -122.421717028328 | (37.8042179371566, -122.421717028328) | ||||
| 173443 | 173443 | 132298 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2836 Larkin St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6006506.15813 | 2120992.00348 | 37.8042069600397 | -122.42171884046199 | (37.8042069600397, -122.421718840462) | ||||
| 66458 | 66458 | 136660 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 7ft | 6003228.45993 | 2120985.21121 | 37.8040029344509 | -122.433061071222 | (37.8040029344509, -122.433061071222) | |||
| 72993 | 72993 | 136716 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 7ft | 6003215.33658 | 2120983.87446 | 37.8039985196804 | -122.43310638985001 | (37.8039985196804, -122.43310638985) | |||
| 147721 | 147721 | 136659 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 7ft | 6003202.747769999 | 2120982.34817 | 37.8039936147875 | -122.433149845112 | (37.8039936147875, -122.433149845112) | |||
| 46836 | 46836 | 136715 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 7ft | 6003190.857480001 | 2120979.91426 | 37.803986257417 | -122.43319081820499 | (37.803986257417, -122.433190818205) | |||
| 75488 | 75488 | 136658 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 7ft | 6003175.48548 | 2120978.26665 | 37.803980861494395 | -122.433243896185 | (37.8039808614944, -122.433243896185) | |||
| 115469 | 115469 | 136714 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.803975515032604 | -122.433293789677 | (37.8039755150326, -122.433293789677) | |||
| 179457 | 179457 | 126275 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2836 Larkin St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | ||||
| 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) | ||||
| 177265 | 177265 | 132399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006512.34183 | 2120961.63143 | 37.8041239148476 | -122.421695282708 | (37.8041239148476, -122.421695282708) | ||||
| 58870 | 58870 | 132398 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006507.37075 | 2120957.5617299997 | 37.8041124601724 | -122.421712196283 | (37.8041124601724, -122.421712196283) | ||||
| 57817 | 57817 | 132397 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006502.73263 | 2120950.76111 | 37.804093525861795 | -122.42172776352899 | (37.8040935258618, -122.421727763529) | ||||
| 30048 | 30048 | 132396 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 6006504.32212 | 2120945.10898 | 37.804078096188704 | -122.421721861273 | (37.8040780961887, -122.421721861273) | ||||
| 122555 | 122555 | 126122 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2833 Larkin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6006473.28428 | 2120942.81763 | 37.804070054442 | -122.42182910722799 | (37.804070054442, -122.421829107228) | ||||
| 38844 | 38844 | 132391 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6006489.423769999 | 2120936.29447 | 37.8040530536607 | -122.421772791676 | (37.8040530536607, -122.421772791676) | ||||
| 155855 | 155855 | 132392 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006479.362930001 | 2120932.81603 | 37.8040429353981 | -122.421807360741 | (37.8040429353981, -122.421807360741) | ||||
| 31588 | 31588 | 132395 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6006513.4872 | 2120932.40539 | 37.8040437321931 | -122.42168924196999 | (37.8040437321931, -122.42168924197) | ||||
| 72084 | 72084 | 132393 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6006475.56322 | 2120927.38496 | 37.8040278087899 | -122.42182012391001 | (37.8040278087899, -122.42182012391) | ||||
| 130704 | 130704 | 132394 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006476.08021 | 2120921.35396 | 37.804011278359205 | -122.42181790617599 | (37.8040112783592, -122.421817906176) | ||||
| 31310 | 31310 | 249769 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 295 Kearny St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6010840.59654 | 2120830.53405 | 37.8040070713206 | -122.40670772380399 | (37.8040070713206, -122.406707723804) | |||
| 171449 | 171449 | 249865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 0ft | 6011350.601919999 | 2120707.91777 | 37.8036989186248 | -122.404934168095 | (37.8036989186248, -122.404934168095) | |||
| 38454 | 38454 | 249866 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011357.005059999 | 2120690.5710400003 | 37.8036516466761 | -122.404910787509 | (37.8036516466761, -122.404910787509) | |||
| 127197 | 127197 | 249899 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011381.09793 | 2120471.14228 | 37.8030504957345 | -122.404811954701 | (37.8030504957345, -122.404811954701) | |||
| 173273 | 173273 | 249898 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1497 Montgomery St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011364.51666 | 2120462.68134 | 37.8030263372523 | -122.404868738822 | (37.8030263372523, -122.404868738822) | |||
| 171284 | 171284 | 249897 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.40479885070101 | (37.8030148322229, -122.404798850701) | |||
| 28950 | 28950 | 132461 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006461.025 | 2120401.5247299997 | 37.8025831108771 | -122.42183305885901 | (37.8025831108771, -122.421833058859) | ||||
| 154158 | 154158 | 132459 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006454.20417 | 2120400.58953 | 37.8025801584021 | -122.42185659591699 | (37.8025801584021, -122.421856595917) | ||||
| 62403 | 62403 | 132460 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006458.07728 | 2120400.55617 | 37.8025802852249 | -122.421843190623 | (37.8025802852249, -122.421843190623) | ||||
| 71454 | 71454 | 249847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 289 Greenwich St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011426.79495 | 2120392.20909 | 37.8028363185975 | -122.40464825831002 | (37.8028363185975, -122.40464825831) | |||
| 169728 | 169728 | 249848 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 289 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011433.333 | 2120390.12785 | 37.8028309694274 | -122.404625486584 | (37.8028309694274, -122.404625486584) | |||
| 134892 | 134892 | 249849 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 289 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011439.22895 | 2120384.4493 | 37.8028157070334 | -122.40460468348499 | (37.8028157070334, -122.404604683485) | |||
| 28161 | 28161 | 249840 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 305 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011283.33525 | 2120383.34662 | 37.8028039654926 | -122.405144080631 | (37.8028039654926, -122.405144080631) | |||
| 25968 | 25968 | 249846 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 289 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011427.16735 | 2120382.55668 | 37.8028098362532 | -122.40464628970601 | (37.8028098362532, -122.404646289706) | |||
| 168329 | 168329 | 249839 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 305 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011296.15098 | 2120380.09271 | 37.802795747494706 | -122.405099502163 | (37.8027957474947, -122.405099502163) | |||
| 150119 | 150119 | 249838 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 305 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011296.05526 | 2120375.39097 | 37.8027828323166 | -122.405099502142 | (37.8027828323166, -122.405099502142) | |||
| 86485 | 86485 | 122824 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 407x Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6010366.0 | 2120356.0 | 37.8026775529699 | -122.40831661418899 | (37.8026775529699, -122.408316614189) | |||||
| 52971 | 52971 | 126040 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2390 Bay St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 4ft | 5999373.78481 | 2120164.23699 | 37.801529357251205 | -122.446341287942 | (37.8015293572512, -122.446341287942) | |||
| 162918 | 162918 | 126034 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 2390 Bay St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 4ft | 5999370.04259 | 2120163.81894 | 37.801527995669204 | -122.446354207574 | (37.8015279956692, -122.446354207574) | |||
| 158284 | 158284 | 250003 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 232 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011516.941380001 | 2120107.55399 | 37.802059763016096 | -122.404316256511 | (37.8020597630161, -122.404316256511) | |||
| 60330 | 60330 | 250004 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 232 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011504.01109 | 2120100.18107 | 37.802038796226796 | -122.40436048246599 | (37.8020387962268, -122.404360482466) | |||
| 27269 | 27269 | 250005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 232 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) | |||
| 28898 | 28898 | 250221 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 312 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | |||
| 67773 | 67773 | 250220 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 312 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011282.86826 | 2120079.66018 | 37.8019700907042 | -122.405124300067 | (37.8019700907042, -122.405124300067) | |||
| 184457 | 184457 | 250222 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 312 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011281.01551 | 2120075.58607 | 37.8019588006185 | -122.40513042444701 | (37.8019588006185, -122.405130424447) | |||
| 187720 | 187720 | 249956 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 285 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 6011495.629790001 | 2120073.57822 | 37.8019652829314 | -122.404387612316 | (37.8019652829314, -122.404387612316) | |||
| 166321 | 166321 | 250223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011234.32087 | 2120070.9566599997 | 37.80194347887979 | -122.405291684587 | (37.8019434788798, -122.405291684587) | |||
| 165572 | 165572 | 250224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011221.34302 | 2120070.92711 | 37.8019426721638 | -122.405336592216 | (37.8019426721638, -122.405336592216) | |||
| 169459 | 169459 | 249955 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011505.97031 | 2120064.83328 | 37.801941849301 | -122.404351213161 | (37.801941849301, -122.404351213161) | |||
| 69791 | 69791 | 250225 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011230.02021 | 2120062.52676 | 37.8019200919915 | -122.40530597298701 | (37.8019200919915, -122.405305972987) | |||
| 172111 | 172111 | 250226 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 0ft | 6011217.042090001 | 2120062.49723 | 37.8019192853099 | -122.405350881537 | (37.8019192853099, -122.405350881537) | |||
| 26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
| 30719 | 30719 | 249951 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 303 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011370.2265099995 | 2120056.34585 | 37.8019109584873 | -122.40482035527799 | (37.8019109584873, -122.404820355278) | |||
| 60021 | 60021 | 249949 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | |||
| 67816 | 67816 | 250228 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 0ft | 6011211.1715400005 | 2120049.4002099996 | 37.8018829958704 | -122.40537027363101 | (37.8018829958704, -122.405370273631) | |||
| 181873 | 181873 | 250227 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 312 Filbert St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011220.88869 | 2120048.61475 | 37.8018813824768 | -122.40533659221902 | (37.8018813824768, -122.405336592219) | |||
| 166394 | 166394 | 250229 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011206.629819999 | 2120043.6184099996 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | |||
| 64441 | 64441 | 249953 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 0ft | 6011372.652369999 | 2120041.55492 | 37.8018704817969 | -122.40481091868901 | (37.8018704817969, -122.404810918689) | |||
| 71813 | 71813 | 249952 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 0ft | 6011371.46837 | 2120040.8031 | 37.801868351303796 | -122.40481496294399 | (37.8018683513038, -122.404814962944) | |||
| 165775 | 165775 | 249954 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 0ft | 6011374.5207 | 2120037.6372700003 | 37.8018598293151 | -122.404804177386 | (37.8018598293151, -122.404804177386) | |||
| 32280 | 32280 | 129119 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1114 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007553.05086 | 2119913.7987599997 | 37.8013054611424 | -122.418019497203 | (37.8013054611424, -122.418019497203) | ||||
| 179334 | 179334 | 136052 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1114 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6007569.13805 | 2119905.68389 | 37.801284085155004 | -122.41796325270201 | (37.801284085155, -122.417963252702) | ||||
| 38374 | 38374 | 136055 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1114 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007559.35658 | 2119902.6850400004 | 37.8012753005604 | -122.417996888269 | (37.8012753005604, -122.417996888269) | ||||
| 156317 | 156317 | 250196 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011857.70339 | 2119785.90004 | 37.801195615236395 | -122.403114412425 | (37.8011956152364, -122.403114412425) | |||
| 186554 | 186554 | 250195 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011875.28376 | 2119779.56963 | 37.8011792152183 | -122.40305313080401 | (37.8011792152183, -122.403053130804) | |||
| 179735 | 179735 | 250198 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 201 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011825.11075 | 2119776.45008 | 37.8011678477679 | -122.40322653269199 | (37.8011678477679, -122.403226532692) | |||
| 60552 | 60552 | 250197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011839.72623 | 2119769.92251 | 37.8011507408769 | -122.403175497057 | (37.8011507408769, -122.403175497057) | |||
| 46469 | 46469 | 250199 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011821.07725 | 2119768.34547 | 37.8011453692141 | -122.403239919993 | (37.8011453692141, -122.403239919993) | |||
| 181546 | 181546 | 125276 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6006714.64641 | 2119759.73621 | 37.800835221824 | -122.420909807645 | (37.800835221824, -122.420909807645) | ||||
| 29301 | 29301 | 250202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 203 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | |||
| 165040 | 165040 | 131051 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1285 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006739.62065 | 2119756.87873 | 37.8008287835889 | -122.42082318315701 | (37.8008287835889, -122.420823183157) | ||||
| 176347 | 176347 | 125277 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6006721.71386 | 2119753.35883 | 37.800818109519206 | -122.420884898228 | (37.8008181095192, -122.420884898228) | ||||
| 60533 | 60533 | 250200 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | Width 0ft | 6011776.4013 | 2119745.07747 | 37.8010789857668 | -122.403392881194 | (37.8010789857668, -122.403392881194) | |||
| 65961 | 65961 | 250201 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | Width 0ft | 6011763.02504 | 2119743.5219400004 | 37.8010739675505 | -122.40343905958099 | (37.8010739675505, -122.403439059581) | |||
| 41959 | 41959 | 250203 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 203 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 0ft | 6011748.4940599995 | 2119742.37279 | 37.8010700006395 | -122.403489262419 | (37.8010700006395, -122.403489262419) | |||
| 53803 | 53803 | 250309 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Redfield Aly | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | |||
| 183929 | 183929 | 125339 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6008681.4461 | 2118995.9175299997 | 37.7988486311296 | -122.414049766478 | (37.7988486311296, -122.414049766478) | ||||
| 172088 | 172088 | 125288 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 943 Green St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.41407270821101 | (37.7988459853112, -122.414072708211) |
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");