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) |
6318 |
261662 |
5 |
168 |
137 Elsie St |
1 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
02/13/2020 12:00:00 AM |
3 |
|
|
6007155.81154 |
2098485.15545 |
37.7424451335194 |
-122.417874270912 |
(37.7424451335194, -122.417874270912) |
2 |
7 |
7 |
28859 |
2 |
5528 |
167133 |
5 |
10 |
4564 19th St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/01/2019 12:00:00 AM |
3 |
3x5 |
Permit Number 785333 |
6000784.60188 |
2104670.73247 |
37.7590686222364 |
-122.440347461192 |
(37.7590686222364, -122.440347461192) |
2 |
4 |
5 |
28862 |
3 |
6198 |
112830 |
5 |
36 |
2265 MISSION ST |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
08/21/2015 12:00:00 AM |
3 |
3x3 |
|
6006944 |
2105170 |
37.760788269781 |
-122.419080706794 |
(37.760788269781, -122.419080706794) |
2 |
4 |
7 |
28859 |
19 |
7765 |
263633 |
5 |
146 |
160 Caselli Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/01/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 782824 |
6000235.49843 |
2104901.88273 |
37.7596720242526 |
-122.442263109517 |
(37.7596720242526, -122.442263109517) |
2 |
4 |
5 |
28862 |
3 |
6139 |
264669 |
5 |
297 |
1890 Church St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/11/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 770415 |
6004581.61952 |
2097649.26106 |
37.7400047512279 |
-122.426715548384 |
(37.7400047512279, -122.426715548384) |
2 |
7 |
5 |
63 |
7 |
15098 |
169494 |
5 |
297 |
1890 Church St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/11/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 770415 |
6004581.61952 |
2097649.26106 |
37.7400047512279 |
-122.426715548384 |
(37.7400047512279, -122.426715548384) |
2 |
7 |
5 |
63 |
7 |
17710 |
169495 |
5 |
297 |
150 Randall St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/11/2020 12:00:00 AM |
3 |
Width 3ft |
Permit Number 770415 |
6004561.3283 |
2097566.6275 |
37.7397767110236 |
-122.426779823841 |
(37.7397767110236, -122.426779823841) |
2 |
7 |
5 |
63 |
7 |
11247 |
264702 |
5 |
19 |
625 Guerrero St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/17/2020 12:00:00 AM |
|
3x3 |
Permit Number 783216 |
6005628.43923 |
2105332.18724 |
37.761159426347 |
-122.42364218242 |
(37.761159426347, -122.42364218242) |
2 |
4 |
5 |
28859 |
19 |
9107 |
264723 |
5 |
32 |
335 Precita Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/18/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 782646 |
6008658.96802 |
2100212.34216 |
37.7472720863526 |
-122.412798868954 |
(37.7472720863526, -122.412798868954) |
2 |
7 |
7 |
28859 |
2 |
16257 |
225172 |
5 |
343 |
248 Prospect Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
10/08/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 779647 |
6006535.62128 |
2098220.14009 |
37.7416825381227 |
-122.419999905071 |
(37.7416825381227, -122.419999905071) |
2 |
7 |
7 |
28859 |
2 |
16057 |
167157 |
5 |
19 |
368 Diamond St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/11/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 782616 |
6001774.58914 |
2103700.91584 |
37.7564620577863 |
-122.436854194887 |
(37.7564620577863, -122.436854194887) |
2 |
4 |
5 |
28862 |
3 |
18916 |
152848 |
5 |
1 |
160 San Carlos St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/12/2019 12:00:00 AM |
3 |
Width 3ft |
Permit Number 781252 |
6006654.74312 |
2105190.58967 |
37.7608285109489 |
-122.420082580673 |
(37.7608285109489, -122.420082580673) |
2 |
4 |
7 |
28859 |
19 |