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) |
5494 |
261029 |
1 |
2 |
863 31st Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/18/2019 12:00:00 AM |
3 |
4x6 |
|
5986308 |
2110038 |
37.7729707519219 |
-122.490808659035 |
(37.7729707519219, -122.490808659035) |
11 |
6 |
2 |
55 |
26 |
10779 |
49299 |
1 |
2 |
640 45th Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/16/2020 12:00:00 AM |
3 |
|
Permit Number 46308 |
5981979.10455 |
2111331.16831 |
37.7762675789736 |
-122.505878467652 |
(37.7762675789736, -122.505878467652) |
11 |
6 |
2 |
55 |
26 |
13828 |
144979 |
1 |
2 |
626 17th Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/18/2019 12:00:00 AM |
3 |
Width 3ft |
|
5990674.57486 |
2111094.54046 |
37.7761258404607 |
-122.47578147193 |
(37.7761258404607, -122.47578147193) |
11 |
6 |
2 |
54 |
26 |
18500 |
144214 |
1 |
2 |
786 42nd Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/15/2020 12:25:00 PM |
0 |
Width 4ft |
|
5982943.75928 |
2110448.71022 |
37.7739013377013 |
-122.502476188525 |
(37.7739013377013, -122.502476188525) |
11 |
6 |
2 |
55 |
26 |
62023 |
108507 |
7 |
2 |
796 19th Ave |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
FUF |
12/23/2014 12:00:00 AM |
3 |
3x3 |
Permit Number 773790 |
5990094.5666 |
2109953.25495 |
37.772958540137 |
-122.477704410848 |
(37.772958540137, -122.477704410848) |
11 |
6 |
2 |
55 |
26 |
163472 |
109142 |
7 |
2 |
342 29th Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
FUF |
01/29/2015 12:00:00 AM |
3 |
3x3 |
Permit Number 773572 |
5986886.5 |
2113633.7 |
37.7828773022088 |
-122.489071978745 |
(37.7828773022088, -122.489071978745) |
11 |
6 |
2 |
55 |
26 |
190320 |
72375 |
9 |
2 |
4299X Fulton St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
FUF |
03/09/1996 12:00:00 AM |
|
3x3 |
Permit Number 773790 |
5990099.63678033 |
2109979.56687008 |
37.773031079694 |
-122.477688796337 |
(37.773031079694, -122.477688796337) |
11 |
6 |
2 |
55 |
26 |
12272 |
117721 |
1 |
2 |
471 40th Ave |
1 |
Sidewalk: Curb side : Yard |
Tree |
2 |
|
01/25/2020 11:12:00 AM |
3 |
Width 3ft |
|
5983437.41308 |
2112653.95912 |
37.779985305245 |
-122.500931708584 |
(37.779985305245, -122.500931708584) |
11 |
6 |
2 |
55 |
26 |