Street_Tree_List

Data source: data.sfgov.org

6,221 rows where qSpecies = 21

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
42 28375 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 3014 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/09/2003 12:00:00 AM 3 3x3 Permit Number 54020 6000248.590919999 2115494.6796 37.788757908594896 -122.442978542939 (37.7887579085949, -122.442978542939)
83 130626 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 3660 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft Permit Number 779583 5996802.12344 2115996.768 37.789939408212206 -122.454939052208 (37.7899394082122, -122.454939052208)
190 57209 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2898 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2014 12:00:00 AM 3   Permit Number 773671 6000999.92024 2115926.87738 37.7899874194288 -122.440410066565 (37.7899874194288, -122.440410066565)
198 103786 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1221 Polk St 1 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006804.9894 2115120.2532 37.7881014522033 -122.420267712778 (37.7881014522033, -122.420267712778)
215 17196 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2235X Octavia St 5 Median : Cutout 11 Tree 1 DPW 2     24 20   6004629.787409999 2116932.39582 37.792954330542 -122.42792271466601 (37.792954330542, -122.427922714666)
246 251253 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1350 Howard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008544.9526 2110145.4696299997 37.774539777213995 -122.413895673958 (37.774539777214, -122.413895673958)
254 98489 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 1813 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/2016 12:00:00 AM 3 4.5x5 Permit Number 777656 5999969.69733 2115286.35323 37.7881699939074 -122.443928497714 (37.7881699939074, -122.443928497714)
430 103824 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 1000 Polk St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006951.91038 2114418.6460599997 37.786183288961205 -122.419709589538 (37.7861832889612, -122.419709589538)
465 200701 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1433 Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/26/2012 12:00:00 AM 1 Width 0ft   6014951.6841 2095311.6378 37.7341669595219 -122.390696529464 (37.7341669595219, -122.390696529464)
508 6667 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1550 Evans Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 01:21:00 PM 3 3X3   6015906.32098 2098408.37334 37.7427228837554 -122.387611997891 (37.7427228837554, -122.387611997891)
566 243384 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 88 Montcalm St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/2017 12:00:00 AM 3 3x3   6010512.94245 2100000.19671 37.746793468955204 -122.406372986245 (37.7467934689552, -122.406372986245)
690 230152 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6004291.387 2105480.80272 37.761491925527395 -122.42827706645299 (37.7614919255274, -122.428277066453)
691 230156 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 Width 3ft   6004288.891419999 2105591.3935700003 37.7617954404249 -122.42829357981 (37.7617954404249, -122.42829357981)
698 230154 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6004288.78705 2105528.40005 37.7616224693351 -122.42828945101999 (37.7616224693351, -122.42828945102)
699 230157 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 Width 3ft   6004285.8388 2105617.0111 37.7618656073228 -122.428305963472 (37.7618656073228, -122.428305963472)
722 230151 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 Width 3ft   6004293.8189199995 2105454.00937 37.761418494979296 -122.42826674581998 (37.7614184949793, -122.42826674582)
723 230153 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 Width 3ft   6004293.15538 2105508.69845 37.7615686206128 -122.428272938555 (37.7615686206128, -122.428272938555)
725 230155 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 Width 3ft   6004284.84721 2105568.89365 37.7617334321738 -122.42830596346201 (37.7617334321738, -122.428305963462)
768 13057 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 566 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/04/2014 12:00:00 AM 3 2x2   6009630.8999 2120542.6321 37.8031488074681 -122.410873631329 (37.8031488074681, -122.410873631329)
808 193091 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1395 Fairfax Ave 1 : 4 Tree 1 DPW 2   01/27/2015 12:22:00 PM 6 Width 3ft   6016598.40823 2097419.6759099998 37.7400464320877 -122.38515006152201 (37.7400464320877, -122.385150061522)
840 193039 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1800 Evans Ave 10 : 4 Tree 1 DPW 2   05/12/2011 12:00:00 AM 5 Width 4ft   6014331.82546 2099544.27863 37.7457545046729 -122.39313565907699 (37.7457545046729, -122.393135659077)
878 108700 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 3024 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 772805 6001479.41501 2118822.32035 37.7979648412708 -122.438958648025 (37.7979648412708, -122.438958648025)
943 17376 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 1600 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3 Property owner contact Achmed 821-1594. 6014810.6051199995 2095342.4042099998 37.7342436096391 -122.391186437905 (37.7342436096391, -122.391186437905)
972 17847 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2082 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003983.5737 2115317.762 37.788484376640206 -122.430043414021 (37.7884843766402, -122.430043414021)
1138 44040 Section 143 8 Magnolia grandiflora :: Southern Magnolia 21 2504 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/2012 12:00:00 AM 3   Permit Number 769379 6002104.9323 2116736.7445400003 37.7922739619269 -122.436644820121 (37.7922739619269, -122.436644820121)
1179 40176 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 3591 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1999 12:00:00 AM 7 4X4 Permit Number 41367 5997123.1138 2115994.68514 37.7899520976567 -122.453828309438 (37.7899520976567, -122.453828309438)
1258 143477 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 645 CALIFORNIA ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6010516.819 2116392.3089 37.791802666645104 -122.407515085146 (37.7918026666451, -122.407515085146)
1267 18523 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1751X Powell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6009567.6842 2119779.6829 37.801050393337604 -122.41103847024901 (37.8010503933376, -122.411038470249)
1329 108251 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2342 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2014 12:00:00 AM 3   Permit Number 772707 6003487.823480001 2116598.59659 37.791973133309796 -122.43185012238199 (37.7919731333098, -122.431850122382)
1337 251410 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 21 2777 Pine St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 779015 6000658.0 2114782.0 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069)
1396 21755 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2350 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6008465.3581 2120976.6726 37.8042751503167 -122.414937771753 (37.8042751503167, -122.414937771753)
1443 229286 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 301 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/06/2009 12:00:00 AM 1 Width 4ft   6004913.9735 2106476.40674 37.7642608257117 -122.426194678137 (37.7642608257117, -122.426194678137)
1566 21756 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2350 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3x3   6008463.4743 2120995.0395 37.8043254753522 -122.41494559157199 (37.8043254753522, -122.414945591572)
1746 7330 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2049 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 1X1   6002872.8198 2115392.1403 37.7886256306485 -122.433891763872 (37.7886256306485, -122.433891763872)
1853 1906 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 27 Beideman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001522.4059 2113011.2495 37.782011588916795 -122.43839333989901 (37.7820115889168, -122.438393339899)
1857 251765 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1870 251767 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1871 176854 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1876 251766 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1915 124401 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 3974 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2017 12:00:00 AM 3 Width 3ft Permit Number 779990 5995681.39121 2115513.426 37.788547927118294 -122.45878165411999 (37.7885479271183, -122.45878165412)
2040 29049 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 270 11th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/04/2016 12:00:00 AM 3 3x3   6008308.58603 2109310.64459 37.772234267135 -122.414654224229 (37.772234267135, -122.414654224229)
2055 130716 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 2998 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/2017 12:00:00 AM 3 Width 4ft Permit Number 779575 5999812.313709999 2117089.58142 37.79311220651329 -122.444602671772 (37.7931122065133, -122.444602671772)
2148 18880 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2315 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/13/2014 12:00:00 AM 3 3x3   6003622.42952 2115918.82336 37.790114278706604 -122.43133583878799 (37.7901142787066, -122.431335838788)
2176 103962 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 3240 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/28/2017 12:00:00 AM 3   Permit Number 780028 5998623.05948 2116578.56663 37.7916411629484 -122.448680722253 (37.7916411629484, -122.448680722253)
2187 47144 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 3240 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 3x3 Permit Number 780028 5998645.601919999 2116582.6217400003 37.7916535861885 -122.448603018129 (37.7916535861885, -122.448603018129)
2217 13060 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Lombard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/26/2013 12:00:00 AM 3 2X2   6009601.7098 2120500.5639 37.8030316618488 -122.41097167179701 (37.8030316618488, -122.410971671797)
2241 193105 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 1649 Palou Ave 1 : 4 Tree 1 Private 1   10/28/1996 12:00:00 AM 10 Width 5ft   6014582.89152 2095437.7386599998 37.734492738953 -122.39198038730301 (37.734492738953, -122.391980387303)
2257 229627 Planning Code 138.1 required 4 Magnolia grandiflora :: Southern Magnolia 21 3662 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6008456.11159 2097816.22885 37.7406815009641 -122.41333091228701 (37.7406815009641, -122.413330912287)
2302 97526 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 532 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3 Permit Number 778941 6013958.0435 2114445.5251 37.7866492675441 -122.395471917224 (37.7866492675441, -122.395471917224)
2308 193164 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 282 02nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6013490.496590001 2114117.3583299997 37.785722181364896 -122.397066509426 (37.7857221813649, -122.397066509426)
2311 193166 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 282 02nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft Permit Number 778941 6013536.23807 2114063.46383 37.7855767457266 -122.396904475854 (37.7855767457266, -122.396904475854)
2316 193165 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 282 02nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6013505.95629 2114104.3862 37.7856874234834 -122.39701211302099 (37.7856874234834, -122.397012113021)
2317 97527 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 532 Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3 Permit Number 778941 6013942.6198 2114432.1579 37.7866117064154 -122.395524343042 (37.7866117064154, -122.395524343042)
2321 201175 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 600 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft Permit Number 778941 6013539.5466 2114043.4802 37.7855220594596 -122.396891627661 (37.7855220594596, -122.396891627661)
2348 97523 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 532 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/28/2016 12:00:00 AM 2 3x3 Permit Number 778941 6013933.3655 2114419.8189 37.7865773116244 -122.395555496101 (37.7865773116244, -122.395555496101)
2349 97528 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 532 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3 Permit Number 778941 6013984.7779 2114467.1183 37.78671004442771 -122.395380935237 (37.7867100444277, -122.395380935237)
2353 97525 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 532 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3 Permit Number 778941 6013969.3542 2114455.8076 37.786678130014 -122.395433505269 (37.786678130014, -122.395433505269)
2357 39974 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 0 Steiner St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 41235          
2473 253095 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 1201 29th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/13/2017 12:00:00 AM 3 3x3 Permit Number 779996 5987047.82966 2107087.0186099997 37.7649113707945 -122.488032657316 (37.7649113707945, -122.488032657316)
2679 21616 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 1550 Sutter St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6005148.1308 2114788.2908 37.7870964664996 -122.425976519639 (37.7870964664996, -122.425976519639)
2756 17850 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2100 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6003840.3349 2115295.8514 37.7884161023437 -122.430537433765 (37.7884161023437, -122.430537433765)
2802 229983 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 568 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/1982 12:00:00 AM 15 Width 2ft Permit Number 19661 6003129.342019999 2095763.1248 37.7347436380916 -122.43160229890499 (37.7347436380916, -122.431602298905)
2807 229984 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 570 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 15 Width 2ft Permit Number 18749 6003101.73362 2095751.10024 37.734709056481705 -122.431696892311 (37.7347090564817, -122.431696892311)
2809 229980 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 542 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/1982 12:00:00 AM 15 Width 3ft Permit Number 19660 6003257.39485 2095864.5781900003 37.735029463323 -122.431166815702 (37.735029463323, -122.431166815702)
2813 229987 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 581 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 13 Width 2ft Permit Number 18753 6003140.984180001 2095726.54341 37.734643853813296 -122.431559437241 (37.7346438538133, -122.431559437241)
2818 229986 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 599 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/1984 12:00:00 AM 9 Width 2ft Permit Number 21284 6003081.800919999 2095704.053 37.734578745606704 -122.431762448377 (37.7345787456067, -122.431762448377)
2820 229988 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 569 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 10 Width 2ft Permit Number 18752 6003200.6174 2095770.85092 37.734768891957394 -122.43135642697099 (37.7347688919574, -122.431356426971)
2821 229978 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 530 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 16 Width 2ft Permit Number 18745 6003326.59414 2095915.8411400001 37.735174140867294 -122.43093122660801 (37.7351741408673, -122.430931226608)
2822 229979 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 536 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/1982 12:00:00 AM 11 Width 3ft Permit Number 19659 6003305.39384 2095901.6279 37.7351339132885 -122.431003509611 (37.7351339132885, -122.431003509611)
2831 229982 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 560 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 12 Width 2ft Permit Number 18747 6003179.1898 2095802.1923599998 37.734853734004105 -122.431432746149 (37.7348537340041, -122.431432746149)
2836 229976 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 506 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/1983 12:00:00 AM 13 Width 2ft Permit Number 20257 6003460.201330001 2096023.8631099998 37.7354783140686 -122.430477003328 (37.7354783140686, -122.430477003328)
2838 229981 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 556 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 14 Width 3ft Permit Number 18746 6003219.85889 2095834.25264 37.7349440691062 -122.431294426813 (37.7349440691062, -122.431294426813)
2840 229977 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 522 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 14 Width 2ft Permit Number 18744 6003363.64026 2095947.4621700002 37.7352630640274 -122.43080540066099 (37.7352630640274, -122.430805400661)
2905 140308 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 2084 HAYES ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5997875.744 2109950.7455 37.773400144182 -122.450788324281 (37.773400144182, -122.450788324281)
2938 60590 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 601 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/1983 12:00:00 AM 14 4x4 Permit Number 20209 6000481.0 2111039.0 37.77653700517929 -122.441854521628 (37.7765370051793, -122.441854521628)
2969 139518 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 601 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6000481.0 2111039.0 37.77653700517929 -122.441854521628 (37.7765370051793, -122.441854521628)
3021 230623 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 1189 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 5ft Permit Number 780105 6003227.47781 2101395.97858 37.7502157130929 -122.431665039223 (37.7502157130929, -122.431665039223)
3326 230158 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 583 Church St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 6x9   6004286.27951 2105638.39668 37.7619243519609 -122.42830596346901 (37.7619243519609, -122.428305963469)
3365 229966 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 278 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1980 12:00:00 AM 17 Width 3ft Permit Number 18733 6004468.47248 2096814.7875400002 37.7377070787211 -122.42704734426 (37.7377070787211, -122.42704734426)
3456 27619 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2799X Sacramento St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6001525.7969 2115623.6000599996 37.7891846270188 -122.438568843173 (37.7891846270188, -122.438568843173)
3473 8205 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 1374 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/01/2006 12:00:00 AM 30 3X3   6001195.167 2111111.9943 37.7767780974284 -122.43938925166599 (37.7767780974284, -122.439389251666)
3593 108302 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2200X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2014 12:00:00 AM 3   Permit Number 773671 6000905.886 2115941.06387 37.7900210171946 -122.440736434162 (37.7900210171946, -122.440736434162)
3616 97137 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2929 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2015 12:00:00 AM 24 3x3 Permit Number 776885 6000677.09541 2116163.2813 37.790618136459706 -122.441543981264 (37.7906181364597, -122.441543981264)
3634 245136 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 102 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2017 12:00:00 AM 3 Width 0ft   6000842.6527 2109374.9669 37.7719885903551 -122.440484089064 (37.7719885903551, -122.440484089064)
3678 208759 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 300 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993126.46853 2099702.60224 37.7449884054972 -122.466471606489 (37.7449884054972, -122.466471606489)
3711 229522 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1400 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/02/2008 12:00:00 AM 3 Width 2ft   6004493.41372 2100695.79384 37.748364843572794 -122.427237482541 (37.7483648435728, -122.427237482541)
3753 253554 Planning Code 138.1 required 4 Magnolia grandiflora :: Southern Magnolia 21 1855 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/2017 12:00:00 AM 3 3x3 Permit Number 778968 5986885.63083 2102641.2721 37.7526951056681 -122.48826692291901 (37.7526951056681, -122.488266922919)
3821 46195 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2001 12:00:00 AM     Permit Number 44518          
3824 229287 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 420 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 SFUSD 6   2 6x6   6004863.64618 2105856.17124 37.7625549619753 -122.42632458341299 (37.7625549619753, -122.426324583413)
3888 229599 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 955 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2000 12:00:00 AM 2 Width 4ft Permit Number 43291 5999204.37358 2106797.0588 37.7648168837066 -122.44596555389 (37.7648168837066, -122.44596555389)
4027 253600 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 865 El Camino Del Mar 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
4034 253599 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 865 El Camino Del Mar 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       5x9   5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
4041 253601 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 865 El Camino Del Mar 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
4619 130948 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2361 Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/20/2015 12:00:00 AM 2 Width 3ft   6008329.55597 2121605.69745 37.8059946620911 -122.41545228710501 (37.8059946620911, -122.415452287105)
4651 229338 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2154 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/30/2007 12:00:00 AM 5 8x6   6009553.168190001 2104723.82915 37.759709771404296 -122.41002522030001 (37.7597097714043, -122.4100252203)
4777 177351 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 501X San Juan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2005 12:00:00 AM 4 Width 3ft Permit Number 48612 6000375.5599 2092850.3110099998 37.7265892548896 -122.440914152761 (37.7265892548896, -122.440914152761)
4783 177353 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 501X San Juan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2005 12:00:00 AM 7 Width 3ft Permit Number 48612 6000427.73907 2092811.4085099997 37.726485409251794 -122.44073098247401 (37.7264854092518, -122.440730982474)
4824 177352 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 501X San Juan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2005 12:00:00 AM 8 Width 3ft Permit Number 48612 6000403.69972 2092831.46295 37.7265391050915 -122.44081552323999 (37.7265391050915, -122.44081552324)
4833 4457 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1408 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/26/2017 12:00:00 AM 3 3X3 Permit Number 779671 6004499.90701 2100635.94447 37.748200878269294 -122.42721076637599 (37.7482008782693, -122.427210766376)
4864 253698 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 2200 Ofarrell St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       Width 0ft   6000775.0 2113124.0 37.7822786323031 -122.440987106931 (37.7822786323031, -122.440987106931)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2606.405ms · Data source: data.sfgov.org