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) |
54547 |
105345 |
12 |
70 |
466 Gonzalez Dr |
3 |
Sidewalk: Curb side : Yard |
Tree |
2 |
|
|
|
|
|
5989603.4 |
2089229.6 |
37.7160282834266 |
-122.477888136934 |
(37.7160282834266, -122.477888136934) |
1 |
8 |
4 |
64 |
14 |
4559 |
109532 |
12 |
155 |
818 Goettingen St |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6010847.3 |
2090865.3 |
37.7217296747854 |
-122.404573864697 |
(37.7217296747854, -122.404573864697) |
10 |
3 |
7 |
309 |
28 |
27555 |
173771 |
12 |
17 |
231 Stratford Dr |
1 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
02/13/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 779366 |
5990884.97189 |
2090977.23451 |
37.7209011553391 |
-122.473585870316 |
(37.7209011553391, -122.473585870316) |
9 |
8 |
4 |
64 |
40 |
2598 |
95032 |
12 |
17 |
211 Maynard St |
|
Front Yard : Cutout |
Landscaping |
2 |
|
|
|
|
|
6004772 |
2093802 |
37.7294517978782 |
-122.425783519869 |
(37.7294517978782, -122.425783519869) |
9 |
7 |
6 |
28861 |
5 |
153890 |
173885 |
12 |
17 |
410 Hearst Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
02/03/2017 12:00:00 AM |
3 |
3x3 |
Permit Number 774920 |
5998687.3529 |
2094401.81487 |
37.7307530256695 |
-122.446861792344 |
(37.7307530256695, -122.446861792344) |
9 |
7 |
4 |
59 |
40 |
39770 |
122604 |
12 |
84 |
132 Surrey St |
3 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
11/21/2016 12:00:00 AM |
3 |
3x3 |
Permit Number 779127 |
6002205.30607 |
2096205.31937 |
37.7359053840536 |
-122.434828615692 |
(37.7359053840536, -122.434828615692) |
2 |
7 |
5 |
63 |
7 |
175182 |
122603 |
12 |
84 |
132 Surrey St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
Permit Number 779127 |
6002205.30607 |
2096205.31937 |
37.7359053840536 |
-122.434828615692 |
(37.7359053840536, -122.434828615692) |
2 |
7 |
5 |
63 |
7 |
161403 |
85018 |
12 |
7 |
455 Valley St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
06/14/2007 12:00:00 AM |
|
|
Permit Number 49374 |
6002971 |
2099180 |
37.744116613623 |
-122.432393702977 |
(37.744116613623, -122.432393702977) |
2 |
7 |
5 |
63 |
22 |
37579 |
110020 |
12 |
62 |
1490X Douglass St |
1 |
Sidewalk: Property side : Yard |
Tree |
2 |
|
|
|
9x9 |
|
6001386.81709 |
2099547.0285 |
37.7450344302078 |
-122.437897729467 |
(37.7450344302078, -122.437897729467) |
2 |
7 |
5 |
63 |
22 |
57641 |
87858 |
12 |
131 |
|
|
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
3x3 |
|
6000340.49747 |
2104887.90927 |
37.7596396402708 |
-122.441898968169 |
(37.7596396402708, -122.441898968169) |
2 |
4 |
5 |
28862 |
3 |
50373 |
95369 |
12 |
17 |
27 Hartford St |
|
Front Yard : Cutout |
Landscaping |
2 |
|
02/18/2011 12:00:00 AM |
|
|
|
6002651 |
2105744 |
37.7621216467866 |
-122.433969295968 |
(37.7621216467866, -122.433969295968) |
15 |
4 |
5 |
28862 |
3 |
132048 |
105442 |
12 |
17 |
38 Museum Way |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
|
|
|
6000691.7 |
2106753.8 |
37.764782922965 |
-122.440818185531 |
(37.764782922965, -122.440818185531) |
15 |
5 |
5 |
28862 |
3 |
88442 |
32776 |
12 |
17 |
552 Broderick St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
FUF |
12/20/2010 12:00:00 AM |
|
|
Permit Number 54024 |
6001158.24288979 |
2110568.68225327 |
37.7752841981665 |
-122.43947802668 |
(37.7752841981665, -122.43947802668) |
15 |
5 |
11 |
29492 |
10 |
66547 |
105124 |
12 |
58 |
134 26th Ave |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
14 |
4x4 |
|
5987764.1 |
2115070.3 |
37.7868729795597 |
-122.486141380245 |
(37.7868729795597, -122.486141380245) |
11 |
6 |
1 |
55 |
33 |
16209 |
262261 |
12 |
40 |
290 Green St |
|
: |
Tree |
2 |
FUF |
06/18/2020 12:00:00 AM |
3 |
|
Permit Number 785454 |
6011550.34746 |
2119418.71162 |
37.8001702361868 |
-122.404152146942 |
(37.8001702361868, -122.404152146942) |
3 |
1 |
10 |
308 |
23 |