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) |
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 |
86960 |
115393 |
1 |
27 |
800x Rutland St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
Private |
|
4 |
3x3 |
|
6009906.50061 |
2087474.92929 |
37.712367789705 |
-122.407587055718 |
(37.712367789705, -122.407587055718) |
9 |
7 |
8 |
309 |
39 |
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 |
97775 |
114024 |
4 |
17 |
3151X CLAY ST |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
|
|
3x3 |
|
5999725 |
2115439 |
37.7885751609396 |
-122.444786082443 |
(37.7885751609396, -122.444786082443) |
13 |
6 |
1 |
29490 |
27 |
107985 |
115744 |
4 |
53 |
1X POND ST |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
Rec/Park |
|
24 |
3x3 |
|
6003250 |
2106477 |
37.764168263012 |
-122.431949928803 |
(37.764168263012, -122.431949928803) |
15 |
4 |
5 |
28862 |
3 |
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 |
52492 |
15728 |
7 |
1 |
4400 Mission St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
12 |
|
04/20/1995 12:00:00 AM |
4 |
3X3 |
|
6002668.6888386 |
2093023.5286977 |
37.7271952084184 |
-122.432999267314 |
(37.7271952084184, -122.432999267314) |
9 |
7 |
6 |
28861 |
25 |
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 |