Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
34297 | 34297 | 220329 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4489 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 8ft | 6000090.03644 | 2101642.36493 | 37.7507138925428 | -122.44253216264099 | (37.7507138925428, -122.442532162641) | |||
41613 | 41613 | 228518 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 481 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 8ft | 6002169.605269999 | 2103070.00392 | 37.7547521677948 | -122.435442960743 | (37.7547521677948, -122.435442960743) | |||
41771 | 41771 | 223284 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.28454 | 2099249.93485 | 37.7442535469551 | -122.43575521973801 | (37.7442535469551, -122.435755219738) | |||
45189 | 45189 | 220002 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6009383.355930001 | 2096884.0702099998 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | |||
45522 | 45522 | 221192 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 38 Dolores St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6004728.48786 | 2108042.49071 | 37.7685504308788 | -122.426947766841 | (37.7685504308788, -122.426947766841) | |||
50860 | 50860 | 245727 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 20 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002249.128 | 2105868.24313 | 37.7624399737353 | -122.43536810295299 | (37.7624399737353, -122.435368102953) | |||
53136 | 53136 | 226919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 90 Fountain St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 8ft | 6000343.27555 | 2101131.8365 | 37.7493265362977 | -122.44161980940001 | (37.7493265362977, -122.4416198094) | |||
59515 | 59515 | 220330 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4485 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 8ft | 6000116.06479 | 2101643.1701 | 37.7507175869655 | -122.44244221244499 | (37.7507175869655, -122.442442212445) | |||
63137 | 63137 | 235070 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 215 Downey St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 21 | Width 8ft | 5998946.73151 | 2106903.42094 | 37.7650942121447 | -122.44686432194901 | (37.7650942121447, -122.446864321949) | |||
67975 | 67975 | 222532 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002001.73175 | 2099265.91821 | 37.744297515714 | -122.43575135893101 | (37.744297515714, -122.435751358931) | |||
68299 | 68299 | 176169 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6008410.17529 | 2086203.98853 | 37.7087941752841 | -122.41266903556999 | (37.7087941752841, -122.41266903557) | |||
70316 | 70316 | 222536 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.604180001 | 2099254.59883 | 37.7442663713055 | -122.43575444811898 | (37.7442663713055, -122.435754448119) | |||
71812 | 71812 | 220339 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 581 27th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002773.4167 | 2100032.87717 | 37.7464472092741 | -122.43313782747101 | (37.7464472092741, -122.433137827471) | |||
75268 | 75268 | 231771 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2123 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002709.35623 | 2099334.27137 | 37.744525367058394 | -122.43330942979901 | (37.7445253670584, -122.433309429799) | |||
75644 | 75644 | 233317 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 8ft | 6001489.22958 | 2098922.00585 | 37.7433240886333 | -122.437498855898 | (37.7433240886333, -122.437498855898) | |||
132275 | 132275 | 125715 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 165 Francisco St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6010453.93223 | 2121307.9619 | 37.8052963286168 | -122.408079498365 | (37.8052963286168, -122.408079498365) | |||
133999 | 133999 | 223283 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.55819 | 2099252.37585 | 37.744260264912 | -122.435754448127 | (37.744260264912, -122.435754448127) | |||
148190 | 148190 | 222534 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 8ft | 6002001.170390001 | 2099260.36967 | 37.7442822488393 | -122.43575290309099 | (37.7442822488393, -122.435752903091) | |||
148264 | 148264 | 231487 | Undocumented 2 | Malus :: Crab Apple 235 | 2119 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 8ft | 6002708.75912 | 2099359.82748 | 37.7445955042953 | -122.433313320275 | (37.7445955042953, -122.433313320275) | |||
148744 | 148744 | 226918 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 90 Fountain St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 8ft | 6000342.712069999 | 2101137.2305099997 | 37.749341314846504 | -122.44162214496299 | (37.7493413148465, -122.441622144963) | |||
150339 | 150339 | 222535 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.66396 | 2099257.4887 | 37.7442743096056 | -122.435754448132 | (37.7442743096056, -122.435754448132) | |||
150975 | 150975 | 245724 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 17 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002238.95199 | 2105860.0462 | 37.7624168890453 | -122.435402711587 | (37.7624168890453, -122.435402711587) | |||
151491 | 151491 | 176168 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6008416.5566300005 | 2086198.9199700002 | 37.7087806162127 | -122.412646622645 | (37.7087806162127, -122.412646622645) | |||
156115 | 156115 | 133175 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 8ft | 6010562.9606 | 2122079.77861 | 37.807421649655204 | -122.407756646259 | (37.8074216496552, -122.407756646259) | |||
164386 | 164386 | 223285 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.46161 | 2099247.70726 | 37.7442474405741 | -122.435754448124 | (37.7442474405741, -122.435754448124) | |||
164401 | 164401 | 222530 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002000.54412 | 2099273.2820900003 | 37.7443176677386 | -122.435755992253 | (37.7443176677386, -122.435755992253) | |||
164823 | 164823 | 226270 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4491 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 8ft | 6000072.435819999 | 2101640.71207 | 37.7507083509117 | -122.442592908247 | (37.7507083509117, -122.442592908247) | |||
169393 | 169393 | 245726 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 19 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002246.8756800005 | 2105865.17588 | 37.762431423900296 | -122.435375673468 | (37.7624314239003, -122.435375673468) | |||
169447 | 169447 | 231770 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2127 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002711.64432 | 2099292.5474900003 | 37.7444109328282 | -122.433298537219 | (37.7444109328282, -122.433298537219) | |||
171451 | 171451 | 222533 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002001.23018 | 2099263.25954 | 37.74429018714 | -122.435752903069 | (37.74429018714, -122.435752903069) | |||
173984 | 173984 | 225892 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 5300 Diamond Heights Blvd | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 8ft | 6001517.16924 | 2098900.94096 | 37.743267837842104 | -122.437400739863 | (37.7432678378421, -122.437400739863) | |||
174400 | 174400 | 245728 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 21 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002221.89305 | 2105851.67983 | 37.7623929481978 | -122.43546111354799 | (37.7623929481978, -122.435461113548) | |||
174743 | 174743 | 241120 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 743 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 8ft | 6001715.8268 | 2099681.5159400003 | 37.745422404833704 | -122.436769699986 | (37.7454224048337, -122.436769699986) | |||
174763 | 174763 | 222751 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 465 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 8ft | 6002166.472080001 | 2103160.19285 | 37.7549996270445 | -122.43546024751998 | (37.7549996270445, -122.43546024752) | |||
175864 | 175864 | 200451 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 8ft | 6014956.18254 | 2103836.3549900004 | 37.757574303320204 | -122.391276680392 | (37.7575743033202, -122.391276680392) | |||
178346 | 178346 | 176831 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1567 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 8ft | 5998676.7168 | 2089183.1568 | 37.7164231943611 | -122.446523251341 | (37.7164231943611, -122.446523251341) | |||
178540 | 178540 | 220003 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 8ft | 6009365.07591 | 2096886.4272 | 37.738179459299296 | -122.410122419925 | (37.7381794592993, -122.410122419925) | |||
179667 | 179667 | 222531 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.69845 | 2099269.9426700003 | 37.7443085072419 | -122.43575521973601 | (37.7443085072419, -122.435755219736) | |||
180789 | 180789 | 221193 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 38 Dolores St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6004729.52945 | 2108000.8777 | 37.7684362304735 | -122.42694119996901 | (37.7684362304735, -122.426941199969) | |||
181351 | 181351 | 245725 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 18 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002243.08627 | 2105863.38602 | 37.7624262941732 | -122.43538865158001 | (37.7624262941732, -122.43538865158) | |||
182193 | 182193 | 222529 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002000.5993 | 2099275.94966 | 37.7443249953938 | -122.435755992271 | (37.7443249953938, -122.435755992271) | |||
182447 | 182447 | 222528 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002000.45417 | 2099279.73368 | 37.74433537718021 | -122.43575676478001 | (37.7443353771802, -122.43575676478) | |||
182544 | 182544 | 200450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 8ft | 6014955.45065 | 2103853.5745099997 | 37.7576215438129 | -122.391280415259 | (37.7576215438129, -122.391280415259) | |||
183128 | 183128 | 233318 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 8ft | 6001505.99922 | 2098909.6493900004 | 37.7432911141078 | -122.43743998627501 | (37.7432911141078, -122.437439986275) | |||
187929 | 187929 | 245723 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 16 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002221.88018 | 2105851.05746 | 37.762391238590205 | -122.435461113537 | (37.7623912385902, -122.435461113537) |
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");