Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189033 | 189033 | 249723 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000201.87433 | 2117349.10426 | 37.7938470092862 | -122.443273421624 | (37.7938470092862, -122.443273421624) | ||||
| 188979 | 188979 | 208590 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1640 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 6ft | 5993420.78428 | 2104324.2280599996 | 37.757695183915104 | -122.465789652393 | (37.7576951839151, -122.465789652393) | |||
| 188787 | 188787 | 198716 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012435.45526 | 2104782.66199 | 37.760032437365105 | -122.40006088669901 | (37.7600324373651, -122.400060886699) | ||||
| 188736 | 188736 | 207124 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | |||
| 188711 | 188711 | 249682 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999744.1267099995 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | ||||
| 188669 | 188669 | 224174 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6005169.04255 | 2097308.79446 | 37.739103100825794 | -122.424660266574 | (37.7391031008258, -122.424660266574) | ||||
| 188666 | 188666 | 224021 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6003548.3510300005 | 2095664.8984299998 | 37.734497671711296 | -122.430146636467 | (37.7344976717113, -122.430146636467) | ||||
| 188593 | 188593 | 249830 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 0ft | 6011191.13425 | 2120368.12029 | 37.8027570028825 | -122.405462071912 | (37.8027570028825, -122.405462071912) | |||
| 188585 | 188585 | 133186 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010537.33866 | 2121307.06763 | 37.80529854275579 | -122.40779079533199 | (37.8052985427558, -122.407790795332) | ||||
| 188577 | 188577 | 249695 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999678.04202 | 2117322.75965 | 37.7937447896309 | -122.445084029412 | (37.7937447896309, -122.445084029412) | ||||
| 188575 | 188575 | 223004 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 671 Church St | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6004322.20484 | 2105083.5512599996 | 37.760402911294996 | -122.428142169046 | (37.760402911295, -122.428142169046) | |||
| 188449 | 188449 | 224191 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 122 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005002.1777800005 | 2096858.81533 | 37.7378581342538 | -122.425205199076 | (37.7378581342538, -122.425205199076) | ||||
| 188407 | 188407 | 249906 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 302 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011297.142419999 | 2120427.5377700003 | 37.802926075438 | -122.405099414011 | (37.802926075438, -122.405099414011) | |||
| 188356 | 188356 | 191826 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010905.89274 | 2107192.31992 | 37.7665634148087 | -122.40552064836099 | (37.7665634148087, -122.405520648361) | ||||
| 188340 | 188340 | 224188 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 117 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005014.01111 | 2096876.39929 | 37.7379070843395 | -122.42516553628799 | (37.7379070843395, -122.425165536288) | ||||
| 188249 | 188249 | 211273 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 419 Baden St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6000744.76025 | 2095358.13165 | 37.733496172296796 | -122.43981756802201 | (37.7334961722968, -122.439817568022) | ||||
| 188185 | 188185 | 133189 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010562.1879199995 | 2121314.22329 | 37.8053195814974 | -122.40770530575399 | (37.8053195814974, -122.407705305754) | ||||
| 188096 | 188096 | 233295 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6003571.72573 | 2095651.64525 | 37.7344626053608 | -122.430064877286 | (37.7344626053608, -122.430064877286) | ||||
| 188089 | 188089 | 245817 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 94 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004980.52596 | 2096892.5237200002 | 37.737949466684206 | -122.425282458027 | (37.7379494666842, -122.425282458027) | ||||
| 187938 | 187938 | 223985 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 1000 San Jose Ave | 100 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005168.16195 | 2097235.94873 | 37.7389030331571 | -122.424658130684 | (37.7389030331571, -122.424658130684) | ||||
| 187931 | 187931 | 247837 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 98 Nevada St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009030.264690001 | 2098089.7261099997 | 37.7414646836551 | -122.411365018597 | (37.7414646836551, -122.411365018597) | ||||
| 187909 | 187909 | 223830 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006171.8374 | 2097486.11107 | 37.73964655665021 | -122.42120563965099 | (37.7396465566502, -122.421205639651) | ||||
| 187890 | 187890 | 233335 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 601 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002596.9990300005 | 2098294.71472 | 37.741664611941104 | -122.433623657423 | (37.7416646119411, -122.433623657423) | ||||
| 187763 | 187763 | 224197 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005251.17489 | 2097047.32393 | 37.738389799949104 | -122.424357697761 | (37.7383897999491, -122.424357697761) | ||||
| 187747 | 187747 | 234503 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1000 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005117.95051 | 2097175.7705599996 | 37.738734961555295 | -122.42482745862101 | (37.7387349615553, -122.424827458621) | ||||
| 187538 | 187538 | 240942 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004290.97855 | 2105224.4421599996 | 37.760787997378394 | -122.428260207767 | (37.7607879973784, -122.428260207767) | |||
| 187524 | 187524 | 224449 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1201 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004503.55801 | 2096138.79869 | 37.73585295005579 | -122.426877907491 | (37.7358529500558, -122.426877907491) | ||||
| 187509 | 187509 | 191704 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1501 Quint St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 4ft | 6013263.69136 | 2096352.02038 | 37.736929838751294 | -122.396605400918 | (37.7369298387513, -122.396605400918) | |||
| 187463 | 187463 | 249725 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6000213.93335 | 2117265.22883 | 37.793617397063606 | -122.44322566942301 | (37.7936173970636, -122.443225669423) | ||||
| 187358 | 187358 | 136282 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 941 Vallejo St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009001.702330001 | 2118702.23978 | 37.798060246745 | -122.41292079626699 | (37.798060246745, -122.412920796267) | ||||
| 187204 | 187204 | 237951 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 200 Eugenia Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6006574.718780001 | 2098103.54318 | 37.7413645918137 | -122.419856447043 | (37.7413645918137, -122.419856447043) | ||||
| 187196 | 187196 | 224277 | Undocumented 2 | Eucalyptus melliodora :: Yellow Box 416 | 1300 San Jose Ave | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6003308.13091 | 2095510.5396 | 37.734060228878604 | -122.430966143696 | (37.7340602288786, -122.430966143696) | ||||
| 187180 | 187180 | 223054 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 701 Church St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004339.171130001 | 2104460.25399 | 37.758692444824206 | -122.42803907256099 | (37.7586924448242, -122.428039072561) | |||
| 187045 | 187045 | 247097 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2301 Castro St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002735.730380001 | 2098630.4546 | 37.74259434634529 | -122.433167954764 | (37.7425943463453, -122.433167954764) | ||||
| 186894 | 186894 | 246755 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1838 Alabama St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6009311.20113 | 2098998.06122 | 37.7439745260177 | -122.410457757318 | (37.7439745260177, -122.410457757318) | ||||
| 186792 | 186792 | 221972 | Undocumented 2 | Albizia distachya :: Plume Albizia Tree 360 | 1100 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004717.97013 | 2096540.7716599999 | 37.7369687982596 | -122.426165208265 | (37.7369687982596, -122.426165208265) | ||||
| 186723 | 186723 | 196338 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015971.97004 | 2099951.82403 | 37.7469645173129 | -122.387492652478 | (37.7469645173129, -122.387492652478) | ||||
| 186600 | 186600 | 224287 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1201 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6004351.28385 | 2095952.40857 | 37.7353325537541 | -122.42739110562799 | (37.7353325537541, -122.427391105628) | ||||
| 186584 | 186584 | 136382 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1015 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6008613.871780001 | 2118642.82165 | 37.7978753218528 | -122.414258600758 | (37.7978753218528, -122.414258600758) | ||||
| 186465 | 186465 | 247089 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2301 Castro St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002763.937390001 | 2098596.7389 | 37.7425033709224 | -122.433068014888 | (37.7425033709224, -122.433068014888) | ||||
| 186419 | 186419 | 245810 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6005122.10608 | 2097126.3109900001 | 37.7385993914497 | -122.424809572906 | (37.7385993914497, -122.424809572906) | ||||
| 186379 | 186379 | 249717 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2500 Broderick St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 7ft | 6000147.51069 | 2117427.0095900004 | 37.794057816679995 | -122.44346712302601 | (37.79405781668, -122.443467123026) | |||
| 186305 | 186305 | 198719 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012426.60188 | 2104780.3365 | 37.760025558456 | -122.40009134316001 | (37.760025558456, -122.40009134316) | ||||
| 186298 | 186298 | 179808 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1401 Cayuga Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 5999197.6114300005 | 2089687.8289299998 | 37.7178386481083 | -122.444759045 | (37.7178386481083, -122.444759045) | |||
| 186152 | 186152 | 193440 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 1775 Silver Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6011367.39112 | 2095333.90709 | 37.7340285952496 | -122.403090198147 | (37.7340285952496, -122.403090198147) | |||
| 186126 | 186126 | 246762 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6009259.9688 | 2098886.63063 | 37.743665689828 | -122.41062704033101 | (37.743665689828, -122.410627040331) | ||||
| 186078 | 186078 | 224160 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1001 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6005289.7901800005 | 2097128.1553900002 | 37.73861392540321 | -122.424229931984 | (37.7386139254032, -122.424229931984) | ||||
| 185980 | 185980 | 132428 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 945 Green St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008612.46815 | 2118979.35525 | 37.798799280808204 | -122.414287281056 | (37.7987992808082, -122.414287281056) | ||||
| 185958 | 185958 | 107058 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 600X Front St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 14 | Permit Number 771755 | 6012887.2102 | 2118277.8013400002 | 37.797112176041004 | -122.39944591049601 | (37.797112176041, -122.399445910496) | ||
| 185940 | 185940 | 196285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2209 25th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012134.59471 | 2101859.1570900003 | 37.7519883551004 | -122.400896021442 | (37.7519883551004, -122.400896021442) | ||||
| 185896 | 185896 | 247105 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 2301 Castro St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002700.647969999 | 2098823.03882 | 37.7431211476283 | -122.433303017637 | (37.7431211476283, -122.433303017637) | ||||
| 185881 | 185881 | 176018 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6009605.36223 | 2089158.99044 | 37.7169750147514 | -122.40874661906 | (37.7169750147514, -122.40874661906) | ||||
| 185848 | 185848 | 132161 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 165 Francisco St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6010552.8238 | 2121311.7929599998 | 37.8053123842132 | -122.407737540175 | (37.8053123842132, -122.407737540175) | ||||
| 185839 | 185839 | 250211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 212 Union St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796002 | (37.80121941579, -122.40351603796) | |||
| 185701 | 185701 | 246440 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 485 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003368.11948 | 2099777.56573 | 37.745779900623 | -122.431063194026 | (37.745779900623, -122.431063194026) | ||||
| 185609 | 185609 | 248127 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.40672522818701 | (37.7452436393873, -122.406725228187) | ||||
| 185592 | 185592 | 191731 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009975.967759999 | 2107617.96239 | 37.76768009039721 | -122.408767140702 | (37.7676800903972, -122.408767140702) | ||||
| 185569 | 185569 | 223999 | Undocumented 2 | Eucalyptus saligna :: Sidney Blue Gum 367 | 1000 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005178.79511 | 2097262.34474 | 37.7389761111702 | -122.424623243294 | (37.7389761111702, -122.424623243294) | ||||
| 185498 | 185498 | 233290 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Eugenia Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6006619.00302 | 2098071.9660799997 | 37.741280382872894 | -122.419701087332 | (37.7412803828729, -122.419701087332) | ||||
| 185402 | 185402 | 250219 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 310 Montgomery St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6011287.59722 | 2120080.15149 | 37.801971704085396 | -122.40510797016 | (37.8019717040854, -122.40510797016) | |||
| 185389 | 185389 | 178268 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 26 Ervine St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009638.638230001 | 2089257.8052599998 | 37.7172482036179 | -122.40863856641899 | (37.7172482036179, -122.408638566419) | ||||
| 185350 | 185350 | 187595 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 745 University St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008748.723069999 | 2090677.61672 | 37.721096827151605 | -122.41181486576099 | (37.7210968271516, -122.411814865761) | ||||
| 185302 | 185302 | 223737 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6002025.38373 | 2098740.99425 | 37.7428575410441 | -122.43563202880699 | (37.7428575410441, -122.435632028807) | ||||
| 185256 | 185256 | 224148 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005206.54925 | 2097441.52928 | 37.739469678882706 | -122.42454002452101 | (37.7394696788827, -122.424540024521) | ||||
| 185231 | 185231 | 197341 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | ||||
| 185207 | 185207 | 246760 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6009218.12342 | 2098889.2056 | 37.7436704139605 | -122.410771913907 | (37.7436704139605, -122.410771913907) | ||||
| 185147 | 185147 | 246639 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 3320 Harrison St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6009035.16234 | 2099239.17175 | 37.744621083714 | -122.41142927065201 | (37.744621083714, -122.411429270652) | ||||
| 185104 | 185104 | 191404 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6016173.59275 | 2100299.3088 | 37.7479298037296 | -122.3868196817 | (37.7479298037296, -122.3868196817) | ||||
| 185057 | 185057 | 220805 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6003673.53965 | 2095753.0634 | 37.7347468423996 | -122.429720104197 | (37.7347468423996, -122.429720104197) | |||
| 185041 | 185041 | 193617 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Tulare St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6016111.33567 | 2100275.95351 | 37.7478622277646 | -122.387033337217 | (37.7478622277646, -122.387033337217) | ||||
| 185030 | 185030 | 108987 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3560 Baker St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999200.334980001 | 2121108.96976 | 37.804113430551894 | -122.447009524696 | (37.8041134305519, -122.447009524696) | ||||
| 184990 | 184990 | 221388 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 671 Church St | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 3ft | 6004298.752230001 | 2105308.1718200003 | 37.7610183389455 | -122.428239289531 | (37.7610183389455, -122.428239289531) | |||
| 184985 | 184985 | 125281 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6006708.63096 | 2119779.53165 | 37.8008892360157 | -122.42093202991 | (37.8008892360157, -122.42093202991) | ||||
| 184956 | 184956 | 249990 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | |||
| 184903 | 184903 | 201683 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010259.3376400005 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | ||||
| 184842 | 184842 | 203176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015380.59839 | 2102345.27771 | 37.753503666864205 | -122.38970472391199 | (37.7535036668642, -122.389704723912) | ||||
| 184814 | 184814 | 207122 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.47234340152399 | (37.7338141267018, -122.472343401524) | |||
| 184802 | 184802 | 249765 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 53 | Width 0ft | 6010998.40684 | 2120702.14433 | 37.8036633729317 | -122.406152556991 | (37.8036633729317, -122.406152556991) | |||
| 184746 | 184746 | 191699 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 50 Quint St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 6ft | 6015737.97927 | 2099766.7157099997 | 37.7464432855229 | -122.388288861864 | (37.7464432855229, -122.388288861864) | |||
| 184653 | 184653 | 126036 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 2100 Jefferson St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999082.9482 | 2121164.53578 | 37.8042592925024 | -122.44741975044501 | (37.8042592925024, -122.447419750445) | ||||
| 184626 | 184626 | 247071 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2401 Castro St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6002776.8237 | 2098415.08611 | 37.7420053254986 | -122.433010482544 | (37.7420053254986, -122.433010482544) | ||||
| 184498 | 184498 | 228514 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 200 Kingston St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006246.808619999 | 2098039.50803 | 37.7411702869721 | -122.420985702322 | (37.7411702869721, -122.420985702322) | ||||
| 184460 | 184460 | 188420 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 602 Arthur Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015754.64256 | 2099883.72463 | 37.746765491048706 | -122.38823940633301 | (37.7467654910487, -122.388239406333) | ||||
| 184411 | 184411 | 245588 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3937 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6002234.37005 | 2103520.06292 | 37.7559915999457 | -122.43525117671801 | (37.7559915999457, -122.435251176718) | ||||
| 184382 | 184382 | 227607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004513.177130001 | 2096122.0643 | 37.735807545078295 | -122.426843458979 | (37.7358075450783, -122.426843458979) | ||||
| 184269 | 184269 | 227602 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657887994 | -122.426906353066 | (37.735757657888, -122.426906353066) | ||||
| 184202 | 184202 | 177807 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 8ft | 6009274.965480001 | 2086528.64182 | 37.7097341062031 | -122.409703090337 | (37.7097341062031, -122.409703090337) | |||
| 184115 | 184115 | 249937 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | |||
| 184049 | 184049 | 249789 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 6010910.8847900005 | 2121034.69861 | 37.804571589270296 | -122.40647888049 | (37.8045715892703, -122.40647888049) | |||
| 184038 | 184038 | 249689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999718.81935 | 2117298.99939 | 37.7936818775552 | -122.444941227873 | (37.7936818775552, -122.444941227873) | ||||
| 184005 | 184005 | 197977 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1301 Minnesota St | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015364.560269999 | 2102275.50149 | 37.7533111867689 | -122.389755314382 | (37.7533111867689, -122.389755314382) | ||||
| 183953 | 183953 | 191827 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 295 San Bruno Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010901.57651 | 2107243.4746 | 37.7667036325957 | -122.405539180706 | (37.7667036325957, -122.405539180706) | ||||
| 183937 | 183937 | 249822 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6010893.58143 | 2120633.6568400003 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | |||
| 183919 | 183919 | 228677 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 190 Storrie St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6000787.94516 | 2105321.30732 | 37.7608551317704 | -122.44038255632 | (37.7608551317704, -122.44038255632) | |||
| 183901 | 183901 | 249915 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 356 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011213.4228 | 2120410.2337700003 | 37.8028738823843 | -122.405387909344 | (37.8028738823843, -122.405387909344) | |||
| 183745 | 183745 | 196351 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6011965.48 | 2105145.22305 | 37.7610017347515 | -122.40171179916901 | (37.7610017347515, -122.401711799169) | ||||
| 183705 | 183705 | 249985 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.40405778055799 | (37.802062092258, -122.404057780558) | |||
| 183690 | 183690 | 249685 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999728.9564 | 2117260.57889 | 37.793576963545796 | -122.444903389791 | (37.7935769635458, -122.444903389791) | ||||
| 183620 | 183620 | 247075 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2401 Castro St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6002772.7491 | 2098496.73645 | 37.7422292872545 | -122.433030403449 | (37.7422292872545, -122.433030403449) | ||||
| 183588 | 183588 | 196335 | Undocumented 2 | Prunus spp :: Cherry 84 | 1900 19th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012008.47004 | 2105145.92381 | 37.761006057794 | -122.401563163706 | (37.761006057794, -122.401563163706) |
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");