Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 104 | 104 | 251210 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1170 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | |||||||||
| 197 | 197 | 251245 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 6002463.96916 | 2095671.24377 | 37.73445361741221 | -122.433896153002 | (37.7344536174122, -122.433896153002) | ||||
| 479 | 479 | 85531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007317.968280001 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | |||
| 487 | 487 | 85532 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007270.64018 | 2109417.23244 | 37.7724685621036 | -122.418252136526 | (37.7724685621036, -122.418252136526) | |||
| 497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
| 501 | 501 | 251171 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:21:00 AM | 3 | ||||||||
| 731 | 731 | 251375 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 747 | 747 | 251378 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 749 | 749 | 251374 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 757 | 757 | 251377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 764 | 764 | 251379 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 785 | 785 | 251376 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 794 | 794 | 212187 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | ||||
| 796 | 796 | 212189 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002068.0773599995 | 2095471.6867 | 37.7338832054473 | -122.435250610137 | (37.7338832054473, -122.435250610137) | ||||
| 797 | 797 | 212191 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002043.865019999 | 2095478.6742 | 37.7339010165159 | -122.435334819059 | (37.7339010165159, -122.435334819059) | ||||
| 801 | 801 | 212193 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 14 | 6002021.19403 | 2095482.3719 | 37.7339098820273 | -122.43541346386002 | (37.7339098820273, -122.43541346386) | ||||
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 1023 | 1023 | 24311 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6006902.669840001 | 2121389.92308 | 37.8053218972443 | -122.420374939461 | (37.8053218972443, -122.420374939461) | ||||
| 1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 1177 | 1177 | 251471 | DPW Maintained 3 | Brugmansia spp :: Angel trumpet 137 | 2423 Market St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 1183 | 1183 | 119797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1185 | 1185 | 119832 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1189 | 1189 | 119798 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1191 | 1191 | 119838 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1196 | 1196 | 119750 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1199 | 1199 | 119799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1201 | 1201 | 119839 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1203 | 1203 | 119796 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1206 | 1206 | 119801 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1208 | 1208 | 119803 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1209 | 1209 | 119800 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1211 | 1211 | 119836 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1219 | 1219 | 119829 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1222 | 1222 | 119837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1223 | 1223 | 119752 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1226 | 1226 | 119830 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1228 | 1228 | 119831 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1230 | 1230 | 119834 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1231 | 1231 | 119833 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1233 | 1233 | 119757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1234 | 1234 | 119748 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1235 | 1235 | 119756 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1272 | 1272 | 251489 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 31 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1277 | 1277 | 212203 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6001598.82808 | 2095593.8833700002 | 37.7341920703926 | -122.436881688932 | (37.7341920703926, -122.436881688932) | ||||
| 1282 | 1282 | 251482 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1283 | 1283 | 251493 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 35 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1286 | 1286 | 251492 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1288 | 1288 | 251487 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 29 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1290 | 1290 | 251486 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 28 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1295 | 1295 | 251491 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 33 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1298 | 1298 | 251490 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 32 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1299 | 1299 | 251494 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 36 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1307 | 1307 | 212207 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 11 | 6001467.5944 | 2095628.72955 | 37.7342802902926 | -122.43733789885 | (37.7342802902926, -122.43733789885) | ||||
| 1316 | 1316 | 251488 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 30 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1320 | 1320 | 251503 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 15 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1322 | 1322 | 251483 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1324 | 1324 | 251501 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 13 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1326 | 1326 | 251502 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 14 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1332 | 1332 | 251484 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1335 | 1335 | 251499 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 11 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1338 | 1338 | 251485 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1341 | 1341 | 251498 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 10 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1348 | 1348 | 251500 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 12 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1355 | 1355 | 29680 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006072.343230001 | 2117086.04016 | 37.7934577026643 | -122.422942314134 | (37.7934577026643, -122.422942314134) | ||||
| 1392 | 1392 | 29683 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2012 12:00:00 AM | 5 | 6006051.34304 | 2117188.93929 | 37.793739052873704 | -122.423022293545 | (37.7937390528737, -122.423022293545) | |||
| 1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
| 1703 | 1703 | 29682 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006057.50051 | 2117137.8264200003 | 37.7935990572132 | -122.422997353566 | (37.7935990572132, -122.422997353566) | ||||
| 1796 | 1796 | 29783 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2000X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 6006016.33701 | 2117432.70817 | 37.794406405577 | -122.423160753176 | (37.794406405577, -122.423160753176) | |||
| 1822 | 1822 | 251717 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000X San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004710.0 | 2096486.0 | 37.736817957153605 | -122.426188866367 | (37.7368179571536, -122.426188866367) | |||||
| 1982 | 1982 | 118349 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 3 | ||||||||
| 2168 | 2168 | 118346 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 3 | ||||||||
| 2179 | 2179 | 252925 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 2186 | 2186 | 252924 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 2333 | 2333 | 253025 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2017 12:00:00 AM | 3 | 5993444.58369 | 2103545.63859 | 37.7555587516047 | -122.465650780273 | (37.7555587516047, -122.465650780273) | |||
| 2581 | 2581 | 107490 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1306x Montgomery St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6011447.18476 | 2119974.7633599997 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | ||||
| 2766 | 2766 | 118353 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 3 | ||||||||
| 3111 | 3111 | 118355 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 3 | ||||||||
| 3394 | 3394 | 118348 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 3 | ||||||||
| 3497 | 3497 | 247942 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.40705728398399 | (37.7437730949632, -122.407057283984) | |||
| 3500 | 3500 | 13943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Permit Number 780155 | 6008953.3362 | 2112197.3558 | 37.780196698058894 | -122.412628072717 | (37.7801966980589, -122.412628072717) | |||
| 3501 | 3501 | 247943 | Planning Code 138.1 required 4 | Maytenus boaria :: Mayten 22 | 29 Joy St | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | |||
| 3506 | 3506 | 247939 | Planning Code 138.1 required 4 | Quercus agrifolia :: Coast Live Oak 180 | 29 Joy St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 12 | Permit Number 775404 | 6010258.299769999 | 2098917.5156900003 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | |||
| 3510 | 3510 | 247941 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.40707457072901 | (37.743786764646, -122.407074570729) | |||
| 3511 | 3511 | 247940 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.2881400003 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | |||
| 3513 | 3513 | 247938 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 29 Joy St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | |||
| 3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 3586 | 3586 | 253468 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 801X Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | ||||||||||
| 3723 | 3723 | 253167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 3794 | 3794 | 29684 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6006028.673359999 | 2117355.72849 | 37.7941957348865 | -122.42311259358699 | (37.7941957348865, -122.423112593587) |
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");