trees
261 rows where qSpecies_id = 177 sorted by Zip Codes
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1346 | 260123 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3195X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
4868 | 256192 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
6907 | 108593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | ||||||||||
9500 | 256189 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
15675 | 256190 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
16520 | 121489 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Judah St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | ||||||||||||||
17536 | 264654 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 999 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:51:00 PM | 3x3 | |||||||||||||
1199 | 116255 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
12604 | 116259 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
20378 | 116241 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
30042 | 258516 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
30538 | 258520 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
42496 | 116243 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
49933 | 258519 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
56227 | 116244 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
59182 | 116252 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
69531 | 116248 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
74050 | 103596 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||
74249 | 116261 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
83740 | 116253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
92392 | 116250 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
94231 | 258514 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
95489 | 103593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||
102477 | 116246 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
102780 | 116254 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
102904 | 258517 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
103816 | 116240 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
113350 | 116238 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
114926 | 116249 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120038 | 116245 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120178 | 116251 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
123771 | 116260 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
148384 | 116242 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
150109 | 116239 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
153151 | 103584 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
159702 | 258515 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
170457 | 116247 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
172681 | 116256 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
173794 | 103586 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
185678 | 116258 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
185917 | 103585 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
188472 | 116257 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
10237 | 243286 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 552 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 4x5 | 6005074.488 | 2107832.11687 | 37.7679923530051 | -122.425736005029 | (37.7679923530051, -122.425736005029) | 8 | 4 | 5 | 28853 | 19 | ||
88961 | 252853 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
102218 | 252854 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
129328 | 92913 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 87 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2009 12:00:00 AM | 3 | 6x12 | Permit Number 53113 | 6005252.7 | 2107310.7 | 37.7665707358936 | -122.425082484344 | (37.7665707358936, -122.425082484344) | 8 | 4 | 5 | 28853 | 19 | |
144072 | 252852 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
175524 | 103085 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 99 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.420335581823 | (37.7728452155106, -122.420335581823) | 8 | 2 | 9 | 28853 | 19 | ||
177248 | 103086 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.420335581823 | (37.7728452155106, -122.420335581823) | 8 | 2 | 9 | 28853 | 19 | ||
189227 | 109745 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2730 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769296 | 6008568.6 | 2106948.2 | 37.7657621501348 | -122.413587690705 | (37.7657621501348, -122.413587690705) | 8 | 4 | 7 | 28853 | 19 |
34396 | 116471 | Section 143 10 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 882 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | 6012399.9 | 2103853.8 | 37.757480004392 | -122.400118621436 | (37.757480004392, -122.400118621436) | 10 | 3 | 8 | 28856 | 29 | |||
77303 | 100044 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1250 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2012 12:00:00 AM | 3x3 | Permit Number 768984 | 6012201 | 2102568.4 | 37.7539394855375 | -122.400716201774 | (37.7539394855375, -122.400716201774) | 10 | 3 | 8 | 28856 | 29 | ||
101932 | 116717 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 690X 03RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 5 | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | ||
134325 | 60027 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 41 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/2013 12:00:00 AM | Permit Number 769856 | 6014655.81368733 | 2112837.99803451 | 37.7822741509003 | -122.392945269869 | (37.7822741509003, -122.392945269869) | 6 | 2 | 9 | 28856 | 6 | ||
148366 | 30786 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 477 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2011 12:00:00 AM | Permit Number 768077 | 6013986.79222779 | 2112639.44439925 | 37.781691783585 | -122.395245890478 | (37.781691783585, -122.395245890478) | 6 | 2 | 9 | 28856 | 6 | ||
5804 | 253280 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2335 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007032 | 2120361 | 37.8025040230696 | -122.419854317954 | (37.8025040230696, -122.419854317954) | 5 | 1 | 1 | 28858 | 32 | ||||
12471 | 76775 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
36912 | 46881 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2300@Green Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2012 12:00:00 AM | Permit Number 768822 | 6006358.85800747 | 2118685.04678939 | 37.7978643358127 | -122.422064597009 | (37.7978643358127, -122.422064597009) | 13 | 9 | 10 | 28858 | 32 | |||
42180 | 114695 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
46430 | 76789 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
48637 | 114696 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
51070 | 76761 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
53958 | 76804 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
74355 | 115438 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2500X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777506 | 6006688.6 | 2119773.1 | 37.8008704472237 | -122.421000888697 | (37.8008704472237, -122.421000888697) | 5 | 9 | 1 | 28858 | 32 | ||
74650 | 84929 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1500@Polk Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49344 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
85994 | 76813 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
91598 | 76793 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
93318 | 111178 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
94466 | 255395 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
106404 | 76809 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
114150 | 104604 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
125406 | 104605 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
128713 | 255394 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
133250 | 76766 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
156289 | 76753 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
158445 | 76746 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
162511 | 104603 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
172881 | 121042 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2101 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
178606 | 76782 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
179281 | 76817 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | 3x3 | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | ||
185355 | 76799 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
189069 | 104606 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 30 Russell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007173 | 2118980 | 37.7987200876771 | -122.419268364856 | (37.7987200876771, -122.419268364856) | 5 | 1 | 10 | 28858 | 32 | ||
5224 | 229828 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1456 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6010092.99129 | 2100772.65012 | 37.7488909550714 | -122.407879605175 | (37.7488909550714, -122.407879605175) | 2 | 4 | 7 | 28859 | 19 | ||
42853 | 113802 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 806 SHOTWELL ST | 4 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
162432 | 92388 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 170 Park St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52791 | 6005986 | 2096352 | 37.7365220626686 | -122.421767651977 | (37.7365220626686, -122.421767651977) | 2 | 7 | 7 | 28859 | 2 | |||
2745 | 260577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
4599 | 172187 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 721 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 3ft | 6003854.60179 | 2091058.27085 | 37.7218662421102 | -122.428759536545 | (37.7218662421102, -122.428759536545) | 9 | 7 | 6 | 28861 | 5 | ||
7157 | 260575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
8112 | 172239 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 285 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002395.65434 | 2092018.35321 | 37.7244197321571 | -122.433871328009 | (37.7244197321571, -122.433871328009) | 9 | 7 | 6 | 28861 | 5 | ||
8356 | 260576 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
9505 | 260574 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
9697 | 172238 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 285 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002385.64302 | 2092003.99063 | 37.7243797276157 | -122.433904909592 | (37.7243797276157, -122.433904909592) | 9 | 7 | 6 | 28861 | 5 | ||
10093 | 172178 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 350 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6004331.00068 | 2091119.78411 | 37.7220620955851 | -122.427117126271 | (37.7220620955851, -122.427117126271) | 9 | 7 | 6 | 28861 | 5 | ||
24212 | 115769 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.7090557478467 | -122.435886292244 | (37.7090557478467, -122.435886292244) | 9 | 7 | 6 | 28861 | 5 | ||
57966 | 115768 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.7090557478467 | -122.435886292244 | (37.7090557478467, -122.435886292244) | 9 | 7 | 6 | 28861 | 5 | ||
60053 | 93574 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | ||
102162 | 216685 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.87199 | 37.7202447887441 | -122.462335661261 | (37.7202447887441, -122.462335661261) | 9 | 8 | 6 | 28861 | 24 | ||
108273 | 93575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | ||
119291 | 93577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );