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) |
81974 |
256777 |
2 |
9 |
2828 Webster St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/13/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 777329 |
6003004.23187 |
2118313.15271 |
37.7966534371422 |
-122.433645942426 |
(37.7966534371422, -122.433645942426) |
13 |
9 |
1 |
57 |
17 |
70470 |
146088 |
2 |
9 |
2828 Webster St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
12/13/2018 12:00:00 AM |
3 |
3x3 |
Permit Number 777329 |
6003000.78966 |
2118372.69184 |
37.7968167208658 |
-122.433662110612 |
(37.7968167208658, -122.433662110612) |
13 |
9 |
1 |
57 |
17 |
145251 |
108356 |
2 |
13 |
250X Pixley St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
16 |
|
11/02/2018 12:00:00 AM |
3 |
2x4 |
Permit Number 773698 |
6002158.91155 |
2118972.60439 |
37.7984161192732 |
-122.436618162405 |
(37.7984161192732, -122.436618162405) |
13 |
9 |
1 |
57 |
17 |
119169 |
117250 |
2 |
7 |
2474 Broadway |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
09/13/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 773044 |
6001780.62325 |
2117368.05955 |
37.7939889537763 |
-122.437812170719 |
(37.7939889537763, -122.437812170719) |
13 |
9 |
1 |
57 |
27 |
148701 |
115559 |
2 |
27 |
2539 Vallejo St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
18 |
3x3 |
|
6001373.79142 |
2117611.09107 |
37.7946331129763 |
-122.439237274207 |
(37.7946331129763, -122.439237274207) |
13 |
9 |
1 |
57 |
27 |
148677 |
121464 |
2 |
11 |
2353 Lombard St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6001140 |
2119261 |
37.7991500226194 |
-122.440164592168 |
(37.7991500226194, -122.440164592168) |
13 |
9 |
1 |
57 |
17 |
86670 |
146397 |
2 |
1 |
3318 Scott St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/28/2019 12:00:00 AM |
3 |
Width 4ft |
Permit Number 780850 |
6000857.39871 |
2119780.85133 |
37.8005613036105 |
-122.441179804419 |
(37.8005613036105, -122.441179804419) |
13 |
9 |
1 |
57 |
17 |
127597 |
103379 |
2 |
31 |
2712 Broadway |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/21/2013 12:00:00 AM |
4 |
3x3 |
Permit Number 770136 |
6000520 |
2117210 |
37.7934832007909 |
-122.44216269001 |
(37.7934832007909, -122.44216269001) |
13 |
9 |
1 |
57 |
27 |
15497 |
33110 |
2 |
149 |
2626 Filbert St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
FUF |
07/02/2020 12:00:00 AM |
3 |
|
Permit Number 769981 |
6000381.41365 |
2118563.70291 |
37.7971922129921 |
-122.442739455458 |
(37.7971922129921, -122.442739455458) |
13 |
9 |
1 |
57 |
17 |
4259 |
33111 |
2 |
22 |
2626 Filbert St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/02/2020 12:00:00 AM |
3 |
4x4 |
Permit Number 769981 |
6000363.34088 |
2118561.77591 |
37.7971858916671 |
-122.442801853125 |
(37.7971858916671, -122.442801853125) |
13 |
9 |
1 |
57 |
17 |
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 |
17726 |
65839 |
2 |
14 |
2328 North Point St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/03/2018 12:00:00 AM |
3 |
6x6 |
Permit Number 772721 |
5999589.88517 |
2120533.82376 |
37.802556482867 |
-122.445620078411 |
(37.802556482867, -122.445620078411) |
13 |
9 |
1 |
57 |
17 |
175587 |
68987 |
2 |
64 |
767 Marina Blvd |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
10/06/2016 12:00:00 AM |
3 |
10x10 |
Permit Number 775182 |
5999291.63198947 |
2121477.34728573 |
37.8051301110493 |
-122.44672010757 |
(37.8051301110493, -122.44672010757) |
13 |
9 |
1 |
57 |
17 |