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) |
84993 |
253492 |
2 |
116 |
1x Gordon St |
10 |
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 |
178080 |
253744 |
2 |
11 |
1 Henry Adams St |
10 |
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 |
72419 |
255414 |
2 |
75 |
199x Hayes St |
10 |
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 |
63982 |
121515 |
2 |
11 |
300 Folsom St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6014751 |
2115177 |
37.7887018021562 |
-122.392779649259 |
(37.7887018021562, -122.392779649259) |
6 |
2 |
9 |
28855 |
6 |
127405 |
256685 |
2 |
385 |
330 Twin Peaks Blvd |
10 |
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 |
172560 |
122428 |
2 |
159 |
2655 Bush St |
10 |
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 |
16206 |
109465 |
2 |
164 |
360 Berry St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
8 |
4x4 |
Permit Number 773752 |
6013321.87847 |
2109385.26551 |
37.7727195476045 |
-122.397317921189 |
(37.7727195476045, -122.397317921189) |
14 |
2 |
9 |
310 |
20 |
37035 |
198590 |
2 |
31 |
980 16th St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013501.44813 |
2107135.10099 |
37.766551094089 |
-122.396539005766 |
(37.766551094089, -122.396539005766) |
14 |
3 |
8 |
28856 |
20 |
61796 |
203209 |
2 |
72 |
189 Hubbell St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013274.22218 |
2107384.36901 |
37.7672228804628 |
-122.397342427714 |
(37.7672228804628, -122.397342427714) |
14 |
3 |
8 |
28856 |
20 |
109444 |
255700 |
2 |
72 |
510 Townsend St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
06/27/2018 12:00:00 AM |
3 |
3x3 |
|
6012573 |
2109637 |
37.773369031352 |
-122.399926071367 |
(37.773369031352, -122.399926071367) |
14 |
2 |
9 |
28853 |
34 |
5543 |
121277 |
2 |
22 |
369 18th Ave |
10 |
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 |