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) |
3788 |
110746 |
5 |
215 |
2300x Mariposa St |
6 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/05/2015 12:00:00 AM |
3 |
3x3 |
|
6010517.26001 |
2106013.51672 |
37.7633049506856 |
-122.406781781161 |
(37.7633049506856, -122.406781781161) |
8 |
4 |
8 |
28859 |
19 |
9924 |
101922 |
5 |
27 |
1401X California St |
6 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/07/2012 12:00:00 AM |
4 |
3x3 |
Permit Number 769132 |
6007599.52227 |
2116115.67925 |
37.7908793859256 |
-122.417589338874 |
(37.7908793859256, -122.417589338874) |
13 |
1 |
10 |
28858 |
21 |
10996 |
103096 |
5 |
272 |
1540 Jones St |
6 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2013 12:00:00 AM |
3 |
3x3 |
Permit Number 768649 |
6008414.12252 |
2117870.41106 |
37.7957432514055 |
-122.414895095058 |
(37.7957432514055, -122.414895095058) |
5 |
1 |
10 |
308 |
21 |
12625 |
97159 |
5 |
91 |
1079 Le Conte Ave |
6 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
08/25/2011 12:00:00 AM |
3 |
|
Permit Number 768080 |
6012757.60574 |
2089814.3813 |
37.7189506418481 |
-122.397896712286 |
(37.7189506418481, -122.397896712286) |
10 |
3 |
8 |
58 |
1 |
18648 |
108454 |
5 |
276 |
696 Pennsylvania Ave |
6 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
8 |
3x3 |
|
6014383.50929 |
2103916.35065 |
37.757762155526 |
-122.393262829511 |
(37.757762155526, -122.393262829511) |
10 |
3 |
8 |
28856 |
29 |
8602 |
228283 |
5 |
22 |
2036X 15th St |
6 |
Sidewalk: Curb side : Yard |
Tree |
2 |
|
|
3 |
Width 3ft |
|
6003817 |
2107261 |
37.7663530653237 |
-122.430044770651 |
(37.7663530653237, -122.430044770651) |
8 |
4 |
5 |
28862 |
3 |
9940 |
261738 |
5 |
14 |
540 De Haro St |
6 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
02/25/2020 12:00:00 AM |
3 |
|
Permit Number 774839 |
6012051.5879 |
2105883.7172 |
37.7630342801454 |
-122.401465890035 |
(37.7630342801454, -122.401465890035) |
8 |
3 |
8 |
28856 |
29 |
5206 |
264864 |
5 |
186 |
10X Selma Way |
6 |
Unaccepted Street : Yard |
Tree |
2 |
|
|
|
10x100 |
|
5992494 |
2103402 |
37.7551094821546 |
-122.468927712716 |
(37.7551094821546, -122.468927712716) |
1 |
8 |
4 |
56 |
12 |