Street_Tree_List

Data source: data.sfgov.org

1,114 rows where qLegalStatus = 1 and qSpecies = 18 sorted by rowid descending

View and edit SQL

qLegalStatus

  • Permitted Site · 1,114
Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189115 53052 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2517@ SCOTT Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/2006 12:00:00 AM 5   Permit Number 49029 6001372.258169999 2117256.0832 37.7936582667653 -122.439217122188 (37.7936582667653, -122.439217122188)
189048 95921 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 275 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 3 3x3 Permit Number 767619 5988991.254980001 2113497.8107 37.782626811071296 -122.48178053312701 (37.7826268110713, -122.481780533127)
188706 98034 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1817 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/09/2011 12:00:00 AM 3 3x3 Permit Number 768344 5999961.07212 2115342.88884 37.788324733938396 -122.44396240304899 (37.7883247339384, -122.443962403049)
188053 66364 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 472 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/14/1991 12:00:00 AM 4   Permit Number 29965 5991908.34552 2112195.95462 37.7792214762424 -122.471593848027 (37.7792214762424, -122.471593848027)
187658 92257 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 862 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52706 5981411.16308 2109852.88199 37.7721751933845 -122.50773337462299 (37.7721751933845, -122.507733374623)
187355 50504 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 671 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/2003 12:00:00 AM 9   Permit Number 47140 6001297.56946 2089761.94857 37.7181617790314 -122.437505740198 (37.7181617790314, -122.437505740198)
186659 94703 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 658 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM 3 3x3 Permit Number 53843 5992262.68777 2110962.91491 37.77585637803789 -122.470278225754 (37.7758563780379, -122.470278225754)
186651 96029 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 730 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/2011 12:00:00 AM 3 3x3 Permit Number 767669 6007514.32648 2113867.32169 37.78470115228 -122.417724680544 (37.78470115228, -122.417724680544)
186414 45549 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990323.96119 2095935.96592 37.7344840775814 -122.47588704426201 (37.7344840775814, -122.475887044262)
186409 45569 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 310 Locust St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 4   Permit Number 44312 5997642.12042 2115315.11009 37.7881159077753 -122.451983551718 (37.7881159077753, -122.451983551718)
186347 47388 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 476Howard Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/2002 12:00:00 AM 1   Permit Number 45304 6010838.51311 2112011.8477 37.7797929592141 -122.406093276399 (37.7797929592141, -122.406093276399)
186222 56305 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 147 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/1973 12:00:00 AM 6   Permit Number 12437 5993019.12779 2114510.13973 37.785639797963704 -122.467919595671 (37.7856397979637, -122.467919595671)
185776 50300 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2917 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 5   Permit Number 47010 5989048.80024 2095796.1569299998 37.7340261814504 -122.480285417057 (37.7340261814504, -122.480285417057)
185754 30598 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 66 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/26/1995 12:00:00 AM 12   Permit Number 34565 6004323.10435 2108874.18954 37.7708111439393 -122.428409241587 (37.7708111439393, -122.428409241587)
185481 51890 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 475 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2005 12:00:00 AM 1   Permit Number 48103 6010867.53759 2112000.42013 37.779763205136206 -122.40599206220301 (37.7797632051362, -122.405992062203)
185419 96033 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 955 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/2011 12:00:00 AM 4 3x3 Permit Number 767672 6008167.44383 2115805.7111 37.790060229456294 -122.41560239383301 (37.7900602294563, -122.415602393833)
185006 52876 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 118@ BEACH Cervantes Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2006 12:00:00 AM 3   Permit Number 48887 6001354.74762 2121139.05445 37.8043188860645 -122.439556198976 (37.8043188860645, -122.439556198976)
184941 66120 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 474 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/1990 12:00:00 AM 11 6x9 Permit Number 29180 5992838.2067599995 2112235.24508 37.7793831093725 -122.4683799616 (37.7793831093725, -122.4683799616)
184937 36732 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8 South Park 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM 9   Permit Number 39511 6014611.904019999 2112877.2892299998 37.7823795964711 -122.393099929045 (37.7823795964711, -122.393099929045)
184864 42977 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 272 Oxford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 6   Permit Number 42862 6006537.3191599995 2092680.57085 37.7264721982142 -122.419601095323 (37.7264721982142, -122.419601095323)
184812 94696 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2443 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM 3 3x3 Permit Number 53831 5987889.1247 2113258.0139599997 37.7819042437171 -122.48557577955201 (37.7819042437171, -122.485575779552)
184608 62176 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 42 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/26/1985 12:00:00 AM 14   Permit Number 22292 6000115.63671 2091826.84592 37.723764247800396 -122.441739275348 (37.7237642478004, -122.441739275348)
184323 45553 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 168 Sylvan Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 3   Permit Number 44300 5987588.08064 2094826.81646 37.7312796348483 -122.485264410152 (37.7312796348483, -122.485264410152)
184236 65288 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 41 Rico Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1990 12:00:00 AM 7   Permit Number 28836 6001457.593230001 2121333.88235 37.8048596843835 -122.439214266819 (37.8048596843835, -122.439214266819)
184160 45526 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3001 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/23/2001 12:00:00 AM 3   Permit Number 44287 5988554.87545 2095154.91197 37.732236774288396 -122.481946089834 (37.7322367742884, -122.481946089834)
184129 32690 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 480 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 1   Permit Number 37101 6010817.622359999 2111993.44255 37.7797412544913 -122.406164249981 (37.7797412544913, -122.406164249981)
184059 39688 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 464 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7   Permit Number 41073 5991907.09743 2112240.92064 37.779344868431004 -122.47160144327101 (37.779344868431, -122.471601443271)
183771 33141 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3143 Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 9   Permit Number 37367 6001898.22805 2118969.0422099996 37.7983915210181 -122.437519950413 (37.7983915210181, -122.437519950413)
183324 68544 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 571 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 8   Permit Number 32430 5982530.7498 2111896.5441900003 37.777852390021 -122.504012093664 (37.777852390021, -122.504012093664)
182902 40949 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 543 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 8   Permit Number 45163 5989370.51415 2111642.49878 37.7775546903632 -122.480332633054 (37.7775546903632, -122.480332633054)
182777 49699 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 87@ TUCKER Alpha St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2008 12:00:00 AM 5 3x3 Permit Number 50825 6011128.67682 2088300.86402 37.7147039774881 -122.403420891467 (37.7147039774881, -122.403420891467)
182770 34483 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 845 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1997 12:00:00 AM 8   Permit Number 38210 6008918.6183400005 2119360.64227 37.7998633928514 -122.413254875509 (37.7998633928514, -122.413254875509)
182102 103454 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 284 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5988396.696330001 2114118.88325 37.7842975073391 -122.48388298077101 (37.7842975073391, -122.483882980771)
181801 48394 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2520 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/13/2003 12:00:00 AM 14   Permit Number 45776 6002671.64848 2116160.62189 37.7907242663701 -122.434642758376 (37.7907242663701, -122.434642758376)
181369 31513 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2513 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/1995 12:00:00 AM 15   Permit Number 35071 6011012.0661 2102261.56789 37.7530306081845 -122.40480623683399 (37.7530306081845, -122.404806236834)
180717 62178 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 28 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/24/1985 12:00:00 AM 11   Permit Number 22295 6000183.38046 2091791.51338 37.723671092440796 -122.441502563011 (37.7236710924408, -122.441502563011)
180438 103498 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1850X Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2014 12:00:00 AM 1 3x3 Permit Number 771036 5989807.55073 2110619.1422900003 37.774770222887604 -122.478745931564 (37.7747702228876, -122.478745931564)
180103 64839 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 21 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/1989 12:00:00 AM 13   Permit Number 25851 6003826.24575 2093276.39298 37.727955108333795 -122.429015623867 (37.7279551083338, -122.429015623867)
180014 100870 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 23 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2012 12:00:00 AM 1 3x3 Permit Number 769325 5995481.9791 2111446.40578 37.7773695144675 -122.45917696584299 (37.7773695144675, -122.459176965843)
179064 39571 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 835 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1998 12:00:00 AM 8   Permit Number 40989 6011610.458330001 2104449.8311400004 37.7590725253066 -122.402890761795 (37.7590725253066, -122.402890761795)
178641 70480 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 919 Avalon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 2 3x3 Permit Number 767510 6005011.406280001 2092024.56337 37.724584874666206 -122.42482946681001 (37.7245848746662, -122.42482946681)
178476 43281 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 731 Bacon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 9   Permit Number 43050 6009296.58944 2092411.7929900002 37.725889231602395 -122.410043408191 (37.7258892316024, -122.410043408191)
178402 31022 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 330 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1995 12:00:00 AM 8   Permit Number 34788 6002783.56511 2086520.12567 37.7093448166924 -122.43213791266001 (37.7093448166924, -122.43213791266)
178265 95761 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 211 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767498 6004841.33495 2091865.6988400002 37.724139060046795 -122.425406081532 (37.7241390600468, -122.425406081532)
178173 88272 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 518 Utah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/09/2008 12:00:00 AM 2 3x3 Permit Number 51258 6010632.7883 2105837.1165299998 37.7628270590352 -122.40636977475599 (37.7628270590352, -122.406369774756)
177958 45540 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 159 Middlefield Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 3   Permit Number 44295 5987294.0576 2094889.97142 37.7314359091244 -122.48628552285801 (37.7314359091244, -122.486285522858)
177891 62079 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 595 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1985 12:00:00 AM 14   Permit Number 22161 6013301.58361 2104304.12984 37.7587667459021 -122.397031791103 (37.7587667459021, -122.397031791103)
177753 111197 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6     6003620.633230001 2116569.07161 37.791899593028205 -122.43138849140499 (37.7918995930282, -122.431388491405)
177715 40658 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Congdon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 8   Permit Number 47919 6004683.64689 2093722.1701 37.7292276094514 -122.426083284515 (37.7292276094514, -122.426083284515)
177092 94734 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 706 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53865 5992586.2471199995 2110603.0007 37.7748868521692 -122.46913276056002 (37.7748868521692, -122.46913276056)
176951 48912 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1930 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/22/2002 12:00:00 AM 2 3x3 Permit Number 46107 6004309.09705 2118070.5094 37.796061152762796 -122.429113506091 (37.7960611527628, -122.429113506091)
176209 32514 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 814 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM 3   Permit Number 37016 6007565.02408 2095597.87607 37.7345403220735 -122.41625488347799 (37.7345403220735, -122.416254883478)
175674 45552 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 168 Sylvan Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/2003 12:00:00 AM 3   Permit Number 44300 5987586.8772599995 2094815.36489 37.7312481217032 -122.485267730441 (37.7312481217032, -122.485267730441)
175579 64857 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 21 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 5   Permit Number 25873 5995838.9792599995 2112526.25675 37.780355016559504 -122.458020161226 (37.7803550165595, -122.458020161226)
175301 67942 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 586 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/1993 12:00:00 AM 4   Permit Number 31656 5989115.53927 2111342.9098799997 37.776717282669296 -122.48119272322701 (37.7767172826693, -122.481192723227)
175252 51995 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2837 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/29/2005 12:00:00 AM 11   Permit Number 48213 5999309.41845 2118712.36147 37.797539220023296 -122.44645951279301 (37.7975392200233, -122.446459512793)
175243 96075 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 411 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 3 3x3 Permit Number 767701 5983103.04582 2113013.19289 37.7809520179972 -122.50211500631399 (37.7809520179972, -122.502115006314)
175130 32497 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 665 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM 16   Permit Number 37002 6007442.3069400005 2095863.1015400002 37.7352616718948 -122.416697941676 (37.7352616718948, -122.416697941676)
174698 49745 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 34@ LELAND Britton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 4   Permit Number 46544 6008556.3350599995 2087877.23988 37.7133967814171 -122.41228206988899 (37.7133967814171, -122.412282069889)
174561 68280 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Bowdoin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 7   Permit Number 32088 6008949.32855 2093160.8279900001 37.7279264532255 -122.411296760036 (37.7279264532255, -122.411296760036)
173911 84352 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 06th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 4 3x3 Permit Number 51575 5994138.19056 2110541.38294 37.7748072179408 -122.463759829065 (37.7748072179408, -122.463759829065)
173766 36753 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2579 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/25/1999 12:00:00 AM 8   Permit Number 41197 6002394.06342 2116399.40669 37.7913641456997 -122.435620277371 (37.7913641456997, -122.435620277371)
173587 95934 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 674 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767631 5987254.50705 2111348.9878700003 37.7766256032795 -122.487630947058 (37.7766256032795, -122.487630947058)
173547 37340 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 131 Brunswick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM 10   Permit Number 39848 6000626.60293 2087367.0099799999 37.7115476439893 -122.43965337791799 (37.7115476439893, -122.439653377918)
173528 39575 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 885 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1998 12:00:00 AM 13   Permit Number 40992 6011619.84178 2104260.65443 37.7585536119741 -122.40284500428999 (37.7585536119741, -122.40284500429)
173356 38235 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 81 Langton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM 10   Permit Number 40353 6010102.82343 2110824.83764 37.7764925318532 -122.408554604827 (37.7764925318532, -122.408554604827)
173069 62262 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 78 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1985 12:00:00 AM 18   Permit Number 22388 5999957.62074 2091909.06342 37.7239809934048 -122.442291407838 (37.7239809934048, -122.442291407838)
172983 50299 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2917 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 4   Permit Number 47010 5989048.57412 2095810.2761099997 37.7340649359436 -122.480287231884 (37.7340649359436, -122.480287231884)
172980 50792 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2740 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2   Permit Number 47317 5999864.3976 2118141.20218 37.7960026509676 -122.444498073449 (37.7960026509676, -122.444498073449)
172628 34523 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 586 Utah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/1997 12:00:00 AM 8   Permit Number 38233 6010643.980930001 2105619.91693 37.762231304058204 -122.40631575879 (37.7622313040582, -122.40631575879)
172523 62479 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 35 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 10   Permit Number 31826 6000682.25846 2093099.2989400001 37.7272903816351 -122.43987175399499 (37.7272903816351, -122.439871753995)
172196 35478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 524 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/1998 12:00:00 AM 6   Permit Number 38890 5986598.81458 2112347.1481 37.779328002919705 -122.489972580124 (37.7793280029197, -122.489972580124)
172079 41946 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 690 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 10   Permit Number 42304 5993510.89143 2110826.8547 37.775554879409206 -122.46595051642299 (37.7755548794092, -122.465950516423)
171618 68224 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/01/2012 12:00:00 AM 1   Permit Number 769229 5990833.387490001 2113424.07906 37.782531317215295 -122.47540222511999 (37.7825313172153, -122.47540222512)
171041 65739 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Concord St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/19/1990 12:00:00 AM 12   Permit Number 28675 5999799.15568 2087425.51821 37.7116611636025 -122.442517443427 (37.7116611636025, -122.442517443427)
170838 68956 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 874 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 7   Permit Number 32945 5988542.5052 2110035.3324599997 37.7730937088544 -122.483079131422 (37.7730937088544, -122.483079131422)
170516 44260 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 320 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM 6   Permit Number 43692 6003282.08858 2092150.8754099999 37.72483387178 -122.430816500988 (37.72483387178, -122.430816500988)
170473 82703 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 67 Jennings Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/09/2009 12:00:00 AM 6 3x3 Permit Number 52500 6012950.17329 2089208.10371 37.71729664739521 -122.39718858698 (37.7172966473952, -122.39718858698)
170297 65278 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 415 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/1989 12:00:00 AM 1   Permit Number 28081 6011215.3927 2112332.46737 37.7806943784819 -122.40481205633999 (37.7806943784819, -122.40481205634)
170172 59138 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 531 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/1980 12:00:00 AM 1   Permit Number 18444 5992185.73773 2111803.62567 37.7781602921817 -122.47060565987302 (37.7781602921817, -122.470605659873)
169964 43259 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 445 Wayland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 8   Permit Number 43042 6010225.92511 2092216.8838799999 37.725406095999396 -122.406817013015 (37.7254060959994, -122.406817013015)
169580 84326 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 728 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/09/2010 12:00:00 AM 5 3x3 Permit Number 53994 5987888.08845 2110995.2066599997 37.7756911522049 -122.48541326443899 (37.7756911522049, -122.485413264439)
168755 41936 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 684 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 10 3x9 Permit Number 42295 5994746.112840001 2110871.9454099997 37.7757498669665 -122.461680887642 (37.7757498669665, -122.461680887642)
168539 45578 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 325 Walnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 6   Permit Number 44318 5998557.11063 2115405.08726 37.788415328045204 -122.448824341269 (37.7884153280452, -122.448824341269)
167820 45548 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990306.88184 2095939.17218 37.734491890873606 -122.475946326684 (37.7344918908736, -122.475946326684)
166797 50876 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 322 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2004 12:00:00 AM 7   Permit Number 47534 5987167.73714 2113766.40078 37.7832580715076 -122.48810878253401 (37.7832580715076, -122.488108782534)
166558 68939 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 491 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/12/2010 12:00:00 AM 3   Permit Number 53187 5989664.28625 2112063.79605 37.7787285224831 -122.479347217114 (37.7787285224831, -122.479347217114)
166312 68274 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 Bowdoin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 2   Permit Number 32081 6008779.93848 2093554.1542200001 37.7289969414408 -122.411910130973 (37.7289969414408, -122.411910130973)
166176 68393 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 248 Cotter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1993 12:00:00 AM 4   Permit Number 32221 6001588.48331 2093972.4225299999 37.729739323692705 -122.436801419974 (37.7297393236927, -122.436801419974)
166051 64856 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Almaden Ct 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 2   Permit Number 25872 5995898.09877 2112568.97781 37.7804757138181 -122.45781873289499 (37.7804757138181, -122.457818732895)
165958 66569 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/15/1991 12:00:00 AM 15   Permit Number 29758 6005069.72782 2093317.4329799998 37.728138104176004 -122.424719787291 (37.728138104176, -122.424719787291)
165794 41942 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 760 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 12   Permit Number 42300 5994453.07656 2110414.51665 37.7744770167939 -122.462661376327 (37.7744770167939, -122.462661376327)
165599 68952 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 747 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 3   Permit Number 32941 5988797.45218 2110217.11495 37.7736076654938 -122.482210568345 (37.7736076654938, -122.482210568345)
165571 30804 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 137 Chilton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1995 12:00:00 AM 14   Permit Number 34669 6001616.65191 2095326.1919200001 37.733458064439 -122.43680091003401 (37.733458064439, -122.436800910034)
165506 95992 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 858 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767644 5986371.40114 2110056.12968 37.7730242344515 -122.490590683906 (37.7730242344515, -122.490590683906)
165469 45480 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3014 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 4   Permit Number 44262 5990294.42195 2095159.6612900002 37.732350829908704 -122.47593249418699 (37.7323508299087, -122.475932494187)
165270 95771 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 335 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767506 6003734.79279 2091608.3124 37.7233697529841 -122.429212886579 (37.7233697529841, -122.429212886579)
164850 31788 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 160 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1995 12:00:00 AM 4   Permit Number 35258 6001692.80487 2107894.1622099997 37.7679710399513 -122.437437296395 (37.7679710399513, -122.437437296395)
164404 40950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 543 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM 6   Permit Number 42451 5989371.25434 2111628.81002 37.777517147846204 -122.480329070335 (37.7775171478462, -122.480329070335)
164246 62478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 19 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/25/1986 12:00:00 AM 17   Permit Number 22649 6000701.05589 2093131.58953 37.7273801141826 -122.43980908564501 (37.7273801141826, -122.439809085645)

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 2755.245ms · Data source: data.sfgov.org