261 rows where qSpecies_id = 177 sorted by DBH

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)
166626 115253 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 20 Edgar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 772988 5997135.3 2090888.7 37.7210180538388 -122.451974094521 (37.7210180538388, -122.451974094521) 9 8 6 28861 24
167419 254751 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 701 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008942 2120384 37.8026745911634 -122.413246372322 (37.8026745911634, -122.413246372322) 3 1 10 308 23
167508 256485 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1047 Hollister Ave 3 unknown : Yard Tree Private 2       Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738) 10 3 8 58 1
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
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
171538 54801 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1301X 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/1982 12:00:00 AM   3x3 Permit Number 20098 5994223.60304226 2106594.5281627 37.7639751162558 -122.463177926852 (37.7639751162558, -122.463177926852) 1 5 11 56 12
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
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
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
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
176540 37129 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1501 46th Ave 4 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
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
177950 113397 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 603 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998367 2108846 37.7703949048055 -122.449009410311 (37.7703949048055, -122.449009410311) 15 5 11 29492 9
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
178780 112777 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1899X Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2015 12:00:00 AM     Permit Number 774327 5992976.20102 2112064.24796 37.7789215671599 -122.467890144832 (37.7789215671599, -122.467890144832) 11 6 2 54 11
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
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
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
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
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
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
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
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
116618 43627 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2230 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2016 12:00:00 AM 0 3x3 Permit Number 775700 5985470.85834553 2100027.42958295 37.7454355618475 -122.492966865959 (37.7454355618475, -122.492966865959) 1 8 3 29491 35
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
143392 100949 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1561 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2012 12:00:00 AM 1   Permit Number 769342 5982149.6 2104456.5 37.7574017552939 -122.504779173294 (37.7574017552939, -122.504779173294) 1 8 3 56 35
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
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
191012 137900 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2191 PINE ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/19/2013 12:00:00 AM 11 Width 0ft   6003458.0512 2115193.5788 37.7881136242314 -122.431852768372 (37.7881136242314, -122.431852768372) 13 9 11 29490 27
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
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
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
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
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
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
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
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
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
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
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
94001 143039 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 520 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6009841.4502 2120571.1962 37.8032390411539 -122.410147031042 (37.8032390411539, -122.410147031042) 3 1 10 308 23
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
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                        
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
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                    
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
72719 90526 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 705 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/18/2008 12:00:00 AM 3 3x3   5988149.756261 2111164.589328 37.7761714707406 -122.484520528522 (37.7761714707406, -122.484520528522) 11 6 2 55 26

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