trees

261 rows where qSpecies_id = 177 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

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)
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
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
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
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
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
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
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
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
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
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
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
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
124462 17911 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2321 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/12/2016 10:58:00 AM 3 3X3   6002821.483 2115107.812 37.7878420242306 -122.434049048426 (37.7878420242306, -122.434049048426) 13 9 11 29490 27
146054 92047 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2323 Cesar Chavez St   Sidewalk: Property side : Yard Tree DPW 1   05/16/2009 12:00:00 AM       6012395.863444 2100936.77011 37.7494702500338 -122.399927744224 (37.7494702500338, -122.399927744224) 10 3 8 58 1
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
45539 683 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2340X Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2010 12:00:00 AM 0 3X3 Permit Number 53450 5988222.7193 2114685.44657 37.7858429996456 -122.484526443804 (37.7858429996456, -122.484526443804) 11 6 1 55 33
66436 98847 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2400 Noriega St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2012 12:00:00 AM 2 3x3 Permit Number 768753 5986497.5 2103053.8 37.753805142535 -122.489639464015 (37.753805142535, -122.489639464015) 1 8 3 56 35
143629 98845 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2400 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2012 12:00:00 AM 2 3x3 Permit Number 768753 5986497.5 2103053.8 37.753805142535 -122.489639464015 (37.753805142535, -122.489639464015) 1 8 3 56 35
170941 98846 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2400 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2012 12:00:00 AM 2 3x3 Permit Number 768753 5986497.5 2103053.8 37.753805142535 -122.489639464015 (37.753805142535, -122.489639464015) 1 8 3 56 35
181198 118312 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2410 STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002301 2116562 37.7918052987456 -122.435953913571 (37.7918052987456, -122.435953913571) 13 9 1 29490 27
167690 256776 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 244 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2018 12:00:00 AM 3 3x3 Permit Number 781951 5994190.23703 2091515.08881 37.7225688371899 -122.462199635944 (37.7225688371899, -122.462199635944) 9 8 4 28861 24
31119 255523 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
70345 255525 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 3 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
80914 255524 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
102669 255526 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 4 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
170762 256228 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
115031 122520 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 250 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004004.54241313 2097731.78472111 37.740198698919 -122.428716724311 (37.740198698919, -122.428716724311) 2 7 5 63 7
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
87120 107140 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 250X Roosevelt Way   Median : Cutout Tree Private 2   08/01/2014 12:00:00 AM   5x5 Permit Number 773751 6000794.71275 2107196.95489 37.7660055827084 -122.440493678393 (37.7660055827084, -122.440493678393) 15 5 5 29492 3
191399 25159 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2600X Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2015 12:55:00 PM 3 3X3   6001683.708124 2105708.1424059 37.7619682491468 -122.437312213886 (37.7619682491468, -122.437312213886) 15 4 5 28862 3
11136 131782 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2646 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft Permit Number 779549 6000337.27442 2118211.39807 37.7962223607332 -122.442866875924 (37.7962223607332, -122.442866875924) 13 9 1 57 17
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
16011 131781 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2758 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2020 12:00:00 AM 3 Width 3ft   5999580.2108 2118368.89391 37.7966116124855 -122.445497792185 (37.7966116124855, -122.445497792185) 13 9 1 57 17
91107 102914 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2848 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2013 12:00:00 AM   3x3 Permit Number 770041 5999369.2 2118090.3 37.7958346193373 -122.446207883579 (37.7958346193373, -122.446207883579) 13 9 1 57 17
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
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
154970 139362 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2869 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999793.3033 2114332.6333 37.7855412639984 -122.444470219362 (37.7855412639984, -122.444470219362) 15 6 1 29490 31
120674 124797 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2898 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2017 12:00:00 AM 3 Width 3ft Permit Number 780062 5999308.846 2118065.45598 37.7957629573367 -122.446414930702 (37.7957629573367, -122.446414930702) 13 9 1 57 17
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
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
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
128647 255530 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 301 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6010757.6116 2120655.4263 37.8035216252403 -122.406982550515 (37.8035216252403, -122.406982550515) 3 1 10 308 23
17402 12986 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 312 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2016 06:43:00 AM 3 3X3   6010791.3462 2120702.976 37.8036540726688 -122.406869163124 (37.8036540726688, -122.406869163124) 3 1 10 308 23
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                      
53358 12988 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 324 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2016 06:56:00 AM 3 3X3   6010748.7594 2120699.4941 37.8036421292086 -122.407016292062 (37.8036421292086, -122.407016292062) 3 1 10 308 23
111732 12989 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 325 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 3X3 Permit Number 780097 6010757.6116 2120655.4263 37.8035216252403 -122.406982550515 (37.8035216252403, -122.406982550515) 3 1 10 308 23
76277 24659 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 3299X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2014 12:00:00 AM 3 3x3 Permit Number 772930 5997061.39714 2112911.45264 37.7814828219847 -122.453819096525 (37.7814828219847, -122.453819096525) 11 6 2 54 16
91501 12995 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 336 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6010707.244 2120695.2086 37.8036280390364 -122.407159656622 (37.8036280390364, -122.407159656622) 3 1 10 308 23
10133 12999 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 349 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/2017 09:03:00 AM 3 3X3   6010644.3554 2120634.1907 37.8034569792808 -122.407372982577 (37.8034569792808, -122.407372982577) 3 1 10 308 23
10503 233771 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 35 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2019 03:11:00 PM 3 Width 3ft   6003168.16978 2108097.17278 37.7686122241979 -122.432348677773 (37.7686122241979, -122.432348677773) 15 5 5 28862 3
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
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                        
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                        
19019 13004 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 368 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2016 06:38:00 AM 3 4X4   6010562.3418 2120670.5672 37.8035522695821 -122.407659361785 (37.8035522695821, -122.407659361785) 3 1 10 308 23
6110 13007 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 373 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2015 10:56:00 AM 3 3x3   6010526.1986 2120617.8557 37.8034055135257 -122.407780718516 (37.8034055135257, -122.407780718516) 3 1 10 308 23
11154 13008 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 373 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/27/2015 10:06:00 AM 3 3X3   6010552.8791 2120622.2117 37.8034189676022 -122.407688696484 (37.8034189676022, -122.407688696484) 3 1 10 308 23
63720 13009 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 378 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/2016 02:11:00 PM 3 4X4   6010539.0395 2120665.4782 37.8035369920045 -122.407739641802 (37.8035369920045, -122.407739641802) 3 1 10 308 23
141100 55048 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 3791 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2012 12:00:00 AM     Permit Number 768924 6003127.14535424 2103564.68904381 37.7561647909862 -122.432166852953 (37.7561647909862, -122.432166852953) 2 4 5 28862 22
9548 13006 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 383 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2015 10:51:00 AM 3 3X3   6010482.094 2120612.9552 37.8033895888272 -122.407932999148 (37.8033895888272, -122.407932999148) 3 1 10 308 23
16151 13005 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 383 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2015 10:59:00 AM 3 3X3   6010464.6699 2120611.8662 37.8033856231837 -122.407993219356 (37.8033856231837, -122.407993219356) 3 1 10 308 23
72976 13010 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 396 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2015 07:16:00 AM 3 3X3   6010502.3453 2120665.4782 37.8035349377887 -122.407866624342 (37.8035349377887, -122.407866624342) 3 1 10 308 23
76872 13011 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 396 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2015 07:12:00 AM 3 3X3   6010476.6325 2120660.3892 37.8035195251148 -122.40795524598 (37.8035195251148, -122.40795524598) 3 1 10 308 23
108474 63786 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 4035 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2009 12:00:00 AM   3x3 Permit Number 52930 6003624.27213054 2101252.89355661 37.7498453184987 -122.43028269297 (37.7498453184987, -122.43028269297) 2 4 5 28862 22
68237 13015 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 407 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2016 12:00:00 AM 12 3X3   6010332.686 2120602.2788 37.8033519082048 -122.408449280112 (37.8033519082048, -122.408449280112) 3 1 10 308 23
70827 13016 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 407 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/16/2016 02:31:00 PM 3 3X3   6010356.171 2120603.3463 37.8033561544514 -122.408368084374 (37.8033561544514, -122.408368084374) 3 1 10 308 23
126183 13014 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 408 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2016 02:25:00 PM 3 3X3   6010352 2120661 37.8035142236954 -122.408386587386 (37.8035142236954, -122.408386587386) 3 1 10 308 23
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
116521 143019 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 410 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6010368.5125 2120644.4743 37.8034697728784 -122.408328278578 (37.8034697728784, -122.408328278578) 3 1 10 308 23
61397 13017 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 412 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2016 12:00:00 AM 3 3X3   6010331 2120658 37.8035048104324 -122.408459047408 (37.8035048104324, -122.408459047408) 3 1 10 308 23
7066 115194 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 4150 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 777365 6002684.1 2104186.2 37.7578461817613 -122.433743471638 (37.7578461817613, -122.433743471638) 2 4 5 28862 3
35355 13022 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 431 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2015 07:20:00 AM 3 3X3   6010276.62799 2120585.425 37.8033024923724 -122.408642082138 (37.8033024923724, -122.408642082138) 3 1 10 308 23
72042 13024 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 445 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/04/2014 02:58:00 PM 3 3X3   6010214.1933 2120583.5975 37.8032939775537 -122.40885801149 (37.8032939775537, -122.40885801149) 3 1 10 308 23
151386 106547 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 4509A 25th St   Sidewalk: Curb side : Cutout Tree Private 2   05/08/2014 12:00:00 AM   3x3 Permit Number 772697 6000984.2 2101089.3 37.7492462369191 -122.439400435576 (37.7492462369191, -122.439400435576) 2 4 5 28862 22
137875 13025 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 451 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2016 07:02:00 AM 3 3X3   6010198.7145 2120581.4625 37.8032872483458 -122.40891142592 (37.8032872483458, -122.40891142592) 3 1 10 308 23
58624 58070 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 4530 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM 2 6x9 Permit Number 17040 6000943.54601309 2105249.62912473 37.7606671794335 -122.439839263811 (37.7606671794335, -122.439839263811) 15 4 5 28862 3
178223 256896 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 470 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2018 12:00:00 AM 3 3x3 Permit Number 780643 5985651.17942 2112710.44444 37.7802701294342 -122.493277571063 (37.7802701294342, -122.493277571063) 11 6 2 55 26
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
66864 117270 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 481 JERSEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6002050 2101440 37.7502697725383 -122.435739974128 (37.7502697725383, -122.435739974128) 2 4 5 28862 22
123811 13034 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 490 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/16/2016 02:07:00 PM 3 3x3   6010037.8987 2120598.0598 37.8033238110836 -122.409469108899 (37.8033238110836, -122.409469108899) 3 1 10 308 23
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
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
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
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
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
55911 100649 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003141 2108015 37.7683850571797 -122.432436785894 (37.7683850571797, -122.432436785894) 15 5 5 28862 3
77118 100396 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 500X Oak Park Dr 1 Sidewalk: Property side : Yard Tree Private 2   09/18/2012 12:00:00 AM 3 3x9 Permit Number 769101 5994983.3 2103652.8 37.7559416221353 -122.460337221652 (37.7559416221353, -122.460337221652) 1 5 4 63 12
88367 95578 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 501@ 6th Ave Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2           5994244 2106639 37.7640983993107 -122.463110607355 (37.7640983993107, -122.463110607355) 1 5 11 56 12
160746 105053 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 501X 27th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2013 12:00:00 AM   3x3 Permit Number 770390 5987510.95423 2112219.64233 37.7790311285688 -122.48680778308 (37.7790311285688, -122.48680778308) 11 6 2 55 26
68114 8974 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 5045 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/12/2011 12:00:00 AM 3 3x3   5991343.5266 2112609.97523 37.7803255698787 -122.473577979119 (37.7803255698787, -122.473577979119) 11 6 2 54 26
45752 143037 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 510 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/16/2015 07:44:00 AM 19 Width 0ft   6009884.4437 2120577.0857 37.8032576219869 -122.409998666067 (37.8032576219869, -122.409998666067) 3 1 10 308 23
11709 13039 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 515-519 Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6009909.1781 2120541.7464 37.8031619752733 -122.409910575369 (37.8031619752733, -122.409910575369) 3 1 10 308 23

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