home / trees

Street_Tree_List

Data source: data.sfgov.org

367 rows where qSpecies = 74

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
399 100431 Significant Tree 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 200X Stonecrest Dr 1 Front Yard : Yard 4 Tree 1 Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
400 100432 Significant Tree 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 200X Stonecrest Dr 2 Front Yard : Yard 4 Tree 1 Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
416 100465 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1140 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6010498.9 2102571.5 37.75385291653011 -122.40660271212 (37.7538529165301, -122.40660271212) 10 4 7 28859 19
2028 10232 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 11 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 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
2069 10236 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 33 Haight St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/30/2002 12:00:00 AM 8 4X4   6005944.57875 2109639.18298 37.7730032531225 -122.42285489644699 (37.7730032531225, -122.422854896447) 7 9 11 28852 10
2290 102590 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1205 Plymouth Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 47971 5995820.0 2092088.8 37.724237816628 -122.4566074133 (37.724237816628, -122.4566074133) 9 7 4 28861 40
3054 10342 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 935 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/04/2011 12:00:00 AM 3 4x4   6001663.937059999 2109024.15924 37.7710720905099 -122.437618081823 (37.7710720905099, -122.437618081823) 15 5 11 29492 9
3408 103791 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1214 Polk St 1 Sidewalk: Curb side : Cutout 2 Tree 1 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
3409 103792 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1214 Polk St 2 Sidewalk: Curb side : Cutout 2 Tree 1 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
3410 103793 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1214 Polk St 3 Sidewalk: Curb side : Cutout 2 Tree 1 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
3411 103794 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1214 Polk St 4 Sidewalk: Curb side : Cutout 2 Tree 1 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
3437 103817 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1100 Polk St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/2009 12:00:00 AM 3 3x3   6006925.9 2114751.5 37.787095758933894 -122.41982320605 (37.7870957589339, -122.41982320605) 13 9 10 28858 21
3455 103834 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 900X O'Farrell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
3456 103835 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 900X O'Farrell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
3457 103836 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 900X O'Farrell St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
3458 103837 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 900X O'Farrell St 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
3459 103838 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 900X O'Farrell St 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
3465 103843 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1541 Polk St 1 Sidewalk: Curb side : Pot 3 Tree 1 DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.791101384779296 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
3466 103844 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1541 Polk St 2 Sidewalk: Curb side : Pot 3 Tree 1 DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.791101384779296 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
3467 103845 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1540 Polk St 1 Sidewalk: Curb side : Pot 3 Tree 1 DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006747.0 2116248.1 37.7911949727431 -122.42054843762399 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
3468 103846 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1540 Polk St 2 Sidewalk: Curb side : Pot 3 Tree 1 DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006747.0 2116248.1 37.7911949727431 -122.42054843762399 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
3469 103847 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1529 Polk St 1 Sidewalk: Curb side : Pot 3 Tree 1 DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006640.1 2116184.7 37.7910148670423 -122.42091380589399 (37.7910148670423, -122.420913805894) 13 9 10 28858 21
3470 103848 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1524 Polk St 1 Sidewalk: Curb side : Pot 3 Tree 1 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
3471 103849 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1524 Polk St 2 Sidewalk: Curb side : Pot 3 Tree 1 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
3473 103850 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1524 Polk St 3 Sidewalk: Curb side : Pot 3 Tree 1 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
3474 103851 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1524 Polk St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
3485 103862 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1436 Polk St 2 Sidewalk: Curb side : Pot 3 Tree 1 DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006766.2 2115894.4 37.7902248822442 -122.42045688909701 (37.7902248822442, -122.420456889097) 13 9 10 28858 21
3498 103874 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1331 Polk St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006716.3 2115545.2 37.7892632533111 -122.42060474068998 (37.7892632533111, -122.42060474069) 13 9 10 28858 21
4200 104727 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1079 Church St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 DPW 3     3x3 Permit Number 770313 6004450.0 2102615.0 37.7536320814231 -122.427524315639 (37.7536320814231, -122.427524315639) 2 4 5 28862 22
7266 108392 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1382 San Bruno Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773801 6011141.7607 2101910.8917 37.7520749768049 -122.40433304488701 (37.7520749768049, -122.404333044887) 10 4 8 28859 19
7384 108507 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 796 19th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773790 5990094.5666 2109953.25495 37.772958540137 -122.477704410848 (37.772958540137, -122.477704410848) 11 6 2 55 26
7598 108709 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 280 Fair Oaks St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773390 6005432.93594 2102084.07132 37.752229821306706 -122.42408734733101 (37.7522298213067, -122.424087347331) 2 4 5 28859 19
7651 108760 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1350 Church St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3   6004491.73804 2101024.57628 37.749267509186204 -122.427266693799 (37.7492675091862, -122.427266693799) 2 4 5 28862 22
7652 108761 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1350 Church St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/05/2015 12:00:00 AM 3 3x3 Permit Number 774645 6004491.73804 2101024.57628 37.749267509186204 -122.427266693799 (37.7492675091862, -122.427266693799) 2 4 5 28862 22
7684 108791 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 323 Edinburgh St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 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
7731 108834 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 163 Ney St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774662 6004445.49273 2094062.1156099997 37.73014756094079 -122.42693080570601 (37.7301475609408, -122.426930805706) 9 7 6 28861 5
7772 108873 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 137 Cole St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773403 5997771.922180001 2110131.23662 37.7738897825389 -122.45116047571699 (37.7738897825389, -122.451160475717) 15 5 11 29492 16
7879 108977 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 2970 21st St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/20/2015 12:00:00 AM 3 3x3 Permit Number 773794 6008402.2 2103930.0 37.7574655215329 -122.413949705223 (37.7574655215329, -122.413949705223) 2 4 7 28859 19
8042 109142 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 342 29th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773572 5986886.5 2113633.7 37.782877302208796 -122.489071978745 (37.7828773022088, -122.489071978745) 11 6 2 55 26
8162 109258 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1290 45th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773444 5982171.0 2106334.4 37.762559192748604 -122.504844313965 (37.7625591927486, -122.504844313965) 1 8 3 56 35
8191 109286 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1438 43rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/05/2015 12:00:00 AM 3 3x3 Permit Number 771727 5982826.9 2105321.3 37.75981607235 -122.502500845014 (37.75981607235, -122.502500845014) 1 8 3 56 35
8407 109530 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 76 Alvarado St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/20/2015 12:00:00 AM 3 3x3 Permit Number 775000 6005863.7 2102913.1 37.7545304541232 -122.42265660342301 (37.7545304541232, -122.422656603423) 2 4 5 28859 19
8791 110043 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 890 Rhode Island St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   9     6011841.59848 2104237.14125 37.7585014297196 -122.402076412192 (37.7585014297196, -122.402076412192) 10 3 8 28856 29
11184 112744 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 235 Bright St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/18/2015 12:00:00 AM     Permit Number 774127 5993719.1 2088769.4 37.7150026970857 -122.463629063261 (37.7150026970857, -122.463629063261) 9 8 6 64 24
12397 114091 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1717 15th Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/01/2015 12:00:00 AM     Permit Number 775992 5991423.2 2103752.9 37.7560110367904 -122.472656396727 (37.7560110367904, -122.472656396727) 1 8 4 56 12
13014 114762 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 27X Highland Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/07/2015 12:00:00 AM     Permit Number 46967 6005096.96871 2096699.6024099998 37.7374263260205 -122.424866136467 (37.7374263260205, -122.424866136467) 2 7 5 28859 2
13582 115346 Planning Code 138.1 required 8 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 398X HARRISON ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854.0 2114630.0 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
13583 115347 Planning Code 138.1 required 8 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 398X HARRISON ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854.0 2114630.0 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
13665 115435 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 563 Lisbon St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777504 6001919.8 2090201.1 37.7194029477524 -122.43538635551901 (37.7194029477524, -122.435386355519) 9 7 6 28861 5
15116 116966 Planning Code 138.1 required 8 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 480 Potrero Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6010311.678719999 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703) 8 4 8 28859 19
15451 117298 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1590 08th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778522 5993741.6 2104678.7 37.7586869726954 -122.46470588880699 (37.7586869726954, -122.464705888807) 1 8 4 56 12
15544 117395 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 544 Wawona St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/08/2016 12:00:00 AM 3   Permit Number 778554 5991215.4 2097083.4 37.737686285904296 -122.47288871789 (37.7376862859043, -122.47288871789) 1 8 4 29491 40
17049 11953 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1436 Kirkwood Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/27/2007 12:00:00 AM 6 3X4   6015854.7568499 2096315.1604746997 37.7369724919298 -122.38764428476802 (37.7369724919298, -122.387644284768) 10 3 8 58 1
21923 12447 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1989X Pine St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/18/2004 12:00:00 AM 4 3x3   6004432.626396201 2115327.1853143997 37.7885356724235 -122.428490433403 (37.7885356724235, -122.428490433403) 13 9 11 28858 27
22388 124910 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 3234 Pacific Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998760.117380001 2116596.00833 37.79169688945171 -122.4482077616 (37.7916968894517, -122.4482077616) 11 6 1 54 30
22389 124911 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 3234 Pacific Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 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
22584 125087 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 2498X Pierce St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/13/2018 12:00:00 AM 3 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064) 13 6 1 29490 27
22585 125088 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 2498X Pierce St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/13/2018 12:00:00 AM 3 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064) 13 6 1 29490 27
28602 13061 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 583 Lombard St 4 Sidewalk: Curb side : Cutout 2 Tree 1 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
29041 131010 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 3099 Steiner St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6001935.38679 2118702.3343700003 37.797661323668606 -122.437372261923 (37.7976613236686, -122.437372261923) 13 9 1 57 17
29042 131011 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1771 North Point St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6002300.20603 2120865.81933 37.8036224187107 -122.436264801676 (37.8036224187107, -122.436264801676) 13 9 1 57 17
29062 13103 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1516 Lombard St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/11/2008 12:00:00 AM 3 3x3   6005111.0 2119918.0 37.801179250916796 -122.426470375667 (37.8011792509168, -122.426470375667) 13 9 1 57 17
31624 13340 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 230 Mansell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/29/2007 12:00:00 AM 3 3X24   6011187.2509688 2090638.9738565 37.721127222942 -122.40338282278499 (37.721127222942, -122.403382822785) 10 3 7 309 28
34161 135722 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 2498X Pierce St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/13/2018 12:00:00 AM 3 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064) 13 6 1 29490 27
42927 149924 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 595 Mariposa St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/26/2018 12:00:00 AM 3 Width 4ft Permit Number 778997 6015473.115569999 2106243.07147 37.764211304534996 -122.389656990574 (37.764211304535, -122.389656990574) 14 3 8 28856 29
42928 149925 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 595 Mariposa St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/26/2018 12:00:00 AM 3 Width 4ft Permit Number 778997 6015496.37916 2106243.7604799997 37.7642144863464 -122.389576575905 (37.7642144863464, -122.389576575905) 14 3 8 28856 29
42929 149926 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 595 Mariposa St 3 Sidewalk: Curb side : Cutout 2 Tree 1 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
42995 15056 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1441 Mendell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/26/2012 12:00:00 AM 3 4x4   6015002.0 2095363.0 37.7343107811298 -122.390526157796 (37.7343107811298, -122.390526157796) 10 3 8 58 1
44745 16583 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 810X Lake St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/26/2008 12:00:00 AM 2 3X3   5992991.92524 2114858.80829 37.7865955752076 -122.46803907898199 (37.7865955752076, -122.468039078982) 11 6 1 54 11
45329 17177 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1601 Octavia St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/14/2007 12:00:00 AM 3 4X4   6004921.1693652 2114736.5058391998 37.7869414485048 -122.426758067349 (37.7869414485048, -122.426758067349) 13 9 11 28858 27
45337 171814 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 100 Dartmouth St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 FUF 2 08/05/2017 12:00:00 AM 3 4x5   6008473.26376 2093533.30473 37.728922482984096 -122.41296885872801 (37.7289224829841, -122.412968858728) 9 3 7 309 28
45753 17385 Permitted Site 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1649 Palou Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/28/1996 12:00:00 AM 12 6x5   6014583.05525 2095408.96107 37.7344137306531 -122.39197780950899 (37.7344137306531, -122.391977809509) 10 3 8 58 1
45874 17426 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1869 Palou Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/05/2015 01:06:00 PM 3 3X3   6013447.639169999 2096284.8118900002 37.736755533926 -122.39596469871401 (37.736755533926, -122.395964698714) 10 3 8 58 1
48635 177451 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 836 Brazil Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 2ft   6004096.8384300005 2090858.43848 37.7213312534072 -122.427907954105 (37.7213312534072, -122.427907954105) 9 7 6 28861 5
48636 177452 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 404 Naples St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 4ft   6003440.2849 2091219.73942 37.7222861409715 -122.430203237092 (37.7222861409715, -122.430203237092) 9 7 6 28861 5
54472 18344 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 440 Potrero Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   07/16/2015 07:27:00 AM 3 3X3   6010309.570730001 2106285.64769 37.7640405376657 -122.40751930078001 (37.7640405376657, -122.40751930078) 8 4 8 28859 19
54527 18349 Planning Code 138.1 required 8 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 480 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/28/2006 12:00:00 AM 3 3X3   6010310.27618 2106136.10948 37.763629979170496 -122.40750631726101 (37.7636299791705, -122.407506317261) 8 4 8 28859 19
54571 18353 Planning Code 138.1 required 8 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 480 Potrero Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/02/2013 12:00:00 AM 3 3x3   6010310.709559999 2106111.3358 37.76356198052329 -122.407503071611 (37.7635619805233, -122.407503071611) 8 4 8 28859 19
54660 18361 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 530 Potrero Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/02/2015 11:39:00 AM 3 3x3   6010330.807907499 2105828.5872592 37.762786742062204 -122.407413622665 (37.7627867420622, -122.407413622665) 8 4 8 28859 19
54769 18371 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 636 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/02/2016 12:00:00 AM 4 2X2   6010355.5730099995 2105342.69627 37.7614539813358 -122.40729371393999 (37.7614539813358, -122.40729371394) 10 4 8 28859 19
54986 18391 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 874 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/14/2013 12:00:00 AM 3 4x4   6010420.6643105 2104143.6455038004 37.7581653002339 -122.406984073056 (37.7581653002339, -122.406984073056) 10 4 7 28859 19
55279 18418 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 645X POTRERO AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/02/2016 12:00:00 AM 3 3X3   6010440.0 2105310.0 37.7613689295586 -122.40699940993099 (37.7613689295586, -122.406999409931) 10 4 8 28859 19
55301 18420 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 924 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 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
55322 18422 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 940 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 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
55333 18423 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 952 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/20/2013 12:00:00 AM 3 3x3   6010455.30853 2103703.2834799998 37.75695810316021 -122.406833222372 (37.7569581031602, -122.406833222372) 10 4 7 28859 19
55948 18480 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1298 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/31/2017 01:20:00 PM 3 3x3   6010561.39126 2101710.28558 37.751491708090896 -122.406325925618 (37.7514917080909, -122.406325925618) 10 4 7 28859 19
59922 188685 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1300 Evans Ave 14 : 14 Tree 1 DPW 1   04/10/2017 01:01:00 PM 3 Width 3ft   6017863.857919999 2096944.2017700002 37.738810795988606 -122.38074156686301 (37.7388107959886, -122.380741566863) 10 3 8 58 1
59924 188687 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1300 Evans Ave 30 Sidewalk: Curb side : Cutout 2 Tree 1 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
65015 193406 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 746 Kansas St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6011525.03424 2104899.87784 37.7603034831294 -122.40321785872601 (37.7603034831294, -122.403217858726) 10 3 8 28856 29
65016 193407 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 541 Missouri St 1 : 14 Tree 1 Private 2     3 Width 2ft   6013570.69062 2104547.33874 37.7594495210946 -122.396118132954 (37.7594495210946, -122.396118132954) 10 3 8 28856 29
65017 193408 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 480 Potrero Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   6010314.12402 2106048.6526900004 37.763390058038794 -122.40748684246401 (37.7633900580388, -122.407486842464) 8 4 8 28859 19
69615 197655 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1300 Fairfax Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     22 Width 4ft   6016998.37545 2097206.43045 37.7394830203258 -122.383752282143 (37.7394830203258, -122.383752282143) 10 3 8 58 1
71494 2 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 850X Lake St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/25/2009 12:00:00 AM 3 3X3   5992872.52482 2114854.21479 37.78657606668221 -122.468451837381 (37.7865760666822, -122.468451837381) 11 6 1 54 11
74445 203064 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 1300 Evans Ave 34 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/18/2017 01:07:00 PM 3 Width 3ft   6017493.20317 2097219.3147299998 37.7395457381522 -122.382042262644 (37.7395457381522, -122.382042262644) 10 3 8 58 1
96730 225503 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 450 Church St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4     17 6x6   6004180.73654 2106512.8354 37.764319378749796 -122.42873333389099 (37.7643193787498, -122.428733333891) 8 4 5 28862 3
96731 225504 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 450 Church St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4     18 6x6   6004179.96928 2106475.61191 37.7642171285539 -122.428733333881 (37.7642171285539, -122.428733333881) 8 4 5 28862 3
96732 225505 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 450 Church St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4     19 6x6   6004182.33297 2106439.0994700002 37.76411700792929 -122.42872255551599 (37.7641170079293, -122.428722555516) 8 4 5 28862 3
96734 225507 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 450 Church St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4     17 6x6   6004191.740130001 2106290.7229299997 37.763710133929294 -122.428679441106 (37.7637101339293, -122.428679441106) 8 4 5 28862 3
96735 225508 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 450 Church St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     17 6x6   6004195.74141 2106258.0557 37.763620663995 -122.428663273099 (37.763620663995, -122.428663273099) 8 4 5 28862 3
96736 225509 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 74 450 Church St 9 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4     22 6x6   6004197.80145 2106206.80833 37.7634800675805 -122.42865249471201 (37.7634800675805, -122.428652494712) 8 4 5 28862 3

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 26.583ms · Data source: data.sfgov.org