trees
2,180 rows where qSpecies_id = 57 sorted by Latitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190462 | 207852 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 442 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5992499.13103 | 2090773.12014 | 37.7204340555615 | -122.467991417565 | (37.7204340555615, -122.467991417565) | 9 | 8 | 6 | 64 | 24 | |||
96212 | 177050 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998727.35732 | 2090872.12433 | 37.7210636034854 | -122.446469652679 | (37.7210636034854, -122.446469652679) | 9 | 7 | 6 | 28861 | 25 | |||
61804 | 177049 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998733.2334 | 2090880.12484 | 37.7210859066631 | -122.446449916153 | (37.7210859066631, -122.446449916153) | 9 | 7 | 6 | 28861 | 25 | |||
48667 | 207846 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 160 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995656.91883 | 2090949.83096 | 37.7211011142092 | -122.457088808724 | (37.7211011142092, -122.457088808724) | 9 | 8 | 6 | 28861 | 24 | |||
94055 | 177048 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998741.12463 | 2090893.49817 | 37.7211230774582 | -122.446423600184 | (37.7211230774582, -122.446423600184) | 9 | 7 | 6 | 28861 | 25 | |||
50969 | 177047 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998747.58389 | 2090903.38197 | 37.721150585016 | -122.446401983167 | (37.721150585016, -122.446401983167) | 9 | 7 | 6 | 28861 | 25 | |||
174910 | 67008 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30363 | 5995610.42846311 | 2090973.17671265 | 37.721162546103 | -122.457251199338 | (37.721162546103, -122.457251199338) | 9 | 8 | 6 | 28861 | 24 | ||
183547 | 207844 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 163 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995613.36953 | 2090975.38331 | 37.721168773811 | -122.457241192529 | (37.721168773811, -122.457241192529) | 9 | 8 | 6 | 28861 | 24 | |||
111818 | 207843 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995613.80856 | 2091011.1988 | 37.7212671398548 | -122.457242264538 | (37.7212671398548, -122.457242264538) | 9 | 8 | 6 | 28861 | 24 | |||
18528 | 66992 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.7213364301148 | -122.457251654811 | (37.7213364301148, -122.457251654811) | 9 | 8 | 6 | 28861 | 24 | ||
44319 | 96882 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
48518 | 96883 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
72943 | 96884 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
102355 | 96885 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
101652 | 207842 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 193 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995618.10907 | 2091172.31825 | 37.7217097825699 | -122.457239048551 | (37.7217097825699, -122.457239048551) | 9 | 8 | 6 | 28861 | 24 | |||
138045 | 207839 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 626X Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994826.85492 | 2091253.86729 | 37.721888220645 | -122.459980091334 | (37.721888220645, -122.459980091334) | 9 | 8 | 4 | 28861 | 24 | |||
176521 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard | Tree | MTA 3 | 7 | Width 5ft | 5998933.17773 | 2091518.16383 | 37.7228492325857 | -122.445804632792 | (37.7228492325857, -122.445804632792) | 9 | 7 | 6 | 28861 | 25 | |||
49633 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998924.5969 | 2091518.78116 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | 9 | 7 | 6 | 28861 | 25 | |||
57339 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard | Tree | MTA 3 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369564 | (37.7228504376851, -122.44574369564) | 9 | 7 | 6 | 28861 | 25 | |||
36628 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.7228516427597 | -122.445718558684 | (37.7228516427597, -122.445718558684) | 9 | 7 | 6 | 28861 | 25 | |||
165567 | 177107 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998942.44698 | 2091518.84886 | 37.7228516427689 | -122.445772640307 | (37.7228516427689, -122.445772640307) | 9 | 7 | 6 | 28861 | 25 | |||
173815 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998921.08183 | 2091519.29315 | 37.7228516427808 | -122.445846526795 | (37.7228516427808, -122.445846526795) | 9 | 7 | 6 | 28861 | 25 | |||
18794 | 177112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5998995.97899 | 2091518.17463 | 37.7228528478523 | -122.445587543638 | (37.7228528478523, -122.445587543638) | 9 | 7 | 6 | 28861 | 25 | |||
47041 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998978.57855 | 2091518.53644 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | 9 | 7 | 6 | 28861 | 25 | |||
63651 | 177111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5998987.39789 | 2091518.79195 | 37.7228540529596 | -122.445617250956 | (37.7228540529596, -122.445617250956) | 9 | 7 | 6 | 28861 | 25 | |||
80257 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
92548 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
102801 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
136955 | 122414 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 11 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
141801 | 122417 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 14 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
148884 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
149548 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
156105 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
162950 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
93095 | 177141 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 355 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003671.36983 | 2091507.33706 | 37.7230889064227 | -122.429424930532 | (37.7230889064227, -122.429424930532) | 9 | 7 | 6 | 28861 | 5 | |||
78639 | 177046 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 317 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000299.83904 | 2091602.15468 | 37.7231577908794 | -122.441086408025 | (37.7231577908794, -122.441086408025) | 9 | 7 | 6 | 28861 | 25 | |||
62230 | 25304 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 5999755.51283 | 2091622.1717 | 37.7231817335313 | -122.442969467865 | (37.7231817335313, -122.442969467865) | 9 | 7 | 6 | 28861 | 25 | |||
190071 | 25303 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | 9 | 7 | 6 | 28861 | 25 | |||
106232 | 62791 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23147 | 5999722.02733953 | 2091630.11110927 | 37.7232016241068 | -122.443085790223 | (37.7232016241068, -122.443085790223) | 9 | 7 | 6 | 28861 | 25 | ||
50578 | 177099 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 377 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999714.66231 | 2091641.03543 | 37.7232311998395 | -122.443112033811 | (37.7232311998395, -122.443112033811) | 9 | 7 | 6 | 28861 | 25 | |||
114572 | 62790 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23146 | 6000313.64252899 | 2091641.02456839 | 37.7232653049393 | -122.441041479459 | (37.7232653049393, -122.441041479459) | 9 | 7 | 6 | 28861 | 25 | ||
119912 | 177100 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 377 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999723.90595 | 2091657.94251 | 37.7232781498534 | -122.443081294068 | (37.7232781498534, -122.443081294068) | 9 | 7 | 6 | 28861 | 25 | |||
105160 | 177045 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 21 Wanda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000634.57339 | 2091639.69962 | 37.7232799412972 | -122.439931990591 | (37.7232799412972, -122.439931990591) | 9 | 7 | 6 | 28861 | 25 | |||
163691 | 25310 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 197 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000354.04016 | 2091646.91959 | 37.7232837922084 | -122.440902255631 | (37.7232837922084, -122.440902255631) | 9 | 7 | 6 | 28861 | 25 | |||
33376 | 67278 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 3 | Permit Number 30752 | 6004928.68664 | 2091573.73243 | 37.7233423191649 | -122.42508335531 | (37.7233423191649, -122.42508335531) | 9 | 7 | 6 | 28861 | 5 | |
115523 | 62784 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 137 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23140 | 6000712.17881294 | 2091681.24596218 | 37.7233984355119 | -122.439666701145 | (37.7233984355119, -122.439666701145) | 9 | 7 | 6 | 28861 | 25 | ||
123233 | 62782 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23138 | 6000753.3579224 | 2091686.36985433 | 37.7234148482869 | -122.439524720053 | (37.7234148482869, -122.439524720053) | 9 | 7 | 6 | 28861 | 25 | ||
165390 | 62781 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23137 | 6000780.81066937 | 2091689.78578334 | 37.7234257900447 | -122.439430065931 | (37.7234257900447, -122.439430065931) | 9 | 7 | 6 | 28861 | 25 | ||
49882 | 62789 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.441019917909 | (37.7234373055999, -122.441019917909) | 9 | 7 | 6 | 28861 | 25 | ||
178079 | 25299 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000418.66631 | 2091706.69164 | 37.7234515931109 | -122.44068314123 | (37.7234515931109, -122.44068314123) | 9 | 7 | 6 | 28861 | 25 | |||
118121 | 62788 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23144 | 6000370.84981794 | 2091713.58104778 | 37.7234677867045 | -122.440848927652 | (37.7234677867045, -122.440848927652) | 9 | 7 | 6 | 28861 | 25 | ||
182672 | 62826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 170 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | 8 | Permit Number 23191 | 6000498.41934 | 2091715.94048 | 37.7234815297285 | -122.440408113263 | (37.7234815297285, -122.440408113263) | 9 | 7 | 6 | 28861 | 25 | |
158088 | 177103 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 154 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000580.38347 | 2091726.23406 | 37.7235144602024 | -122.440125516598 | (37.7235144602024, -122.440125516598) | 9 | 7 | 6 | 28861 | 25 | |||
186136 | 62787 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23143 | 6000550.01003757 | 2091735.82644797 | 37.7235390694702 | -122.440231199397 | (37.7235390694702, -122.440231199397) | 9 | 7 | 6 | 28861 | 25 | ||
85313 | 25293 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6000659.82425 | 2091738.03378 | 37.7235513818789 | -122.43985175037 | (37.7235513818789, -122.43985175037) | 9 | 7 | 6 | 28861 | 25 | |||
88222 | 62786 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23142 | 6000618.91780925 | 2091744.38237049 | 37.723566485054 | -122.439993611308 | (37.723566485054, -122.439993611308) | 9 | 7 | 6 | 28861 | 25 | ||
188007 | 25290 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000711.5604 | 2091742.59446 | 37.7235668493142 | -122.439673234935 | (37.7235668493142, -122.439673234935) | 9 | 7 | 6 | 28861 | 25 | |||
142101 | 25294 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 150 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000635.34988 | 2091747.89359 | 37.7235770614816 | -122.439937060329 | (37.7235770614816, -122.439937060329) | 9 | 7 | 6 | 28861 | 25 | |||
50603 | 25289 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000745.99488 | 2091748.78566 | 37.7235858088167 | -122.439554644937 | (37.7235858088167, -122.439554644937) | 9 | 7 | 6 | 28861 | 25 | |||
126041 | 177102 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 130 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000764.64112 | 2091750.39808 | 37.7235912973767 | -122.439490303855 | (37.7235912973767, -122.439490303855) | 9 | 7 | 6 | 28861 | 25 | |||
180329 | 62785 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23141 | 6000686.30847209 | 2091752.62403135 | 37.7235929509131 | -122.43976124489 | (37.7235929509131, -122.43976124489) | 9 | 7 | 6 | 28861 | 25 | ||
121893 | 177101 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 130 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000792.03134 | 2091751.28395 | 37.7235952885821 | -122.439395684376 | (37.7235952885821, -122.439395684376) | 9 | 7 | 6 | 28861 | 25 | |||
131640 | 62783 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23139 | 6000734.28765752 | 2091758.59405485 | 37.7236120741182 | -122.439595817461 | (37.7236120741182, -122.439595817461) | 9 | 7 | 6 | 28861 | 25 | ||
50736 | 25291 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000743.11246 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | 9 | 7 | 6 | 28861 | 25 | |||
100014 | 25292 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000743.11246 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | 9 | 7 | 6 | 28861 | 25 | |||
127448 | 207836 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995005.14377 | 2091917.04933 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | 9 | 8 | 4 | 28861 | 24 | |||
81473 | 207835 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1209 Capitol Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995030.31814 | 2091918.85126 | 37.7237258071947 | -122.459324908222 | (37.7237258071947, -122.459324908222) | 9 | 8 | 4 | 28861 | 24 | |||
146922 | 177124 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 469 Amherst St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007846.14363 | 2091662.35838 | 37.723750042115 | -122.415004493075 | (37.723750042115, -122.415004493075) | 9 | 3 | 7 | 309 | 28 | |||
177031 | 30911 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 500 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 13 | Permit Number 34732 | 5994801.07425 | 2091932.47974 | 37.7237500448081 | -122.460118346802 | (37.7237500448081, -122.460118346802) | 9 | 8 | 4 | 28861 | 24 | |
14950 | 177116 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 280 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004076.34637 | 2091739.89789 | 37.7237503874544 | -122.428041571781 | (37.7237503874544, -122.428041571781) | 9 | 7 | 6 | 28861 | 5 | |||
82930 | 30910 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 500 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34732 | 5994801.3845 | 2091947.29043 | 37.723790729247 | -122.460118346809 | (37.723790729247, -122.460118346809) | 9 | 8 | 4 | 28861 | 24 | ||
96139 | 207837 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 506 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 1ft | 5994801.27267 | 2091957.06598 | 37.7238175641248 | -122.460119441258 | (37.7238175641248, -122.460119441258) | 9 | 8 | 4 | 28861 | 24 | |||
129956 | 207838 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 506 Faxon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 1ft | 5994800.95024 | 2091971.89024 | 37.7238582494329 | -122.460121629304 | (37.7238582494329, -122.460121629304) | 9 | 8 | 4 | 28861 | 24 | |||
76842 | 177125 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 418 Amherst St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007739.52277 | 2091837.25861 | 37.724224288797 | -122.41538544049 | (37.724224288797, -122.41538544049) | 9 | 3 | 7 | 309 | 28 | |||
93440 | 177117 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 226 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6004541.32921 | 2091944.569 | 37.7243386654761 | -122.426448769894 | (37.7243386654761, -122.426448769894) | 9 | 7 | 6 | 28861 | 5 | ||||
174043 | 177123 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 342 Harvard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6006356.99395 | 2092231.60745 | 37.7252292829921 | -122.4201926235 | (37.7252292829921, -122.4201926235) | 9 | 7 | 7 | 309 | 5 | |||
19574 | 261987 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1599x Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014919 | 2092067 | 37.7252560234082 | -122.390582878929 | (37.7252560234082, -122.390582878929) | 10 | 3 | 8 | 58 | 1 | ||||
159234 | 177122 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 342 Harvard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6006351.77193 | 2092249.47025 | 37.7252780361255 | -122.420211942723 | (37.7252780361255, -122.420211942723) | 9 | 7 | 7 | 309 | 5 | |||
173362 | 177121 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 163 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6004588.38718 | 2092450.06692 | 37.7257293114356 | -122.426322070732 | (37.7257293114356, -122.426322070732) | 9 | 7 | 6 | 28861 | 5 | |||
100886 | 177120 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 163 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6004577.78198 | 2092457.96973 | 37.7257504113309 | -122.42635929454 | (37.7257504113309, -122.42635929454) | 9 | 7 | 6 | 28861 | 5 | |||
187081 | 207929 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995760.63845 | 2092696.43129 | 37.7259028185378 | -122.456856543506 | (37.7259028185378, -122.456856543506) | 9 | 7 | 4 | 28861 | 40 | |||
154549 | 207930 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995748.4181 | 2092708.16322 | 37.7259343298845 | -122.456899636325 | (37.7259343298845, -122.456899636325) | 9 | 7 | 4 | 28861 | 40 | |||
170880 | 177119 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Avalon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6003367.9404 | 2092809.07535 | 37.7266460056919 | -122.430566665719 | (37.7266460056919, -122.430566665719) | 9 | 7 | 6 | 28861 | 5 | |||
128627 | 177118 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Avalon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6003359.98068 | 2092814.59927 | 37.726660722214 | -122.430594576183 | (37.726660722214, -122.430594576183) | 9 | 7 | 6 | 28861 | 5 | |||
86839 | 62794 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23151 | 6000307.76766309 | 2093181.82122993 | 37.727495644326 | -122.441172281845 | (37.727495644326, -122.441172281845) | 9 | 7 | 6 | 28861 | 25 | ||
86744 | 207834 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | 9 | 7 | 4 | 28861 | 40 | |||
167414 | 208013 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998954.84466 | 2093225.77807 | 37.7275391817664 | -122.44585248661 | (37.7275391817664, -122.44585248661) | 9 | 7 | 4 | 28861 | 40 | ||||
150989 | 208014 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998954.76587 | 2093228.45695 | 37.7275465328469 | -122.445852951569 | (37.7275465328469, -122.445852951569) | 9 | 7 | 4 | 28861 | 40 | ||||
137128 | 208015 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5998954.57237 | 2093232.07461 | 37.7275564550483 | -122.445853880569 | (37.7275564550483, -122.445853880569) | 9 | 7 | 4 | 28861 | 40 | ||||
59332 | 177098 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 16 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000285.11463 | 2093206.10275 | 37.727561025398 | -122.441252334748 | (37.727561025398, -122.441252334748) | 9 | 7 | 6 | 28861 | 25 | |||
88097 | 31105 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 3 | Permit Number 34835 | 5998736.13021 | 2093248.30764 | 37.7275885518652 | -122.446610201415 | (37.7275885518652, -122.446610201415) | 9 | 7 | 4 | 28861 | 40 | |
111106 | 31106 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | 9 | 7 | 4 | 28861 | 40 | |
178048 | 207833 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 115 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5998736.57601 | 2093305.76326 | 37.7277463370249 | -122.44661279235 | (37.7277463370249, -122.44661279235) | 9 | 7 | 4 | 28861 | 40 | |||
129312 | 77648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.14742 | 2093142.98247 | 37.7277576387802 | -122.418666516263 | (37.7277576387802, -122.418666516263) | 9 | 3 | 7 | 309 | 5 | |
17218 | 77646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | 9 | 3 | 7 | 309 | 5 | ||
132102 | 207931 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 9 Homewood Ct | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994625.2236 | 2093411.18724 | 37.7278001020881 | -122.460833344698 | (37.7278001020881, -122.460833344698) | 9 | 8 | 4 | 59 | 40 | |||
7775 | 77645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006883.85072 | 2093162.97754 | 37.7278162961767 | -122.418437338432 | (37.7278162961767, -122.418437338432) | 9 | 3 | 7 | 309 | 5 | ||
3789 | 77644 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | 9 | 3 | 7 | 309 | 5 | ||
1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
9319 | 77642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006942.10409 | 2093179.93326 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | 9 | 3 | 7 | 309 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );