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) |
26350 |
115356 |
2 |
75 |
399 Fremont St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/28/2016 12:00:00 AM |
3 |
4x10 |
Permit Number 773314 |
6014763.69701 |
2114705.74438 |
37.7874085478076 |
-122.392702738938 |
(37.7874085478076, -122.392702738938) |
6 |
2 |
9 |
28855 |
6 |
189573 |
198589 |
2 |
31 |
980 16th St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013524.37895 |
2107133.46335 |
37.76654787361 |
-122.396459576758 |
(37.76654787361, -122.396459576758) |
14 |
3 |
8 |
28856 |
20 |
57754 |
203208 |
2 |
72 |
189 Hubbell St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013261.21102 |
2107370.66012 |
37.7671845144907 |
-122.397386470235 |
(37.7671845144907, -122.397386470235) |
14 |
3 |
8 |
28856 |
20 |
15918 |
255699 |
2 |
11 |
510 Townsend St |
9 |
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 |
6978 |
253743 |
2 |
11 |
1 Henry Adams St |
9 |
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 |
36333 |
253491 |
2 |
116 |
1x Gordon St |
9 |
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 |
178102 |
255413 |
2 |
75 |
199x Hayes St |
9 |
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 |
81956 |
122427 |
2 |
159 |
2655 Bush St |
9 |
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 |
185964 |
256684 |
2 |
385 |
330 Twin Peaks Blvd |
9 |
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 |