Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
qLegalStatus ✖
| 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) | |||
| 31804 | 31804 | 226706 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Eugenia Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 10ft | 6006654.02073 | 2098088.9273900003 | 37.7413289273824 | -122.419581211314 | (37.7413289273824, -122.419581211314) | |||
| 136150 | 136150 | 191437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300x De Haro St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012282.34359 | 2102012.29375 | 37.7524170754114 | -122.400395836501 | (37.7524170754114, -122.400395836501) | ||||
| 47682 | 47682 | 207809 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 200x Terrace Dr | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993795.90954 | 2096545.0474900003 | 37.736357157655604 | -122.46392766184601 | (37.7363571576556, -122.463927661846) | ||||
| 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) | ||||
| 31616 | 31616 | 191508 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 55 Sherman St | 25 | : 4 | Tree 1 | Private 1 | 3 | Width 10ft | 6010631.502780001 | 2111081.40715 | 37.777226606154706 | -122.406743828871 | (37.7772266061547, -122.406743828871) | |||
| 53472 | 53472 | 207987 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 19 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999466.174219999 | 2095456.6543299998 | 37.7336938298041 | -122.444245066271 | (37.7336938298041, -122.444245066271) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 26664 | 26664 | 207878 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992430.64291 | 2104640.28912 | 37.75850584000379 | -122.469236940844 | (37.7585058400038, -122.469236940844) | |||
| 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) | |||
| 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) | |||
| 182181 | 182181 | 207877 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992430.68315 | 2104656.73178 | 37.7585509895658 | -122.469237998432 | (37.7585509895658, -122.469237998432) | |||
| 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) | |||
| 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) | |||
| 99827 | 99827 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 130185 | 130185 | 207876 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5992430.48818 | 2104676.5294 | 37.7586053373771 | -122.469240113663 | (37.7586053373771, -122.469240113663) | |||
| 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) | |||
| 73020 | 73020 | 207875 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992429.92349 | 2104693.2894 | 37.7586513233149 | -122.46924328645599 | (37.7586513233149, -122.469243286456) | |||
| 112319 | 112319 | 122417 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 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) | |||
| 3625 | 3625 | 129585 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Webster St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003281.99401 | 2116331.1346 | 37.7912270809146 | -122.432543180443 | (37.7912270809146, -122.432543180443) | ||
| 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) | |||
| 29328 | 29328 | 207874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992430.658340001 | 2104713.67602 | 37.758707342094496 | -122.46924222885 | (37.7587073420945, -122.46924222885) | |||
| 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) | |||
| 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) | |||
| 85949 | 85949 | 109996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 88675 | 88675 | 77637 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
| 112873 | 112873 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 130506 | 130506 | 227224 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007875.676419999 | 2104900.76598 | 37.76010143696 | -122.415839378705 | (37.76010143696, -122.415839378705) | |||
| 137196 | 137196 | 250120 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005918.65484 | 2115399.35562 | 37.7888178151318 | -122.423354129013 | (37.7888178151318, -122.423354129013) | |||
| 166818 | 166818 | 177134 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6006986.52486 | 2093261.74193 | 37.7280932612704 | -122.41808938983601 | (37.7280932612704, -122.418089389836) | |||
| 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) | |||
| 38013 | 38013 | 227223 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007877.46921 | 2104880.99853 | 37.7600472608797 | -122.41583177852101 | (37.7600472608797, -122.415831778521) | |||
| 60222 | 60222 | 250119 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005940.01116 | 2115401.03546 | 37.7888236328491 | -122.423280358508 | (37.7888236328491, -122.423280358508) | |||
| 78861 | 78861 | 6767 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017284.4858800005 | 2096909.9197200001 | 37.738684672549205 | -122.38274239930401 | (37.7386846725492, -122.382742399304) | ||
| 104152 | 104152 | 6715 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 106116 | 106116 | 109995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 115266 | 115266 | 77636 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
| 116737 | 116737 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 147117 | 147117 | 129641 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 943 Green St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.41406679246201 | (37.7987948111981, -122.414066792462) | ||||
| 149890 | 149890 | 227506 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 149 Otis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006716.29525 | 2108893.94632 | 37.7710005240788 | -122.42013252988501 | (37.7710005240788, -122.420132529885) | |||
| 160583 | 160583 | 177133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006981.25379 | 2093279.99997 | 37.7281430972085 | -122.418108906001 | (37.7281430972085, -122.418108906001) | |||
| 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) | |||
| 178601 | 178601 | 207873 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992428.50791 | 2104727.72891 | 37.7587458033845 | -122.46925068878201 | (37.7587458033845, -122.469250688782) | |||
| 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) | |||
| 22641 | 22641 | 23386 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006045.46684 | 2115549.5575099997 | 37.789237388446296 | -122.422926056205 | (37.7892373884463, -122.422926056205) | |||
| 26614 | 26614 | 98657 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002607.56666 | 2119218.5959900003 | 37.7991170337862 | -122.43508328318701 | (37.7991170337862, -122.435083283187) | ||
| 26923 | 26923 | 250118 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005957.66488 | 2115404.7946 | 37.7888349508074 | -122.42321954634899 | (37.7888349508074, -122.423219546349) | |||
| 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) | |||
| 40853 | 40853 | 129584 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Webster St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003287.46949 | 2116304.94268 | 37.7911554750944 | -122.432522363823 | (37.7911554750944, -122.432522363823) | |||
| 58071 | 58071 | 177132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006974.89341 | 2093300.20785 | 37.728198225668 | -122.418132326164 | (37.728198225668, -122.418132326164) | |||
| 59018 | 59018 | 227222 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007876.49698 | 2104861.23825 | 37.759992949041795 | -122.415833741754 | (37.7599929490418, -122.415833741754) | |||
| 110638 | 110638 | 122414 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 111433 | 111433 | 77635 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
| 122742 | 122742 | 102156 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | ||
| 132450 | 132450 | 227451 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 190 Storrie St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 6000780.7251 | 2105298.9199099997 | 37.7607932503354 | -122.44040592161899 | (37.7607932503354, -122.440405921619) | |||
| 142889 | 142889 | 109994 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 155073 | 155073 | 207872 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992428.33216 | 2104748.4393 | 37.7588026585314 | -122.469252803993 | (37.7588026585314, -122.469252803993) | |||
| 4592 | 4592 | 129653 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009793.38554 | 2121873.20249 | 37.806811331947706 | -122.410405350227 | (37.8068113319477, -122.410405350227) | |||
| 23408 | 23408 | 129662 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009783.75485 | 2121643.62173 | 37.806180420661505 | -122.41042245803101 | (37.8061804206615, -122.410422458031) | |||
| 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) | ||||
| 26297 | 26297 | 227221 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007877.8147 | 2104842.60134 | 37.7599418504554 | -122.415827864682 | (37.7599418504554, -122.415827864682) | |||
| 27221 | 27221 | 250098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006037.70809 | 2115548.99376 | 37.789235402731705 | -122.42295286049601 | (37.7892354027317, -122.422952860496) | |||
| 31571 | 31571 | 98656 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.799126161900396 | -122.435006269744 | (37.7991261619004, -122.435006269744) | ||
| 67652 | 67652 | 177131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006969.3427 | 2093320.5596099999 | 37.728253794759205 | -122.418152957489 | (37.7282537947592, -122.418152957489) | |||
| 80252 | 80252 | 102194 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 91687 | 91687 | 85306 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005989.138522 | 2115548.501173 | 37.789231309471795 | -122.423120870526 | (37.7892313094718, -122.423120870526) | ||||
| 94860 | 94860 | 102155 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | ||
| 102293 | 102293 | 96885 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 103981 | 103981 | 17345 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 175X Otis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
| 109913 | 109913 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 124316 | 124316 | 109993 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 129020 | 129020 | 77649 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
| 139987 | 139987 | 77634 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
| 156894 | 156894 | 250117 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005979.63604 | 2115408.27637 | 37.7888457507891 | -122.423143776687 | (37.7888457507891, -122.423143776687) | |||
| 157897 | 157897 | 129565 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2399 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999377.07485 | 2120460.44202 | 37.802342844411996 | -122.44635122363 | (37.802342844412, -122.44635122363) | |||
| 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) | |||
| 173227 | 173227 | 129672 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6009324.29914 | 2121805.6091 | 37.806599430082 | -122.412023942863 | (37.806599430082, -122.412023942863) | |||
| 177365 | 177365 | 191447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1300 Phelps St | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) | |||
| 185619 | 185619 | 191460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6014521.60501 | 2115886.5907099997 | 37.7906374305211 | -122.393623012505 | (37.7906374305211, -122.393623012505) | |||
| 187170 | 187170 | 207869 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992429.29261 | 2104765.0149 | 37.7588482262841 | -122.46925068878599 | (37.7588482262841, -122.469250688786) | |||
| 4614 | 4614 | 129652 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009798.02273 | 2121850.3999900003 | 37.80674898193529 | -122.41038769114401 | (37.8067489819353, -122.410387691144) | |||
| 12092 | 12092 | 77648 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.147419999 | 2093142.9824700002 | 37.727757638780204 | -122.418666516263 | (37.7277576387802, -122.418666516263) | |
| 19863 | 19863 | 27655 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006765.6884 | 2108667.1143 | 37.770380480168704 | -122.419945578015 | (37.7703804801687, -122.419945578015) | |||
| 22764 | 22764 | 23385 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006030.41853 | 2115547.69719 | 37.7892314313446 | -122.42297798933599 | (37.7892314313446, -122.422977989336) | |||
| 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) | |||
| 41097 | 41097 | 207871 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992427.77388 | 2104765.5037700003 | 37.7588494808325 | -122.46925597679399 | (37.7588494808325, -122.469255976794) | |||
| 41229 | 41229 | 227220 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007878.47133 | 2104829.72546 | 37.7599065331661 | -122.41582468195601 | (37.7599065331661, -122.415824681956) | |||
| 44444 | 44444 | 177130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006962.9694300005 | 2093340.1251400001 | 37.7283071587297 | -122.41817637676 | (37.7283071587297, -122.41817637676) | |||
| 46512 | 46512 | 227338 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008438.44095 | 2096875.5776400003 | 37.738097686665895 | -122.41332550648998 | (37.7380976866659, -122.41332550649) | |||
| 49010 | 49010 | 227460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | |||
| 51641 | 51641 | 191459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014515.877119999 | 2115897.3284299998 | 37.790666595532606 | -122.393643582697 | (37.7906665955326, -122.393643582697) | |||
| 52361 | 52361 | 207866 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 374 Irving St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995689.6925099995 | 2106690.80313 | 37.7643238106111 | -122.458114159946 | (37.7643238106111, -122.458114159946) | |||
| 60959 | 60959 | 129661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009779.91781 | 2121666.56674 | 37.8062432068281 | -122.41043735801 | (37.8062432068281, -122.41043735801) | |||
| 66231 | 66231 | 207904 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991482.67128 | 2097068.4954400002 | 37.737660831087496 | -122.47196355577299 | (37.7376608310875, -122.471963555773) | |||
| 77610 | 77610 | 109992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 80701 | 80701 | 99678 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 4x4 | Permit Number 770537 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | |
| 86463 | 86463 | 96884 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) |
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");