399 rows where qSpecies_id = 2 sorted by rowid descending

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)
193910 85695 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 1 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
193856 85810 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1675 Howard St 1 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
193387 230379 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 636 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010352.94216 2105328.73163 37.7614154903439 -122.407301828531 (37.7614154903439, -122.407301828531) 10 4 8 28859 19
193248 85830 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 3 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
192832 85814 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1607 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6007663 2109095 37.7716058657462 -122.416872087793 (37.7716058657462, -122.416872087793) 8 2 9 28853 19
192345 85697 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 3 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
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
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
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
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
190320 72375 Private 9 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 4299X Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.477688796337 (37.773031079694, -122.477688796337) 11 6 2 55 26
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
189245 52671 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1234@ LINCOLN 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53911 5993637.83557736 2107090.14039952 37.7653021756316 -122.465239907967 (37.7653021756316, -122.465239907967) 11 8 11 56 12
188775 85561 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767) 10 3 8 58 1
188352 103791 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1214 Polk St 1 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
188346 85707 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 960 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6010763 2112242 37.7804206796364 -122.406370731962 (37.7804206796364, -122.406370731962) 14 2 9 28853 34
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
186849 88363 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2294 31st Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52532 5986746.4 2099664.8 37.7445143908471 -122.48852965845 (37.7445143908471, -122.48852965845) 1 8 3 29491 35
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
185712 94261 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 2 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
185603 85565 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1276 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016630.35305 2093972.02339 37.7305816357941 -122.384799493903 (37.7305816357941, -122.384799493903) 10 3 8 58 1
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
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
184398 115346 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 398X HARRISON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854 2114630 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
184033 103836 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 3 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
183348 83827 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 755-757 Green St 2 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
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
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
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
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
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
181472 15056 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1441 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2012 12:00:00 AM 3 4x4   6015002 2095363 37.7343107811298 -122.390526157796 (37.7343107811298, -122.390526157796) 10 3 8 58 1
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
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
180205 230377 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 11 Haight St 2 : Tree Private 2     6 Width 4ft   6006012.13878 2109648.33208 37.7730321861234 -122.422621847921 (37.7730321861234, -122.422621847921) 7 9 11 28852 10
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
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
179720 87673 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2610 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2006 12:00:00 AM 3 3x3   6010582.741346 2086196.470906 37.708895230886 -122.405159783861 (37.708895230886, -122.405159783861) 9 7 8 309 39
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
179157 193406 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 746 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011525.03424 2104899.87784 37.7603034831294 -122.403217858726 (37.7603034831294, -122.403217858726) 10 3 8 28856 29
179089 85719 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1175 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 3x3   6009405 2110901 37.7766625499179 -122.410973965657 (37.7766625499179, -122.410973965657) 8 2 9 28853 34
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
177837 85570 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1260 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.519633 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139) 10 3 8 58 1
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
177200 94896 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1375 Keith St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53955 6016208.4 2094705 37.7325708970962 -122.386309345138 (37.7325708970962, -122.386309345138) 10 3 8 58 1
176520 85577 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1370 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016127.199744 2094347.098919 37.73158367729 -122.386565129485 (37.73158367729, -122.386565129485) 10 3 8 58 1
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
174678 86796 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 1 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
174018 114091 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1717 15th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/01/2015 12:00:00 AM     Permit Number 775992 5991423.2 2103752.9 37.7560110367904 -122.472656396727 (37.7560110367904, -122.472656396727) 1 8 4 56 12
173913 85733 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 901 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 4 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988) 14 2 9 28853 34
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
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
172339 94247 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 11 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
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
171702 85728 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1025 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2007 12:00:00 AM 3 3x3   6010365 2111820 37.7792396944918 -122.40771784288 (37.7792396944918, -122.40771784288) 14 2 9 28853 34
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
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
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
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
168926 85580 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1458 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015655.098903 2094699.254039 37.7325244779387 -122.38822185678 (37.7325244779387, -122.38822185678) 10 3 8 58 1
168460 3904 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 84 Castro St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2014 11:00:00 AM 3 2X2   6002180.9408165 2107753.3024618 37.7676120130603 -122.435738811724 (37.7676120130603, -122.435738811724) 15 5 5 29492 3
168373 85597 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1101 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 6 3x3   6017523.881587 2093256.051678 37.7286650962772 -122.381660625783 (37.7286650962772, -122.381660625783) 10 3 8 58 1
168045 85818 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1525 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6007957 2109502 37.7727399243445 -122.415883947269 (37.7727399243445, -122.415883947269) 8 2 9 28853 19
167714 98719 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1500 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2012 12:00:00 AM     Permit Number 768751 6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767) 13 9 10 28858 32
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
167046 85824 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1399X Howard St 1 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
165962 85737 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 843 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6011572.165806 2112967.734183 37.7824586081659 -122.40362250947 (37.7824586081659, -122.40362250947) 6 2 9 28853 34
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
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
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
163472 109142 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 342 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773572 5986886.5 2113633.7 37.7828773022088 -122.489071978745 (37.7828773022088, -122.489071978745) 11 6 2 55 26
163406 85562 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767) 10 3 8 58 1
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
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
161466 96015 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 10 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
161160 5458 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 589 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2009 12:00:00 AM 90 3x3   6004996.57492 2104960.58209 37.7601033992601 -122.425801080858 (37.7601033992601, -122.425801080858) 2 4 5 28859 19
160902 85607 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1397 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015969.720597 2094414.600713 37.7317603044799 -122.387114277117 (37.7317603044799, -122.387114277117) 10 3 8 58 1
160107 85560 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 980 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6018187.977749 2092810.892369 37.727479421244 -122.379333871981 (37.727479421244, -122.379333871981) 10 3 8 58 1
159858 17177 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2007 12:00:00 AM 3 4X4   6004921.1693652 2114736.5058392 37.7869414485048 -122.426758067349 (37.7869414485048, -122.426758067349) 13 9 11 28858 27
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
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
158563 103862 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1436 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006766.2 2115894.4 37.7902248822442 -122.420456889097 (37.7902248822442, -122.420456889097) 13 9 10 28858 21
158553 85822 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1499X Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2007 12:00:00 AM 3 3x3   6008077.269337 2109627.004998 37.7730899192917 -122.415476772701 (37.7730899192917, -122.415476772701) 8 2 9 28853 34
157770 5356 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 220 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/2015 03:17:00 PM 3 6x6 posted for removal 3/27/14 DPW 6004796.95819 2107043.90776 37.7658124332187 -122.426639815582 (37.7658124332187, -122.426639815582) 8 4 5 28862 3
156287 117298 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1590 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778522 5993741.6 2104678.7 37.7586869726954 -122.464705888807 (37.7586869726954, -122.464705888807) 1 8 4 56 12
155368 93268 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1574 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/29/2015 05:47:00 AM 3 3x3   6004569 2099722 37.7456953047191 -122.42690676352 (37.7456953047191, -122.42690676352) 2 7 5 63 22
154650 11953 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1436 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/27/2007 12:00:00 AM 6 3X4   6015854.7568499 2096315.1604747 37.7369724919298 -122.387644284768 (37.7369724919298, -122.387644284768) 10 3 8 58 1
153966 98720 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1500 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2012 12:00:00 AM   4x4 Permit Number 768751 6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767) 13 9 10 28858 32
153477 225511 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4     17 6x6   6004201.15911 2106105.10523 37.7632010052443 -122.428633631453 (37.7632010052443, -122.428633631453) 8 4 5 28862 3
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
152696 95786 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3431 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767530 6005503 2103116 37.7550672136514 -122.423918427558 (37.7550672136514, -122.423918427558) 2 4 5 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
151153 6746 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300X Fairfax Ave 16 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2007 12:00:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
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
150628 230385 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 581 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 9ft   6004995.95318 2104998.86424 37.760208477866 -122.425805956086 (37.760208477866, -122.425805956086) 2 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
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
147657 85568 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1264 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016691.22613 2093926.645569 37.7304604038472 -122.384585884949 (37.7304604038472, -122.384585884949) 10 3 8 58 1
147278 100431 Significant Tree 6 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 200X Stonecrest Dr 1 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
147253 93292 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1059 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004443 2102732 37.7539529400822 -122.427556858105 (37.7539529400822, -122.427556858105) 2 4 5 28862 22

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