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) |
50564 |
250075 |
2 |
36 |
1599X Bush St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/05/2017 12:00:00 AM |
3 |
Width 4ft |
Permit Number 770925 |
6006083 |
2115238 |
37.7883840466687 |
-122.422774045373 |
(37.7883840466687, -122.422774045373) |
13 |
9 |
1 |
28858 |
41 |
74321 |
117115 |
2 |
1 |
1650 Broadway |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
06/07/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 773961 |
6005638.31982 |
2117909.64088 |
37.7956946025865 |
-122.42450268015 |
(37.7956946025865, -122.42450268015) |
13 |
9 |
1 |
28858 |
27 |
157692 |
249558 |
2 |
11 |
1450 Franklin St |
4 |
: |
Tree |
2 |
|
04/05/2017 12:00:00 AM |
3 |
Width 4ft |
Permit Number 770925 |
6005877.98213 |
2115146.79048 |
37.7881220384566 |
-122.423476888259 |
(37.7881220384566, -122.423476888259) |
13 |
9 |
1 |
28858 |
41 |
179827 |
118360 |
2 |
11 |
1600X Franklin St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
08/01/2016 12:00:00 AM |
3 |
|
Permit Number 773331 |
6005773.76538 |
2115716.99395 |
37.7896817924241 |
-122.423878022401 |
(37.7896817924241, -122.423878022401) |
13 |
9 |
1 |
28858 |
41 |
2311 |
256568 |
2 |
110 |
2099X Steiner St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6002352 |
2115365 |
37.7885215412843 |
-122.435691777518 |
(37.7885215412843, -122.435691777518) |
13 |
6 |
1 |
29490 |
27 |
99982 |
122422 |
2 |
159 |
2655 Bush St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
10/31/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 770253 |
6000851.7 |
2114462.1 |
37.7859570793449 |
-122.440817776746 |
(37.7859570793449, -122.440817776746) |
15 |
6 |
1 |
29490 |
27 |
169255 |
256692 |
2 |
19 |
2825 Lake St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/21/2018 12:00:00 AM |
3 |
|
Permit Number 772474 |
5986729.50015 |
2114421.37847 |
37.7850308764656 |
-122.489673069254 |
(37.7850308764656, -122.489673069254) |
11 |
6 |
1 |
55 |
33 |
148677 |
121464 |
2 |
11 |
2353 Lombard St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6001140 |
2119261 |
37.7991500226194 |
-122.440164592168 |
(37.7991500226194, -122.440164592168) |
13 |
9 |
1 |
57 |
17 |