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) |
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 |
37766 |
150676 |
2 |
36 |
548 Rhode Island St |
1 |
Front Yard : Cutout |
Tree |
2 |
|
11/07/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 780811 |
6011754.98399 |
2105812.52377 |
37.7628222449765 |
-122.402486741392 |
(37.7628222449765, -122.402486741392) |
8 |
3 |
8 |
28856 |
29 |
145785 |
253796 |
2 |
8 |
100 Scotia Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/07/2017 12:00:00 AM |
3 |
|
Permit Number 779938 |
6011980.63004 |
2095004.60122 |
37.7331586170673 |
-122.400946899168 |
(37.7331586170673, -122.400946899168) |
10 |
3 |
8 |
58 |
1 |
26571 |
150167 |
2 |
83 |
333 Pennsylvania Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/20/2017 12:00:00 AM |
3 |
Width 3ft |
Permit Number 779492 |
6014367.55242 |
2105483.96934 |
37.7620656102492 |
-122.393427719319 |
(37.7620656102492, -122.393427719319) |
10 |
3 |
8 |
28856 |
29 |
180648 |
57578 |
2 |
13 |
1916 18th St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/23/1976 12:00:00 AM |
20 |
3x3 |
Permit Number 16445 |
6012032 |
2105628 |
37.7623310447467 |
-122.401515665193 |
(37.7623310447467, -122.401515665193) |
8 |
3 |
8 |
28856 |
29 |
21720 |
122796 |
2 |
19 |
306 Arleta Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/28/2016 12:00:00 AM |
3 |
3x3 |
|
6009497.08014 |
2088289.51504 |
37.7145815488228 |
-122.4090595839 |
(37.7145815488228, -122.4090595839) |
9 |
7 |
8 |
309 |
39 |