261 rows where qSpecies_id = 177

View and edit SQL

These facets timed out: 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)
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
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                      
2233 256484 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1047 Hollister Ave 2 unknown : Yard Tree Private 2       Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738) 10 3 8 58 1
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                        
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
3302 256186 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
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
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                        
4989 256185 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
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
5376 203267 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2 Garcia Ave 2 Sidewalk: Curb side : Yard Tree Private 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 781591 5995210.8831 2099639.94271 37.7449364165845 -122.45925958957 (37.7449364165845, -122.45925958957) 1 8 4 59 40
5642 13071 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 645X Lombard St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   09/27/2006 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
5671 13046 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 534 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x3   6009764.2975 2120561.184 37.8032072253646 -122.410413314112 (37.8032072253646, -122.410413314112) 3 1 10 308 23
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
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
6215 256187 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
6587 261546 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1955 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2020 12:00:00 AM 3 3X3 Permit Number 783144 5985360.77923 2101907.46183 37.750591180724 -122.493485992107 (37.750591180724, -122.493485992107) 1 8 3 29491 35
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                    
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
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
8763 13089 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 722 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008909.0684 2120447.731 37.8028477316821 -122.41336484235 (37.8028477316821, -122.41336484235) 3 1 10 308 23
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                        
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
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
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
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
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
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
10940 92249 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1382 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2020 12:00:00 AM 3 3x3 Permit Number 52698 5985580.0638 2105823.8988 37.7613574627672 -122.493016162233 (37.7613574627672, -122.493016162233) 1 8 3 56 35
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
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
11531 203268 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2 Garcia Ave 3 Sidewalk: Curb side : Yard Tree Private 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 781591 5995209.06254 2099610.1708 37.7448545656781 -122.459263729153 (37.7448545656781, -122.459263729153) 1 8 4 59 40
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
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
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
13429 105011 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 11 Commonwealth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2013 12:00:00 AM 5   Permit Number 770953 5996464.5 2114492.5 37.7857897179877 -122.455998396638 (37.7857897179877, -122.455998396638) 11 6 1 54 31
13587 13088 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 722 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2019 06:03:00 AM 3 3X3   6008925.6016 2120449.3844 37.8028531997518 -122.413307745784 (37.8028531997518, -122.413307745784) 3 1 10 308 23
13736 90469 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 578 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/17/2008 12:00:00 AM 3 3x3   5988158.072517 2112047.558198 37.778596339842 -122.484556541536 (37.778596339842, -122.484556541536) 11 6 2 55 26
14369 203266 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2 Garcia Ave 1 Sidewalk: Curb side : Yard Tree Private 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 781591 5995196 2099610 37.7448533456978 -122.459308884303 (37.7448533456978, -122.459308884303) 1 8 4 59 40
14797 264653 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 982 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/08/2020 04:50:00 PM   3x3   6014279.95597 2089795.48577 37.71898342396 -122.39263318135 (37.71898342396, -122.39263318135) 10 3 8 58 1
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                        
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
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
16281 13043 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 526 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 11:51:00 AM 3 3x3   6009812.0026 2120568.2515 37.8032293051326 -122.410248727784 (37.8032293051326, -122.410248727784) 3 1 10 308 23
16520 121489 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2 Judah St 1 Median : Cutout Tree DPW 1       3x3                      
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
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                      
17835 146870 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 747 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:07:00 PM 0 Width 3ft   5983198.23429 2110712.37785 37.7746402422966 -122.501615441996 (37.7746402422966, -122.501615441996) 11 6 2 55 26
18840 83046 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 100X Cargo Way 6 Sidewalk: Curb side : Cutout Tree Port 6     1     6018811.25128 2097616.11187 37.740707968002 -122.377512501614 (37.740707968002, -122.377512501614) 10 3 8 58 1
18862 256188 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
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
20330 115297 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2016 12:00:00 AM     Permit Number 775683 5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
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
22838 143258 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 661 LOMBARD ST 10 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6009397.1671 2120467.3833 37.8029290843214 -122.411677153186 (37.8029290843214, -122.411677153186) 3 1 10 308 23
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
25056 105010 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 11 Commonwealth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2013 12:00:00 AM 5   Permit Number 770953 5996464.5 2114492.5 37.7857897179877 -122.455998396638 (37.7857897179877, -122.455998396638) 11 6 1 54 31
27136 114680 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 54 Colby St 1 Front Yard : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 774571 6007954.9 2093861 37.7297931519994 -122.414784067206 (37.7297931519994, -122.414784067206) 9 3 7 309 28
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
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
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
34675 13072 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 645X Lombard St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   09/27/2008 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
35337 143011 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 650-654 LOMBARD ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2017 12:26:00 PM 3 Width 0ft   6009188.4253 2120483.2963 37.8029610657241 -122.412400635876 (37.8029610657241, -122.412400635876) 3 1 10 308 23
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
35798 210473 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 855 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2016 12:00:00 AM 14 Width 3ft Permit Number 41828 5993066.85825 2107284.57434 37.765803096459 -122.467228905809 (37.765803096459, -122.467228905809) 11 8 11 56 12
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
37778 104607 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1839 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2013 12:00:00 AM   3x3 Permit Number 770939 6009882.8 2120354 37.8026449918113 -122.409988596173 (37.8026449918113, -122.409988596173) 3 1 10 308 23
38919 84742 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 147 Alhambra St 1 Sidewalk: Property side : Cutout Tree Private 2   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001618 2120311 37.8020602472718 -122.438585827087 (37.8020602472718, -122.438585827087) 13 9 1 57 17
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
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
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
44103 115287 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1526 12th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/22/2016 12:00:00 AM     Permit Number 776185 5992489.2 2105046.7 37.7596251212978 -122.469064003389 (37.7596251212978, -122.469064003389) 1 8 4 56 12
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
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
45994 56898 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1886 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775792 5985700.55899725 2102390.4838018 37.7519372972974 -122.492346587933 (37.7519372972974, -122.492346587933) 1 8 3 56 35
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
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
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
51392 37127 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1501 46th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM   2x2 Permit Number 39712 5981856.07887628 2104857.97095308 37.7584868087664 -122.50582403114 (37.7584868087664, -122.50582403114) 1 8 3 56 35
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
53752 121107 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1391 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2016 12:00:00 AM 3 3x3   5993608 2106030 37.7623895873424 -122.465266089176 (37.7623895873424, -122.465266089176) 1 8 11 56 12
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
54561 16816 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2105 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/13/2015 01:25:00 PM 3 4x4   6001234.7809998 2113147.0836075 37.7823681904894 -122.439398128028 (37.7823681904894, -122.439398128028) 15 5 11 29490 41
54873 98330 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 147 Alhambra St 2 Sidewalk: Property side : Cutout Tree Private 2   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001593.9 2120254.3 37.801903193112 -122.438665159251 (37.801903193112, -122.438665159251) 13 9 1 57 17
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
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
57341 105009 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 11 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2013 12:00:00 AM 7   Permit Number 770953 5996464.5 2114492.5 37.7857897179877 -122.455998396638 (37.7857897179877, -122.455998396638) 11 6 1 54 31
57461 55718 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 53 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/1973 12:00:00 AM 12 6x7 Permit Number 11741 6003183.88384083 2107999.49897853 37.7683449267986 -122.432287347534 (37.7683449267986, -122.432287347534) 15 5 5 28862 3
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
58253 13040 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 515-519 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2016 07:26:00 AM 3 3X3   6009890.5899 2120540.3695 37.8031571528751 -122.409974803368 (37.8031571528751, -122.409974803368) 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
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
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
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
61488 254585 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1236 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995818 2107128 37.7655316119834 -122.457702020035 (37.7655316119834, -122.457702020035) 15 5 11 29492 12
62962 97446 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 200X Parker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2014 12:00:00 AM   3x3 Permit Number 772930 5997060.8 2112843.2 37.7812953839865 -122.453816232036 (37.7812953839865, -122.453816232036) 11 6 2 54 16

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