Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168459 | 168459 | 188642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6018846.51114 | 2097536.89048 | 37.7404923843103 | -122.377385089264 | (37.7404923843103, -122.377385089264) | ||||
| 158166 | 158166 | 188643 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018388.81738 | 2097879.37789 | 37.7414075614118 | -122.378991412446 | (37.7414075614118, -122.378991412446) | ||||
| 44332 | 44332 | 188644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | ||||
| 137062 | 137062 | 188645 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6018140.58939 | 2098064.90862 | 37.7419033019107 | -122.37986259559601 | (37.7419033019107, -122.379862595596) | ||||
| 55759 | 55759 | 188646 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6018092.675340001 | 2098102.14022 | 37.74200288923021 | -122.380030855133 | (37.7420028892302, -122.380030855133) | ||||
| 187551 | 187551 | 188647 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018073.116719999 | 2098111.74487 | 37.7420281826481 | -122.38009915058001 | (37.7420281826481, -122.38009915058) | ||||
| 137718 | 137718 | 188648 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018027.576669999 | 2098147.2670299998 | 37.7421232068329 | -122.380259083311 | (37.7421232068329, -122.380259083311) | ||||
| 41904 | 41904 | 188655 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017659.9469 | 2098420.67777 | 37.7428536469791 | -122.38154925430099 | (37.7428536469791, -122.381549254301) | ||||
| 71743 | 71743 | 195234 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017566.91027 | 2097112.20997 | 37.7392557202661 | -122.38177996546999 | (37.7392557202661, -122.38177996547) | ||||
| 64206 | 64206 | 190913 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 10x Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017428.5626 | 2095806.2606900001 | 37.73566220385221 | -122.38216748876002 | (37.7356622038522, -122.38216748876) | ||||
| 58460 | 58460 | 194518 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 15x Reuel Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017388.67134 | 2096078.81136 | 37.7364083704432 | -122.382324365581 | (37.7364083704432, -122.382324365581) | ||||
| 175369 | 175369 | 188654 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | ||||
| 133833 | 133833 | 188653 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | ||||
| 153654 | 153654 | 188652 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6017392.84765 | 2098647.1595799997 | 37.7434607693943 | -122.382488572792 | (37.7434607693943, -122.382488572792) | ||||
| 136589 | 136589 | 188651 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6017373.9642900005 | 2098663.52344 | 37.7435046581055 | -122.38255500572399 | (37.7435046581055, -122.382555005724) | ||||
| 32031 | 32031 | 190995 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 10x Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.38283280631599 | (37.7358015834667, -122.382832806316) | ||||
| 189069 | 189069 | 195235 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017260.82922 | 2097339.16357 | 37.7398619829554 | -122.382854057268 | (37.7398619829554, -122.382854057268) | ||||
| 162122 | 162122 | 195236 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017248.0064199995 | 2097338.05613 | 37.7398582336715 | -122.382898316528 | (37.7398582336715, -122.382898316528) | ||||
| 70908 | 70908 | 195237 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017245.0547 | 2097350.40694 | 37.7398919834226 | -122.38290938175699 | (37.7398919834226, -122.382909381757) | ||||
| 149614 | 149614 | 195238 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6017232.2408 | 2097349.7546 | 37.7398894842228 | -122.382953641924 | (37.7398894842228, -122.382953641924) | ||||
| 76154 | 76154 | 195239 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017229.97011 | 2097361.8640799997 | 37.739922608954394 | -122.38296233565 | (37.7399226089544, -122.38296233565) | ||||
| 32926 | 32926 | 195231 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300x Evans Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6017124.15925 | 2097442.52392 | 37.7401382376012 | -122.38333380241001 | (37.7401382376012, -122.38333380241) | |||
| 40010 | 40010 | 113539 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | ||||
| 88481 | 88481 | 113536 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 96850 | 96850 | 113535 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12/05/2015 12:49:00 PM | 3 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||
| 103732 | 103732 | 113537 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 104927 | 104927 | 113538 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 148507 | 148507 | 195232 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300x Evans Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 6017081.8167 | 2097473.87775 | 37.740221988756105 | -122.383482389326 | (37.7402219887561, -122.383482389326) | |||
| 119608 | 119608 | 188659 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6017103.6349 | 2098887.87453 | 37.744105743386 | -122.383505361577 | (37.744105743386, -122.383505361577) | ||||
| 71608 | 71608 | 188660 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017087.3290800005 | 2098898.6066400004 | 37.7441343103446 | -122.38356249103902 | (37.7441343103446, -122.383562491039) | ||||
| 89300 | 89300 | 195233 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300x Evans Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6017040.627309999 | 2097503.91536 | 37.740302189387 | -122.383626897758 | (37.740302189387, -122.383626897758) | ||||
| 152285 | 152285 | 199383 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400x Cargo Way | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6017000.482369999 | 2098965.68052 | 37.7443136810333 | -122.38386746011801 | (37.7443136810333, -122.383867460118) | ||||
| 154902 | 154902 | 191501 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6016915.88272 | 2095866.14342 | 37.735798300938704 | -122.383944206463 | (37.7357983009387, -122.383944206463) | ||||
| 133804 | 133804 | 111782 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299X Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016893.15772 | 2095859.5830599999 | 37.7357790311769 | -122.38402231977 | (37.7357790311769, -122.38402231977) | ||||
| 46910 | 46910 | 116450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299X Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6016873.48707 | 2095860.59847 | 37.735780731778895 | -122.384090400246 | (37.7357807317789, -122.384090400246) | ||||
| 133969 | 133969 | 188661 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6016926.49281 | 2099019.67279 | 37.7444578423491 | -122.384127062023 | (37.7444578423491, -122.384127062023) | ||||
| 43128 | 43128 | 196270 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | ||||
| 29345 | 29345 | 196269 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.38418909364599 | (37.7366779736991, -122.384189093646) | ||||
| 28030 | 28030 | 197577 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691002 | (37.735854408739, -122.38427457691) | ||||
| 165542 | 165542 | 197578 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6016803.94707 | 2095896.67464 | 37.7358759448203 | -122.384333341329 | (37.7358759448203, -122.384333341329) | ||||
| 134097 | 134097 | 189485 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Garlington Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016768.7449900005 | 2094679.8943900003 | 37.7325329624249 | -122.384370330438 | (37.7325329624249, -122.384370330438) | |||
| 42374 | 42374 | 192668 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 299x Cashmere St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016780.4943 | 2095894.1585799998 | 37.73586773939579 | -122.384414252424 | (37.7358677393958, -122.384414252424) | ||||
| 71073 | 71073 | 199399 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016725.29246 | 2095937.31293 | 37.7359831799735 | -122.38460811386999 | (37.7359831799735, -122.38460811387) | ||||
| 169095 | 169095 | 199401 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6016684.16305 | 2095970.28806 | 37.7360714484387 | -122.38475261246799 | (37.7360714484387, -122.384752612468) | ||||
| 68100 | 68100 | 194503 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016679.95616 | 2095990.1573599998 | 37.7361257728833 | -122.38476854124399 | (37.7361257728833, -122.384768541244) | ||||
| 69972 | 69972 | 194504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6016665.2898 | 2096001.51106 | 37.7361561367049 | -122.38482004001001 | (37.7361561367049, -122.38482004001) | ||||
| 184281 | 184281 | 199402 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016663.61896 | 2095979.5906099998 | 37.736095855134394 | -122.384824290234 | (37.7360958551344, -122.384824290234) | ||||
| 156780 | 156780 | 199403 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016641.57283 | 2096000.10584 | 37.7361509664773 | -122.384901942178 | (37.7361509664773, -122.384901942178) | ||||
| 50657 | 50657 | 187735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 299x Cashmere St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016637.03713 | 2096003.6378799998 | 37.7361604138763 | -122.384917870088 | (37.7361604138763, -122.384917870088) | ||||
| 50131 | 50131 | 199404 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6016629.65755 | 2096008.94769 | 37.7361745853726 | -122.38494375437 | (37.7361745853726, -122.38494375437) | ||||
| 171534 | 171534 | 194505 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016625.92106 | 2096014.8365599997 | 37.7361905483545 | -122.384957083216 | (37.7361905483545, -122.384957083216) | ||||
| 36172 | 36172 | 194506 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016624.93937 | 2096021.7822099999 | 37.7362095654157 | -122.38496096110501 | (37.7362095654157, -122.384960961105) | ||||
| 39942 | 39942 | 194507 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016618.68245 | 2096023.0251200001 | 37.7362126321093 | -122.384982680622 | (37.7362126321093, -122.384982680622) | ||||
| 36701 | 36701 | 194508 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6016611.71691 | 2096022.49532 | 37.7362107920965 | -122.385006726687 | (37.7362107920965, -122.385006726687) | ||||
| 53526 | 53526 | 188662 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6016659.34022 | 2099218.12626 | 37.7449879810223 | -122.38506465383101 | (37.7449879810223, -122.385064653831) | ||||
| 159868 | 159868 | 190994 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 50x Dedman Ct | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6016552.89235 | 2096279.67285 | 37.736913695911 | -122.385228023775 | (37.736913695911, -122.385228023775) | ||||
| 53966 | 53966 | 191502 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6016510.31046 | 2096089.32701 | 37.736388688783705 | -122.38536198946899 | (37.7363886887837, -122.385361989469) | ||||
| 67725 | 67725 | 189321 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 299x Cashmere St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6016453.45941 | 2096140.5163099999 | 37.7365260988976 | -122.38556211562 | (37.7365260988976, -122.38556211562) | ||||
| 142482 | 142482 | 96128 | DPW Maintained 3 | Tree(s) :: 17 | 1420X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016441.6 | 2096581.1 | 37.7377351967413 | -122.385633815961 | (37.7377351967413, -122.385633815961) | ||||
| 102603 | 102603 | 96129 | DPW Maintained 3 | Tree(s) :: 17 | 1424X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016423.9 | 2096594.4 | 37.7377707364606 | -122.385695940665 | (37.7377707364606, -122.385695940665) | ||||
| 41450 | 41450 | 189322 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 299x Cashmere St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6016409.152290001 | 2096168.4415799999 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | ||||
| 94441 | 94441 | 96130 | DPW Maintained 3 | Tree(s) :: 17 | 1428X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016403.1 | 2096603.7 | 37.737795121412795 | -122.385768505015 | (37.7377951214128, -122.385768505015) | ||||
| 40944 | 40944 | 189323 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 301x Cashmere St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6016365.09613 | 2096197.7024299998 | 37.736678230916795 | -122.38587161279499 | (37.7366782309168, -122.385871612795) | ||||
| 35636 | 35636 | 187736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016350.44721 | 2096194.4230400003 | 37.7366684157019 | -122.38592203240101 | (37.7366684157019, -122.385922032401) | ||||
| 173646 | 173646 | 195240 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Evans Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016376.5567 | 2097988.3018 | 37.7415954882544 | -122.385956766892 | (37.7415954882544, -122.385956766892) | ||||
| 153771 | 153771 | 199428 | DPW Maintained 3 | Ficus Spp. :: 253 | 1427x Innes Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016347.26409 | 2096602.7687900001 | 37.7377894745941 | -122.385961493726 | (37.7377894745941, -122.385961493726) | ||||
| 27106 | 27106 | 195241 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Evans Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6016370.1217 | 2098002.92096 | 37.7416352733631 | -122.38598003597299 | (37.7416352733631, -122.385980035973) | ||||
| 109811 | 109811 | 96135 | DPW Maintained 3 | Tree(s) :: 17 | 1444X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016335.2 | 2096661.0 | 37.7379486980737 | -122.386007263552 | (37.7379486980737, -122.386007263552) | ||||
| 185837 | 185837 | 189989 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1427x Innes Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6016321.76004 | 2096621.1016 | 37.737838401311706 | -122.386050952014 | (37.7378384013117, -122.386050952014) | ||||
| 70561 | 70561 | 195242 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Evans Ave | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6016348.05088 | 2098008.79915 | 37.7416501921989 | -122.38605675982099 | (37.7416501921989, -122.386056759821) | ||||
| 176097 | 176097 | 190644 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 1427x Innes Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016311.73446 | 2096627.56435 | 37.7378555918516 | -122.38608606604299 | (37.7378555918516, -122.386086066043) | ||||
| 149672 | 149672 | 190645 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 1427x Innes Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016289.875580001 | 2096646.78665 | 37.737907162586396 | -122.38616298323 | (37.7379071625864, -122.38616298323) | ||||
| 82638 | 82638 | 96136 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 115913 | 115913 | 96138 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 129100 | 129100 | 96137 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 55441 | 55441 | 199405 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301x Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016273.90453 | 2096214.7321400002 | 37.736719944173004 | -122.386188091409 | (37.736719944173, -122.386188091409) | ||||
| 91583 | 91583 | 96139 | DPW Maintained 3 | Tree(s) :: 17 | 1460X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016261.2 | 2096710.2 | 37.738079695647706 | -122.386266549459 | (37.7380796956477, -122.386266549459) | ||||
| 144035 | 144035 | 96140 | DPW Maintained 3 | Tree(s) :: 17 | 1460X Innes Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016261.2 | 2096710.2 | 37.738079695647706 | -122.386266549459 | (37.7380796956477, -122.386266549459) | ||||
| 153730 | 153730 | 195015 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1427x Innes Ave | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6016257.183540001 | 2096668.3945900002 | 37.737964684134 | -122.38627752271299 | (37.737964684134, -122.386277522713) | ||||
| 24270 | 24270 | 188526 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1427x Innes Ave | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6016254.90623 | 2096663.3838099998 | 37.7379507994938 | -122.386285047323 | (37.7379507994938, -122.386285047323) | ||||
| 55018 | 55018 | 189324 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6016254.7178 | 2096666.0363099999 | 37.7379580722924 | -122.386285883701 | (37.7379580722924, -122.386285883701) | ||||
| 56776 | 56776 | 187772 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427x Innes Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016235.94312 | 2096682.30704 | 37.7380017092031 | -122.3863519317 | (37.7380017092031, -122.3863519317) | ||||
| 161690 | 161690 | 199406 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301x Cashmere St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016219.39095 | 2096203.7669400002 | 37.7366868185504 | -122.38637580600599 | (37.7366868185504, -122.386375806006) | ||||
| 79938 | 79938 | 96141 | DPW Maintained 3 | Tree(s) :: 17 | 1468X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | ||||
| 145563 | 145563 | 96142 | DPW Maintained 3 | Tree(s) :: 17 | 1468X Innes Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | ||||
| 36635 | 36635 | 189990 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1427x Innes Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016227.39671 | 2096690.1847299999 | 37.7380228666701 | -122.386382030231 | (37.7380228666701, -122.386382030231) | ||||
| 145598 | 145598 | 96143 | DPW Maintained 3 | Tree(s) :: 17 | 1470X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016219.9 | 2096747.5 | 37.738179827823 | -122.38641194538201 | (37.738179827823, -122.386411945382) | ||||
| 166453 | 166453 | 189325 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6016204.94299 | 2096703.88094 | 37.73805923075761 | -122.386460619275 | (37.7380592307576, -122.386460619275) | ||||
| 24866 | 24866 | 189991 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1427x Innes Ave | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6016204.83732 | 2096710.6252 | 37.7380777432808 | -122.386461454743 | (37.7380777432808, -122.386461454743) | ||||
| 28724 | 28724 | 199407 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301x Cashmere St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016184.136419999 | 2096191.07332 | 37.736650012889 | -122.386496812495 | (37.736650012889, -122.386496812495) | ||||
| 58189 | 58189 | 190989 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016178.9228300005 | 2096206.88071 | 37.7366931281786 | -122.386515940161 | (37.7366931281786, -122.386515940161) | ||||
| 72110 | 72110 | 189326 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016187.80706 | 2096717.46995 | 37.7380955948279 | -122.386520814503 | (37.7380955948279, -122.386520814503) | ||||
| 40086 | 40086 | 190990 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6016177.273030001 | 2096204.98812 | 37.7366878401785 | -122.38652151236201 | (37.7366878401785, -122.386521512362) | ||||
| 125889 | 125889 | 189327 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6016185.549980001 | 2096725.46158 | 37.7381174132775 | -122.386529175505 | (37.7381174132775, -122.386529175505) | ||||
| 173471 | 173471 | 189328 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6016180.048909999 | 2096728.46226 | 37.7381253480046 | -122.386548404801 | (37.7381253480046, -122.386548404801) | ||||
| 60010 | 60010 | 189329 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016170.50674 | 2096734.9149900002 | 37.7381425376441 | -122.386581846976 | (37.7381425376441, -122.386581846976) | ||||
| 163246 | 163246 | 187737 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016156.13559 | 2096195.78467 | 37.7366613992076 | -122.386593952757 | (37.7366613992076, -122.386593952757) | ||||
| 31115 | 31115 | 189330 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | ||||
| 153230 | 153230 | 189331 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016158.581590001 | 2096743.10155 | 37.7381643560956 | -122.38662364926701 | (37.7381643560956, -122.386623649267) | ||||
| 58370 | 58370 | 187738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016145.734540001 | 2096191.5007099998 | 37.7366490605065 | -122.38662961537399 | (37.7366490605065, -122.386629615374) |
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");