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) |
4228 |
254718 |
2 |
31 |
900 16th St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
3x4 |
|
6013911 |
2107143 |
37.7665955668607 |
-122.39512298129 |
(37.7665955668607, -122.39512298129) |
14 |
3 |
8 |
28856 |
20 |
24826 |
198583 |
2 |
31 |
980 16th St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013760.46871 |
2107146.56354 |
37.7665969793027 |
-122.395643896153 |
(37.7665969793027, -122.395643896153) |
14 |
3 |
8 |
28856 |
20 |
26024 |
203202 |
2 |
72 |
189 Hubbell St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013039.197 |
2107156.64294 |
37.7665845074832 |
-122.398139372753 |
(37.7665845074832, -122.398139372753) |
14 |
3 |
8 |
28856 |
20 |
36960 |
113338 |
2 |
14 |
2X STANFORD ST |
3 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
11/10/2015 12:00:00 AM |
|
3x9 |
Permit Number 770912 |
6014727 |
2112481 |
37.7812978691674 |
-122.392674013487 |
(37.7812978691674, -122.392674013487) |
6 |
2 |
9 |
28856 |
6 |
47139 |
257910 |
2 |
17 |
199x Townsend St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/18/2019 12:00:00 AM |
3 |
3x3 |
|
6014800 |
2111540 |
37.778718149686 |
-122.392355631341 |
(37.778718149686, -122.392355631341) |
6 |
2 |
9 |
28856 |
20 |
72432 |
122594 |
2 |
44 |
72 Townsend St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/12/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 779103 |
6015480 |
2112413 |
37.781152948088 |
-122.390064228941 |
(37.781152948088, -122.390064228941) |
6 |
2 |
9 |
28856 |
6 |
84600 |
117455 |
2 |
1 |
236 Shipley St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
3 |
3x3 |
Permit Number 776408 |
6011503.45491 |
2111758.78759 |
37.7791352841027 |
-122.403775126323 |
(37.7791352841027, -122.403775126323) |
14 |
2 |
9 |
28856 |
34 |
91455 |
85807 |
2 |
75 |
210X Shipley St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/05/2017 12:00:00 AM |
3 |
2.5x6 |
Permit Number 778048 |
6011604 |
2111950 |
37.7796659253507 |
-122.403440753721 |
(37.7796659253507, -122.403440753721) |
14 |
2 |
9 |
28856 |
34 |
118733 |
72480 |
2 |
44 |
42X Colin P Kelly Jr St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/12/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 779103 |
6015480 |
2112413 |
37.781152948088 |
-122.390064228941 |
(37.781152948088, -122.390064228941) |
6 |
2 |
9 |
28856 |
6 |
134726 |
113241 |
2 |
27 |
329 Brannan St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/10/2015 12:00:00 AM |
3 |
3x4 |
Permit Number 770912 |
6014742.36618 |
2112476.99378 |
37.7812877223957 |
-122.39262057329 |
(37.7812877223957, -122.39262057329) |
6 |
2 |
9 |
28856 |
6 |
160922 |
121508 |
2 |
19 |
300 Folsom St |
3 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
6 |
3x3 |
|
6012258.9126 |
2112729.3972 |
37.7818425275943 |
-122.401229897449 |
(37.7818425275943, -122.401229897449) |
6 |
2 |
9 |
28856 |
34 |
191366 |
254701 |
2 |
19 |
650 Illinois St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
|
Permit Number 778364 |
6015970.50894 |
2106056.61706 |
37.7637269088073 |
-122.387923622314 |
(37.7637269088073, -122.387923622314) |
14 |
3 |
8 |
28856 |
29 |