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) |
179761 |
160920 |
2 |
36 |
666 Madrid St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
06/28/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 779533 |
6002104.11317 |
2090113.36167 |
37.7191725036747 |
-122.434742983299 |
(37.7191725036747, -122.434742983299) |
9 |
7 |
6 |
28861 |
5 |
179839 |
160370 |
2 |
14 |
868 Edinburgh St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/26/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 779314 |
6001693.73373 |
2088950.71414 |
37.715956825716 |
-122.436078353349 |
(37.715956825716, -122.436078353349) |
9 |
7 |
6 |
28861 |
5 |
179923 |
122379 |
2 |
13 |
466 Vernon St |
1 |
Front Yard : Cutout |
Tree |
2 |
|
10/26/2016 12:00:00 AM |
3 |
3x3 |
|
5992521 |
2090937 |
37.7208852925782 |
-122.467927737968 |
(37.7208852925782, -122.467927737968) |
9 |
8 |
6 |
64 |
24 |
182774 |
255792 |
2 |
8 |
368 Princeton St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/18/2018 12:00:00 AM |
3 |
3x3 |
|
6007843 |
2092137 |
37.7250531301082 |
-122.415048939995 |
(37.7250531301082, -122.415048939995) |
9 |
3 |
7 |
309 |
28 |
186409 |
115490 |
2 |
72 |
280 BRIGHTON AVE |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/10/2016 12:00:00 AM |
3 |
4x12 |
Permit Number 777362 |
5996259 |
2091739 |
37.7233025441304 |
-122.455064598389 |
(37.7233025441304, -122.455064598389) |
9 |
8 |
4 |
28861 |
24 |