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) |
5412 |
261620 |
2 |
17 |
1633 Washington St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/05/2020 12:00:00 AM |
3 |
3x3 |
|
6006860 |
2117000 |
37.7932658708928 |
-122.420210847334 |
(37.7932658708928, -122.420210847334) |
13 |
9 |
10 |
28858 |
32 |
20307 |
253871 |
2 |
19 |
1601 Larkin St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/27/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 56289 |
6007037 |
2116831 |
37.7928118105792 |
-122.419586418272 |
(37.7928118105792, -122.419586418272) |
13 |
9 |
10 |
28858 |
32 |
25098 |
257924 |
2 |
9 |
1490x Green St |
5 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/04/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 779557 |
6005922 |
2118675 |
37.79781210117 |
-122.423575535726 |
(37.79781210117, -122.423575535726) |
13 |
9 |
10 |
28858 |
32 |
45019 |
253872 |
2 |
19 |
1601 Larkin St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/27/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 56289 |
6007037 |
2116831 |
37.7928118105792 |
-122.419586418272 |
(37.7928118105792, -122.419586418272) |
13 |
9 |
10 |
28858 |
32 |
50619 |
257922 |
2 |
9 |
1490x Green St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/04/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 779557 |
6005922 |
2118675 |
37.79781210117 |
-122.423575535726 |
(37.79781210117, -122.423575535726) |
13 |
9 |
10 |
28858 |
32 |
72671 |
255301 |
2 |
1 |
1238 Sutter St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/07/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 777218 |
6006649 |
2115006 |
37.7877789501949 |
-122.420799295532 |
(37.7877789501949, -122.420799295532) |
13 |
9 |
10 |
28858 |
21 |
104150 |
257920 |
2 |
9 |
1490x Green St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/04/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 779557 |
6005922 |
2118675 |
37.79781210117 |
-122.423575535726 |
(37.79781210117, -122.423575535726) |
13 |
9 |
10 |
28858 |
32 |
156271 |
253867 |
2 |
19 |
1628 Clay St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/27/2017 12:00:00 AM |
3 |
Width 3ft |
Permit Number 56289 |
6006959.29312 |
2116755.16361 |
37.7925992053311 |
-122.419849904466 |
(37.7925992053311, -122.419849904466) |
13 |
9 |
10 |
28858 |
32 |
156329 |
253868 |
2 |
19 |
1628 Clay St |
5 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/27/2017 12:00:00 AM |
3 |
Width 3ft |
Permit Number 56289 |
6006959.29312 |
2116755.16361 |
37.7925992053311 |
-122.419849904466 |
(37.7925992053311, -122.419849904466) |
13 |
9 |
10 |
28858 |
32 |
160601 |
255300 |
2 |
1 |
1238 Sutter St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/07/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 777218 |
6006649 |
2115006 |
37.7877789501949 |
-122.420799295532 |
(37.7877789501949, -122.420799295532) |
13 |
9 |
10 |
28858 |
21 |
178936 |
257923 |
2 |
9 |
1490x Green St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/04/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 779557 |
6005922 |
2118675 |
37.79781210117 |
-122.423575535726 |
(37.79781210117, -122.423575535726) |
13 |
9 |
10 |
28858 |
32 |
179226 |
253869 |
2 |
19 |
1601 Larkin St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/27/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 56289 |
6007037 |
2116831 |
37.7928118105792 |
-122.419586418272 |
(37.7928118105792, -122.419586418272) |
13 |
9 |
10 |
28858 |
32 |
186623 |
257921 |
2 |
9 |
1490x Green St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/04/2019 12:00:00 AM |
3 |
3x3 |
Permit Number 779557 |
6005922 |
2118675 |
37.79781210117 |
-122.423575535726 |
(37.79781210117, -122.423575535726) |
13 |
9 |
10 |
28858 |
32 |