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) |
189757 |
98741 |
4 |
149 |
1150 Scott St |
5 |
Sidewalk: Curb side : Cutout |
Tree |
15 |
DPW for City Agency |
03/21/2012 12:00:00 AM |
3 |
4X4 |
|
6002360 |
2112467 |
37.7805648236525 |
-122.435456706153 |
(37.7805648236525, -122.435456706153) |
15 |
5 |
11 |
29490 |
41 |
141758 |
95359 |
1 |
70 |
775X Broadway |
5 |
Sidewalk: Curb side : Cutout |
Tree |
15 |
DPW for City Agency |
|
12 |
3x3 |
Permit Number 778058 |
6009884 |
2118395.5 |
37.7972675002992 |
-122.409846113399 |
(37.7972675002992, -122.409846113399) |
3 |
1 |
10 |
308 |
4 |
85896 |
128382 |
4 |
38 |
127 Trenton St |
5 |
Sidewalk: Curb side : Cutout |
Tree |
15 |
|
05/21/2018 12:00:00 AM |
3 |
Width 3ft |
|
6010062.26131 |
2118004.30718 |
37.7962033688491 |
-122.409201662523 |
(37.7962033688491, -122.409201662523) |
3 |
1 |
10 |
308 |
4 |
43430 |
112751 |
4 |
53 |
135X TRENTON ST |
5 |
Sidewalk: Curb side : Cutout |
Tree |
15 |
Private |
|
|
3x3 |
|
6009947 |
2118097 |
37.7964514227226 |
-122.409607037418 |
(37.7964514227226, -122.409607037418) |
3 |
1 |
10 |
308 |
4 |
20461 |
104283 |
6 |
17 |
150X Middle Point Rd |
5 |
Front Yard : Yard |
Tree |
15 |
|
09/17/2013 12:00:00 AM |
|
|
Permit Number 770341 |
6018215 |
2095138 |
37.7338706954973 |
-122.379402036794 |
(37.7338706954973, -122.379402036794) |
10 |
3 |
8 |
58 |
1 |