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) |
189245 |
52671 |
7 |
2 |
1234@ LINCOLN 08th Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
FUF |
11/10/2010 12:00:00 AM |
|
3x3 |
Permit Number 53911 |
5993637.83557736 |
2107090.14039952 |
37.7653021756316 |
-122.465239907967 |
(37.7653021756316, -122.465239907967) |
11 |
8 |
11 |
56 |
12 |
180205 |
230377 |
1 |
2 |
11 Haight St |
2 |
: |
Tree |
2 |
|
|
6 |
Width 4ft |
|
6006012.13878 |
2109648.33208 |
37.7730321861234 |
-122.422621847921 |
(37.7730321861234, -122.422621847921) |
7 |
9 |
11 |
28852 |
10 |
175044 |
230378 |
1 |
2 |
11 Haight St |
3 |
: |
Tree |
2 |
|
|
5 |
Width 4ft |
|
6006027.69558 |
2109650.1201 |
37.7730379732539 |
-122.422568162015 |
(37.7730379732539, -122.422568162015) |
7 |
9 |
11 |
28852 |
10 |
159858 |
17177 |
7 |
2 |
1601 Octavia St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/14/2007 12:00:00 AM |
3 |
4X4 |
|
6004921.1693652 |
2114736.5058392 |
37.7869414485048 |
-122.426758067349 |
(37.7869414485048, -122.426758067349) |
13 |
9 |
11 |
28858 |
27 |
144860 |
10236 |
1 |
2 |
33 Haight St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
05/30/2002 12:00:00 AM |
8 |
4X4 |
|
6005944.57875 |
2109639.18298 |
37.7730032531225 |
-122.422854896447 |
(37.7730032531225, -122.422854896447) |
7 |
9 |
11 |
28852 |
10 |
70138 |
88771 |
7 |
2 |
461 Baker St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/03/2015 12:00:00 AM |
3 |
3x3 |
Permit Number 775199 |
6000624 |
2110522 |
37.7751256013752 |
-122.441322740074 |
(37.7751256013752, -122.441322740074) |
15 |
5 |
11 |
29492 |
16 |
42966 |
10342 |
1 |
2 |
935 Haight St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
06/04/2011 12:00:00 AM |
3 |
4x4 |
|
6001663.93706 |
2109024.15924 |
37.7710720905099 |
-122.437618081823 |
(37.7710720905099, -122.437618081823) |
15 |
5 |
11 |
29492 |
9 |
41844 |
108873 |
1 |
2 |
137 Cole St |
|
Sidewalk: Curb side : Cutout |
Tree |
2 |
FUF |
01/08/2015 12:00:00 AM |
3 |
3x3 |
Permit Number 773403 |
5997771.92218 |
2110131.23662 |
37.7738897825389 |
-122.451160475717 |
(37.7738897825389, -122.451160475717) |
15 |
5 |
11 |
29492 |
16 |
37211 |
87647 |
1 |
2 |
1989X PINE ST |
3 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
01/30/2008 12:00:00 AM |
3 |
3x3 |
|
6004432 |
2115332 |
37.7885488568913 |
-122.428492943957 |
(37.7885488568913, -122.428492943957) |
13 |
9 |
11 |
28858 |
27 |
30278 |
10232 |
1 |
2 |
11 Haight St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
05/30/2002 12:00:00 AM |
8 |
|
|
6005984.55063 |
2109644.68395 |
37.7730206127534 |
-122.422717019597 |
(37.7730206127534, -122.422717019597) |
7 |
9 |
11 |
28852 |
10 |
21886 |
12447 |
1 |
2 |
1989X Pine St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
02/18/2004 12:00:00 AM |
4 |
3x3 |
|
6004432.6263962 |
2115327.1853144 |
37.7885356724235 |
-122.428490433403 |
(37.7885356724235, -122.428490433403) |
13 |
9 |
11 |
28858 |
27 |