Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
98762 | 98762 | 207846 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 160 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995656.91883 | 2090949.83096 | 37.721101114209205 | -122.45708880872401 | (37.7211011142092, -122.457088808724) | |||
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) | |||
142846 | 142846 | 67008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30363 | 5995610.42846311 | 2090973.17671265 | 37.721162546103 | -122.457251199338 | (37.721162546103, -122.457251199338) | ||
177872 | 177872 | 207844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995613.369530001 | 2090975.38331 | 37.721168773811 | -122.457241192529 | (37.721168773811, -122.457241192529) | |||
147795 | 147795 | 207843 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995613.80856 | 2091011.1988 | 37.721267139854795 | -122.457242264538 | (37.7212671398548, -122.457242264538) | |||
44078 | 44078 | 66992 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.721336430114796 | -122.457251654811 | (37.7213364301148, -122.457251654811) | ||
82276 | 82276 | 96882 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
84624 | 84624 | 96883 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
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) | |||||
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) | |||||
181443 | 181443 | 207842 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 193 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995618.109069999 | 2091172.31825 | 37.7217097825699 | -122.457239048551 | (37.7217097825699, -122.457239048551) | |||
2689 | 2689 | 207839 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626X Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994826.85492 | 2091253.8672900002 | 37.721888220645 | -122.459980091334 | (37.721888220645, -122.459980091334) | |||
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) | |||
91855 | 91855 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
91870 | 91870 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
122326 | 122326 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
188009 | 188009 | 177141 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 355 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003671.36983 | 2091507.3370599998 | 37.7230889064227 | -122.429424930532 | (37.7230889064227, -122.429424930532) | |||
60851 | 60851 | 177046 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 317 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6000299.83904 | 2091602.15468 | 37.7231577908794 | -122.441086408025 | (37.7231577908794, -122.441086408025) | |||
11106 | 11106 | 25304 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 5999755.51283 | 2091622.1717 | 37.7231817335313 | -122.44296946786501 | (37.7231817335313, -122.442969467865) | |||
13198 | 13198 | 25303 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | |||
97971 | 97971 | 62791 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23147 | 5999722.02733953 | 2091630.11110927 | 37.7232016241068 | -122.44308579022301 | (37.7232016241068, -122.443085790223) | ||
55936 | 55936 | 177099 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999714.66231 | 2091641.03543 | 37.7232311998395 | -122.44311203381099 | (37.7232311998395, -122.443112033811) | |||
104134 | 104134 | 62790 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23146 | 6000313.64252899 | 2091641.02456839 | 37.7232653049393 | -122.441041479459 | (37.7232653049393, -122.441041479459) | ||
41100 | 41100 | 177100 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999723.90595 | 2091657.9425099997 | 37.7232781498534 | -122.443081294068 | (37.7232781498534, -122.443081294068) | |||
169770 | 169770 | 177045 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 21 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6000634.5733900005 | 2091639.69962 | 37.7232799412972 | -122.43993199059099 | (37.7232799412972, -122.439931990591) | |||
12673 | 12673 | 25310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 197 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000354.040159999 | 2091646.91959 | 37.7232837922084 | -122.440902255631 | (37.7232837922084, -122.440902255631) | |||
42836 | 42836 | 67278 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 58 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1992 12:00:00 AM | 3 | Permit Number 30752 | 6004928.68664 | 2091573.7324299999 | 37.7233423191649 | -122.42508335531001 | (37.7233423191649, -122.42508335531) | |
106537 | 106537 | 62784 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 137 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23140 | 6000712.17881294 | 2091681.24596218 | 37.723398435511896 | -122.439666701145 | (37.7233984355119, -122.439666701145) | ||
106547 | 106547 | 62782 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23138 | 6000753.3579224 | 2091686.36985433 | 37.7234148482869 | -122.439524720053 | (37.7234148482869, -122.439524720053) | ||
119329 | 119329 | 62781 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23137 | 6000780.81066937 | 2091689.78578334 | 37.7234257900447 | -122.43943006593099 | (37.7234257900447, -122.439430065931) | ||
82598 | 82598 | 62789 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.44101991790899 | (37.7234373055999, -122.441019917909) | ||
13006 | 13006 | 25299 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000418.66631 | 2091706.69164 | 37.7234515931109 | -122.44068314123001 | (37.7234515931109, -122.44068314123) | |||
108690 | 108690 | 62788 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23144 | 6000370.84981794 | 2091713.58104778 | 37.723467786704504 | -122.440848927652 | (37.7234677867045, -122.440848927652) | ||
178387 | 178387 | 62826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 170 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | 8 | Permit Number 23191 | 6000498.4193400005 | 2091715.9404799999 | 37.723481529728495 | -122.44040811326299 | (37.7234815297285, -122.440408113263) | |
11709 | 11709 | 25297 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000520.37509 | 2091718.7559 | 37.723490510352995 | -122.440332418218 | (37.723490510353, -122.440332418218) | |||
172527 | 172527 | 177103 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 154 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000580.38347 | 2091726.23406 | 37.723514460202395 | -122.440125516598 | (37.7235144602024, -122.440125516598) | |||
142722 | 142722 | 62787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23143 | 6000550.01003757 | 2091735.82644797 | 37.723539069470206 | -122.44023119939699 | (37.7235390694702, -122.440231199397) | ||
11537 | 11537 | 25293 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6000659.82425 | 2091738.03378 | 37.7235513818789 | -122.43985175036998 | (37.7235513818789, -122.43985175037) | |||
94190 | 94190 | 62786 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23142 | 6000618.91780925 | 2091744.38237049 | 37.723566485054 | -122.439993611308 | (37.723566485054, -122.439993611308) | ||
10599 | 10599 | 25290 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000711.5604 | 2091742.5944599998 | 37.7235668493142 | -122.439673234935 | (37.7235668493142, -122.439673234935) | |||
111795 | 111795 | 25294 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000635.349880001 | 2091747.8935900002 | 37.7235770614816 | -122.439937060329 | (37.7235770614816, -122.439937060329) | |||
10803 | 10803 | 25289 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000745.99488 | 2091748.7856599998 | 37.72358580881671 | -122.439554644937 | (37.7235858088167, -122.439554644937) | |||
73882 | 73882 | 177102 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 130 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000764.64112 | 2091750.39808 | 37.72359129737671 | -122.439490303855 | (37.7235912973767, -122.439490303855) | |||
140867 | 140867 | 62785 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23141 | 6000686.30847209 | 2091752.62403135 | 37.7235929509131 | -122.43976124488998 | (37.7235929509131, -122.43976124489) | ||
32505 | 32505 | 177101 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 130 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000792.03134 | 2091751.28395 | 37.7235952885821 | -122.439395684376 | (37.7235952885821, -122.439395684376) | |||
109197 | 109197 | 62783 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23139 | 6000734.28765752 | 2091758.59405485 | 37.7236120741182 | -122.439595817461 | (37.7236120741182, -122.439595817461) | ||
80877 | 80877 | 25291 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
103677 | 103677 | 25292 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
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) | |||
146966 | 146966 | 30911 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34732 | 5994801.07425 | 2091932.47974 | 37.7237500448081 | -122.460118346802 | (37.7237500448081, -122.460118346802) | |
52565 | 52565 | 177116 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 280 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004076.346369999 | 2091739.8978900001 | 37.7237503874544 | -122.42804157178101 | (37.7237503874544, -122.428041571781) | |||
172576 | 172576 | 30910 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34732 | 5994801.3845 | 2091947.2904299998 | 37.723790729247 | -122.46011834680901 | (37.723790729247, -122.460118346809) | ||
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) | |||
76560 | 76560 | 177125 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 418 Amherst St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007739.52277 | 2091837.25861 | 37.724224288797004 | -122.41538544049 | (37.724224288797, -122.41538544049) | |||
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) | |||
35298 | 35298 | 207929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995760.63845 | 2092696.4312900002 | 37.7259028185378 | -122.45685654350599 | (37.7259028185378, -122.456856543506) | |||
40319 | 40319 | 207930 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.4181 | 2092708.16322 | 37.7259343298845 | -122.45689963632499 | (37.7259343298845, -122.456899636325) | |||
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) | |||
96364 | 96364 | 62794 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23151 | 6000307.76766309 | 2093181.82122993 | 37.727495644326 | -122.441172281845 | (37.727495644326, -122.441172281845) | ||
153989 | 153989 | 207834 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | |||
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) | ||||
137316 | 137316 | 177098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 16 Paulding St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000285.114630001 | 2093206.10275 | 37.727561025398 | -122.441252334748 | (37.727561025398, -122.441252334748) | |||
134922 | 134922 | 31105 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34835 | 5998736.13021 | 2093248.3076400002 | 37.7275885518652 | -122.446610201415 | (37.7275885518652, -122.446610201415) | |
176161 | 176161 | 31106 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | |
167737 | 167737 | 207833 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 115 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 5998736.57601 | 2093305.76326 | 37.7277463370249 | -122.44661279235001 | (37.7277463370249, -122.44661279235) | |||
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) | |
13090 | 13090 | 77646 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | |
64518 | 64518 | 207931 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 9 Homewood Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994625.2236 | 2093411.18724 | 37.7278001020881 | -122.460833344698 | (37.7278001020881, -122.460833344698) | |||
10784 | 10784 | 77645 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006883.8507199995 | 2093162.97754 | 37.727816296176705 | -122.41843733843201 | (37.7278162961767, -122.418437338432) | |
11692 | 11692 | 77644 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | |
10289 | 10289 | 77643 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006923.4408599995 | 2093174.3728599998 | 37.7278498138936 | -122.41830128179899 | (37.7278498138936, -122.418301281799) | |
11530 | 11530 | 77642 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006942.1040900005 | 2093179.9332599998 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) |
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");