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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||||
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) | ||||
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) | |
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) | |||
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) | ||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||
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) | ||
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) | ||
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) | |||
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) | |
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) | |
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) |
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");