Street_Tree_List

Data source: data.sfgov.org

601 rows where qCareAssistant = 1 and qSpecies = 18 sorted by rowid descending

View and edit SQL

qCareAssistant

  • FUF · 601
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)
188032 72515 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 44 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/12/1996 12:00:00 AM 6     5995895.10246 2112445.80394 37.7801373389306 -122.457820182784 (37.7801373389306, -122.457820182784)
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)
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)
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)
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)
185087 70501 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 75 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 9     6004654.404130001 2093072.1677599999 37.72744119435129 -122.42613812337 (37.7274411943513, -122.42613812337)
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)
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)
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)
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)
180951 73633 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 782 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 1     5983562.4874599995 2110479.0519 37.7740209842304 -122.500338183608 (37.7740209842304, -122.500338183608)
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)
179705 70127 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 236 Avalon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 9     6003416.21624 2092787.3454599997 37.726589075011894 -122.430398228113 (37.7265890750119, -122.430398228113)
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)
178828 78251 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 559 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/2000 12:00:00 AM 16     6002953.557080001 2090366.3939 37.7199154633005 -122.431824838869 (37.7199154633005, -122.431824838869)
178772 78229 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Colby St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 6 3x9   6008895.81383 2091285.82356 37.7227750861924 -122.411349358704 (37.7227750861924, -122.411349358704)
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)
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)
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)
177146 70504 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 437 Peru Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 18     6004727.68791 2092850.7822900002 37.7268374605684 -122.42586902913901 (37.7268374605684, -122.425869029139)
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)
175813 72259 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 231 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1996 12:00:00 AM 10     6002836.88949 2092205.7074400003 37.7249591941085 -122.432359414777 (37.7249591941085, -122.432359414777)
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)
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)
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)
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)
172644 70497 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 182 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 13     6003784.020880001 2092788.04528 37.726611824260104 -122.42912679089301 (37.7266118242601, -122.429126790893)
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)
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)
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)
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)
169316 71443 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 924 Sansome St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1995 12:00:00 AM 6     6012090.037819999 2119001.59006 37.7990550614973 -122.40225525407101 (37.7990550614973, -122.402255254071)
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)
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)
165384 79359 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 567 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2004 12:00:00 AM 4     5985009.753819999 2112015.61326 37.778324785429895 -122.495445265062 (37.7783247854299, -122.495445265062)
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)
164352 78215 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 869 Goettingen St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 14     6010959.76408 2090685.67745 37.7212427529373 -122.404172468398 (37.7212427529373, -122.404172468398)
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)
163917 79764 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 26 Wanda St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 7     6000559.455569999 2091550.49268 37.723030722971394 -122.440185263946 (37.7230307229714, -122.440185263946)
163806 31987 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 128 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/13/2004 12:00:00 AM 11   Permit Number 35387 5994614.2845 2114627.8658 37.7860550266291 -122.462409396175 (37.7860550266291, -122.462409396175)
163564 70459 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 73 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 12     6004663.961569999 2093087.11793 37.727482784398 -122.426106147103 (37.727482784398, -122.426106147103)
163282 31057 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1995 12:00:00 AM 5   Permit Number 34809 6002747.277969999 2087115.5773200002 37.7109777400017 -122.43230582505 (37.7109777400017, -122.43230582505)
163171 32104 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 242 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 7   Permit Number 35476 6002688.38371 2104495.7919400004 37.7586964899576 -122.433750783787 (37.7586964899576, -122.433750783787)
162769 37773 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 611 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/06/1998 12:00:00 AM 5   Permit Number 40111 6009477.59682 2092948.39833 37.7273727802074 -122.409455529449 (37.7273727802074, -122.409455529449)
162648 82704 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 67 Jennings Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/12/2005 12:00:00 AM 4     6012930.127090001 2089200.7150299998 37.7172752435332 -122.39725735994301 (37.7172752435332, -122.397257359943)
161720 88140 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2445 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/2008 12:00:00 AM 3 3x3 Permit Number 51172 5987869.621169999 2113257.1957099997 37.78190086066029 -122.485643191826 (37.7819008606603, -122.485643191826)
161379 33142 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3148 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2005 12:00:00 AM 8   Permit Number 37368 6001934.81136 2119023.6664400003 37.798543584677894 -122.437397274777 (37.7985435846779, -122.437397274777)
161168 68950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 734 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 32939 5988846.075 2110312.98983 37.7738737393837 -122.482049401575 (37.7738737393837, -122.482049401575)
160636 35253 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2250 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1998 12:00:00 AM 16   Permit Number 38739 6008088.43141 2120207.50426 37.8021420203875 -122.416187651964 (37.8021420203875, -122.416187651964)
160624 72323 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 35 Almaden Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/1996 12:00:00 AM 3     5995855.97542 2112465.40969 37.7801889231991 -122.45795695938101 (37.7801889231991, -122.457956959381)
160545 52065 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 155 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/11/2006 12:00:00 AM 3   Permit Number 48260 5994571.97803 2114501.44364 37.7857054693715 -122.462546590502 (37.7857054693715, -122.462546590502)
159954 62779 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/24/1986 12:00:00 AM 8   Permit Number 23134 6000268.11132 2091745.7518099998 37.7235502685229 -122.441206382083 (37.7235502685229, -122.441206382083)
158939 45481 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3014 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 3   Permit Number 44262 5990295.6794300005 2095138.00578 37.732291442289295 -122.475926565872 (37.7322914422893, -122.475926565872)

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