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) |
5288 |
260453 |
8 |
62 |
3554 Alemany Blvd |
4 |
unknown : Yard |
Tree |
2 |
|
|
|
3x3 |
|
5993855 |
2087505 |
37.7115387848875 |
-122.463067653224 |
(37.7115387848875, -122.463067653224) |
9 |
8 |
6 |
64 |
24 |
13075 |
261490 |
8 |
15 |
1100X Portola Dr |
4 |
Median : Yard |
Tree |
1 |
|
|
|
10x10 |
|
5995262 |
2098056 |
37.7405902419398 |
-122.458968175006 |
(37.7405902419398, -122.458968175006) |
1 |
7 |
4 |
59 |
40 |
49750 |
104540 |
8 |
113 |
1101 Van Ness Ave |
4 |
Front Yard : Yard |
Tree |
2 |
|
|
|
|
|
6006375.5 |
2114401.9 |
37.7861048214583 |
-122.421702631224 |
(37.7861048214583, -122.421702631224) |
13 |
9 |
11 |
28858 |
41 |
53202 |
102251 |
8 |
317 |
125X Powhattan Ave |
4 |
Front Yard : Yard |
Tree |
2 |
|
01/07/2013 12:00:00 AM |
|
|
Permit Number 768486 |
6007606 |
2098071 |
37.7413332800665 |
-122.416288322592 |
(37.7413332800665, -122.416288322592) |
2 |
7 |
7 |
28859 |
2 |
61637 |
115638 |
8 |
15 |
81x ELSIE ST |
4 |
Back Yard : Cutout |
Tree |
1 |
|
|
7 |
3x3 |
|
6007403 |
2098902 |
37.7436036039275 |
-122.417049094013 |
(37.7436036039275, -122.417049094013) |
2 |
7 |
7 |
28859 |
2 |
64778 |
109377 |
8 |
59 |
111 BAY ST |
4 |
Back Yard : Yard |
Tree |
2 |
|
|
|
|
|
6010193.2 |
2121519.2 |
37.8058617340589 |
-122.408996713259 |
(37.8058617340589, -122.408996713259) |
3 |
1 |
10 |
308 |
23 |
68467 |
224715 |
8 |
38 |
3255x 24th St |
4 |
Front Yard : Cutout |
Tree |
3 |
|
|
12 |
Width 3ft |
|
6007298 |
2102020 |
37.7521590216883 |
-122.417633107694 |
(37.7521590216883, -122.417633107694) |
2 |
4 |
7 |
28859 |
19 |
90011 |
256555 |
8 |
75 |
3401X 16th St |
4 |
Side Yard : Yard |
Tree |
4 |
|
02/08/2019 08:48:00 AM |
3 |
3x3 |
|
6004088 |
2106523 |
37.7643420392989 |
-122.429054808288 |
(37.7643420392989, -122.429054808288) |
8 |
4 |
5 |
28862 |
3 |
128219 |
101903 |
8 |
72 |
1100 Ocean Ave |
4 |
Front Yard : Yard |
Tree |
1 |
|
|
|
|
Permit Number 769623 |
5996507.7 |
2092470.2 |
37.7253245106519 |
-122.454257683967 |
(37.7253245106519, -122.454257683967) |
9 |
7 |
4 |
28861 |
40 |
140802 |
33786 |
8 |
19 |
200x Mission St |
4 |
Sidewalk: Curb side : Cutout |
Tree |
2 |
|
01/05/2015 12:00:00 AM |
3 |
3x3 |
Permit Number 770804 |
6014138 |
2116340 |
37.7918610639158 |
-122.394982044679 |
(37.7918610639158, -122.394982044679) |
12 |
2 |
9 |
28855 |
6 |
164164 |
105170 |
8 |
19 |
4755X 03RD ST |
4 |
Front Yard : Cutout |
Tree |
19 |
|
|
2 |
3x3 |
|
6015032 |
2095658 |
37.7351224553975 |
-122.390443042679 |
(37.7351224553975, -122.390443042679) |
10 |
3 |
8 |
58 |
1 |