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) |
639 |
261347 |
2 |
6 |
3300x Alemany Blvd |
2 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
01/13/2020 12:00:00 AM |
3 |
3X3 |
Permit Number 780859 |
5994476 |
2087151 |
37.7106025369579 |
-122.460895688785 |
(37.7106025369579, -122.460895688785) |
9 |
8 |
6 |
28861 |
24 |
14035 |
159355 |
2 |
10 |
417 Ellington Ave |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/28/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 776198 |
5998509.88268 |
2087558.19074 |
37.7119518775514 |
-122.44698304145 |
(37.7119518775514, -122.44698304145) |
9 |
7 |
6 |
28861 |
25 |
19183 |
261351 |
2 |
6 |
299 Sagamore St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/13/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 784323 |
5994169 |
2087374 |
37.7111971725927 |
-122.461972900974 |
(37.7111971725927, -122.461972900974) |
9 |
8 |
6 |
28861 |
24 |
49019 |
113699 |
2 |
1 |
239 Minerva St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/15/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 778180 |
5994635.15348587 |
2088996.04011087 |
37.7156777383317 |
-122.460479228374 |
(37.7156777383317, -122.460479228374) |
9 |
8 |
6 |
28861 |
24 |
113669 |
159358 |
2 |
51 |
49 Naglee Ave |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/28/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 776198 |
5998584.62871 |
2087583.88571 |
37.712026700246 |
-122.446726546692 |
(37.712026700246, -122.446726546692) |
9 |
7 |
6 |
28861 |
25 |
158442 |
254367 |
2 |
13 |
79 Ashton Ave |
2 |
Front Yard : Yard |
Tree |
2 |
|
02/06/2018 12:00:00 AM |
3 |
|
Permit Number 778929 |
5994130.90698 |
2090445.22251 |
37.7196278254181 |
-122.462327167234 |
(37.7196278254181, -122.462327167234) |
9 |
8 |
6 |
28861 |
24 |
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 |