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) |
171171 |
253477 |
2 |
140 |
1222 Harrison St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/12/2017 12:00:00 AM |
3 |
3x6 |
Permit Number 772214 |
6009984 |
2109753 |
37.7735428603255 |
-122.408890010762 |
(37.7735428603255, -122.408890010762) |
8 |
2 |
9 |
28853 |
34 |
176443 |
253103 |
2 |
14 |
3000x Irving St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/25/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 778939 |
5986427 |
2106455 |
37.7631397866436 |
-122.490133427734 |
(37.7631397866436, -122.490133427734) |
1 |
8 |
3 |
56 |
35 |
176471 |
252908 |
2 |
36 |
600 South Van Ness Ave |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
06/26/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 777588 |
6007451.05071 |
2106154.24093 |
37.7635193076139 |
-122.417396792879 |
(37.7635193076139, -122.417396792879) |
8 |
4 |
7 |
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 |
183902 |
253394 |
2 |
31 |
115 Steuart St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
08/30/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 771767 |
6014754.16338 |
2116767.09226 |
37.7930680031541 |
-122.392879995147 |
(37.7930680031541, -122.392879995147) |
12 |
2 |
9 |
28855 |
6 |
184177 |
121536 |
2 |
11 |
201 Folsom St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
6x6 |
|
6015114 |
2115064 |
37.7884116849322 |
-122.391515808663 |
(37.7884116849322, -122.391515808663) |
6 |
2 |
9 |
28855 |
6 |
187328 |
117481 |
2 |
163 |
601 PACHECO ST |
3 |
Sidewalk: Property side : Cutout |
Tree |
2 |
|
|
|
3x9 |
|
5993107 |
2101833 |
37.7508368102529 |
-122.466693753982 |
(37.7508368102529, -122.466693753982) |
1 |
8 |
4 |
29491 |
12 |
187618 |
253249 |
2 |
72 |
570 Jessie St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
08/09/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 775513 |
6009730.1467 |
2112442.13768 |
37.7809123781536 |
-122.409958002933 |
(37.7809123781536, -122.409958002933) |
14 |
2 |
9 |
28853 |
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 |
194150 |
121524 |
2 |
12 |
280 Beale St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
6x10 |
|
6014751 |
2115177 |
37.7887018021562 |
-122.392779649259 |
(37.7887018021562, -122.392779649259) |
6 |
2 |
9 |
28855 |
6 |
194230 |
251520 |
2 |
11 |
173 Sanchez St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x15 |
|
6003549.6097 |
2107381.8851 |
37.7666698392386 |
-122.430978251884 |
(37.7666698392386, -122.430978251884) |
7 |
9 |
5 |
28862 |
3 |