Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

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)
189090 238416 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 68 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001018.956780001 2106039.93414 37.7628414553775 -122.439635110868 (37.7628414553775, -122.439635110868)
189082 239416 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1271 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   6003261.0959 2100827.35219 37.7486563039573 -122.431508196563 (37.7486563039573, -122.431508196563)
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)
189023 238388 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 80 Collingwood St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   6001986.47657 2105431.50433 37.7612258754818 -122.436245259426 (37.7612258754818, -122.436245259426)
189007 214828 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 14 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5996730.05288 2091219.63097 37.7219034920315 -122.453398786937 (37.7219034920315, -122.453398786937)
188990 237330 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Montezuma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007590.604590001 2099741.7313 37.745919870209605 -122.416459870422 (37.7459198702096, -122.416459870422)
188912 213530 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1301 Plymouth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5995845.09161 2092749.1474400002 37.7260524135838 -122.456568407028 (37.7260524135838, -122.456568407028)
188794 239516 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 248 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008976.50075 2097193.92135 37.739001983760296 -122.411487642954 (37.7390019837603, -122.411487642954)
188763 213318 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 347 Howth St 1 : 4 Tree 1 Private 1     3 Width 3ft   5997130.27848 2090199.39045 37.7191250833297 -122.45194174763 (37.7191250833297, -122.45194174763)
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)
188604 237088 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600 15th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006692.25312 2107335.17282 37.7667191467912 -122.420105051126 (37.7667191467912, -122.420105051126)
188584 214655 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1797 10th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993099.09717 2103293.8568599997 37.754847490535795 -122.466827267677 (37.7548474905358, -122.466827267677)
188578 213560 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Montecito Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5996382.63845 2094254.1039 37.7302155120395 -122.454818838046 (37.7302155120395, -122.454818838046)
188545 214625 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1449 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5992706.45428 2105582.72685 37.7611094609571 -122.46835163292 (37.7611094609571, -122.46835163292)
188398 238218 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3917 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004401.25357 2101297.60902 37.7500120760091 -122.42759904058398 (37.7500120760091, -122.427599040584)
188393 238414 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000656.2221099995 2105622.5799 37.761674851230296 -122.44085973930099 (37.7616748512303, -122.440859739301)
188388 238394 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 30 Collingwood St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6001974.4587 2105696.43162 37.761952618548605 -122.436305784682 (37.7619526185486, -122.436305784682)
188338 237241 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 467 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5998529.49857 2106472.57998 37.7638873867061 -122.448276395158 (37.7638873867061, -122.448276395158)
188326 237054 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6005797.6398599995 2107141.4188 37.766136698186706 -122.423185596933 (37.7661366981867, -122.423185596933)
188294 238393 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 80 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6001682.14825 2105375.84228 37.761055745351 -122.437293814064 (37.761055745351, -122.437293814064)
188235 196437 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2125 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6011358.58417 2105543.63854 37.762061808827795 -122.40383883519199 (37.7620618088278, -122.403838835192)
188228 237211 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 144 Day St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004988.02286 2098744.77183 37.743035743513 -122.42538831273701 (37.743035743513, -122.425388312737)
188145 213572 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6 Merced Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995340.05175 2100264.05702 37.7466575040536 -122.45885812859801 (37.7466575040536, -122.458858128598)
188084 237121 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3008 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6009469.279709999 2101040.98493 37.749592804880706 -122.410055350289 (37.7495928048807, -122.410055350289)
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)
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)
187959 88452 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2   06/07/2008 12:00:00 AM 4 5x12   6005470.42698 2121378.16696 37.8052088057127 -122.425330567252 (37.8052088057127, -122.425330567252)
187914 135943 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2056 Jefferson St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   5999351.778519999 2121203.50658 37.8043816542415 -122.446492250814 (37.8043816542415, -122.446492250814)
187910 237431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1204 Diamond St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8     6001926.93451 2100562.26984 37.747852742609204 -122.43610273936899 (37.7478527426092, -122.436102739369)
187828 238273 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4134 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002159.93034 2104730.60743 37.7593112359535 -122.435595213262 (37.7593112359535, -122.435595213262)
187756 238343 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 219 Collingwood St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002082.73822 2104584.2017099997 37.7589048565973 -122.43585170530001 (37.7589048565973, -122.4358517053)
187732 214729 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 620 Faxon Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994877.75254 2092392.95175 37.725018800251796 -122.459886624766 (37.7250188002518, -122.459886624766)
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)
187604 213526 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 54 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5995666.10329 2092922.0821200002 37.72651697277671 -122.457199659138 (37.7265169727767, -122.457199659138)
187600 239480 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1301 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997758.32648 2106133.54952 37.7629123768383 -122.450919186079 (37.7629123768383, -122.450919186079)
187534 213472 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 390 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993869.43858 2099604.78571 37.744762670277204 -122.463895471497 (37.7447626702772, -122.463895471497)
187377 196498 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 649 Bryant St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6012784.03099 2111475.7584 37.7784296058662 -122.399325187321 (37.7784296058662, -122.399325187321)
187362 179078 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 72 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6004357.38264 2093191.8849400003 37.72775311880321 -122.427173451712 (37.7277531188032, -122.427173451712)
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)
187321 238358 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 311 Cumberland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6003533.598130001 2104464.98127 37.75865981562411 -122.43082544834 (37.7586598156241, -122.43082544834)
187309 214781 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5992834.3473 2095346.2214400002 37.733010019498 -122.467165018866 (37.733010019498, -122.467165018866)
187208 214694 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 115 Pacheco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5994500.96734 2099944.5523099997 37.7457319577612 -122.461736412418 (37.7457319577612, -122.461736412418)
187199 238511 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 220 Arlington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   6004891.32109 2096838.98029 37.7377974084324 -122.425587073701 (37.7377974084324, -122.425587073701)
187197 120727 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 474 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5989397.82148 2112121.21454 37.7788706974235 -122.48027321576001 (37.7788706974235, -122.48027321576)
187134 237166 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 309 Montcalm St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009651.505030001 2099579.8056400004 37.7455909404652 -122.409322104236 (37.7455909404652, -122.409322104236)
187125 214605 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1336 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5993356.31377 2106389.87121 37.76336318179771 -122.46616272445499 (37.7633631817977, -122.466162724455)
187122 238176 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4037 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002928.2338 2101801.18414 37.75131134544971 -122.4327287852 (37.7513113454497, -122.4327287852)
187085 239519 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 132 Putnam St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009111.365619999 2096703.94776 37.7376641864385 -122.41098674217 (37.7376641864385, -122.41098674217)
187035 213389 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1758 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5993139.29631 2103519.85044 37.755470330397394 -122.46670467568701 (37.7554703303974, -122.466704675687)
186977 213378 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1222 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993325.39992 2107141.02877 37.7654238793266 -122.466324239095 (37.7654238793266, -122.466324239095)
186975 119011 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 43rd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5982518.7729400005 2112266.03771 37.778866206576794 -122.504080901039 (37.7788662065768, -122.504080901039)
186758 238479 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 82 Germania St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003859.40004 2108866.56108 37.770763947529296 -122.43001265998001 (37.7707639475293, -122.43001265998)
186721 213319 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 262 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   5991459.9673 2090912.89222 37.7207577701313 -122.471593616958 (37.7207577701313, -122.471593616958)
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)
186655 238405 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 Belcher St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003809.565119999 2108171.76515 37.7688533845966 -122.430135465991 (37.7688533845966, -122.430135465991)
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)
186644 123107 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 526 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992541.355380001 2111846.16706 37.778297656419795 -122.469378557612 (37.7782976564198, -122.469378557612)
186638 238427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 46 Mars St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999551.73328 2105494.96582 37.761261489550705 -122.444670533732 (37.7612614895507, -122.444670533732)
186561 179064 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 252 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6000355.465580001 2091781.1110900003 37.7236523325845 -122.440906950114 (37.7236523325845, -122.440906950114)
186491 237290 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008290.53524 2097979.90466 37.7411216210694 -122.41391498957898 (37.7411216210694, -122.413914989579)
186438 213370 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1567 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5992114.844269999 2104775.13643 37.758857841827606 -122.47033892420001 (37.7588578418276, -122.4703389242)
186426 214765 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993613.7342 2101408.96874 37.7497017595309 -122.464910643325 (37.7497017595309, -122.464910643325)
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)
186400 214739 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 163 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995642.708819999 2093778.0293599998 37.7288658544767 -122.457342428316 (37.7288658544767, -122.457342428316)
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)
186346 238431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 308 Corbett Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5999560.07225 2105167.63212 37.760363188228396 -122.444618165306 (37.7603631882284, -122.444618165306)
186273 237139 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1333 York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6010091.8415 2101431.32988 37.75069948002071 -122.407930023866 (37.7506994800207, -122.407930023866)
186256 196495 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 728 Brannan St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012138.917640001 2110082.47387 37.7745679907399 -122.401458945783 (37.7745679907399, -122.401458945783)
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)
186156 178984 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 33 Leo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6001422.09119 2091414.6513 37.722706807859396 -122.43719359092199 (37.7227068078594, -122.437193590922)
186142 213502 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 799 Faxon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5994882.72041 2093271.2307900002 37.727430628209795 -122.459933045084 (37.7274306282098, -122.459933045084)
186138 238131 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 71 Cuvier St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6003997.1048 2095455.09167 37.733946996161706 -122.428580195541 (37.7339469961617, -122.428580195541)
186097 214552 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 910 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992905.53931 2106654.87937 37.764064806773206 -122.46774106792 (37.7640648067732, -122.46774106792)
186096 246690 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 51 Stoneman St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6008005.33416 2099391.14992 37.7449805661161 -122.41500097851002 (37.7449805661161, -122.41500097851)
186079 213586 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2146 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992608.85526 2100815.1518900003 37.748013300381395 -122.468342327659 (37.7480133003814, -122.468342327659)
186077 238329 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 236 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002043.38339 2104453.45148 37.7585436124229 -122.43597845665701 (37.7585436124229, -122.435978456657)
185988 239387 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 418 Jersey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002328.89544 2101520.5865700003 37.750506882090704 -122.434781298937 (37.7505068820907, -122.434781298937)
185970 237122 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2957 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 6ft   6009722.71045 2101009.1052200003 37.749519471442206 -122.40917672522 (37.7495194714422, -122.40917672522)
185931 118627 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 494 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981628.0956 2112437.91019 37.7792856992778 -122.50717480668301 (37.7792856992778, -122.507174806683)
185899 238058 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 216 Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6006774.036069999 2098239.1296 37.741748108594706 -122.419176891418 (37.7417481085947, -122.419176891418)
185894 213368 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1590 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5992480.65426 2104648.2196 37.7585305048007 -122.469064557877 (37.7585305048007, -122.469064557877)
185845 238428 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 48 Mars St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5999550.38613 2105480.9679099997 37.76122297789 -122.444674186789 (37.76122297789, -122.444674186789)
185823 237189 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6004351.715890001 2103282.1102 37.7554582498219 -122.427911736635 (37.7554582498219, -122.427911736635)
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)
185740 237188 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 904 Church St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6004338.3422300005 2103543.5695 37.756175398901206 -122.42797661735001 (37.7561753989012, -122.42797661735)
185578 214698 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 550 Dewey Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 6ft   5994208.796569999 2099551.1927 37.7446350681495 -122.46271815822901 (37.7446350681495, -122.462718158229)
185530 237333 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 379 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6007360.67513 2096538.56664 37.7371117589919 -122.417028018027 (37.7371117589919, -122.417028018027)
185527 237450 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 48 Fountain St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6000333.56461 2101396.44944 37.750052546398 -122.441672377502 (37.750052546398, -122.441672377502)
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)
185480 238501 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 144 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003787.691869999 2097526.63527 37.7396231301891 -122.429451879611 (37.7396231301891, -122.429451879611)
185440 213504 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 435 Montecito Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995680.74302 2093936.8329099999 37.7293040752209 -122.457222425468 (37.7293040752209, -122.457222425468)
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)
185392 238527 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103 Randall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6004847.1355800005 2097543.60322 37.7397296468092 -122.425789984144 (37.7397296468092, -122.425789984144)
185356 135996 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Washington St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6009314.46183 2117374.97438 37.794433452692104 -122.41174472045601 (37.7944334526921, -122.411744720456)
185307 213627 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 Sequoia Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5998237.04023 2097606.63387 37.7395269584975 -122.44864932061 (37.7395269584975, -122.44864932061)
185274 135977 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2065 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6003684.735780001 2117929.31477 37.795638105372895 -122.431263834562 (37.7956381053729, -122.431263834562)
185251 213304 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 252 Sadowa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994495.39623 2087783.3442799998 37.71233992151021 -122.460874450904 (37.7123399215102, -122.460874450904)

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