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) |
5835 |
118375 |
2 |
75 |
340 Fremont St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
2 |
4x6 |
|
6014712.48727 |
2114662.02755 |
37.7872856671566 |
-122.392876855803 |
(37.7872856671566, -122.392876855803) |
6 |
2 |
9 |
28855 |
6 |
37358 |
247943 |
2 |
58 |
29 Joy St |
6 |
Unaccepted Street : Yard |
Tree |
1 |
|
|
2 |
|
Permit Number 775404 |
6010304.2598 |
2098903.51059 |
37.7437705318851 |
-122.407017307297 |
(37.7437705318851, -122.407017307297) |
2 |
7 |
7 |
28859 |
2 |
57149 |
115098 |
2 |
14 |
537 Natoma St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/12/2016 12:00:00 AM |
2 |
2x4 |
Permit Number 769476 |
6010148.06204 |
2111925.42664 |
37.7795170247346 |
-122.408475763058 |
(37.7795170247346, -122.408475763058) |
14 |
2 |
9 |
28853 |
34 |
93218 |
113240 |
2 |
27 |
329 Brannan St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/10/2015 12:00:00 AM |
2 |
3x4 |
Permit Number 770912 |
6014728.70394 |
2112464.72966 |
37.7812532891345 |
-122.392666980121 |
(37.7812532891345, -122.392666980121) |
6 |
2 |
9 |
28856 |
6 |
96451 |
225775 |
2 |
22 |
577 Castro St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
2 |
Width 3ft |
Permit Number 782239 |
6002401.77617 |
2104846.28665 |
37.75964259654 |
-122.43476706624 |
(37.75964259654, -122.43476706624) |
2 |
4 |
5 |
28862 |
3 |
98758 |
101942 |
2 |
14 |
537 Natoma St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/12/2016 12:00:00 AM |
2 |
2x4 |
Permit Number 769476 |
6010108.29372 |
2111885.47528 |
37.7794051005107 |
-122.408610520167 |
(37.7794051005107, -122.408610520167) |
14 |
2 |
9 |
28853 |
34 |
118314 |
120115 |
2 |
33 |
2225 Bay St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
2 |
3x3 |
|
6000127.23839 |
2120216.52423 |
37.8017159270068 |
-122.443737765003 |
(37.8017159270068, -122.443737765003) |
13 |
9 |
1 |
57 |
17 |
122740 |
115096 |
2 |
14 |
537 Natoma St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/12/2016 12:00:00 AM |
2 |
2x4 |
Permit Number 769476 |
6010119.08101 |
2111896.4319 |
37.7794357889593 |
-122.408573975335 |
(37.7794357889593, -122.408573975335) |
14 |
2 |
9 |
28853 |
34 |
141915 |
225774 |
2 |
22 |
577 Castro St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
2 |
Width 3ft |
Permit Number 782239 |
6002400.68275 |
2104833.82508 |
37.7596083179996 |
-122.434769956692 |
(37.7596083179996, -122.434769956692) |
2 |
4 |
5 |
28862 |
3 |
159283 |
192594 |
2 |
11 |
1321 Mission St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/09/1995 12:00:00 AM |
2 |
Width 4ft |
Permit Number 770747 |
6008274.3646 |
2110675.08431 |
37.7759787734355 |
-122.414869184668 |
(37.7759787734355, -122.414869184668) |
8 |
2 |
9 |
28853 |
34 |
180615 |
122686 |
2 |
51 |
3474 17th St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
2 |
3x3 |
|
6005720 |
2106109 |
37.7632975389877 |
-122.423380737252 |
(37.7632975389877, -122.423380737252) |
8 |
4 |
5 |
28859 |
19 |
183224 |
115097 |
2 |
14 |
537 Natoma St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/12/2016 12:00:00 AM |
2 |
2x4 |
Permit Number 769476 |
6010133.89472 |
2111910.59383 |
37.779475503918 |
-122.408523727481 |
(37.779475503918, -122.408523727481) |
14 |
2 |
9 |
28853 |
34 |