Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 43925 | 43925 | 177069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000083.89105 | 2087741.94761 | 37.7125462340909 | -122.44155601691901 | (37.7125462340909, -122.441556016919) | |||
| 26709 | 26709 | 177070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.712548932973206 | -122.44155935339501 | (37.7125489329732, -122.441559353395) | |||
| 148786 | 148786 | 177071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | |||
| 166760 | 166760 | 207853 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 258 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992483.116230001 | 2089580.8821400001 | 37.7171595349616 | -122.467960100499 | (37.7171595349616, -122.467960100499) | |||
| 49286 | 49286 | 207854 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 258 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992483.5365 | 2089596.1759 | 37.717201552190105 | -122.467959759631 | (37.7172015521901, -122.467959759631) | |||
| 29050 | 29050 | 207850 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 277 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994296.2066 | 2089616.42482 | 37.7173616620944 | -122.461695729788 | (37.7173616620944, -122.461695729788) | |||
| 34744 | 34744 | 177051 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.44564302283199 | (37.7191438872553, -122.445643022832) | |||
| 154412 | 154412 | 177052 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998953.787769999 | 2090172.9381799998 | 37.719156729587 | -122.445636697899 | (37.719156729587, -122.445636697899) | |||
| 149576 | 149576 | 177053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998955.229780001 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | |||
| 68735 | 68735 | 177054 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998957.42918 | 2090181.0336799999 | 37.719179165869996 | -122.44562469283001 | (37.71917916587, -122.44562469283) | |||
| 64895 | 64895 | 177055 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998959.63131 | 2090185.20091 | 37.7191907338521 | -122.44561738044399 | (37.7191907338521, -122.445617380444) | |||
| 183308 | 183308 | 177056 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998961.55007 | 2090188.4526900002 | 37.71919977204001 | -122.44561098175801 | (37.71919977204, -122.445610981758) | |||
| 177642 | 177642 | 177057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998963.193390001 | 2090191.18353 | 37.7192073641203 | -122.44560549771799 | (37.7192073641203, -122.445605497718) | |||
| 97569 | 97569 | 177058 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998964.8504 | 2090194.5720900001 | 37.7192167629302 | -122.44560001362801 | (37.7192167629302, -122.445600013628) | |||
| 156675 | 156675 | 177064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 France Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | |||
| 58525 | 58525 | 207855 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993274.09777 | 2090428.4072099999 | 37.719532280163 | -122.46528760316099 | (37.719532280163, -122.465287603161) | |||
| 47662 | 47662 | 207856 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993273.296130001 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | |||
| 130658 | 130658 | 207857 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5993273.27728 | 2090450.4863099998 | 37.7195928567171 | -122.465292042207 | (37.7195928567171, -122.465292042207) | |||
| 55814 | 55814 | 177063 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999015.35979 | 2090528.72065 | 37.7201371416945 | -122.44544943653601 | (37.7201371416945, -122.445449436536) | |||
| 156713 | 156713 | 177062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.720141550179896 | -122.44546243984199 | (37.7201415501799, -122.445462439842) | |||
| 53642 | 53642 | 177061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5999007.9061199995 | 2090532.0864 | 37.720145957757104 | -122.44547544316002 | (37.7201459577571, -122.44547544316) | |||
| 187210 | 187210 | 177060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999004.711019999 | 2090533.4907900002 | 37.7201496314864 | -122.445486588437 | (37.7201496314864, -122.445486588437) | |||
| 64268 | 64268 | 177059 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999000.98419 | 2090535.17383 | 37.7201540399677 | -122.445499591747 | (37.7201540399677, -122.445499591747) | |||
| 35972 | 35972 | 207841 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5994779.70633 | 2090681.1537400002 | 37.72031297444521 | -122.460101600536 | (37.7203129744452, -122.460101600536) | |||
| 150660 | 150660 | 207840 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5994777.11096 | 2090681.2081099998 | 37.7203129744533 | -122.460110575752 | (37.7203129744533, -122.460110575752) | |||
| 72489 | 72489 | 207852 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 442 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5992499.131030001 | 2090773.1201400002 | 37.7204340555615 | -122.467991417565 | (37.7204340555615, -122.467991417565) | |||
| 51892 | 51892 | 177050 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5998727.3573199995 | 2090872.12433 | 37.7210636034854 | -122.446469652679 | (37.7210636034854, -122.446469652679) | |||
| 23612 | 23612 | 177049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998733.2334 | 2090880.1248400002 | 37.721085906663106 | -122.44644991615299 | (37.7210859066631, -122.446449916153) | |||
| 173479 | 173479 | 177048 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998741.12463 | 2090893.49817 | 37.7211230774582 | -122.446423600184 | (37.7211230774582, -122.446423600184) | |||
| 44811 | 44811 | 177047 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998747.58389 | 2090903.38197 | 37.721150585016 | -122.446401983167 | (37.721150585016, -122.446401983167) | |||
| 3827 | 3827 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 7 | Width 5ft | 5998933.177730001 | 2091518.16383 | 37.7228492325857 | -122.44580463279199 | (37.7228492325857, -122.445804632792) | |||
| 3805 | 3805 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998924.5969 | 2091518.7811599998 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | |||
| 3808 | 3808 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369563999 | (37.7228504376851, -122.44574369564) | |||
| 3801 | 3801 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.72285164275971 | -122.445718558684 | (37.7228516427597, -122.445718558684) | |||
| 66212 | 66212 | 177107 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5998942.4469800005 | 2091518.8488599998 | 37.722851642768894 | -122.44577264030701 | (37.7228516427689, -122.445772640307) | |||
| 3826 | 3826 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998921.0818300005 | 2091519.29315 | 37.722851642780796 | -122.44584652679501 | (37.7228516427808, -122.445846526795) | |||
| 177793 | 177793 | 177112 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5998995.97899 | 2091518.17463 | 37.722852847852295 | -122.445587543638 | (37.7228528478523, -122.445587543638) | |||
| 3806 | 3806 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998978.57855 | 2091518.5364400002 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | |||
| 174409 | 174409 | 177111 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5998987.397890001 | 2091518.79195 | 37.7228540529596 | -122.445617250956 | (37.7228540529596, -122.445617250956) | |||
| 149329 | 149329 | 207836 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995005.14377 | 2091917.0493299998 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | |||
| 182511 | 182511 | 207835 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1209 Capitol Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995030.31814 | 2091918.85126 | 37.723725807194704 | -122.459324908222 | (37.7237258071947, -122.459324908222) | |||
| 71850 | 71850 | 177124 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 469 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6007846.143630001 | 2091662.3583799999 | 37.723750042115 | -122.415004493075 | (37.723750042115, -122.415004493075) | |||
| 47270 | 47270 | 207837 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 506 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 1ft | 5994801.27267 | 2091957.06598 | 37.7238175641248 | -122.46011944125799 | (37.7238175641248, -122.460119441258) | |||
| 160540 | 160540 | 207838 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 506 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 1ft | 5994800.95024 | 2091971.89024 | 37.7238582494329 | -122.46012162930401 | (37.7238582494329, -122.460121629304) | |||
| 155186 | 155186 | 177117 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 226 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004541.32921 | 2091944.5690000001 | 37.724338665476104 | -122.42644876989401 | (37.7243386654761, -122.426448769894) | ||||
| 187892 | 187892 | 177123 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 342 Harvard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6006356.99395 | 2092231.60745 | 37.7252292829921 | -122.4201926235 | (37.7252292829921, -122.4201926235) | |||
| 167862 | 167862 | 177122 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 342 Harvard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6006351.771930001 | 2092249.47025 | 37.725278036125495 | -122.420211942723 | (37.7252780361255, -122.420211942723) | |||
| 180646 | 180646 | 177121 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6004588.387180001 | 2092450.0669200001 | 37.7257293114356 | -122.426322070732 | (37.7257293114356, -122.426322070732) | |||
| 76568 | 76568 | 177120 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6004577.78198 | 2092457.96973 | 37.7257504113309 | -122.42635929453999 | (37.7257504113309, -122.42635929454) | |||
| 182185 | 182185 | 177119 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Avalon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6003367.9404 | 2092809.07535 | 37.7266460056919 | -122.430566665719 | (37.7266460056919, -122.430566665719) | |||
| 45149 | 45149 | 177118 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6003359.98068 | 2092814.5992700001 | 37.726660722214 | -122.430594576183 | (37.726660722214, -122.430594576183) | |||
| 31307 | 31307 | 208013 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.84466 | 2093225.77807 | 37.7275391817664 | -122.44585248661001 | (37.7275391817664, -122.44585248661) | ||||
| 36259 | 36259 | 208014 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.765869999 | 2093228.45695 | 37.7275465328469 | -122.44585295156901 | (37.7275465328469, -122.445852951569) | ||||
| 173097 | 173097 | 208015 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5998954.572369999 | 2093232.0746099998 | 37.7275564550483 | -122.445853880569 | (37.7275564550483, -122.445853880569) | ||||
| 50894 | 50894 | 177115 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6005069.55264 | 2093328.8991099999 | 37.7281695777432 | -122.424721208244 | (37.7281695777432, -122.424721208244) | |||
| 59305 | 59305 | 177114 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 6005072.9536 | 2093334.35555 | 37.7281847520053 | -122.42470983899099 | (37.7281847520053, -122.424709838991) | |||
| 75215 | 75215 | 177113 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6005075.07966 | 2093337.7914900002 | 37.728194306415 | -122.42470273344 | (37.728194306415, -122.42470273344) | |||
| 61200 | 61200 | 207832 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 147 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999123.91286 | 2093462.3743099999 | 37.7281984720769 | -122.44528502248001 | (37.7281984720769, -122.44528502248) | ||||
| 69430 | 69430 | 208008 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 247 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998434.03995 | 2093773.3668900002 | 37.72901298084221 | -122.44769230795299 | (37.7290129808422, -122.447692307953) | ||||
| 61831 | 61831 | 207813 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 410 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998661.39505 | 2094413.54813 | 37.7307837594656 | -122.44695237635901 | (37.7307837594656, -122.446952376359) | |||
| 60586 | 60586 | 207937 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.96274 | 2094591.1270299999 | 37.7311633363083 | -122.45349031003201 | (37.7311633363083, -122.453490310032) | |||
| 46018 | 46018 | 207936 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.84945 | 2094603.0079700002 | 37.731195952027996 | -122.453491559201 | (37.731195952028, -122.453491559201) | |||
| 29728 | 29728 | 207935 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996775.70026 | 2094622.40699 | 37.73124932318171 | -122.453486560779 | (37.7312493231817, -122.453486560779) | |||
| 153349 | 153349 | 208006 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998446.5912 | 2094951.6285700002 | 37.7322489268386 | -122.44773370554701 | (37.7322489268386, -122.447733705547) | |||
| 159816 | 159816 | 208005 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998445.88865 | 2094954.90573 | 37.7322578849907 | -122.447736370247 | (37.7322578849907, -122.447736370247) | |||
| 174618 | 174618 | 208003 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5999487.18878 | 2094935.8135400002 | 37.7322649221692 | -122.444135000042 | (37.7322649221692, -122.444135000042) | |||
| 49212 | 49212 | 207992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5999471.24101 | 2094937.00073 | 37.732267272102106 | -122.444190220201 | (37.7322672721021, -122.444190220201) | |||
| 38750 | 38750 | 208004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998446.15319 | 2094958.3543599998 | 37.7322673692323 | -122.447735703852 | (37.7322673692323, -122.447735703852) | |||
| 34135 | 34135 | 208002 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999487.2394900005 | 2094938.2542299998 | 37.7322716266247 | -122.44413500004299 | (37.7322716266247, -122.444135000043) | |||
| 183260 | 183260 | 207993 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5999470.9807400005 | 2094940.5496900002 | 37.732277001865604 | -122.444191374942 | (37.7322770018656, -122.444191374942) | |||
| 169881 | 169881 | 208001 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999487.44652 | 2094940.8443 | 37.732278750160496 | -122.444134470341 | (37.7322787501605, -122.444134470341) | |||
| 151233 | 151233 | 208000 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999487.481380001 | 2094942.52217 | 37.732283359186894 | -122.444134470345 | (37.7322833591869, -122.444134470345) | |||
| 147312 | 147312 | 207994 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999470.93523 | 2094944.41877 | 37.7322876228558 | -122.444191810206 | (37.7322876228558, -122.444191810206) | |||
| 28430 | 28430 | 207999 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5999487.38528 | 2094945.2711599998 | 37.732290901786605 | -122.444135000045 | (37.7322909017866, -122.444135000045) | |||
| 76604 | 76604 | 207995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999470.3608 | 2094946.2688099998 | 37.7322926698604 | -122.44419392902799 | (37.7322926698604, -122.444193929028) | |||
| 184012 | 184012 | 207997 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 5999481.71143 | 2094946.11387 | 37.73229289198321 | -122.444154676308 | (37.7322928919832, -122.444154676308) | |||
| 23905 | 23905 | 207996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999475.26279 | 2094946.5125 | 37.732293618635396 | -122.44417699929 | (37.7322936186354, -122.44417699929) | |||
| 147895 | 147895 | 207998 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5999486.80728 | 2094946.9617700002 | 37.7322955108311 | -122.444137119754 | (37.7322955108311, -122.444137119754) | |||
| 51204 | 51204 | 207991 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 378 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999591.13062 | 2094983.54982 | 37.7324019240113 | -122.44377907894699 | (37.7324019240113, -122.443779078947) | ||||
| 40353 | 40353 | 207983 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 620 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999460.54725 | 2095077.27531 | 37.7326518231051 | -122.44423726735799 | (37.7326518231051, -122.444237267358) | |||
| 57742 | 57742 | 207982 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 620 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999457.28605 | 2095077.61427 | 37.732652567752105 | -122.444248566437 | (37.7326525677521, -122.444248566437) | |||
| 55298 | 55298 | 207980 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 341 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5999148.95483 | 2095220.4410700002 | 37.733027140778 | -122.445324804895 | (37.733027140778, -122.445324804895) | |||
| 165417 | 165417 | 207981 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 337 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5999172.91711 | 2095220.2141099998 | 37.733027885423496 | -122.44524194498301 | (37.7330278854235, -122.445241944983) | |||
| 75870 | 75870 | 207984 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 394 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998812.93096 | 2095267.10672 | 37.7331360864487 | -122.446489879305 | (37.7331360864487, -122.446489879305) | |||
| 183136 | 183136 | 207985 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 394 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998813.609180001 | 2095274.4257 | 37.733156221377 | -122.446488060895 | (37.733156221377, -122.446488060895) | |||
| 176073 | 176073 | 207979 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 6000455.91103 | 2095286.7491099997 | 37.7332837263556 | -122.440811080593 | (37.7332837263556, -122.440811080593) | |||
| 75624 | 75624 | 207863 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 40 Lagunitas Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991134.49125 | 2095574.8768799999 | 37.733539579871504 | -122.47305847768 | (37.7335395798715, -122.47305847768) | |||
| 24370 | 24370 | 207978 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 155 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001108.30575 | 2095400.37488 | 37.733632849462104 | -122.43856371615101 | (37.7336328494621, -122.438563716151) | |||
| 55062 | 55062 | 207989 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 843 Detroit St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999418.49849 | 2095586.86925 | 37.7340486492241 | -122.444419249659 | (37.7340486492241, -122.444419249659) | |||
| 31560 | 31560 | 207988 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 843 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999421.70434 | 2095638.9238900002 | 37.7341917619256 | -122.44441190581101 | (37.7341917619256, -122.444411905811) | |||
| 134404 | 134404 | 207967 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998008.97089 | 2095771.4899 | 37.73447504928421 | -122.44930569891301 | (37.7344750492842, -122.449305698913) | |||
| 147509 | 147509 | 207966 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998008.19389 | 2095778.9308900002 | 37.7344954360226 | -122.449308921174 | (37.7344954360226, -122.449308921174) | |||
| 58696 | 58696 | 207965 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998007.7209 | 2095786.05635 | 37.7345149737803 | -122.44931106965299 | (37.7345149737803, -122.449311069653) | |||
| 63447 | 63447 | 207963 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 41 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5997821.411180001 | 2095826.65809 | 37.734615797675296 | -122.449958126471 | (37.7346157976753, -122.449958126471) | |||
| 176095 | 176095 | 207970 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 63 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998594.466519999 | 2095921.95645 | 37.734921667891506 | -122.44729228142201 | (37.7349216678915, -122.447292281422) |
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");