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) |
142284 |
72735 |
1 |
129 |
3000 Cesar Chavez St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
11/22/1997 12:00:00 AM |
|
3x3 |
|
6009584.26051123 |
2100606.98217244 |
37.7484075731852 |
-122.409627112641 |
(37.7484075731852, -122.409627112641) |
2 |
4 |
7 |
28859 |
19 |
117857 |
231172 |
1 |
129 |
2968 Cesar Chavez St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/09/2016 12:00:00 AM |
3 |
Width 3ft |
|
6009727.404 |
2100624.81411 |
37.7484645559129 |
-122.409133381503 |
(37.7484645559129, -122.409133381503) |
2 |
4 |
7 |
28859 |
19 |
55189 |
13655 |
1 |
129 |
607 Market St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
01/26/2016 10:49:00 AM |
3 |
4X4 |
|
6012064.2714323 |
2115177.7586998 |
37.7885542943226 |
-122.402075446971 |
(37.7885542943226, -122.402075446971) |
12 |
2 |
9 |
28855 |
6 |
144962 |
117956 |
1 |
129 |
851X HARRISON ST |
1 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
|
6 |
3x3 |
|
6012435 |
2111995 |
37.7798358648386 |
-122.400569108585 |
(37.7798358648386, -122.400569108585) |
6 |
2 |
9 |
28856 |
34 |
18276 |
119614 |
6 |
129 |
2X Sutter St |
2 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6012582 |
2115890 |
37.7905388243453 |
-122.400334219916 |
(37.7905388243453, -122.400334219916) |
4 |
1 |
10 |
28854 |
6 |
101055 |
119613 |
6 |
129 |
2X Sutter St |
1 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
12 |
3x3 |
|
6012582 |
2115890 |
37.7905388243453 |
-122.400334219916 |
(37.7905388243453, -122.400334219916) |
4 |
1 |
10 |
28854 |
6 |
11274 |
13515 |
1 |
129 |
333 Market St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
11/25/2019 10:27:00 AM |
3 |
4X4 |
|
6013400.91851 |
2116448.99876 |
37.7921193351998 |
-122.397540013255 |
(37.7921193351998, -122.397540013255) |
12 |
2 |
9 |
28855 |
6 |
40613 |
114302 |
1 |
129 |
435 Brannan St |
6 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/19/2017 12:00:00 AM |
3 |
|
Permit Number 780276 |
6014032.20399 |
2111804.00666 |
37.7794003871666 |
-122.395030252748 |
(37.7794003871666, -122.395030252748) |
6 |
2 |
9 |
28856 |
34 |
71001 |
116973 |
4 |
129 |
121 SPEAR ST |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/05/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 777976 |
6014757 |
2116474 |
37.7922633974731 |
-122.39284966575 |
(37.7922633974731, -122.39284966575) |
12 |
2 |
9 |
28855 |
6 |
687 |
264637 |
1 |
129 |
1290 Egbert Ave |
2 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
FUF |
09/04/2020 12:00:00 AM |
|
4x6 |
|
6014937 |
2090724 |
37.7215694101837 |
-122.390426859327 |
(37.7215694101837, -122.390426859327) |
10 |
3 |
8 |
58 |
1 |
6282 |
264636 |
1 |
129 |
1290 Egbert Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
FUF |
09/04/2020 12:00:00 AM |
|
4x6 |
|
6014937 |
2090724 |
37.7215694101837 |
-122.390426859327 |
(37.7215694101837, -122.390426859327) |
10 |
3 |
8 |
58 |
1 |