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) |
3 |
121463 |
2 |
3 |
415 Oxford St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/01/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 778984 |
6006773.54328 |
2092061.724 |
37.7247862819155 |
-122.418740608563 |
(37.7247862819155, -122.418740608563) |
9 |
7 |
7 |
309 |
28 |
27 |
121462 |
2 |
3 |
415 Oxford St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/01/2020 12:00:00 AM |
3 |
3x3 |
Permit Number 778984 |
6006773.54328 |
2092061.724 |
37.7247862819155 |
-122.418740608563 |
(37.7247862819155, -122.418740608563) |
9 |
7 |
7 |
309 |
28 |
23615 |
117008 |
2 |
40 |
1315 Silliman St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/13/2016 12:00:00 AM |
3 |
3x3 |
|
6006952.61647 |
2093135.11232 |
37.7277436552341 |
-122.418197638517 |
(37.7277436552341, -122.418197638517) |
9 |
3 |
7 |
309 |
5 |
27287 |
255049 |
2 |
49 |
925 Woolsey St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/10/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 779631 |
6009075.60356 |
2091383.60862 |
37.7230536656288 |
-122.410734764023 |
(37.7230536656288, -122.410734764023) |
9 |
3 |
7 |
309 |
28 |
27582 |
116803 |
2 |
14 |
931 Silver Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/27/2016 12:00:00 AM |
3 |
3x3 |
|
6007342.71844 |
2093540.39539 |
37.7288784251848 |
-122.416877747635 |
(37.7288784251848, -122.416877747635) |
9 |
3 |
7 |
309 |
28 |
41739 |
253164 |
2 |
17 |
146 Cambridge St |
1 |
Front Yard : Cutout |
Tree |
2 |
|
07/27/2017 12:00:00 AM |
3 |
4x4 |
|
6006598.94029 |
2094006.41191 |
37.7301161400075 |
-122.419482094225 |
(37.7301161400075, -122.419482094225) |
9 |
7 |
7 |
309 |
5 |
71950 |
176972 |
2 |
18 |
161 University St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
1 |
Width 3ft |
Permit Number 781886 |
6008005.59306 |
2093164.83572 |
37.7278844827614 |
-122.414559571484 |
(37.7278844827614, -122.414559571484) |
9 |
3 |
7 |
309 |
28 |
99548 |
256905 |
2 |
1 |
338 Princeton St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/03/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 781421 |
6007824.5446 |
2092249.93927 |
37.7253622000817 |
-122.415120729164 |
(37.7253622000817, -122.415120729164) |
9 |
3 |
7 |
309 |
28 |
122256 |
254396 |
2 |
14 |
167 Harvard St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/12/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 774780 |
6006150.23201 |
2093073.81475 |
37.7275301484246 |
-122.420967149802 |
(37.7275301484246, -122.420967149802) |
9 |
7 |
7 |
309 |
5 |
173437 |
255664 |
2 |
17 |
368 Princeton St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
06/25/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 781650 |
6007860.32032 |
2092132.7947 |
37.7250425565594 |
-122.414988767826 |
(37.7250425565594, -122.414988767826) |
9 |
3 |
7 |
309 |
28 |
182774 |
255792 |
2 |
8 |
368 Princeton St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/18/2018 12:00:00 AM |
3 |
3x3 |
|
6007843 |
2092137 |
37.7250531301082 |
-122.415048939995 |
(37.7250531301082, -122.415048939995) |
9 |
3 |
7 |
309 |
28 |