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) |
9418 |
251108 |
11 |
160 |
1700X Quesada Ave |
2 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10155 |
251115 |
11 |
160 |
1700X Quesada Ave |
19 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12966 |
251112 |
11 |
160 |
1700X Quesada Ave |
14 |
Median : |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13313 |
251111 |
11 |
160 |
1700X Quesada Ave |
7 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13831 |
251113 |
11 |
160 |
1700X Quesada Ave |
15 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15958 |
251109 |
11 |
160 |
1700X Quesada Ave |
3 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15995 |
251116 |
11 |
160 |
1700X Quesada Ave |
20 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19170 |
251114 |
11 |
160 |
1700X Quesada Ave |
16 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19478 |
251110 |
11 |
160 |
1700X Quesada Ave |
5 |
Median : Yard |
Tree |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45318 |
194287 |
11 |
160 |
1700x Quesada Ave |
32 |
Median : Yard |
Tree |
1 |
|
|
31 |
|
|
6014435.32238 |
2095233.37666 |
37.7339234087228 |
-122.392476296866 |
(37.7339234087228, -122.392476296866) |
10 |
3 |
8 |
58 |
1 |
25166 |
194288 |
11 |
160 |
1700x Quesada Ave |
37 |
Median : Yard |
Tree |
1 |
|
|
34 |
|
|
6014411.93404 |
2095259.01392 |
37.7339925045513 |
-122.392558950849 |
(37.7339925045513, -122.392558950849) |
10 |
3 |
8 |
58 |
1 |
62567 |
194289 |
11 |
160 |
1700x Quesada Ave |
38 |
Median : Yard |
Tree |
1 |
|
|
48 |
|
|
6014396.14271 |
2095264.76436 |
37.734007417094 |
-122.392613948889 |
(37.734007417094, -122.392613948889) |
10 |
3 |
8 |
58 |
1 |
65015 |
194291 |
11 |
160 |
1700x Quesada Ave |
41 |
Median : Yard |
Tree |
1 |
|
|
38 |
|
|
6014364.32912 |
2095287.31351 |
37.7340675655682 |
-122.392725516077 |
(37.7340675655682, -122.392725516077) |
10 |
3 |
8 |
58 |
1 |
100815 |
111757 |
11 |
367 |
3440X Folsom St |
1 |
Front Yard : Yard |
Tree |
5 |
|
|
|
|
|
6008633.69746 |
2098934.7859 |
37.743762781475 |
-122.412795946324 |
(37.743762781475, -122.412795946324) |
2 |
7 |
7 |
28859 |
2 |
92644 |
113742 |
11 |
322 |
1580 Valencia St |
2 |
Front Yard : Yard |
Tree |
2 |
|
|
80 |
|
|
6006496 |
2100402 |
37.747671200831 |
-122.420291724307 |
(37.747671200831, -122.420291724307) |
2 |
7 |
7 |
28859 |
2 |
40100 |
251597 |
11 |
322 |
1650 Valencia St |
1 |
Side Yard : Yard |
Tree |
2 |
|
|
|
|
|
6006336 |
2100501 |
37.7479340151765 |
-122.420852023863 |
(37.7479340151765, -122.420852023863) |
2 |
7 |
7 |
28859 |
2 |
4150 |
111749 |
11 |
172 |
4124 23rd St |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6002319.4 |
2102413.2 |
37.752957247271 |
-122.434877962118 |
(37.752957247271, -122.434877962118) |
2 |
4 |
5 |
28862 |
22 |
126945 |
255504 |
11 |
168 |
757 Pennsylvania Ave |
7 |
Back Yard : Yard |
Tree |
2 |
FUF |
|
|
|
|
6014476.10973 |
2103508.37921 |
37.7566470977886 |
-122.392914033755 |
(37.7566470977886, -122.392914033755) |
10 |
3 |
8 |
28856 |
29 |
16246 |
262100 |
11 |
240 |
3066 Market St |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6000145.77567 |
2105436.95685 |
37.7611360918542 |
-122.442611833669 |
(37.7611360918542, -122.442611833669) |
15 |
5 |
5 |
28862 |
3 |
167750 |
64380 |
11 |
471 |
1221 Stanyan St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
04/21/1988 12:00:00 AM |
|
|
Permit Number 25220 |
5997415.00742592 |
2105661.0761541 |
37.7615954244829 |
-122.452072511028 |
(37.7615954244829, -122.452072511028) |
15 |
5 |
11 |
29492 |
12 |
28932 |
105444 |
11 |
172 |
20-28 ROSEMONT PL |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6005075.5 |
2108088.5 |
37.7686963767089 |
-122.425750755404 |
(37.7686963767089, -122.425750755404) |
8 |
4 |
5 |
28853 |
19 |
16836 |
255909 |
11 |
168 |
2694 McAllister St |
1 |
Front Yard : Yard |
Tree |
2 |
|
|
|
|
Under Review |
5996297 |
2110789 |
37.7756112723889 |
-122.456310013186 |
(37.7756112723889, -122.456310013186) |
11 |
6 |
2 |
54 |
16 |
64831 |
111748 |
11 |
168 |
730 28th Ave |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
5987294.2 |
2110946.4 |
37.7755225253955 |
-122.487464059213 |
(37.7755225253955, -122.487464059213) |
11 |
6 |
2 |
55 |
26 |
146489 |
111205 |
11 |
238 |
46 COOK ST |
|
Back Yard : Yard |
Tree |
2 |
|
|
36 |
|
Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 |
5997514 |
2113392 |
37.7828282170553 |
-122.452288002469 |
(37.7828282170553, -122.452288002469) |
15 |
6 |
1 |
54 |
31 |
172915 |
248932 |
11 |
238 |
46 Cook St |
1 |
Front Yard : Yard |
Tree |
2 |
|
|
|
|
Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 |
5997514 |
2113392 |
37.7828282170553 |
-122.452288002469 |
(37.7828282170553, -122.452288002469) |
15 |
6 |
1 |
54 |
31 |
1493 |
264741 |
11 |
160 |
2040 Sutter St |
2 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6002832.74822 |
2114456.05498 |
37.7860531044459 |
-122.433963466929 |
(37.7860531044459, -122.433963466929) |
13 |
9 |
11 |
29490 |
27 |
15348 |
264739 |
11 |
160 |
2040 Sutter St |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6002832.74822 |
2114456.05498 |
37.7860531044459 |
-122.433963466929 |
(37.7860531044459, -122.433963466929) |
13 |
9 |
11 |
29490 |
27 |
27160 |
111763 |
11 |
41 |
2626 Vallejo St |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6001000.6 |
2117623.4 |
37.7946456667745 |
-122.440529445268 |
(37.7946456667745, -122.440529445268) |
13 |
9 |
1 |
57 |
27 |