trees
This data as json, CSV
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) |
19591 |
264707 |
9 |
67 |
4345 Clement St |
3 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
09/17/2020 12:00:00 AM |
3 |
|
|
5982064.28374 |
2113052.50483 |
37.7809988756405 |
-122.505711450059 |
(37.7809988756405, -122.505711450059) |
11 |
6 |
2 |
55 |
26 |
54959 |
258601 |
9 |
45 |
682 12th Ave |
1 |
Sidewalk: Property side : Cutout |
Landscaping |
2 |
|
05/29/2019 12:00:00 AM |
3 |
9X2 |
|
5992266.47414 |
2110804.58144 |
37.7754218561197 |
-122.470253595146 |
(37.7754218561197, -122.470253595146) |
11 |
6 |
2 |
54 |
11 |
165242 |
104317 |
9 |
44 |
13011305 SANCHEZ ST |
2 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
12 |
3x3 |
|
6003956 |
2100665 |
37.7482498839608 |
-122.429093651106 |
(37.7482498839608, -122.429093651106) |
2 |
4 |
5 |
63 |
22 |
180111 |
256895 |
9 |
22 |
701 Congo St |
1 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
|
3x12 |
Permit Number 768867 |
6000183.68977 |
2096091.89275 |
37.7354789553486 |
-122.441809987085 |
(37.7354789553486, -122.441809987085) |
9 |
7 |
4 |
63 |
40 |
7435 |
239668 |
9 |
313 |
180 Dolores St |
3 |
Sidewalk: Property side : Pot |
Landscaping |
2 |
|
|
23 |
Width 4ft |
|
6004776.3298 |
2107329.36682 |
37.7665950691341 |
-122.426731495165 |
(37.7665950691341, -122.426731495165) |
8 |
4 |
5 |
28862 |
3 |
4985 |
260550 |
9 |
284 |
155 Graystone Ter |
1 |
Sidewalk: Property side : Yard |
Landscaping |
2 |
|
|
|
3x3 |
|
5999080 |
2104142 |
37.7575196509651 |
-122.446204727568 |
(37.7575196509651, -122.446204727568) |
2 |
5 |
5 |
28862 |
3 |
13162 |
251365 |
9 |
41 |
138x Gladeview Way |
2 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13718 |
251364 |
9 |
41 |
138x Gladeview Way |
1 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15219 |
251366 |
9 |
41 |
138x Gladeview Way |
3 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15590 |
260947 |
9 |
17 |
143 Gambier St |
1 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
|
|
3x3 |
|
6005856 |
2093079 |
37.72752779603 |
-122.421984681693 |
(37.72752779603, -122.421984681693) |
9 |
7 |
7 |
309 |
5 |
15840 |
258303 |
9 |
113 |
1x Dawnview Way |
1 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
91085 |
111308 |
9 |
15 |
780x JAMESTOWN AVE |
1 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
|
|
6x90 |
|
6015099 |
2088640 |
37.7158561393861 |
-122.389721379672 |
(37.7158561393861, -122.389721379672) |
10 |
3 |
8 |
58 |
1 |
20327 |
109501 |
9 |
74 |
1400X on Filbert Montgomery St |
1 |
Unaccepted Street : Yard |
Tree |
2 |
|
|
|
|
see 279 Filbert St. Same tree; shared responsibility |
6011485.9 |
2120124.8 |
37.8021053817179 |
-122.404424889694 |
(37.8021053817179, -122.404424889694) |
3 |
1 |
10 |
308 |
23 |
86075 |
100243 |
9 |
17 |
1326-1332 Shotwell St |
|
unknown : Yard |
Tree |
2 |
|
|
|
|
|
6008043 |
2100485 |
37.7479861507453 |
-122.414948142067 |
(37.7479861507453, -122.414948142067) |
2 |
7 |
7 |
28859 |
2 |
119017 |
105441 |
9 |
56 |
425 WAWONA ST |
|
unknown : Yard |
Tree |
2 |
|
|
|
|
|
5991587.6 |
2097036.5 |
37.7375790508831 |
-122.471598439568 |
(37.7375790508831, -122.471598439568) |
1 |
8 |
4 |
29491 |
40 |