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) |
157754 |
251416 |
1 |
48 |
10x Jones St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6009207 |
2112641 |
37.7814290728676 |
-122.411781887248 |
(37.7814290728676, -122.411781887248) |
14 |
10 |
9 |
28852 |
36 |
160069 |
169218 |
1 |
48 |
824 Ellis St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
DPW |
|
0 |
3x3 |
|
6006905.30546 |
2113639.62991 |
37.7840416758297 |
-122.419815533287 |
(37.7840416758297, -122.419815533287) |
7 |
9 |
9 |
28858 |
36 |
160755 |
169217 |
1 |
48 |
800 Ellis St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
DPW |
|
0 |
3x3 |
|
6006932.37231 |
2113646.73425 |
37.7840627073778 |
-122.419722395865 |
(37.7840627073778, -122.419722395865) |
7 |
9 |
9 |
28858 |
36 |
165356 |
120657 |
1 |
48 |
160 Folsom St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
12 |
3x3 |
Permit Number 778623 |
6015078.8336 |
2115510.7898 |
37.7896365150846 |
-122.39166873056 |
(37.7896365150846, -122.39166873056) |
6 |
2 |
9 |
28855 |
6 |
186594 |
169214 |
1 |
48 |
724 Ellis St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
DPW |
|
0 |
Width 4ft |
|
6007369.54432 |
2113705.88387 |
37.7842497348906 |
-122.418214130293 |
(37.7842497348906, -122.418214130293) |
7 |
9 |
9 |
28858 |
36 |
194337 |
265035 |
4 |
48 |
1250X Alabama St |
|
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6009246 |
2101881 |
37.7518867820544 |
-122.410886782822 |
(37.7518867820544, -122.410886782822) |
2 |
4 |
7 |
28859 |
19 |
194339 |
265037 |
4 |
48 |
1250X Alabama St |
|
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6009246 |
2101881 |
37.7518867820544 |
-122.410886782822 |
(37.7518867820544, -122.410886782822) |
2 |
4 |
7 |
28859 |
19 |
194353 |
265038 |
4 |
48 |
1250X Alabama St |
|
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6009246 |
2101881 |
37.7518867820544 |
-122.410886782822 |
(37.7518867820544, -122.410886782822) |
2 |
4 |
7 |
28859 |
19 |
194364 |
265034 |
4 |
48 |
3012 25th St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6009402 |
2101646 |
37.7512502705876 |
-122.410330719668 |
(37.7512502705876, -122.410330719668) |
2 |
4 |
7 |
28859 |
19 |
194365 |
265036 |
4 |
48 |
1250X Alabama St |
|
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6009246 |
2101881 |
37.7518867820544 |
-122.410886782822 |
(37.7518867820544, -122.410886782822) |
2 |
4 |
7 |
28859 |
19 |
14472 |
100972 |
1 |
48 |
450X Chestnut St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW |
03/24/2016 07:43:00 AM |
3 |
|
Permit Number 37341 |
6009614 |
2121059.9 |
37.8045681487804 |
-122.410968670823 |
(37.8045681487804, -122.410968670823) |
3 |
1 |
10 |
308 |
23 |
125354 |
253413 |
1 |
48 |
2433 23rd Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
6 |
Private |
|
|
3x3 |
|
5989193.66308 |
2098780.80152 |
37.7422296590049 |
-122.480002935505 |
(37.7422296590049, -122.480002935505) |
1 |
8 |
3 |
29491 |
35 |