trees
261 rows where DBH = 3 and qSpecies_id = 2 sorted by rowid descending
This data as json, CSV (advanced)
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
146908 | 103849 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1524 Polk St | 2 | 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 | ||
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 | |
144650 | 85708 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 964 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010738 | 2112218 | 37.7803533827236 | -122.406455527485 | (37.7803533827236, -122.406455527485) | 14 | 2 | 9 | 28853 | 34 | ||
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 | |||
143563 | 32720 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
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 | |
143258 | 93294 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1037 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004436 | 2102861 | 37.7543067479004 | -122.427590255736 | (37.7543067479004, -122.427590255736) | 2 | 4 | 5 | 28862 | 22 | ||
142517 | 93280 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1485 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004568 | 2100246 | 37.7471340314151 | -122.426947534581 | (37.7471340314151, -122.426947534581) | 2 | 7 | 5 | 63 | 22 | ||
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 | |
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 | ||
140577 | 93287 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1279 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004501 | 2101449 | 37.7504334019421 | -122.427264894728 | (37.7504334019421, -122.427264894728) | 2 | 4 | 5 | 28862 | 22 | ||
139333 | 93290 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1071 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004519 | 2102665.5 | 37.7537746450798 | -122.427289295317 | (37.7537746450798, -122.427289295317) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
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 |
138694 | 85696 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 2 | 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 | ||
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 | ||
138301 | 32721 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
137137 | 85817 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1581 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007957.739489 | 2109502.485486 | 37.7727412989479 | -122.415881423672 | (37.7727412989479, -122.415881423672) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |
136782 | 5343 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 180 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 02:20:00 PM | 3 | 3X3 | 6004776.79611 | 2107352.0132 | 37.7666572770255 | -122.426731495165 | (37.7666572770255, -122.426731495165) | 8 | 4 | 5 | 28862 | 3 | ||
136361 | 5577 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1041 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2010 12:00:00 AM | 3 | 3x3 | 6005148.8764838 | 2102292.2742932 | 37.7527854561506 | -122.425084482909 | (37.7527854561506, -122.425084482909) | 2 | 4 | 5 | 28859 | 19 | ||
136291 | 5477 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005026.79294 | 2104432.16218 | 37.7586541903676 | -122.425658960999 | (37.7586541903676, -122.425658960999) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
135595 | 93285 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1289 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004504 | 2101389 | 37.7502688255514 | -122.427250247058 | (37.7502688255514, -122.427250247058) | 2 | 4 | 5 | 28862 | 22 | ||
134990 | 85820 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1501 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6008072 | 2109608 | 37.7730374398788 | -122.415493654294 | (37.7730374398788, -122.415493654294) | 8 | 2 | 9 | 28853 | 19 | ||
129205 | 103834 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 1 | 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 | ||
129033 | 85569 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1260 Palou Ave | 1 | 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 | ||
128455 | 93274 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1613 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004607 | 2099503 | 37.7450961296299 | -122.426759771954 | (37.7450961296299, -122.426759771954) | 2 | 7 | 5 | 63 | 22 | ||
127073 | 85583 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1500 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015418.292964 | 2094875.921588 | 37.7329964475839 | -122.389052889382 | (37.7329964475839, -122.389052889382) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | ||
123120 | 193407 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 541 Missouri St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6013570.69062 | 2104547.33874 | 37.7594495210946 | -122.396118132954 | (37.7594495210946, -122.396118132954) | 10 | 3 | 8 | 28856 | 29 | |||
122477 | 93276 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1603 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004604 | 2099562 | 37.7452579604553 | -122.426774346316 | (37.7452579604553, -122.426774346316) | 2 | 7 | 5 | 63 | 22 | ||
121808 | 5355 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 214 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/2009 12:00:00 AM | 3 | 6 | 6004795.29962 | 2107076.64131 | 37.7659022179413 | -122.426647883401 | (37.7659022179413, -122.426647883401) | 8 | 4 | 5 | 28862 | 3 | ||
121444 | 93256 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1120 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted | 6004410 | 2102371 | 37.7529598520175 | -122.427645261537 | (37.7529598520175, -122.427645261537) | 2 | 4 | 5 | 28862 | 22 | |
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 | |||
118417 | 93283 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1377 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004533 | 2100877 | 37.7488646323576 | -122.427113499044 | (37.7488646323576, -122.427113499044) | 2 | 4 | 5 | 28862 | 22 | ||
117680 | 149924 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 595 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 778997 | 6015473.11557 | 2106243.07147 | 37.764211304535 | -122.389656990574 | (37.764211304535, -122.389656990574) | 14 | 3 | 8 | 28856 | 29 | |
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 | ||
115917 | 85721 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1049 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010189 | 2111652 | 37.7787685519268 | -122.408314849736 | (37.7787685519268, -122.408314849736) | 14 | 2 | 9 | 28853 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );