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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186618 | 186618 | 115552 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 15x7 | 6015276.56251 | 2104229.2059299997 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | ||
180919 | 180919 | 115549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | ||
172027 | 172027 | 116857 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 950x Clay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6010080.350930001 | 2117187.65635 | 37.793962057763 | -122.409081415981 | (37.793962057763, -122.409081415981) | ||
168957 | 168957 | 116048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4x4 | 6011498.51602 | 2105372.79225 | 37.7616005195649 | -122.403342842915 | (37.7616005195649, -122.403342842915) | ||
166938 | 166938 | 116059 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011431.5308 | 2105131.75607 | 37.760934946603605 | -122.40355755965099 | (37.7609349466036, -122.403557559651) | ||
163065 | 163065 | 116050 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011499.79329 | 2105331.08163 | 37.76148606285779 | -122.403335490949 | (37.7614860628578, -122.403335490949) | ||
158398 | 158398 | 116058 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011458.59484 | 2105134.56728 | 37.760944177262004 | -122.403464154268 | (37.760944177262, -122.403464154268) | ||
158318 | 158318 | 116046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 5x15 | 6011495.20108 | 2105434.8979700003 | 37.761770862847705 | -122.40335867726002 | (37.7617708628477, -122.40335867726) | ||
155253 | 155253 | 115550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.39018178636199 | (37.7584697654838, -122.390181786362) | ||
145720 | 145720 | 98741 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
144482 | 144482 | 98742 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
143933 | 143933 | 113572 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
142922 | 142922 | 95471 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986558.17112 | 2112222.9767400003 | 37.778984690357 | -122.49010404497 | (37.778984690357, -122.49010404497) | ||
142731 | 142731 | 102192 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
142587 | 142587 | 102023 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
141772 | 141772 | 98748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
141095 | 141095 | 112061 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
140600 | 140600 | 113574 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
140326 | 140326 | 102026 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
140135 | 140135 | 112060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
140063 | 140063 | 74108 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
139365 | 139365 | 98751 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
138350 | 138350 | 98747 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
132178 | 132178 | 116054 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011511.93551 | 2105220.59815 | 37.761183378041395 | -122.403285723377 | (37.7611833780414, -122.403285723377) | ||
130071 | 130071 | 116057 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011480.97635 | 2105135.37266 | 37.760947638753 | -122.40338680266001 | (37.760947638753, -122.40338680266) | ||
129870 | 129870 | 116056 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x Kansas St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011515.191980001 | 2105171.68257 | 37.7610492486475 | -122.40327101944901 | (37.7610492486475, -122.403271019449) | ||
128761 | 128761 | 98739 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 20 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | ||
128300 | 128300 | 102022 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
128247 | 128247 | 116052 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x KANSAS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6011530.0 | 2105347.0 | 37.761531458187 | -122.403232137637 | (37.761531458187, -122.403232137637) | |||
127891 | 127891 | 95465 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986594.5418 | 2111220.3413400003 | 37.7762338621769 | -122.489904464478 | (37.7762338621769, -122.489904464478) | ||
127620 | 127620 | 102189 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
127043 | 127043 | 95458 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986582.44659 | 2111474.61787 | 37.7769313271764 | -122.48996501092199 | (37.7769313271764, -122.489965010922) | |
127011 | 127011 | 102024 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
126702 | 126702 | 98737 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 24 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | ||
126367 | 126367 | 95461 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5986588.1418 | 2111391.86812 | 37.776704452390796 | -122.489939222082 | (37.7767044523908, -122.489939222082) | ||
126306 | 126306 | 70470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
126295 | 126295 | 102028 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
126186 | 126186 | 70471 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 450X Banks St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 32 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
125030 | 125030 | 102033 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
124734 | 124734 | 95452 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986573.32223 | 2111731.4109099996 | 37.7776358751612 | -122.490015466607 | (37.7776358751612, -122.490015466607) | ||
124700 | 124700 | 95475 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986561.73612 | 2112070.55828 | 37.7785664008394 | -122.490080498329 | (37.7785664008394, -122.490080498329) | ||
123118 | 123118 | 112058 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
122742 | 122742 | 102156 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | ||
122089 | 122089 | 95477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986565.00775 | 2112026.27031 | 37.7784449897253 | -122.490065922262 | (37.7784449897253, -122.490065922262) | ||
120907 | 120907 | 78998 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 6 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
120376 | 120376 | 112063 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
120350 | 120350 | 95462 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986590.675530001 | 2111282.39545 | 37.776404019422294 | -122.489922403821 | (37.7764040194223, -122.489922403821) | ||
119479 | 119479 | 113827 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1599x CASTRO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 02/16/2016 05:50:00 AM | 3 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |
118859 | 118859 | 95476 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986563.84754 | 2112047.92011 | 37.778504366165 | -122.490071528655 | (37.778504366165, -122.490071528655) | ||
118717 | 118717 | 102187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3999X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
118537 | 118537 | 95464 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.75422 | 2111242.97331 | 37.7762958987751 | -122.48991231304501 | (37.7762958987751, -122.489912313045) | |
118347 | 118347 | 95483 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.777979727950296 | -122.490036770148 | (37.7779797279503, -122.490036770148) | ||
118157 | 118157 | 102031 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
118133 | 118133 | 73874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
115568 | 115568 | 95457 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986582.95432 | 2111498.49198 | 37.776996908357 | -122.48996501091601 | (37.776996908357, -122.489965010916) | ||
115273 | 115273 | 95481 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | |
114913 | 114913 | 73421 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 450X Banks St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 10 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
114699 | 114699 | 98740 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 20 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | ||
114491 | 114491 | 95467 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 533X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986556.1 | 2112298.0 | 37.779190561911896 | -122.490116729573 | (37.7791905619119, -122.490116729573) | ||
111619 | 111619 | 74109 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
111333 | 111333 | 102034 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
110736 | 110736 | 98753 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
110614 | 110614 | 98755 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
108801 | 108801 | 98744 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 540X Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
108157 | 108157 | 113570 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
107984 | 107984 | 95456 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986576.02446 | 2111660.34524 | 37.7774409068096 | -122.49000089052099 | (37.7774409068096, -122.490000890521) | ||
107741 | 107741 | 95468 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 535X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 53267 | 5986556.7 | 2112284.6 | 37.7791538043677 | -122.49011366804301 | (37.7791538043677, -122.490113668043) |
107003 | 107003 | 102193 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
105856 | 105856 | 113571 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
105405 | 105405 | 98743 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155 Masonic Ave | 5 | Sidewalk: Property side : 26 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5998843.8 | 2112455.0 | 37.7803315496091 | -122.447619999218 | (37.7803315496091, -122.447619999218) | ||||
105164 | 105164 | 102027 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
104766 | 104766 | 95472 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986558.09049 | 2112203.93573 | 37.7789324044573 | -122.49010292295799 | (37.7789324044573, -122.490102922958) | ||
104096 | 104096 | 112062 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/18/2015 12:00:00 AM | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | ||
103838 | 103838 | 102029 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
101877 | 101877 | 102191 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
101641 | 101641 | 78999 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
101167 | 101167 | 102154 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | ||
100398 | 100398 | 95454 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986556.01855 | 2112243.67907 | 37.7790414073553 | -122.49011301465099 | (37.7790414073553, -122.490113014651) | ||
100018 | 100018 | 78992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
99976 | 99976 | 102032 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
98194 | 98194 | 70472 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
96989 | 96989 | 95473 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986560.12785 | 2112162.57896 | 37.778818969517495 | -122.490092832211 | (37.7788189695175, -122.490092832211) | ||
96908 | 96908 | 113825 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/10/2015 12:00:00 AM | 8 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |
95866 | 95866 | 95478 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986565.85749 | 2112005.2728 | 37.7783873861575 | -122.49006143788601 | (37.7783873861575, -122.490061437886) | ||
94912 | 94912 | 98754 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
94860 | 94860 | 102155 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | ||
94177 | 94177 | 95450 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.777740449455294 | -122.49002443626999 | (37.7777404494553, -122.49002443627) | ||
94066 | 94066 | 77325 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/18/1988 12:00:00 AM | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | |
93270 | 93270 | 98756 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
92210 | 92210 | 102025 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
92105 | 92105 | 98750 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
90673 | 90673 | 98752 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
89957 | 89957 | 113573 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007813.0 | 2120272.0 | 37.802303618634795 | -122.417145352251 | (37.8023036186348, -122.417145352251) | |||
88215 | 88215 | 95470 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 539X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986557.7 | 2112257.8 | 37.7790802775989 | -122.49010823686399 | (37.7790802775989, -122.490108236864) | ||
87154 | 87154 | 95463 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.12306 | 2111264.12941 | 37.7763539505765 | -122.489916052727 | (37.7763539505765, -122.489916052727) | |
86909 | 86909 | 120542 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2450 California St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | DPW for City Agency 2 | 6002644.1089699995 | 2115479.97736 | 37.7888538273233 | -122.43468935172599 | (37.7888538273233, -122.434689351726) | ||||
86703 | 86703 | 95460 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.77677535046679 | -122.489949313769 | (37.7767753504668, -122.489949313769) | |
86000 | 86000 | 102186 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3999X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
85371 | 85371 | 95482 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.49004349761299 | (37.7780417630679, -122.490043497613) |
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");