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) |
101029 |
108939 |
7 |
84 |
1801 Green St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
Private |
01/13/2015 12:00:00 AM |
3 |
3x3 |
Permit Number 774694 |
6004341.9 |
2118349.2 |
37.7968282226561 |
-122.429019881342 |
(37.7968282226561, -122.429019881342) |
13 |
9 |
1 |
57 |
17 |
108681 |
19017 |
1 |
9 |
3150 Sacramento St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
01/19/2011 12:00:00 AM |
3 |
3X3 |
Permit Number 767112 |
5999786.66337 |
2115431.41607 |
37.7885578562165 |
-122.444572191968 |
(37.7885578562165, -122.444572191968) |
13 |
6 |
1 |
29490 |
27 |
21458 |
19018 |
1 |
9 |
3150 Sacramento St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
01/19/2011 12:00:00 AM |
3 |
3X3 |
Permit Number 767112 |
5999751.82821 |
2115426.62042 |
37.7885427008259 |
-122.444692371063 |
(37.7885427008259, -122.444692371063) |
13 |
6 |
1 |
29490 |
27 |
122791 |
91912 |
7 |
36 |
1701X Irving St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
12/15/2008 12:00:00 AM |
3 |
3x3 |
|
5990490.453055 |
2106519.165342 |
37.7635524271157 |
-122.47608414324 |
(37.7635524271157, -122.47608414324) |
1 |
8 |
3 |
56 |
12 |
185383 |
91913 |
7 |
36 |
1701X Irving St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
12/15/2008 12:00:00 AM |
3 |
3x3 |
|
5990490.453055 |
2106519.165342 |
37.7635524271157 |
-122.47608414324 |
(37.7635524271157, -122.47608414324) |
1 |
8 |
3 |
56 |
12 |
72345 |
22312 |
7 |
44 |
5075 03rd St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
07/08/2010 12:00:00 AM |
3 |
3x3 |
Permit Number 53643 |
6014763.8406325 |
2094744.5347125 |
37.7325993861716 |
-122.391306339437 |
(37.7325993861716, -122.391306339437) |
10 |
3 |
8 |
58 |
1 |
33150 |
30749 |
7 |
44 |
5075 03rd St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
03/08/2013 12:00:00 AM |
3 |
3x3 |
Permit Number 53643 |
6014764.79010723 |
2094744.21942808 |
37.7325985731591 |
-122.391303034813 |
(37.7325985731591, -122.391303034813) |
10 |
3 |
8 |
58 |
1 |
160787 |
25469 |
1 |
1 |
345 Randolph St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
03/15/2003 12:00:00 AM |
3 |
3X3 |
|
5993035.9294 |
2088489.917 |
37.7141959153246 |
-122.465970075328 |
(37.7141959153246, -122.465970075328) |
9 |
8 |
6 |
64 |
24 |
136528 |
18592 |
1 |
1 |
345 Randolph St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
11/27/2007 12:00:00 AM |
3 |
3X3 |
|
5993019.1084 |
2088489.2823 |
37.7141932021811 |
-122.466028168642 |
(37.7141932021811, -122.466028168642) |
9 |
8 |
6 |
64 |
24 |