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) |
2008 |
106059 |
6 |
203 |
339 FILBERT ST |
1 |
Front Yard : Yard |
Tree |
2 |
|
|
6 |
|
|
6011263.6 |
2119947.8 |
37.801606957686 |
-122.405181687156 |
(37.801606957686, -122.405181687156) |
3 |
1 |
10 |
308 |
23 |
34175 |
87149 |
6 |
155 |
4 Bellair Pl |
2 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6010093 |
2120950 |
37.8042932388788 |
-122.409303278994 |
(37.8042932388788, -122.409303278994) |
3 |
1 |
10 |
308 |
23 |
40158 |
253917 |
6 |
119 |
1819 Mason St |
1 |
Front Yard : Yard |
Tree |
2 |
|
|
|
|
|
6009087 |
2119549 |
37.8003900283184 |
-122.412685532944 |
(37.8003900283184, -122.412685532944) |
3 |
1 |
10 |
308 |
32 |
65969 |
87150 |
6 |
155 |
4 Bellair Pl |
2 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
Permit Number 50135 |
6010093 |
2120950 |
37.8042932388788 |
-122.409303278994 |
(37.8042932388788, -122.409303278994) |
3 |
1 |
10 |
308 |
23 |
70862 |
115250 |
6 |
36 |
1404x Mason St |
1 |
Front Yard : Yard |
Tree |
2 |
|
01/20/2016 12:00:00 AM |
|
|
|
6009352.6 |
2118074.7 |
37.7963568672402 |
-122.41166222086 |
(37.7963568672402, -122.41166222086) |
3 |
1 |
10 |
308 |
4 |
80305 |
111179 |
6 |
63 |
400 NORTH POINT ST |
1 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
03/01/2016 12:00:00 AM |
3 |
9x6 |
|
6008572 |
2121805 |
37.806555520543 |
-122.414627380808 |
(37.806555520543, -122.414627380808) |
3 |
1 |
10 |
308 |
23 |
84037 |
107611 |
6 |
15 |
470x Broadway |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
Permit Number 774041 |
6011286.02608 |
2118707.45024 |
37.7982025127238 |
-122.40501669829 |
(37.7982025127238, -122.40501669829) |
3 |
1 |
10 |
308 |
23 |
97189 |
114476 |
6 |
170 |
299x UNION ST |
1 |
Sidewalk: Curb side : Yard |
Tree |
2 |
|
12/29/2015 12:00:00 AM |
|
|
|
6011527 |
2119680 |
37.8008863659875 |
-122.40425133897 |
(37.8008863659875, -122.40425133897) |
3 |
1 |
10 |
308 |
23 |
104435 |
106173 |
6 |
56 |
267 Green St |
1 |
Front Yard : Yard |
Tree |
2 |
|
|
|
|
Permit Number 771881 |
6011670.8 |
2119368.7 |
37.8000396459541 |
-122.403731811098 |
(37.8000396459541, -122.403731811098) |
3 |
1 |
10 |
308 |
23 |
111290 |
106058 |
6 |
51 |
301 FILBERT ST |
1 |
Front Yard : Yard |
Tree |
2 |
|
|
10 |
|
|
6011273 |
2120044 |
37.8018716248897 |
-122.405155936594 |
(37.8018716248897, -122.405155936594) |
3 |
1 |
10 |
308 |
23 |
142994 |
112559 |
6 |
155 |
1735x GRANT AVE |
1 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6010373 |
2120454 |
37.8029470287696 |
-122.408299306743 |
(37.8029470287696, -122.408299306743) |
3 |
1 |
10 |
308 |
23 |
32951 |
112484 |
6 |
52 |
1275 Columbus Ave |
4 |
Front Yard : Yard |
Tree |
2 |
|
08/03/2015 12:00:00 AM |
|
|
|
6007539.6 |
2121483.9 |
37.8056158049656 |
-122.418177422209 |
(37.8056158049656, -122.418177422209) |
5 |
1 |
1 |
308 |
32 |
45867 |
107185 |
6 |
19 |
10 Florence St |
1 |
Front Yard : Cutout |
Tree |
2 |
|
|
|
|
Permit Number 773363 |
6008515.42073 |
2118375.20615 |
37.7971349853662 |
-122.41458032272 |
(37.7971349853662, -122.41458032272) |
5 |
1 |
10 |
308 |
21 |
83429 |
112481 |
6 |
58 |
1275 Columbus Ave |
1 |
Front Yard : Yard |
Tree |
2 |
|
08/03/2015 12:00:00 AM |
|
|
|
6007539.6 |
2121483.9 |
37.8056158049656 |
-122.418177422209 |
(37.8056158049656, -122.418177422209) |
5 |
1 |
1 |
308 |
32 |
83898 |
112482 |
6 |
36 |
1275 Columbus Ave |
2 |
Front Yard : Yard |
Tree |
2 |
|
08/03/2015 12:00:00 AM |
|
|
|
6007539.6 |
2121483.9 |
37.8056158049656 |
-122.418177422209 |
(37.8056158049656, -122.418177422209) |
5 |
1 |
1 |
308 |
32 |
115879 |
112485 |
6 |
52 |
1275 Columbus Ave |
5 |
Front Yard : Yard |
Tree |
2 |
|
08/03/2015 12:00:00 AM |
|
|
|
6007539.6 |
2121483.9 |
37.8056158049656 |
-122.418177422209 |
(37.8056158049656, -122.418177422209) |
5 |
1 |
1 |
308 |
32 |
123789 |
112483 |
6 |
36 |
1275 Columbus Ave |
3 |
Front Yard : Yard |
Tree |
2 |
|
08/03/2015 12:00:00 AM |
|
|
|
6007539.6 |
2121483.9 |
37.8056158049656 |
-122.418177422209 |
(37.8056158049656, -122.418177422209) |
5 |
1 |
1 |
308 |
32 |
157517 |
112488 |
6 |
52 |
1275 Columbus Ave |
8 |
Front Yard : Yard |
Tree |
2 |
|
|
|
|
|
6007539.6 |
2121483.9 |
37.8056158049656 |
-122.418177422209 |
(37.8056158049656, -122.418177422209) |
5 |
1 |
1 |
308 |
32 |
167115 |
112487 |
6 |
52 |
1275 Columbus Ave |
7 |
Front Yard : Yard |
Tree |
2 |
|
|
|
|
|
6007539.6 |
2121483.9 |
37.8056158049656 |
-122.418177422209 |
(37.8056158049656, -122.418177422209) |
5 |
1 |
1 |
308 |
32 |