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) |
111890 |
95155 |
1 |
71 |
250 23rd Ave |
11 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
|
16 |
|
|
5988718.09873 |
2113738.33114 |
37.7832713237769 |
-122.482743157022 |
(37.7832713237769, -122.482743157022) |
11 |
6 |
2 |
55 |
26 |
56802 |
99677 |
1 |
17 |
1250X Shrader St |
7 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
10/04/2013 12:00:00 AM |
16 |
3x3 |
Permit Number 770537 |
5997882 |
2106337.7 |
37.7634800016896 |
-122.450506162624 |
(37.7634800016896, -122.450506162624) |
15 |
5 |
11 |
29492 |
9 |
12520 |
228662 |
1 |
11 |
4235 19th St |
2 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
|
|
16 |
Width 3ft |
|
6001863.4982 |
2104671.44362 |
37.7591319452903 |
-122.436616182999 |
(37.7591319452903, -122.436616182999) |
2 |
4 |
5 |
28862 |
3 |
152683 |
98649 |
1 |
57 |
2110 Greenwich St |
6 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW |
|
16 |
5x5 |
|
6002707.76445 |
2119233.0203 |
37.7991623281478 |
-122.434737597267 |
(37.7991623281478, -122.434737597267) |
13 |
9 |
1 |
57 |
17 |
163496 |
77992 |
1 |
151 |
163X London St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
04/01/2000 12:00:00 AM |
16 |
3x3 |
|
6002837 |
2092721 |
37.7263740781507 |
-122.432395819389 |
(37.7263740781507, -122.432395819389) |
9 |
7 |
6 |
28861 |
5 |
102614 |
127905 |
4 |
38 |
937 Lombard St |
5 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
|
|
16 |
Width 6ft |
|
6007996.96181 |
2120271.7748 |
37.8023133475557 |
-122.416508736883 |
(37.8023133475557, -122.416508736883) |
5 |
1 |
10 |
308 |
32 |
15390 |
60892 |
1 |
36 |
940 Filbert St |
1 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
05/11/1983 12:00:00 AM |
16 |
5x5 |
Permit Number 20677 |
6008514.66964 |
2119698.45237 |
37.8007682484075 |
-122.414676612845 |
(37.8007682484075, -122.414676612845) |
5 |
1 |
10 |
308 |
32 |
44529 |
97900 |
1 |
148 |
375X Precita Ave |
6 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
|
16 |
3x4 |
|
6008901.5 |
2100225.6 |
37.7473220995732 |
-122.411961145064 |
(37.7473220995732, -122.411961145064) |
2 |
7 |
7 |
28859 |
2 |
35970 |
122754 |
1 |
57 |
693 Vermont St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
|
16 |
|
|
6011277.36342 |
2105334.1858 |
37.7614821606899 |
-122.404105006665 |
(37.7614821606899, -122.404105006665) |
10 |
3 |
8 |
28856 |
29 |
8962 |
116061 |
1 |
70 |
2100x 19th St |
5 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
|
16 |
3x3 |
|
6011385.89017 |
2105128.48272 |
37.7609234092204 |
-122.403715181115 |
(37.7609234092204, -122.403715181115) |
10 |
3 |
8 |
28856 |
29 |
47950 |
97078 |
1 |
17 |
1551 Newcomb Ave |
10 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
|
16 |
4x4 |
|
6015475.3 |
2095481.7 |
37.7346629526589 |
-122.388898077079 |
(37.7346629526589, -122.388898077079) |
10 |
3 |
8 |
58 |
1 |
69692 |
97082 |
1 |
17 |
1551 Newcomb Ave |
13 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
|
16 |
3x3 |
|
6015475.3 |
2095481.7 |
37.7346629526589 |
-122.388898077079 |
(37.7346629526589, -122.388898077079) |
10 |
3 |
8 |
58 |
1 |
175510 |
97079 |
1 |
17 |
1551 Newcomb Ave |
11 |
Sidewalk: Curb side : Cutout |
Tree |
4 |
DPW for City Agency |
|
16 |
4x4 |
|
6015475.3 |
2095481.7 |
37.7346629526589 |
-122.388898077079 |
(37.7346629526589, -122.388898077079) |
10 |
3 |
8 |
58 |
1 |