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) |
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 |
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 |
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 |
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 |
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 |