399 rows where qSpecies_id = 2 sorted by SiteOrder descending

View and edit SQL

These facets timed out: Supervisor Districts

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)
53527 96014 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
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
137187 92586 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
151033 225509 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     22 6x6   6004197.80145 2106206.80833 37.7634800675805 -122.428652494712 (37.7634800675805, -122.428652494712) 8 4 5 28862 3
159193 88752 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
33153 88751 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 8 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
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
53962 96013 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
74920 225508 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 8 Sidewalk: Curb side : Cutout Tree Private 2     17 6x6   6004195.74141 2106258.0557 37.763620663995 -122.428663273099 (37.763620663995, -122.428663273099) 8 4 5 28862 3
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
129134 92585 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 8 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
140650 26918 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2000X Bay Shore Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1   10/19/2010 12:00:00 AM 3 3X3   6012375.8565272 2088505.2474917 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859) 10 7 8 309 39
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
50443 96012 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
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
72989 92584 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
98572 88750 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
126216 225507 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     17 6x6   6004191.74013 2106290.72293 37.7637101339293 -122.428679441106 (37.7637101339293, -122.428679441106) 8 4 5 28862 3
141097 94245 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 7 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
153331 18361 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 530 Potrero Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   06/02/2015 11:39:00 AM 3 3x3   6010330.8079075 2105828.5872592 37.7627867420622 -122.407413622665 (37.7627867420622, -122.407413622665) 8 4 8 28859 19
180775 197655 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6016998.37545 2097206.43045 37.7394830203258 -122.383752282143 (37.7394830203258, -122.383752282143) 10 3 8 58 1
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
84916 85833 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 6 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/2007 12:00:00 AM 3 3x3   6011370.824524 2112775.117387 37.7819184786136 -122.404305504694 (37.7819184786136, -122.404305504694) 6 2 9 28853 34
87848 88749 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
163939 92583 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
167491 91426 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 6 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
4376 259271 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1721x Taylor St 5 Side Yard : Yard Tree DPW 1 Private 05/25/2019 12:00:00 AM 3                        
34950 103838 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.07623 2113939.67696 37.7848568419422 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
69525 92582 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
105437 193408 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010314.12402 2106048.65269 37.7633900580388 -122.407486842464 (37.7633900580388, -122.407486842464) 8 4 8 28859 19
109159 87857 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1X CASELLI AVE 5 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50796 6000842 2104917 37.7597480805722 -122.440166611531 (37.7597480805722, -122.440166611531) 2 4 5 28862 3
120075 230383 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6005020.28561 2104519.96917 37.7588949199761 -122.425687715924 (37.7588949199761, -122.425687715924) 2 4 5 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
148316 94258 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 5 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
170951 85832 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 5 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/2007 12:00:00 AM 3 3x3   6011370.824524 2112775.117387 37.7819184786136 -122.404305504694 (37.7819184786136, -122.404305504694) 6 2 9 28853 34
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
185594 135722 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2498X Pierce St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 Width 4ft Permit Number 779691 6001734 2116823 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064) 13 6 1 29490 27
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
9447 91424 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 4 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
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
24900 13061 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 583 Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/01/2013 12:00:00 AM 12 2X2   6009566.8887098 2120490.1657189 37.8030011583731 -122.411091436508 (37.8030011583731, -122.411091436508) 3 1 10 308 23
43765 5416 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 430X Dolores St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/11/2011 12:00:00 AM 3 6x150   6004853.9708326 2105864.857711 37.7625782660478 -122.426358665446 (37.7625782660478, -122.426358665446) 8 4 5 28859 3
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
62023 108507 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 796 19th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773790 5990094.5666 2109953.25495 37.772958540137 -122.477704410848 (37.772958540137, -122.477704410848) 11 6 2 55 26
73027 85698 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.7861224301769 -122.399185316932 (37.7861224301769, -122.399185316932) 12 2 9 28855 6
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
80541 87452 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 601 Dolores St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2008 12:00:00 AM 4 3x3   6004976 2104871 37.7598562652774 -122.425865863079 (37.7598562652774, -122.425865863079) 2 4 5 28862 19
93248 103851 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
95867 94263 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 4 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
105367 6784 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1360 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2007 12:00:00 AM 4 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
111986 131011 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1771 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002300.20603 2120865.81933 37.8036224187107 -122.436264801676 (37.8036224187107, -122.436264801676) 13 9 1 57 17
114647 103837 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.07623 2113939.67696 37.7848568419422 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
126676 25487 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 645X POTRERO AVE 4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2013 12:00:00 AM 3 3X3   6010440 2105310 37.7613689295586 -122.406999409931 (37.7613689295586, -122.406999409931) 10 4 8 28859 19
138526 103794 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1214 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
139198 93255 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1070 Church St 4 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004394 2102659 37.7537497275294 -122.427721110855 (37.7537497275294, -122.427721110855) 2 4 5 28862 22
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
164462 230384 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 601 Dolores St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005003.81478 2104818.83763 37.7597146115626 -122.425765952455 (37.7597146115626, -122.425765952455) 2 4 5 28859 19
164641 125088 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2498X Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 Width 4ft Permit Number 779691 6001734 2116823 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064) 13 6 1 29490 27
179694 85831 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/2007 12:00:00 AM 3 3x3   6011370.824524 2112775.117387 37.7819184786136 -122.404305504694 (37.7819184786136, -122.404305504694) 6 2 9 28853 34
183182 85813 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1675 Howard St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/18/2007 12:00:00 AM 3 3x3   6007516 2108769 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156) 8 2 9 28853 19
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
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
191699 9298 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 135X Mansell St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/10/1992 12:00:00 AM 3 3X3   6011497.3933158 2090592.5284866 37.7210170109869 -122.40230748066 (37.7210170109869, -122.40230748066) 10 7 8 309 28
192324 92581 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
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
135674 188687 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300 Evans Ave 30 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/2017 12:53:00 PM 3 Width 4ft   6017556.40659 2097171.27575 37.7394173230594 -122.381820390005 (37.7394173230594, -122.381820390005) 10 3 8 58 1
19 262168 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
13136 255218 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 101 Goettingen St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
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
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
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
20501 103817 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1100 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006925.9 2114751.5 37.7870957589339 -122.41982320605 (37.7870957589339, -122.41982320605) 13 9 10 28858 21
37211 87647 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1989X PINE ST 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2008 12:00:00 AM 3 3x3   6004432 2115332 37.7885488568913 -122.428492943957 (37.7885488568913, -122.428492943957) 13 9 11 28858 27
43002 32722 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 644 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2011 12:00:00 AM 3 3x3 Permit Number 768334 6007901.48303797 2114768.35798987 37.7871969578975 -122.416449089052 (37.7871969578975, -122.416449089052) 13 1 9 28858 36
49462 5394 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 347 Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2014 12:00:00 AM 2 7x5   6004926.54556 2106285.12827 37.7637363311974 -122.426137576609 (37.7637363311974, -122.426137576609) 8 4 5 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
60588 125087 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2498X Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 Width 4ft Permit Number 779691 6001734 2116823 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064) 13 6 1 29490 27
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
73332 85812 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1675 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6007516 2108769 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156) 8 2 9 28853 19
75023 5475 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 601 Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2008 12:00:00 AM 3 4X4   6005004.3744 2104794.07494 37.759646650683 -122.425762254445 (37.759646650683, -122.425762254445) 2 4 5 28859 19
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
85121 83826 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 755-757 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM     Permit Number 52235 6009406.96888923 2119078.72581504 37.7991167247732 -122.411545064383 (37.7991167247732, -122.411545064383) 3 1 10 308 4
93337 85826 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1399X Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2007 12:00:00 AM 3 3x3   6008422.422874 2109956.642426 37.7740144201285 -122.414306166437 (37.7740144201285, -122.414306166437) 8 2 9 28853 34
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
105243 93254 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1070 Church St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004394 2102659 37.7537497275294 -122.427721110855 (37.7537497275294, -122.427721110855) 2 4 5 28862 22
105898 103793 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1214 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
114542 225505 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     19 6x6   6004182.33297 2106439.09947 37.7641170079293 -122.428722555516 (37.7641170079293, -122.428722555516) 8 4 5 28862 3
116645 93251 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1060 CHURCH ST 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004371 2102721 37.7539186639277 -122.427805067459 (37.7539186639277, -122.427805067459) 2 4 5 28862 22
120199 116966 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6010311.67872 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703) 8 4 8 28859 19
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
132976 92580 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
137115 149926 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 595 Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2018 12:00:00 AM 3 Width 4ft Permit Number 778997 6015520.39678 2106244.91247 37.7642189811532 -122.389493585568 (37.7642189811532, -122.389493585568) 14 3 8 28856 29
143361 4421 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1133 Church St 3 Sidewalk: Curb side : Cutout Tree DPW 1   08/23/2012 12:00:00 AM 3 4X4 Permit Number 769145 6004474.71062 2102295.4201 37.7527559874039 -122.427416096072 (37.7527559874039, -122.427416096072) 2 4 5 28862 22
144661 5385 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 325X Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/2013 12:00:00 AM   4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
149323 230381 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 6ft   6005021.94421 2104476.35643 37.7587752633866 -122.425678875606 (37.7587752633866, -122.425678875606) 2 4 5 28859 19
162109 91423 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 3 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
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
172825 103850 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 3 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
175044 230378 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 11 Haight St 3 : Tree Private 2     5 Width 4ft   6006027.69558 2109650.1201 37.7730379732539 -122.422568162015 (37.7730379732539, -122.422568162015) 7 9 11 28852 10

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