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) |
106371 |
121516 |
2 |
11 |
300 Folsom St |
11 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6014751 |
2115177 |
37.7887018021562 |
-122.392779649259 |
(37.7887018021562, -122.392779649259) |
6 |
2 |
9 |
28855 |
6 |
72278 |
198591 |
2 |
31 |
980 16th St |
11 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013476.96853 |
2107132.95858 |
37.7665438491392 |
-122.396623526764 |
(37.7665438491392, -122.396623526764) |
14 |
3 |
8 |
28856 |
20 |
155834 |
203210 |
2 |
72 |
189 Hubbell St |
11 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013290.07277 |
2107397.08786 |
37.7672586860712 |
-122.397288494465 |
(37.7672586860712, -122.397288494465) |
14 |
3 |
8 |
28856 |
20 |
16815 |
109466 |
2 |
164 |
360 Berry St |
11 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/15/2017 12:00:00 AM |
3 |
4x4 |
Permit Number 773752 |
6013302.89282 |
2109368.02055 |
37.7726711397891 |
-122.397382385507 |
(37.7726711397891, -122.397382385507) |
14 |
2 |
9 |
310 |
20 |
193569 |
253745 |
2 |
11 |
1 Henry Adams St |
11 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/03/2017 12:00:00 AM |
3 |
3x6 |
|
6011517 |
2108140 |
37.7691996810398 |
-122.403473604048 |
(37.7691996810398, -122.403473604048) |
8 |
2 |
8 |
28853 |
20 |
105665 |
253493 |
2 |
116 |
1x Gordon St |
11 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/12/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 772214 |
6009763 |
2109812 |
37.7736924789578 |
-122.409658650953 |
(37.7736924789578, -122.409658650953) |
8 |
2 |
9 |
28853 |
34 |
130074 |
255415 |
2 |
75 |
199x Hayes St |
11 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/21/2018 12:00:00 AM |
3 |
3x3 |
|
6006976 |
2111107 |
37.7770916699959 |
-122.419391225109 |
(37.7770916699959, -122.419391225109) |
7 |
9 |
9 |
28852 |
36 |
19663 |
256686 |
2 |
385 |
330 Twin Peaks Blvd |
11 |
Back Yard : Yard |
Tree |
2 |
|
03/27/2019 12:00:00 AM |
3 |
3x3 |
|
5998688 |
2103995 |
37.7570936308358 |
-122.447549834506 |
(37.7570936308358, -122.447549834506) |
15 |
5 |
4 |
63 |
38 |
128498 |
121278 |
2 |
22 |
369 18th Ave |
11 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
3 |
4.5x15 |
Permit Number 777516 |
5990184 |
2112906 |
37.781071152831 |
-122.477610920079 |
(37.781071152831, -122.477610920079) |
11 |
6 |
2 |
55 |
26 |