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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38825 | 38825 | 186910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2700 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985181.9251 | 2096700.884 | 37.7362848611965 | -122.49372085206998 | (37.7362848611965, -122.49372085207) | |||
| 42940 | 42940 | 227287 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 689 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6002120.490069999 | 2098829.19814 | 37.74310512978921 | -122.435309486038 | (37.7431051297892, -122.435309486038) | ||||
| 24921 | 24921 | 185624 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.74612969593421 | -122.49450180509399 | (37.7461296959342, -122.494501805094) | |||
| 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) | ||||
| 47166 | 47166 | 227292 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1831 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002653.15618 | 2100170.70248 | 37.746818822623894 | -122.433563522461 | (37.7468188226239, -122.433563522461) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 24079 | 24079 | 207947 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992701.4282599995 | 2100499.03593 | 37.74715067337829 | -122.467999226394 | (37.7471506733783, -122.467999226394) | |||
| 26392 | 26392 | 207957 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995759.15859 | 2100245.2253900003 | 37.7466298786655 | -122.45740754733102 | (37.7466298786655, -122.457407547331) | |||
| 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) | |||
| 27197 | 27197 | 207942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992674.85425 | 2100498.92504 | 37.7471488342516 | -122.468091108325 | (37.7471488342516, -122.468091108325) | |||
| 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) | |||
| 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) | |||
| 45456 | 45456 | 207958 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995753.89015 | 2100245.5855099997 | 37.7466305648554 | -122.457425790981 | (37.7466305648554, -122.457425790981) | |||
| 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) | |||
| 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) | |||
| 50587 | 50587 | 207962 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995734.92484 | 2100251.73667 | 37.7466463650506 | -122.45749181558998 | (37.7466463650506, -122.45749181559) | |||
| 51405 | 51405 | 207949 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992678.23044 | 2100499.52384 | 37.74715067338229 | -122.468079477383 | (37.7471506733823, -122.468079477383) | |||
| 52389 | 52389 | 207960 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995744.16421 | 2100249.0413599997 | 37.7466394951101 | -122.457459672038 | (37.7466394951101, -122.457459672038) | |||
| 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) | |||
| 54549 | 54549 | 227289 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 687 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002191.96194 | 2098829.02358 | 37.743108709092496 | -122.435062343346 | (37.7431087090925, -122.435062343346) | ||||
| 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) | |||
| 59136 | 59136 | 207944 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992687.64397 | 2100499.32584 | 37.7471506733621 | -122.468046912034 | (37.7471506733621, -122.468046912034) | |||
| 59534 | 59534 | 207961 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995740.66413 | 2100249.86529 | 37.7466415563731 | -122.457471834475 | (37.7466415563731, -122.457471834475) | |||
| 59953 | 59953 | 207945 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992693.35222 | 2100498.87072 | 37.7471497533695 | -122.46802714043501 | (37.7471497533695, -122.468027140435) | |||
| 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) | |||
| 62185 | 62185 | 227290 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 685 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | ||||
| 67836 | 67836 | 207948 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992690.99199 | 2100498.58562 | 37.7471488342554 | -122.468035281115 | (37.7471488342554, -122.468035281115) | |||
| 70419 | 70419 | 227286 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 691 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002107.89107 | 2098826.5345400004 | 37.743097100666 | -122.435352859445 | (37.743097100666, -122.435352859445) | ||||
| 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) | |||
| 131196 | 131196 | 207959 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.658340001 | 2100247.6965 | 37.7466360605992 | -122.45744403462 | (37.7466360605992, -122.45744403462) | |||
| 132779 | 132779 | 227268 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001722.7938 | 2099972.97988 | 37.7462230919366 | -122.436766469611 | (37.7462230919366, -122.436766469611) | |||
| 148265 | 148265 | 207950 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992685.27644 | 2100498.70583 | 37.747148834247795 | -122.468055053599 | (37.7471488342478, -122.468055053599) | |||
| 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) | |||
| 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) | |||
| 155134 | 155134 | 207943 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992681.5782 | 2100498.78362 | 37.747148834263896 | -122.46806784736201 | (37.7471488342639, -122.468067847362) | |||
| 159185 | 159185 | 227270 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001726.6658 | 2099973.10248 | 37.746223648621395 | -122.43675308951 | (37.7462236486214, -122.43675308951) | |||
| 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) | |||
| 160883 | 160883 | 227269 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001725.03317 | 2099972.93353 | 37.746223091938894 | -122.43675872284099 | (37.7462230919389, -122.436758722841) | |||
| 166567 | 166567 | 227271 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001729.3164800005 | 2099973.25035 | 37.7462242052805 | -122.436743934384 | (37.7462242052805, -122.436743934384) | |||
| 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) | |||
| 172316 | 172316 | 207956 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995766.68193 | 2100244.56754 | 37.746628504495895 | -122.457381484986 | (37.7466285044959, -122.457381484986) | |||
| 178340 | 178340 | 207946 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992698.06615 | 2100499.1066400004 | 37.7471506733717 | -122.468010857342 | (37.7471506733717, -122.468010857342) | |||
| 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) | |||
| 183703 | 183703 | 227267 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001720.54184 | 2099972.41794 | 37.7462214209976 | -122.436774216378 | (37.7462214209976, -122.436774216378) | |||
| 185957 | 185957 | 207972 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 204 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996281.29923 | 2096182.49278 | 37.7355045886606 | -122.45530848830299 | (37.7355045886606, -122.455308488303) | |||
| 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) | |||
| 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) | |||
| 24194 | 24194 | 122139 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 54144 | 54144 | 120481 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988593.25091 | 2114641.37666 | 37.7857435664695 | -122.48324129171101 | (37.7857435664695, -122.483241291711) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 68485 | 68485 | 120482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988588.087169999 | 2114640.4078900004 | 37.7857406059941 | -122.483259085533 | (37.7857406059941, -122.483259085533) | |||
| 70460 | 70460 | 129566 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99 Toledo Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001391.4418 | 2119925.56535 | 37.800989055367 | -122.439342181017 | (37.800989055367, -122.439342181017) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 72614 | 72614 | 227310 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002320.65439 | 2098300.9350099997 | 37.741666007681296 | -122.434579607974 | (37.7416660076813, -122.434579607974) | |||
| 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) | |||
| 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) | |||
| 76685 | 76685 | 227309 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002319.695169999 | 2098302.33211 | 37.741669789339205 | -122.434583024505 | (37.7416697893392, -122.434583024505) | |||
| 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) | |||
| 153838 | 153838 | 207975 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 538 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998933.253409999 | 2097323.81684 | 37.7387901961225 | -122.44622178873001 | (37.7387901961225, -122.44622178873) | |||
| 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) | |||
| 167423 | 167423 | 227307 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002310.77433 | 2098320.0282799997 | 37.741717872474396 | -122.434615134802 | (37.7417178724744, -122.434615134802) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 184181 | 184181 | 120484 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2309 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5988270.499009999 | 2114625.30582 | 37.785680652510294 | -122.48435672889299 | (37.7856806525103, -122.484356728893) | |||
| 184817 | 184817 | 227298 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6002393.51458 | 2100323.84062 | 37.7472245688541 | -122.434472284662 | (37.7472245688541, -122.434472284662) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 49063 | 49063 | 207971 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 204 Cresta Vista Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5996300.1100699995 | 2096185.08811 | 37.735512794089104 | -122.455243639995 | (37.7355127940891, -122.455243639995) | |||
| 49183 | 49183 | 227263 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 743 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001723.660019999 | 2099680.3247 | 37.7454195791479 | -122.436742528759 | (37.7454195791479, -122.436742528759) | |||
| 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) | |||
| 50841 | 50841 | 207969 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Los Palmos Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998222.895169999 | 2096278.92785 | 37.735880587118004 | -122.44860262962798 | (37.735880587118, -122.448602629628) | |||
| 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) | |||
| 64567 | 64567 | 120483 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2309 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988277.53401 | 2114625.15663 | 37.7856806525102 | -122.48433237916201 | (37.7856806525102, -122.484332379162) | |||
| 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) | |||
| 69652 | 69652 | 120478 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988614.91495 | 2114641.72629 | 37.78574578718071 | -122.483166366817 | (37.7857457871807, -122.483166366817) | |||
| 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) | |||
| 136670 | 136670 | 227260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001350.1729 | 2100676.3582200003 | 37.748133217784 | -122.438105320914 | (37.748133217784, -122.438105320914) | |||
| 137621 | 137621 | 207968 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998212.35549 | 2096276.0168 | 37.735871991408 | -122.448638859714 | (37.735871991408, -122.448638859714) |
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");