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) |
143936 |
106224 |
4 |
53 |
340 SUTTER ST |
1 |
Sidewalk: Curb side : Cutout |
Tree |
3 |
|
|
24 |
3x5 |
|
6010923.2 |
2115578.3 |
37.7895903312377 |
-122.406051628897 |
(37.7895903312377, -122.406051628897) |
5 |
1 |
10 |
28857 |
6 |
152930 |
91827 |
7 |
148 |
1941 Harrison St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
3 |
|
03/07/2007 12:00:00 AM |
3 |
3x3 |
|
6008705.970676 |
2107189.131 |
37.7664314036014 |
-122.413129591178 |
(37.7664314036014, -122.413129591178) |
8 |
4 |
7 |
28853 |
19 |
156649 |
251254 |
1 |
133 |
330 09th Ave |
1 |
unknown : Cutout |
Tree |
3 |
|
|
|
3x3 |
|
5993109 |
2113253 |
37.7821932251036 |
-122.467517213871 |
(37.7821932251036, -122.467517213871) |
11 |
6 |
2 |
54 |
11 |
160410 |
116604 |
4 |
101 |
1325x 08TH AVE |
1 |
Front Yard : Yard |
Tree |
3 |
|
|
|
|
|
5993613 |
2106469 |
37.7635952548206 |
-122.465280685608 |
(37.7635952548206, -122.465280685608) |
1 |
8 |
11 |
56 |
12 |
179300 |
106217 |
1 |
38 |
585X Bush St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
3 |
|
|
10 |
3x5 |
|
6010670.9358 |
2115847.83327 |
37.7903162925068 |
-122.406943445993 |
(37.7903162925068, -122.406943445993) |
5 |
1 |
10 |
28857 |
6 |
183279 |
116347 |
4 |
60 |
4051X 24TH ST |
1 |
Sidewalk: Curb side : Cutout |
Tree |
3 |
|
|
10 |
3x3 |
|
6002850 |
2101803 |
37.7513118941202 |
-122.432999456035 |
(37.7513118941202, -122.432999456035) |
2 |
4 |
5 |
28862 |
22 |
82544 |
91762 |
7 |
32 |
1940 Harrison St |
|
Sidewalk: Curb side : Cutout |
Tree |
3 |
|
03/07/2007 12:00:00 AM |
3 |
3x3 |
|
6008660.813755 |
2107281.610975 |
37.7666827970273 |
-122.413292321769 |
(37.7666827970273, -122.413292321769) |
8 |
4 |
7 |
28853 |
19 |