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) |
25718 |
176421 |
1 |
97 |
526 Lathrop Ave |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
18 |
Width 3ft |
|
6013003.58559 |
2086544.76512 |
37.7099866196603 |
-122.396817348641 |
(37.7099866196603, -122.396817348641) |
10 |
3 |
8 |
309 |
1 |
61919 |
43305 |
1 |
97 |
693 Vermont St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
07/12/2000 12:00:00 AM |
6 |
|
Permit Number 43072 |
6011285.67007 |
2105193.27319 |
37.7610957103087 |
-122.4040663601 |
(37.7610957103087, -122.4040663601) |
10 |
3 |
8 |
28856 |
29 |
131588 |
34153 |
7 |
97 |
30 Steuart St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
05/13/1997 12:00:00 AM |
|
|
Permit Number 37992 |
6014341.06792841 |
2117132.86353937 |
37.7940493718531 |
-122.394334961669 |
(37.7940493718531, -122.394334961669) |
12 |
2 |
9 |
28855 |
6 |
86094 |
117224 |
1 |
97 |
1009 HARRISON ST |
10 |
Sidewalk: Curb side : Cutout |
Tree |
1 |
|
|
|
3x10 |
|
6011058 |
2110680 |
37.7761482889947 |
-122.405240157274 |
(37.7761482889947, -122.405240157274) |
14 |
2 |
9 |
28853 |
34 |
51797 |
224520 |
1 |
97 |
439 Shotwell St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
16 |
Width 3ft |
|
6007846.93969 |
2105383.76914 |
37.7614260366957 |
-122.41597297028 |
(37.7614260366957, -122.41597297028) |
2 |
4 |
7 |
28859 |
19 |
140651 |
48045 |
7 |
97 |
3350 Mission St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
07/11/2002 12:00:00 AM |
|
|
Permit Number 45759 |
6006080.4837518 |
2098740.43590211 |
37.7430854999808 |
-122.42161056574 |
(37.7430854999808, -122.42161056574) |
2 |
7 |
7 |
28859 |
2 |
166779 |
224571 |
1 |
97 |
3235 18th St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
17 |
Width 3ft |
|
6008059.06529 |
2105594.02225 |
37.7620152671241 |
-122.415254197918 |
(37.7620152671241, -122.415254197918) |
2 |
4 |
7 |
28859 |
19 |
157515 |
226496 |
1 |
97 |
1850 Harrison St |
10 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
|
14 |
Width 3ft |
|
6008684.6321 |
2107591.00428 |
37.767533656488 |
-122.413231818694 |
(37.767533656488, -122.413231818694) |
8 |
4 |
7 |
28853 |
19 |