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) |
4221 |
160246 |
9 |
48 |
962 Edinburgh St |
1 |
Front Yard : Cutout |
Tree |
2 |
DPW |
02/20/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 779047 |
6001480.24176 |
2088600.7563 |
37.7149837880375 |
-122.436791243222 |
(37.7149837880375, -122.436791243222) |
9 |
7 |
6 |
28861 |
5 |
6336 |
261055 |
9 |
89 |
1948 Quesada Ave |
1 |
Front Yard : Cutout |
Tree |
2 |
DPW |
11/20/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 780729 |
6013389.35902 |
2096036.97619 |
37.7360717858924 |
-122.396148836191 |
(37.7360717858924, -122.396148836191) |
10 |
3 |
8 |
58 |
1 |
8824 |
261056 |
9 |
89 |
1952 Quesada Ave |
1 |
Front Yard : Cutout |
Tree |
2 |
DPW |
11/20/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 780727 |
6013369.93114 |
2096051.4395 |
37.7361104181421 |
-122.396217020065 |
(37.7361104181421, -122.396217020065) |
10 |
3 |
8 |
58 |
1 |
10378 |
163649 |
9 |
13 |
226 Sagamore St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
DPW |
07/01/2020 12:00:00 AM |
3 |
3x4 |
Permit Number 784460 |
5994737.04022 |
2087470.63166 |
37.71149518743 |
-122.460016622663 |
(37.71149518743, -122.460016622663) |
9 |
8 |
6 |
28861 |
24 |
15228 |
261687 |
9 |
17 |
2067 Bancroft Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
DPW |
02/20/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 782291 |
6011786.16554 |
2094038.32843 |
37.730494584078 |
-122.401551330673 |
(37.730494584078, -122.401551330673) |
10 |
3 |
8 |
58 |
1 |