399 rows where qSpecies_id = 2 sorted by Supervisor Districts

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)
171027 55516 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 299 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2014 12:00:00 AM     Permit Number 772528 6001150.72264648 2104659.12373936 37.7590575866262 -122.439080412698 (37.7590575866262, -122.439080412698) 2 4 5 28862 3
171265 91425 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2008 12:00:00 AM   3x3 Permit Number 52102 6003571 2107157 37.7660535712373 -122.430888215554 (37.7660535712373, -122.430888215554) 7 4 5 28862 3
171845 93265 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1400X Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004448.1 2100692.1 37.7483521384228 -122.427393913264 (37.7483521384228, -122.427393913264) 2 4 5 63 22
179751 72994 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 590 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2011 12:00:00 AM   3x3 Permit Number 768023 6001377.74978743 2100887.76679336 37.748715263692 -122.438025102274 (37.748715263692, -122.438025102274) 2 4 5 28862 22
181273 84852 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1266 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2007 12:00:00 AM     Permit No. 49294 6005132 2100972 37.7491593351889 -122.425048913935 (37.7491593351889, -122.425048913935) 2 4 5 28862 22
183177 93278 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1559 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004592 2099818 37.7459601990913 -122.426834068489 (37.7459601990913, -122.426834068489) 2 7 5 63 22
184649 93289 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1159 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004476 2102138 37.7523238215074 -122.427400423827 (37.7523238215074, -122.427400423827) 2 4 5 28862 22
186916 230382 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 6ft   6005021.64655 2104500.02665 37.7588402394163 -122.42568158976 (37.7588402394163, -122.42568158976) 2 4 5 28859 19
190659 93279 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1557 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004591 2099830 37.7459930917878 -122.426838380811 (37.7459930917878, -122.426838380811) 2 7 5 63 22
190892 93295 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1019 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004430 2102966 37.7545947138847 -122.427618485613 (37.7545947138847, -122.427618485613) 2 4 5 28862 22
15395 262455 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1788 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000684 2093777 37.7291512919898 -122.43991430419 (37.7291512919898, -122.43991430419) 9 7 6 28861 25
24373 177452 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 404 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6003440.2849 2091219.73942 37.7222861409715 -122.430203237092 (37.7222861409715, -122.430203237092) 9 7 6 28861 5
29972 53133 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 925 Holloway Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 08/19/2015 12:00:00 AM     Permit Number 774158 5994000.81776041 2091173.40830125 37.7216197566197 -122.462829635252 (37.7216197566197, -122.462829635252) 9 8 6 64 24
37463 252931 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 71 Edgar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997064 2091155 37.7217451669512 -122.452239761545 (37.7217451669512, -122.452239761545) 9 8 6 28861 24
60208 108834 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 163 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774662 6004445.49273 2094062.11561 37.7301475609408 -122.426930805706 (37.7301475609408, -122.426930805706) 9 7 6 28861 5
61373 88349 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183) 9 7 6 28861 5
72199 88350 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Vienna St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183) 9 7 6 28861 5
95100 112744 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 235 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/2015 12:00:00 AM     Permit Number 774127 5993719.1 2088769.4 37.7150026970857 -122.463629063261 (37.7150026970857, -122.463629063261) 9 8 6 64 24
106272 115435 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 563 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777504 6001919.8 2090201.1 37.7194029477524 -122.435386355519 (37.7194029477524, -122.435386355519) 9 7 6 28861 5
109636 95738 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Edinburg St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767484 6003120.3 2091142.7 37.7220564786865 -122.431303852024 (37.7220564786865, -122.431303852024) 9 7 6 28861 5
177568 108791 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 323 Edinburgh St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774649 6003546.88289 2091819.58764 37.7239392283561 -122.429877518865 (37.7239392283561, -122.429877518865) 9 7 6 28861 5
185957 177451 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 836 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004096.83843 2090858.43848 37.7213312534072 -122.427907954105 (37.7213312534072, -122.427907954105) 9 7 6 28861 5
3345 258176 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 255 Silliman St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010040.21914 2094084.80619 37.7305246249549 -122.4075906244 (37.7305246249549, -122.4075906244) 10 3 7 309 28
3624 151146 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2900 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2020 12:00:00 AM 3 Width 4ft   6008882.69002 2105920.7172 37.7629585507151 -122.412428682741 (37.7629585507151, -122.412428682741) 8 4 7 28859 19
5015 224353 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3030 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 11:50:00 AM 3 Width 4ft   6006632.75905 2106740.09726 37.7650818572521 -122.420268591949 (37.7650818572521, -122.420268591949) 8 4 7 28853 19
7155 258178 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 255 Silliman St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010040.21914 2094084.80619 37.7305246249549 -122.4075906244 (37.7305246249549, -122.4075906244) 10 3 7 309 28
8189 151145 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2900 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2020 12:00:00 AM 3 Width 4ft   6008902.66747 2105921.7543 37.762962519431 -122.412359660679 (37.762962519431, -122.412359660679) 8 4 7 28859 19
10603 18421 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 934 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/2013 12:00:00 AM 3 3x3   6010449.27067 2103789.58404 37.7571947273755 -122.40686018586 (37.7571947273755, -122.40686018586) 10 4 7 28859 19
11859 262397 Undocumented 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 498 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 3x3   6008907 2105964 37.7630787595522 -122.412347662048 (37.7630787595522, -122.412347662048) 8 4 7 28859 19
14858 171814 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Dartmouth St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6008473.26376 2093533.30473 37.7289224829841 -122.412968858728 (37.7289224829841, -122.412968858728) 9 3 7 309 28
16462 91091 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
19302 18446 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1036 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010478.12987 2103164.08177 37.7554788523745 -122.406716298816 (37.7554788523745, -122.406716298816) 10 4 7 28859 19
19452 258177 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 255 Silliman St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010040.21914 2094084.80619 37.7305246249549 -122.4075906244 (37.7305246249549, -122.4075906244) 10 3 7 309 28
21865 91095 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
37543 230386 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 1 : Tree Private 2     9 Width 4ft   6008087.40778 2108285.62264 37.769407368778 -122.415346724678 (37.769407368778, -122.415346724678) 8 4 7 28853 19
39903 18422 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 940 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/2016 06:57:00 AM 3 3x3   6010451.25485 2103753.05423 37.7570945357026 -122.406850749261 (37.7570945357026, -122.406850749261) 10 4 7 28859 19
41743 18420 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 924 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2013 12:00:00 AM 3 3x3   6010442.48956 2103839.41038 37.7573311599314 -122.406887149344 (37.7573311599314, -122.406887149344) 10 4 7 28859 19
64762 13340 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 230 Mansell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2007 12:00:00 AM 3 3X24   6011187.2509688 2090638.9738565 37.721127222942 -122.403382822785 (37.721127222942, -122.403382822785) 10 3 7 309 28
66728 18391 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 874 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2013 12:00:00 AM 3 4x4   6010420.6643105 2104143.6455038 37.7581653002339 -122.406984073056 (37.7581653002339, -122.406984073056) 10 4 7 28859 19
69419 86595 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2154 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 6 3x3   6009566 2104744 37.7597658751742 -122.409982265203 (37.7597658751742, -122.409982265203) 2 4 7 28859 19
71427 2390 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2642X Bryant St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2007 12:00:00 AM 3 3X3   6009749.5258463 2101948.1671123 37.7520994293613 -122.409150251369 (37.7520994293613, -122.409150251369) 2 4 7 28859 19
73558 91094 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
88872 230387 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 2 : Tree Private 2     7 Width 4ft   6008108.07186 2108284.25114 37.7694047643365 -122.415275151222 (37.7694047643365, -122.415275151222) 8 4 7 28853 19
98913 434 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 890X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2013 12:00:00 AM 3 3x3   6010425.4291782 2104052.7086425 37.7579158746071 -122.406961184613 (37.7579158746071, -122.406961184613) 10 4 7 28859 19
99446 86637 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2679 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6009805.531856 2101750.09748 37.7515587115691 -122.408942599671 (37.7515587115691, -122.408942599671) 2 4 7 28859 19
99872 230388 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 3 : Tree Private 2     8 Width 4ft   6008125.59993 2108283.70929 37.7694042616334 -122.41521448386 (37.7694042616334, -122.41521448386) 8 4 7 28853 19
101456 88442 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1148 Treat Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/11/2008 12:00:00 AM   3x3 Permit Number 51406 6008612.9 2101850.1 37.7517664174328 -122.413073954345 (37.7517664174328, -122.413073954345) 2 4 7 28859 19
101791 230380 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1450 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010406.10881 2100942.79845 37.7493756698697 -122.406808829185 (37.7493756698697, -122.406808829185) 2 4 7 28859 19
103120 87853 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 599 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM   3x3 Permit Number 50764 6007684 2096571 37.7372189966792 -122.415912430403 (37.7372189966792, -122.415912430403) 2 7 7 28859 2
125882 9308 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 240X Mansell St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2007 12:00:00 AM 3 3X100   6011154.1519898 2090628.8663314 37.7210976210121 -122.403496526224 (37.7210976210121, -122.403496526224) 10 3 7 309 28
132768 95660 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 431 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767422 6010656.7 2092697.9 37.7267509601998 -122.40536171554 (37.7267509601998, -122.40536171554) 10 3 7 309 28
138954 108977 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2970 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2015 12:00:00 AM 3 3x3 Permit Number 773794 6008402.2 2103930 37.7574655215329 -122.413949705223 (37.7574655215329, -122.413949705223) 2 4 7 28859 19
144023 100465 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1140 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010498.9 2102571.5 37.7538529165301 -122.40660271212 (37.7538529165301, -122.40660271212) 10 4 7 28859 19
146375 91093 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
151915 63015 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 75 Wool St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/16/2014 12:00:00 AM     Permit Number 772837 6007421.64921795 2097871.12423845 37.7407740975251 -122.416911586715 (37.7407740975251, -122.416911586715) 2 7 7 28859 2
159084 230389 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 4 : Tree Private 2     6 Width 3ft   6008142.81587 2108281.73826 37.7693998171644 -122.415154794967 (37.7693998171644, -122.415154794967) 8 4 7 28853 19
162176 34756 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 930 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM     Permit Number 767406 6007964.37275398 2102502.67346206 37.7535218086 -122.415362848727 (37.7535218086, -122.415362848727) 2 4 7 28859 19
171372 30135 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 220X Mansell St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2007 12:00:00 AM 3 3X30   6011221.783784 2090644.291322 37.7211437523189 -122.403263826082 (37.7211437523189, -122.403263826082) 10 3 7 309 28
173603 9306 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 240X Mansell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2007 12:00:00 AM 3 3X100   6011154.1519898 2090628.8663314 37.7210976210121 -122.403496526224 (37.7210976210121, -122.403496526224) 10 3 7 309 28
178576 91090 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
180008 2389 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2642X Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2007 12:00:00 AM 3 3X3   6009749.5258463 2101948.1671123 37.7520994293613 -122.409150251369 (37.7520994293613, -122.409150251369) 2 4 7 28859 19
181972 18423 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 952 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/20/2013 12:00:00 AM 3 3x3   6010455.30853 2103703.28348 37.7569581031602 -122.406833222372 (37.7569581031602, -122.406833222372) 10 4 7 28859 19
182836 91089 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
183063 18480 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1298 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/31/2017 01:20:00 PM 3 3x3   6010561.39126 2101710.28558 37.7514917080909 -122.406325925618 (37.7514917080909, -122.406325925618) 10 4 7 28859 19
189781 91092 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
11 264841 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
21 264839 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
3079 203064 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300 Evans Ave 34 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/2017 01:07:00 PM 3 Width 3ft   6017493.20317 2097219.31473 37.7395457381522 -122.382042262644 (37.7395457381522, -122.382042262644) 10 3 8 58 1
3150 85599 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1115 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2014 12:00:00 AM 3 3x3   6017434.0078 2093308.576 37.7288043549368 -122.381974980078 (37.7288043549368, -122.381974980078) 10 3 8 58 1
3529 79630 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1331 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6011736.35903 2102141.72528 37.7527420040406 -122.402293051689 (37.7527420040406, -122.402293051689) 10 3 8 28856 29
8777 18349 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 3 3X3   6010308 2106081 37.7634785336334 -122.407510304274 (37.7634785336334, -122.407510304274) 8 4 8 28859 19
9624 6769 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1275 Fairfax Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2007 12:00:00 AM 3 3x3   6017217.4089567 2096970.3613046 37.7388469269577 -122.382978527185 (37.7388469269577, -122.382978527185) 10 3 8 58 1
10875 6812 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1400X Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   08/13/2020 01:09:00 PM 3 3X3   6016477.27072 2097595.73141 37.7405231429351 -122.385581175844 (37.7405231429351, -122.385581175844) 10 3 8 58 1
12577 17385 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1649 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1996 12:00:00 AM 12 6x5   6014583.05525 2095408.96107 37.7344137306531 -122.391977809509 (37.7344137306531, -122.391977809509) 10 3 8 58 1
13050 108392 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1382 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773801 6011141.7607 2101910.8917 37.7520749768049 -122.404333044887 (37.7520749768049, -122.404333044887) 10 4 8 28859 19
16221 18344 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 440 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   07/16/2015 07:27:00 AM 3 4x4   6010309.57073 2106285.64769 37.7640405376657 -122.40751930078 (37.7640405376657, -122.40751930078) 8 4 8 28859 19
25377 85589 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1566 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015069.619532 2095135.418187 37.7336896386511 -122.390276478357 (37.7336896386511, -122.390276478357) 10 3 8 58 1
26492 149925 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 595 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2018 12:00:00 AM 3 Width 4ft Permit Number 778997 6015496.37916 2106243.76048 37.7642144863464 -122.389576575905 (37.7642144863464, -122.389576575905) 14 3 8 28856 29
35474 94638 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2000X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/19/2010 12:00:00 AM 3 3x3   6012318.2 2088514.6 37.71535722204 -122.399324379639 (37.71535722204, -122.399324379639) 10 7 8 309 39
38684 85604 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1261 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016687.610646 2093879.449725 37.7303306134548 -122.384595098105 (37.7303306134548, -122.384595098105) 10 3 8 58 1
43519 29856 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1800X Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/12/2011 12:00:00 AM 3 4x4   6014606.392164 2099329.1692391 37.745179108267 -122.392171198439 (37.745179108267, -122.392171198439) 10 3 8 58 1
47537 18353 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2013 12:00:00 AM 3 3x3   6010310.70956 2106111.3358 37.7635619805233 -122.407503071611 (37.7635619805233, -122.407503071611) 8 4 8 28859 19
48598 94246 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 4 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
50146 94262 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.7592608098643 -122.409349258874 (37.7592608098643, -122.409349258874) 2 4 8 28859 19
63030 251164 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1215 Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2017 01:46:00 PM 3 3x3   6017471 2096747 37.7382476302403 -122.382086185189 (37.7382476302403, -122.382086185189) 10 3 8 58 1
64305 18418 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 645X POTRERO AVE 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/02/2016 12:00:00 AM 3 3X3   6010440 2105310 37.7613689295586 -122.406999409931 (37.7613689295586, -122.406999409931) 10 4 8 28859 19
69485 85584 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1512 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015354.897796 2094923.102787 37.7331224832721 -122.389275358402 (37.7331224832721, -122.389275358402) 10 3 8 58 1
72148 6787 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1360 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   01/03/2017 06:55:00 AM 3 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
73597 226527 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 635 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2017 12:00:00 AM 3 3x3 Permit Number 780912 6010443.26884 2105321.1926 37.7613998448343 -122.406988893247 (37.7613998448343, -122.406988893247) 10 4 8 28859 19
74455 94260 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.7592608098643 -122.409349258874 (37.7592608098643, -122.409349258874) 2 4 8 28859 19
77056 251288 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1335 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/18/2017 01:58:00 PM 3 3x3   6016828 2097292 37.7397085577181 -122.384347329812 (37.7397085577181, -122.384347329812) 10 3 8 58 1
77180 248912 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1215 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6017471 2096747 37.7382476302403 -122.382086185189 (37.7382476302403, -122.382086185189) 10 3 8 58 1
77343 17426 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1869 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/05/2015 01:06:00 PM 3 3X3   6013447.63917 2096284.81189 37.736755533926 -122.395964698714 (37.736755533926, -122.395964698714) 10 3 8 58 1
81325 94244 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 3 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
84232 6725 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1200X Fairfax Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2008 12:00:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
85532 110043 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 890 Rhode Island St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6011841.59848 2104237.14125 37.7585014297196 -122.402076412192 (37.7585014297196, -122.402076412192) 10 3 8 28856 29
86673 85578 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1388 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016034.726363 2094416.033185 37.7317678372886 -122.386889636739 (37.7317678372886, -122.386889636739) 10 3 8 58 1
88054 29774 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1100X Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 12:44:00 PM 3 3x3   6018183.3236 2096672.8034 37.7380832156692 -122.379618142779 (37.7380832156692, -122.379618142779) 10 3 8 58 1
88499 67550 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 890 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 8   Permit Number 31097 6011842.05192 2104248.01189 37.7585313034009 -122.402075608207 (37.7585313034009, -122.402075608207) 10 3 8 28856 29
88606 85598 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1101 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/08/2014 12:00:00 AM 3 3x3   6017523.881587 2093256.051678 37.7286650962772 -122.381660625783 (37.7286650962772, -122.381660625783) 10 3 8 58 1

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