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) |
7952 |
262419 |
5 |
19 |
101 Brighton Ave |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/27/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 784737 |
5996197.23422 |
2090625.75995 |
37.7202423066045 |
-122.455197699909 |
(37.7202423066045, -122.455197699909) |
9 |
8 |
6 |
28861 |
24 |
19533 |
259217 |
5 |
19 |
200 Grafton Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/27/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 784737 |
5996177 |
2090586 |
37.7201319742324 |
-122.455264770625 |
(37.7201319742324, -122.455264770625) |
9 |
8 |
6 |
28861 |
24 |
7830 |
262278 |
5 |
1 |
15 Corona St |
1 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
06/25/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 784820 |
5992625 |
2091331 |
37.7219731255806 |
-122.467596882777 |
(37.7219731255806, -122.467596882777) |
9 |
8 |
4 |
59 |
40 |
9135 |
262279 |
5 |
1 |
15 Corona St |
2 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
06/25/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 784820 |
5992625 |
2091331 |
37.7219731255806 |
-122.467596882777 |
(37.7219731255806, -122.467596882777) |
9 |
8 |
4 |
59 |
40 |
7739 |
262320 |
5 |
18 |
2567 31st Ave |
1 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
07/07/2020 12:00:00 AM |
3 |
6x10 |
Permit Number 785009 |
5986744.29234 |
2097795.22153 |
37.7393809030196 |
-122.48839957369 |
(37.7393809030196, -122.48839957369) |
1 |
8 |
3 |
29491 |
35 |
194494 |
264749 |
5 |
78 |
1339 16th Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/12/2021 12:00:00 AM |
3 |
3x3 |
Permit Number 785207 |
5991088 |
2106284 |
37.7629413570223 |
-122.474000279679 |
(37.7629413570223, -122.474000279679) |
1 |
8 |
11 |
56 |
12 |
5528 |
167133 |
5 |
10 |
4564 19th St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/01/2019 12:00:00 AM |
3 |
3x5 |
Permit Number 785333 |
6000784.60188 |
2104670.73247 |
37.7590686222364 |
-122.440347461192 |
(37.7590686222364, -122.440347461192) |
2 |
4 |
5 |
28862 |
3 |
6880 |
24222 |
5 |
78 |
54 Whitney Young Cir |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/07/2010 12:00:00 AM |
3 |
4x4 |
this is original dpw basin record. |
6017205.2608 |
2094992.48681 |
37.7334154068844 |
-122.382882921904 |
(37.7334154068844, -122.382882921904) |
10 |
3 |
8 |
58 |
1 |