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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 272 | 272 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 6592 | 6592 | 98837 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 9596 | 9596 | 102839 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 14567 | 14567 | 98839 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 176642 | 176642 | 178078 | Undocumented 2 | Persea americana :: Avocado 113 | 230 Rhine St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5994079.51921 | 2086287.10063 | 37.7082076509257 | -122.46220339079399 | (37.7082076509257, -122.462203390794) | |||
| 24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
| 131206 | 131206 | 179380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5993077.06779 | 2086425.7469099998 | 37.7085305695939 | -122.46567800964199 | (37.7085305695939, -122.465678009642) | |||
| 77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
| 48697 | 48697 | 177826 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 89 Belle Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5991639.3875 | 2086487.5926299999 | 37.708617351468895 | -122.47065126593999 | (37.7086173514689, -122.47065126594) | |||
| 154719 | 154719 | 178860 | Undocumented 2 | Prunus laurocerasus :: English laurel 227 | 89 Belle Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5991691.410619999 | 2086487.07285 | 37.708618932476504 | -122.470471431226 | (37.7086189324765, -122.470471431226) | |||
| 146626 | 146626 | 179832 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 89 Belle Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5991610.51667 | 2086489.35195 | 37.708620512585895 | -122.470751174349 | (37.7086205125859, -122.470751174349) | |||
| 82512 | 82512 | 176641 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 89 Belle Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5991622.07464 | 2086489.1085299999 | 37.708620512601705 | -122.47071121118 | (37.7086205126017, -122.47071121118) | |||
| 159960 | 159960 | 178246 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 334 Schwerin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 8ft | 6008498.73338 | 2086169.5102900001 | 37.7087044750874 | -122.412360530312 | (37.7087044750874, -122.412360530312) | |||
| 57617 | 57617 | 177094 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.708957449004394 | -122.464678768412 | (37.7089574490044, -122.464678768412) | |||
| 131503 | 131503 | 177093 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | |||
| 171783 | 171783 | 177092 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | |||
| 48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
| 68489 | 68489 | 176113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Santa Barbara Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993424.30452 | 2086604.0814 | 37.709040256765 | -122.464490865868 | (37.709040256765, -122.464490865868) | |||
| 51044 | 51044 | 176285 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 Santa Barbara Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993431.64495 | 2086606.10767 | 37.7090462435678 | -122.464465643484 | (37.7090462435678, -122.464465643484) | |||
| 170072 | 170072 | 177090 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 36 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5993074.958319999 | 2086622.9468 | 37.7090719120225 | -122.46569961766001 | (37.7090719120225, -122.46569961766) | |||
| 42963 | 42963 | 113115 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 81845 | 81845 | 113126 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 82974 | 82974 | 113119 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 84245 | 84245 | 113122 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 84522 | 84522 | 113121 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 85460 | 85460 | 113113 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 88545 | 88545 | 113118 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 94966 | 94966 | 113130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95231 | 95231 | 113127 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 97630 | 97630 | 113116 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1x TOMASO CT | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 100041 | 100041 | 113128 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109788 | 109788 | 113131 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109839 | 109839 | 113123 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 120329 | 120329 | 113129 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 126278 | 126278 | 113114 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 138402 | 138402 | 113117 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 141988 | 141988 | 113120 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1x TOMASO CT | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 62750 | 62750 | 175647 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 199 Shakespeare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5993520.37631 | 2086668.28967 | 37.7092220951912 | -122.464163488366 | (37.7092220951912, -122.464163488366) | |||
| 65399 | 65399 | 178428 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 316 Naylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6002738.37223 | 2086564.4862099998 | 37.709464058702295 | -122.43229727250099 | (37.7094640587023, -122.432297272501) | ||||
| 47078 | 47078 | 178427 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 316 Naylor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6002735.2545300005 | 2086567.4908099999 | 37.7094721319023 | -122.43230826222799 | (37.7094721319023, -122.432308262228) | ||||
| 135543 | 135543 | 175885 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2249 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 5996106.65685 | 2086744.5034 | 37.709580085622896 | -122.455230455925 | (37.7095800856229, -122.455230455925) | |||
| 145739 | 145739 | 176592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2249 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5996118.04902 | 2086754.98706 | 37.70960952494271 | -122.455191839948 | (37.7096095249427, -122.455191839948) | |||
| 76107 | 76107 | 187484 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 701 Velasco Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6006683.55132 | 2086560.9884900001 | 37.7096773634854 | -122.418661795732 | (37.7096773634854, -122.418661795732) | |||
| 45093 | 45093 | 176361 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 33 Burr Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6007913.680380001 | 2086634.77605 | 37.70994915030529 | -122.414415456032 | (37.7099491503053, -122.414415456032) | |||
| 54048 | 54048 | 179198 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 122 Santos St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6006476.020330001 | 2086698.2398299999 | 37.7100425404106 | -122.41938879147 | (37.7100425404106, -122.41938879147) | |||
| 51527 | 51527 | 179437 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006551.53826 | 2086713.5575599999 | 37.71008885278471 | -122.419128872099 | (37.7100888527847, -122.419128872099) | |||
| 185448 | 185448 | 178522 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997828.42227 | 2086900.0351099998 | 37.7101057753261 | -122.449290962629 | (37.7101057753261, -122.449290962629) | |||
| 132286 | 132286 | 179436 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | |||
| 158631 | 158631 | 179435 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006500.6084199995 | 2086740.91409 | 37.710161099825 | -122.41930683535 | (37.710161099825, -122.41930683535) | |||
| 186453 | 186453 | 178523 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997858.27775 | 2086928.7713 | 37.7101863860532 | -122.449189845558 | (37.7101863860532, -122.449189845558) | |||
| 37416 | 37416 | 178201 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 6ft | 6006581.55782 | 2086756.79488 | 37.7102092639221 | -122.419028183127 | (37.7102092639221, -122.419028183127) | |||
| 46358 | 46358 | 179434 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6006514.55403 | 2086760.1932299999 | 37.710214821715496 | -122.419260003144 | (37.7102148217155, -122.419260003144) | |||
| 175446 | 175446 | 178524 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5997869.35085 | 2086941.7630200002 | 37.7102226917018 | -122.44915251020599 | (37.7102226917018, -122.449152510206) | |||
| 152518 | 152518 | 178525 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997892.95524 | 2086962.1133599998 | 37.710279919152704 | -122.44907239407401 | (37.7102799191527, -122.449072394074) | |||
| 51699 | 51699 | 179433 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6006535.42412 | 2086786.7518099998 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | |||
| 172986 | 172986 | 178202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 6ft | 6006601.88887 | 2086790.1113 | 37.710301888699796 | -122.418960276213 | (37.7103018886998, -122.418960276213) | |||
| 48306 | 48306 | 179432 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 122 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006549.425009999 | 2086808.7283400001 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | |||
| 42182 | 42182 | 178526 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997920.74376 | 2086988.8754200002 | 37.710354990967105 | -122.448978278229 | (37.7103549909671, -122.448978278229) | |||
| 55872 | 55872 | 178527 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997931.98579 | 2086999.1742900002 | 37.7103839122559 | -122.448940164984 | (37.7103839122559, -122.448940164984) | |||
| 172306 | 172306 | 178528 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997956.06337 | 2087020.6353099998 | 37.7104442162958 | -122.448858493027 | (37.7104442162958, -122.448858493027) | |||
| 176399 | 176399 | 179357 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007215.96527 | 2086835.5457 | 37.71046120179479 | -122.416841112839 | (37.7104612017948, -122.416841112839) | |||
| 157371 | 157371 | 179356 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007201.1629800005 | 2086840.57155 | 37.710474169120204 | -122.416892628694 | (37.7104741691202, -122.416892628694) | |||
| 25067 | 25067 | 179355 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6007191.75083 | 2086844.1379 | 37.7104834321401 | -122.41692541169901 | (37.7104834321401, -122.416925411699) | |||
| 92201 | 92201 | 176628 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3067 Alemany Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5996456.31752 | 2087068.2457400002 | 37.7104890628041 | -122.454045341035 | (37.7104890628041, -122.454045341035) | |||
| 168544 | 168544 | 179354 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6007178.2893 | 2086848.4615900002 | 37.7104945468639 | -122.41697224389999 | (37.7104945468639, -122.4169722439) | |||
| 173721 | 173721 | 179353 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007163.47347 | 2086852.8130299998 | 37.710505661580896 | -122.417023758845 | (37.7105056615809, -122.417023758845) | |||
| 155848 | 155848 | 178895 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 240 Concord St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999918.78145 | 2087003.9139 | 37.7105103506437 | -122.44207374220801 | (37.7105103506437, -122.442073742208) | |||
| 171027 | 171027 | 179352 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007138.6649400005 | 2086865.4653599998 | 37.710539006644794 | -122.41711039862301 | (37.7105390066448, -122.417110398623) | |||
| 157586 | 157586 | 179441 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007125.21698 | 2086870.4635 | 37.7105519739575 | -122.417157231746 | (37.7105519739575, -122.417157231746) | |||
| 2015 | 2015 | 251655 | DPW Maintained 3 | Shrub :: Shrub 98 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5991691.0 | 2087193.0 | 37.710557214846794 | -122.47052422929701 | (37.7105572148468, -122.470524229297) | ||||
| 63849 | 63849 | 178200 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 122 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 6ft | 6006610.83252 | 2086895.84997 | 37.710592728548605 | -122.418936859664 | (37.7105927285486, -122.418936859664) | |||
| 161232 | 161232 | 179438 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 163 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006665.75653 | 2086898.09687 | 37.7106019906608 | -122.41874718904499 | (37.7106019906608, -122.418747189045) | |||
| 40375 | 40375 | 179440 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | |||
| 163435 | 163435 | 179431 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 121 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006605.70519 | 2086910.12298 | 37.7106316305231 | -122.418955592547 | (37.7106316305231, -122.418955592547) | |||
| 54669 | 54669 | 179439 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Blythdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006794.78813 | 2086912.99237 | 37.7106501547416 | -122.418302281839 | (37.7106501547416, -122.418302281839) | |||
| 31551 | 31551 | 179200 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006727.82618 | 2086918.41314 | 37.7106612694605 | -122.418534101884 | (37.7106612694605, -122.418534101884) | |||
| 26875 | 26875 | 179199 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006710.21835 | 2086918.77417 | 37.710661269476 | -122.41859498419 | (37.710661269476, -122.41859498419) | |||
| 187965 | 187965 | 179351 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006769.15045 | 2086918.2406 | 37.7106631220796 | -122.41839126344601 | (37.7106631220796, -122.418391263446) | |||
| 163628 | 163628 | 178129 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 345 Tocoloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012554.38724 | 2086809.43241 | 37.7106883309719 | -122.398388432799 | (37.7106883309719, -122.398388432799) | |||
| 32064 | 32064 | 178199 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 6ft | 6006562.8379999995 | 2086935.5981299998 | 37.7106991659919 | -122.419105557176 | (37.7106991659919, -122.419105557176) | |||
| 137591 | 137591 | 178198 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 6ft | 6006547.0126 | 2086935.9227099998 | 37.71069916600771 | -122.419160276437 | (37.7106991660077, -122.419160276437) | |||
| 182806 | 182806 | 178197 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 6ft | 6006521.5193300005 | 2086937.9712099999 | 37.7107033550432 | -122.419248532308 | (37.7107033550432, -122.419248532308) | |||
| 60393 | 60393 | 176642 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993005.954030001 | 2087230.75027 | 37.7107368152174 | -122.465982240383 | (37.7107368152174, -122.465982240383) | |||
| 130769 | 130769 | 176644 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992981.09091 | 2087231.27267 | 37.7107368152211 | -122.466068210177 | (37.7107368152211, -122.466068210177) | |||
| 153643 | 153643 | 176643 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992994.85836 | 2087232.28697 | 37.7107403945151 | -122.46602070080401 | (37.7107403945151, -122.466020700804) | |||
| 176861 | 176861 | 178196 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 147 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 6ft | 6006332.21017 | 2086970.8429400001 | 37.710782950433995 | -122.41990515969 | (37.710782950434, -122.41990515969) | |||
| 67886 | 67886 | 181273 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 5993253.89248 | 2087254.87445 | 37.710817354905295 | -122.465127066954 | (37.7108173549053, -122.465127066954) | |||
| 53378 | 53378 | 176489 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 328 Palmetto Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5993263.72067 | 2087255.31983 | 37.7108191445486 | -122.465093131069 | (37.7108191445486, -122.465093131069) | |||
| 147977 | 147977 | 181274 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 5993286.62087 | 2087254.83892 | 37.7108191445702 | -122.46501394844 | (37.7108191445702, -122.46501394844) | |||
| 160335 | 160335 | 179202 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 50 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6006615.933569999 | 2086979.4031 | 37.710822435165205 | -122.41892515139799 | (37.7108224351652, -122.418925151398) |
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");