trees
399 rows where qSpecies_id = 2 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22004 | 93263 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1326 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004490 | 2101167 | 37.7496584733742 | -122.427282847994 | (37.7496584733742, -122.427282847994) | 2 | 4 | 5 | 28862 | 22 | ||
| 22322 | 85732 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 901 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | 14 | 2 | 9 | 28853 | 34 | ||
| 22857 | 93269 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1730 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004618 | 2098811 | 37.7431966782063 | -122.426672467078 | (37.7431966782063, -122.426672467078) | 2 | 7 | 5 | 63 | 22 | ||
| 24373 | 177452 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003440.2849 | 2091219.73942 | 37.7222861409715 | -122.430203237092 | (37.7222861409715, -122.430203237092) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 25318 | 16583 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 810X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2008 12:00:00 AM | 2 | 3X3 | 5992991.92524 | 2114858.80829 | 37.7865955752076 | -122.468039078982 | (37.7865955752076, -122.468039078982) | 11 | 6 | 1 | 54 | 11 | ||
| 25377 | 85589 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1566 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015069.619532 | 2095135.418187 | 37.7336896386511 | -122.390276478357 | (37.7336896386511, -122.390276478357) | 10 | 3 | 8 | 58 | 1 | ||
| 26492 | 149925 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 595 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 778997 | 6015496.37916 | 2106243.76048 | 37.7642144863464 | -122.389576575905 | (37.7642144863464, -122.389576575905) | 14 | 3 | 8 | 28856 | 29 | |
| 28398 | 230376 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 126 Dolores St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004756.55794 | 2107626.00234 | 37.7674084411732 | -122.426821010098 | (37.7674084411732, -122.426821010098) | 8 | 4 | 5 | 28862 | 3 | |||
| 28890 | 85821 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1501 Howard St | 2 | 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 | ||
| 29186 | 85712 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1144 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009550 | 2111081 | 37.7771649174601 | -122.410485079371 | (37.7771649174601, -122.410485079371) | 8 | 2 | 9 | 28853 | 34 | ||
| 29881 | 85825 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1399X Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 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 | ||
| 30278 | 10232 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2002 12:00:00 AM | 8 | 6005984.55063 | 2109644.68395 | 37.7730206127534 | -122.422717019597 | (37.7730206127534, -122.422717019597) | 7 | 9 | 11 | 28852 | 10 | |||
| 32063 | 230390 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3431 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005492.40988 | 2103117.15388 | 37.7550697840629 | -122.423955133335 | (37.7550697840629, -122.423955133335) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | ||
| 33725 | 91422 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2112 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102; Tree 2 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 | 6003571 | 2107157 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | 7 | 4 | 5 | 28862 | 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 | ||
| 35474 | 94638 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2000X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2010 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
| 36426 | 93271 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1699X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004711 | 2099043.6 | 37.7438406020251 | -122.426367454995 | (37.7438406020251, -122.426367454995) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | ||
| 37463 | 252931 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 71 Edgar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997064 | 2091155 | 37.7217451669512 | -122.452239761545 | (37.7217451669512, -122.452239761545) | 9 | 8 | 6 | 28861 | 24 | ||||
| 37543 | 230386 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6008087.40778 | 2108285.62264 | 37.769407368778 | -122.415346724678 | (37.769407368778, -122.415346724678) | 8 | 4 | 7 | 28853 | 19 | |||
| 38042 | 93264 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1326 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004490 | 2101167 | 37.7496584733742 | -122.427282847994 | (37.7496584733742, -122.427282847994) | 2 | 4 | 5 | 28862 | 22 | ||
| 38684 | 85604 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016687.610646 | 2093879.449725 | 37.7303306134548 | -122.384595098105 | (37.7303306134548, -122.384595098105) | 10 | 3 | 8 | 58 | 1 | ||
| 39903 | 18422 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 940 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 06:57:00 AM | 3 | 3x3 | 6010451.25485 | 2103753.05423 | 37.7570945357026 | -122.406850749261 | (37.7570945357026, -122.406850749261) | 10 | 4 | 7 | 28859 | 19 | ||
| 40281 | 103835 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 2 | 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 | ||
| 41333 | 88753 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 10 | 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 | ||
| 41743 | 18420 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 924 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010442.48956 | 2103839.41038 | 37.7573311599314 | -122.406887149344 | (37.7573311599314, -122.406887149344) | 10 | 4 | 7 | 28859 | 19 | ||
| 42638 | 230392 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3416 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005586.33797 | 2103162.25218 | 37.7551989159029 | -122.423633508794 | (37.7551989159029, -122.423633508794) | 2 | 4 | 5 | 28859 | 19 | |||
| 42966 | 10342 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 935 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 4x4 | 6001663.93706 | 2109024.15924 | 37.7710720905099 | -122.437618081823 | (37.7710720905099, -122.437618081823) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |
| 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 | ||
| 43681 | 85727 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1025 Howard St | 1 | 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 | ||
| 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 | ||
| 44915 | 103874 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1331 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.3 | 2115545.2 | 37.7892632533111 | -122.42060474069 | (37.7892632533111, -122.42060474069) | 13 | 9 | 10 | 28858 | 21 | ||
| 47537 | 18353 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2013 12:00:00 AM | 3 | 3x3 | 6010310.70956 | 2106111.3358 | 37.7635619805233 | -122.407503071611 | (37.7635619805233, -122.407503071611) | 8 | 4 | 8 | 28859 | 19 | ||
| 48598 | 94246 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2125 BRYANT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |
| 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 | ||
| 50013 | 93300 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 589X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004575.9 | 2105667 | 37.7620192734995 | -122.427306317148 | (37.7620192734995, -122.427306317148) | 8 | 4 | 5 | 28862 | 3 | ||
| 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 | |
| 52263 | 93252 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1070 Church St | 1 | 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 | ||
| 52463 | 93286 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1283 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004502 | 2101425 | 37.7503675600759 | -122.427259727267 | (37.7503675600759, -122.427259727267) | 2 | 4 | 5 | 28862 | 22 | ||
| 56473 | 93743 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53322 | 6011367.4 | 2112778.7 | 37.7819281242694 | -122.40431760427 | (37.7819281242694, -122.40431760427) | 6 | 2 | 9 | 28853 | 34 | |||
| 56510 | 85815 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1607 Howard St | 2 | 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 | ||
| 56547 | 124911 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3234 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998736.95045 | 2116593.12953 | 37.7916876606053 | -122.448287711302 | (37.7916876606053, -122.448287711302) | 11 | 6 | 1 | 54 | 30 | |
| 57632 | 103843 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1541 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006635.7 | 2116216.3 | 37.7911013847793 | -122.420931274285 | (37.7911013847793, -122.420931274285) | 13 | 9 | 10 | 28858 | 21 | ||
| 58550 | 93288 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1259 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004494 | 2101568 | 37.7507597523824 | -122.427297577126 | (37.7507597523824, -122.427297577126) | 2 | 4 | 5 | 28862 | 22 | ||
| 59261 | 83828 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 755-757 Green St | 1 | 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 | |||
| 59431 | 85827 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1345 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008580 | 2110114 | 37.7744553372704 | -122.413772211324 | (37.7744553372704, -122.413772211324) | 8 | 2 | 9 | 28853 | 34 | ||
| 59794 | 92589 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 12 | 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 | ||
| 60072 | 85828 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 1 | 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 | ||
| 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 | |
| 61373 | 88349 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | 9 | 7 | 6 | 28861 | 5 | ||
| 61769 | 93266 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1440 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004482.7 | 2100527.8 | 37.747902965476 | -122.427262565386 | (37.747902965476, -122.427262565386) | 2 | 4 | 5 | 63 | 22 | ||
| 62082 | 55564 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1X CASELLI AVE | 1 | 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 | ||
| 62341 | 225510 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 21 | 6x6 | 6004199.54992 | 2106135.78909 | 37.7632851647079 | -122.42864138449 | (37.7632851647079, -122.42864138449) | 8 | 4 | 5 | 28862 | 3 | |||
| 63030 | 251164 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 01:46:00 PM | 3 | 3x3 | 6017471 | 2096747 | 37.7382476302403 | -122.382086185189 | (37.7382476302403, -122.382086185189) | 10 | 3 | 8 | 58 | 1 | ||
| 63660 | 124910 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3234 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998760.11738 | 2116596.00833 | 37.7916968894517 | -122.4482077616 | (37.7916968894517, -122.4482077616) | 11 | 6 | 1 | 54 | 30 | |
| 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 | ||
| 64762 | 13340 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 230 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X24 | 6011187.2509688 | 2090638.9738565 | 37.721127222942 | -122.403382822785 | (37.721127222942, -122.403382822785) | 10 | 3 | 7 | 309 | 28 | ||
| 65044 | 93273 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1679 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004706.9 | 2099119.3 | 37.7440482251279 | -122.426387020617 | (37.7440482251279, -122.426387020617) | 2 | 7 | 5 | 63 | 22 | ||
| 66728 | 18391 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 874 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 4x4 | 6010420.6643105 | 2104143.6455038 | 37.7581653002339 | -122.406984073056 | (37.7581653002339, -122.406984073056) | 10 | 4 | 7 | 28859 | 19 | ||
| 67555 | 93267 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1550 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004563 | 2099865 | 37.7460876105373 | -122.426937693393 | (37.7460876105373, -122.426937693393) | 2 | 7 | 5 | 63 | 22 | ||
| 68827 | 93281 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1465 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004562 | 2100365 | 37.7474604386711 | -122.426976756198 | (37.7474604386711, -122.426976756198) | 2 | 7 | 5 | 63 | 22 | ||
| 69419 | 86595 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2154 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 6 | 3x3 | 6009566 | 2104744 | 37.7597658751742 | -122.409982265203 | (37.7597658751742, -122.409982265203) | 2 | 4 | 7 | 28859 | 19 | ||
| 69485 | 85584 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1512 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015354.897796 | 2094923.102787 | 37.7331224832721 | -122.389275358402 | (37.7331224832721, -122.389275358402) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 70138 | 88771 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 461 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775199 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | |
| 71427 | 2390 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2642X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009749.5258463 | 2101948.1671123 | 37.7520994293613 | -122.409150251369 | (37.7520994293613, -122.409150251369) | 2 | 4 | 7 | 28859 | 19 | ||
| 72127 | 230394 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 280 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005433.48505 | 2102088.45121 | 37.7522418784739 | -122.42408575987 | (37.7522418784739, -122.42408575987) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | ||
| 72199 | 88350 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | 9 | 7 | 6 | 28861 | 5 | ||
| 72266 | 93277 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1565 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004670.9 | 2099777.3 | 37.7458529070189 | -122.426558345234 | (37.7458529070189, -122.426558345234) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 73597 | 226527 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 635 Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780912 | 6010443.26884 | 2105321.1926 | 37.7613998448343 | -122.406988893247 | (37.7613998448343, -122.406988893247) | 10 | 4 | 8 | 28859 | 19 | |
| 74455 | 94260 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2850X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.7592608098643 | -122.409349258874 | (37.7592608098643, -122.409349258874) | 2 | 4 | 8 | 28859 | 19 | |
| 74521 | 93293 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1049 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004440 | 2102791 | 37.7541147705659 | -122.42757143594 | (37.7541147705659, -122.42757143594) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 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 | ||
| 76153 | 93291 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1065 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004445 | 2102697 | 37.7538569514077 | -122.427547448283 | (37.7538569514077, -122.427547448283) | 2 | 4 | 5 | 28862 | 22 | ||
| 77180 | 248912 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017471 | 2096747 | 37.7382476302403 | -122.382086185189 | (37.7382476302403, -122.382086185189) | 10 | 3 | 8 | 58 | 1 | ||||
| 77343 | 17426 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1869 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/2015 01:06:00 PM | 3 | 3X3 | 6013447.63917 | 2096284.81189 | 37.736755533926 | -122.395964698714 | (37.736755533926, -122.395964698714) | 10 | 3 | 8 | 58 | 1 | ||
| 77573 | 93260 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1250X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004401.7 | 2101569.1 | 37.7507575523117 | -122.427616837084 | (37.7507575523117, -122.427616837084) | 2 | 4 | 5 | 28862 | 22 | ||
| 78957 | 51994 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3858 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1977 12:00:00 AM | Permit Number 769135 | 5995734.40748516 | 2115851.40858603 | 37.78947898308 | -122.458622703992 | (37.78947898308, -122.458622703992) | 11 | 6 | 1 | 54 | 31 | |||
| 79656 | 2 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 850X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 5992872.52482 | 2114854.21479 | 37.7865760666822 | -122.468451837381 | (37.7865760666822, -122.468451837381) | 11 | 6 | 1 | 54 | 11 | ||
| 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 | ||
| 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 | |
| 81910 | 225512 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 01/08/2019 12:00:00 AM | 3 | 6x6 | 6004203.25115 | 2106055.40872 | 37.7630646689183 | -122.428622853063 | (37.7630646689183, -122.428622853063) | 8 | 4 | 5 | 28862 | 3 | ||
| 82825 | 103844 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1541 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006635.7 | 2116216.3 | 37.7911013847793 | -122.420931274285 | (37.7911013847793, -122.420931274285) | 13 | 9 | 10 | 28858 | 21 | ||
| 84232 | 6725 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1200X Fairfax Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2008 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
| 84741 | 230375 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 70 Pearl St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6005616.00843 | 2108643.76201 | 37.770251521926 | -122.423920665902 | (37.770251521926, -122.423920665902) | 8 | 2 | 5 | 28853 | 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 | ||
| 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 | |||
| 86389 | 230391 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3425 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005521.318 | 2103117.66656 | 37.7550728237692 | -122.423855197061 | (37.7550728237692, -122.423855197061) | 2 | 4 | 5 | 28859 | 19 | |||
| 86673 | 85578 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016034.726363 | 2094416.033185 | 37.7317678372886 | -122.386889636739 | (37.7317678372886, -122.386889636739) | 10 | 3 | 8 | 58 | 1 | ||
| 86741 | 5370 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 265 DOLORES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2015 03:03:00 PM | 3 | 3X3 | 6005008.2 | 2106862.7 | 37.765326820302 | -122.425896274391 | (37.765326820302, -122.425896274391) | 8 | 4 | 5 | 28853 | 19 | ||
| 87079 | 225503 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | 6x6 | 6004180.73654 | 2106512.8354 | 37.7643193787498 | -122.428733333891 | (37.7643193787498, -122.428733333891) | 8 | 4 | 5 | 28862 | 3 |
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) );