trees
399 rows where 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 144860 | 10236 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 33 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2002 12:00:00 AM | 8 | 4X4 | 6005944.57875 | 2109639.18298 | 37.7730032531225 | -122.422854896447 | (37.7730032531225, -122.422854896447) | 7 | 9 | 11 | 28852 | 10 | ||
| 144661 | 5385 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 325X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2013 12:00:00 AM | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | ||
| 142124 | 88687 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 135 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2008 12:00:00 AM | Permit Number 51638 | 6003417 | 2105051 | 37.7602622759886 | -122.431270527939 | (37.7602622759886, -122.431270527939) | 2 | 4 | 5 | 28862 | 3 | |||
| 141097 | 94245 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2125 BRYANT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |
| 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 | ||
| 139812 | 114762 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 27X Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2015 12:00:00 AM | Permit Number 46967 | 6005096.96871 | 2096699.60241 | 37.7374263260205 | -122.424866136467 | (37.7374263260205, -122.424866136467) | 2 | 7 | 5 | 28859 | 2 | |||
| 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 | |
| 137187 | 92586 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 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 | ||
| 132976 | 92580 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 132768 | 95660 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 431 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767422 | 6010656.7 | 2092697.9 | 37.7267509601998 | -122.40536171554 | (37.7267509601998, -122.40536171554) | 10 | 3 | 7 | 309 | 28 | |
| 131390 | 108760 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1350 Church St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6004491.73804 | 2101024.57628 | 37.7492675091862 | -122.427266693799 | (37.7492675091862, -122.427266693799) | 2 | 4 | 5 | 28862 | 22 | ||||
| 129758 | 5348 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004789.90631 | 2107160.01438 | 37.7661308355062 | -122.426672475382 | (37.7661308355062, -122.426672475382) | 8 | 4 | 5 | 28862 | 3 | |
| 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 | ||
| 129134 | 92585 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 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 | ||
| 128897 | 87882 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50853 | 6002283.00879 | 2120864.77597 | 37.8036185768076 | -122.436324238766 | (37.8036185768076, -122.436324238766) | 13 | 9 | 1 | 57 | 17 | |
| 128665 | 95423 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767291 | 5989736.1 | 2100494 | 37.7469651560486 | -122.478252612879 | (37.7469651560486, -122.478252612879) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | ||
| 126216 | 225507 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | 6x6 | 6004191.74013 | 2106290.72293 | 37.7637101339293 | -122.428679441106 | (37.7637101339293, -122.428679441106) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 122719 | 86795 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 2 | 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 | ||
| 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 | |
| 120199 | 116966 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6010311.67872 | 2106089.82191 | 37.7635029625087 | -122.407498202703 | (37.7635029625087, -122.407498202703) | 8 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 119339 | 96670 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1425 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2012 12:00:00 AM | 4 | 4x4 | 6015007.7446 | 2095379.2401 | 37.7343556918302 | -122.390507431087 | (37.7343556918302, -122.390507431087) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 115916 | 94259 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2777X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.409573390285 | (37.7597963985886, -122.409573390285) | 2 | 4 | 8 | 28859 | 19 | |
| 115835 | 92587 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 10 | 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 | ||
| 115105 | 81753 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 565 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52385 | 6013577.35874 | 2104447.02049 | 37.7591744400611 | -122.396088040728 | (37.7591744400611, -122.396088040728) | 10 | 3 | 8 | 28856 | 29 | |
| 114647 | 103837 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
| 114564 | 96160 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2 Milton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | 2 | 7 | 5 | 28861 | 25 | |
| 114542 | 225505 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 19 | 6x6 | 6004182.33297 | 2106439.09947 | 37.7641170079293 | -122.428722555516 | (37.7641170079293, -122.428722555516) | 8 | 4 | 5 | 28862 | 3 | |||
| 114396 | 95387 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 949 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001944 | 2101334 | 37.7499727001327 | -122.436098944037 | (37.7499727001327, -122.436098944037) | 2 | 4 | 5 | 28862 | 22 | |
| 113947 | 85720 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1133 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009666.355548 | 2111144.506481 | 37.777345813652 | -122.410087051507 | (37.777345813652, -122.410087051507) | 8 | 2 | 9 | 28853 | 34 | ||
| 113636 | 103846 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1540 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006747 | 2116248.1 | 37.7911949727431 | -122.420548437624 | (37.7911949727431, -122.420548437624) | 13 | 9 | 10 | 28858 | 21 | ||
| 111986 | 131011 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002300.20603 | 2120865.81933 | 37.8036224187107 | -122.436264801676 | (37.8036224187107, -122.436264801676) | 13 | 9 | 1 | 57 | 17 | |||
| 111254 | 93275 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1607 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004606 | 2099539 | 37.7451949208192 | -122.42676579302 | (37.7451949208192, -122.42676579302) | 2 | 7 | 5 | 63 | 22 | ||
| 110634 | 117395 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 544 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778554 | 5991215.4 | 2097083.4 | 37.7376862859043 | -122.47288871789 | (37.7376862859043, -122.47288871789) | 1 | 8 | 4 | 29491 | 40 | ||
| 110617 | 225504 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 6x6 | 6004179.96928 | 2106475.61191 | 37.7642171285539 | -122.428733333881 | (37.7642171285539, -122.428733333881) | 8 | 4 | 5 | 28862 | 3 | |||
| 109636 | 95738 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Edinburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | 9 | 7 | 6 | 28861 | 5 | |
| 109523 | 108761 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1350 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774645 | 6004491.73804 | 2101024.57628 | 37.7492675091862 | -122.427266693799 | (37.7492675091862, -122.427266693799) | 2 | 4 | 5 | 28862 | 22 |
| 109159 | 87857 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1X CASELLI AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50796 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
| 108744 | 230393 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3420 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005567.36067 | 2103163.57677 | 37.7552014816894 | -122.423699232135 | (37.7552014816894, -122.423699232135) | 2 | 4 | 5 | 28859 | 19 | |||
| 108000 | 108709 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 280 Fair Oaks St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773390 | 6005432.93594 | 2102084.07132 | 37.7522298213067 | -122.424087347331 | (37.7522298213067, -122.424087347331) | 2 | 4 | 5 | 28859 | 19 | |
| 107426 | 5406 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 392 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2012 12:00:00 AM | 5 | 3x3 | 6004848.6988147 | 2106052.9215434 | 37.7630943465887 | -122.426390290354 | (37.7630943465887, -122.426390290354) | 8 | 4 | 5 | 28859 | 3 | ||
| 106272 | 115435 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 563 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001919.8 | 2090201.1 | 37.7194029477524 | -122.435386355519 | (37.7194029477524, -122.435386355519) | 9 | 7 | 6 | 28861 | 5 | ||
| 106231 | 96158 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767791 | 6003728 | 2095595 | 37.7343159198258 | -122.429520547314 | (37.7343159198258, -122.429520547314) | 2 | 7 | 5 | 28861 | 25 | |
| 105898 | 103793 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1214 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006878.4 | 2115091.6 | 37.7880269138329 | -122.420011690177 | (37.7880269138329, -122.420011690177) | 13 | 9 | 10 | 28858 | 21 | ||
| 105437 | 193408 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010314.12402 | 2106048.65269 | 37.7633900580388 | -122.407486842464 | (37.7633900580388, -122.407486842464) | 8 | 4 | 8 | 28859 | 19 | |||
| 105367 | 6784 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1360 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 4 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | ||
| 105243 | 93254 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1070 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004394 | 2102659 | 37.7537497275294 | -122.427721110855 | (37.7537497275294, -122.427721110855) | 2 | 4 | 5 | 28862 | 22 | ||
| 104815 | 93261 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1252 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004465 | 2101602 | 37.7508514683439 | -122.427400283526 | (37.7508514683439, -122.427400283526) | 2 | 4 | 5 | 28862 | 22 | ||
| 103120 | 87853 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50764 | 6007684 | 2096571 | 37.7372189966792 | -122.415912430403 | (37.7372189966792, -122.415912430403) | 2 | 7 | 7 | 28859 | 2 | ||
| 103060 | 13103 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1516 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2008 12:00:00 AM | 3 | 3x3 | 6005111 | 2119918 | 37.8011792509168 | -122.426470375667 | (37.8011792509168, -122.426470375667) | 13 | 9 | 1 | 57 | 17 | ||
| 102956 | 85559 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 980 Palou Ave | 1 | 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 | ||
| 102280 | 131010 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3099 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001935.38679 | 2118702.33437 | 37.7976613236686 | -122.437372261923 | (37.7976613236686, -122.437372261923) | 13 | 9 | 1 | 57 | 17 | |||
| 101899 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
| 101791 | 230380 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1450 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010406.10881 | 2100942.79845 | 37.7493756698697 | -122.406808829185 | (37.7493756698697, -122.406808829185) | 2 | 4 | 7 | 28859 | 19 | |||
| 101718 | 93272 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1689 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004632 | 2099057 | 37.7438729293821 | -122.42664157265 | (37.7438729293821, -122.42664157265) | 2 | 7 | 5 | 63 | 22 | ||
| 101456 | 88442 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1148 Treat Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51406 | 6008612.9 | 2101850.1 | 37.7517664174328 | -122.413073954345 | (37.7517664174328, -122.413073954345) | 2 | 4 | 7 | 28859 | 19 | |||
| 101381 | 188685 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Evans Ave | 14 | : | Tree | DPW 1 | 04/10/2017 01:01:00 PM | 3 | Width 3ft | 6017863.85792 | 2096944.20177 | 37.7388107959886 | -122.380741566863 | (37.7388107959886, -122.380741566863) | 10 | 3 | 8 | 58 | 1 | ||
| 100917 | 103792 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1214 Polk St | 2 | 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 | ||
| 99872 | 230388 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 3 | : | Tree | Private 2 | 8 | Width 4ft | 6008125.59993 | 2108283.70929 | 37.7694042616334 | -122.41521448386 | (37.7694042616334, -122.41521448386) | 8 | 4 | 7 | 28853 | 19 | |||
| 99625 | 93257 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1180X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004390.8 | 2101994.4 | 37.7519247103798 | -122.427684828837 | (37.7519247103798, -122.427684828837) | 2 | 4 | 5 | 28862 | 22 | ||
| 99446 | 86637 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2679 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009805.531856 | 2101750.09748 | 37.7515587115691 | -122.408942599671 | (37.7515587115691, -122.408942599671) | 2 | 4 | 7 | 28859 | 19 | ||
| 98913 | 434 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010425.4291782 | 2104052.7086425 | 37.7579158746071 | -122.406961184613 | (37.7579158746071, -122.406961184613) | 10 | 4 | 7 | 28859 | 19 | ||
| 98656 | 93259 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1234 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004459 | 2101704 | 37.7511311972424 | -122.427428297659 | (37.7511311972424, -122.427428297659) | 2 | 4 | 5 | 28862 | 22 | ||
| 98572 | 88750 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
| 97816 | 103845 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1540 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006747 | 2116248.1 | 37.7911949727431 | -122.420548437624 | (37.7911949727431, -122.420548437624) | 13 | 9 | 10 | 28858 | 21 | ||
| 97145 | 93284 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1347 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004523 | 2101050 | 37.7493390847523 | -122.427160399995 | (37.7493390847523, -122.427160399995) | 2 | 4 | 5 | 28862 | 22 |
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) );