261 rows where qSpecies_id = 177 sorted by Zip Codes

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);