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) |
189573 |
198589 |
2 |
31 |
980 16th St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013524.37895 |
2107133.46335 |
37.76654787361 |
-122.396459576758 |
(37.76654787361, -122.396459576758) |
14 |
3 |
8 |
28856 |
20 |
185964 |
256684 |
2 |
385 |
330 Twin Peaks Blvd |
9 |
Back Yard : Yard |
Tree |
2 |
|
03/27/2019 12:00:00 AM |
3 |
3x3 |
|
5998688 |
2103995 |
37.7570936308358 |
-122.447549834506 |
(37.7570936308358, -122.447549834506) |
15 |
5 |
4 |
63 |
38 |
178102 |
255413 |
2 |
75 |
199x Hayes St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/21/2018 12:00:00 AM |
3 |
3x3 |
|
6006976 |
2111107 |
37.7770916699959 |
-122.419391225109 |
(37.7770916699959, -122.419391225109) |
7 |
9 |
9 |
28852 |
36 |
154592 |
109464 |
2 |
164 |
360 Berry St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
8 |
4x4 |
Permit Number 773752 |
6013338.99753 |
2109402.36294 |
37.7727674463814 |
-122.39725990323 |
(37.7727674463814, -122.39725990323) |
14 |
2 |
9 |
310 |
20 |
103030 |
121533 |
2 |
12 |
333 Beale St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
6x10 |
|
6015114 |
2115064 |
37.7884116849322 |
-122.391515808663 |
(37.7884116849322, -122.391515808663) |
6 |
2 |
9 |
28855 |
6 |
81956 |
122427 |
2 |
159 |
2655 Bush St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
10/31/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 770253 |
6000851.7 |
2114462.1 |
37.7859570793449 |
-122.440817776746 |
(37.7859570793449, -122.440817776746) |
15 |
6 |
1 |
29490 |
27 |
80342 |
121514 |
2 |
11 |
300 Folsom St |
9 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6014751 |
2115177 |
37.7887018021562 |
-122.392779649259 |
(37.7887018021562, -122.392779649259) |
6 |
2 |
9 |
28855 |
6 |
57754 |
203208 |
2 |
72 |
189 Hubbell St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/20/2018 12:00:00 AM |
3 |
Width 4ft |
Permit Number 775761 |
6013261.21102 |
2107370.66012 |
37.7671845144907 |
-122.397386470235 |
(37.7671845144907, -122.397386470235) |
14 |
3 |
8 |
28856 |
20 |
37180 |
44003 |
2 |
50 |
2701X 17th St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/05/2016 12:00:00 AM |
|
3x3 |
Permit Number 775718 |
6009464.30573862 |
2106385.10315991 |
37.7642662704227 |
-122.410449858863 |
(37.7642662704227, -122.410449858863) |
8 |
4 |
7 |
28859 |
19 |
36333 |
253491 |
2 |
116 |
1x Gordon St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/12/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 772214 |
6009763 |
2109812 |
37.7736924789578 |
-122.409658650953 |
(37.7736924789578, -122.409658650953) |
8 |
2 |
9 |
28853 |
34 |
26350 |
115356 |
2 |
75 |
399 Fremont St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/28/2016 12:00:00 AM |
3 |
4x10 |
Permit Number 773314 |
6014763.69701 |
2114705.74438 |
37.7874085478076 |
-122.392702738938 |
(37.7874085478076, -122.392702738938) |
6 |
2 |
9 |
28855 |
6 |
15918 |
255699 |
2 |
11 |
510 Townsend St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
06/27/2018 12:00:00 AM |
3 |
3x3 |
|
6012573 |
2109637 |
37.773369031352 |
-122.399926071367 |
(37.773369031352, -122.399926071367) |
14 |
2 |
9 |
28853 |
34 |
6978 |
253743 |
2 |
11 |
1 Henry Adams St |
9 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/03/2017 12:00:00 AM |
3 |
3x6 |
|
6011517 |
2108140 |
37.7691996810398 |
-122.403473604048 |
(37.7691996810398, -122.403473604048) |
8 |
2 |
8 |
28853 |
20 |