Street_Tree_List

Data source: data.sfgov.org

14,663 rows where search matches "cherry"

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26 237469 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 4200 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2000 12:00:00 AM 0 Width 3ft Permit Number 43111 6001814.64366 2102375.07824 37.75282390261339 -122.43662077403299 (37.7528239026134, -122.436620774033)
34 240126 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Lily St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6006399.28254 2110261.0751 37.7747364652596 -122.42132618837299 (37.7747364652596, -122.421326188373)
71 251206 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 270 Trumbull St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
73 65479 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1051 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1997 12:00:00 AM 10 3x3 Permit Number 28361 6008468.497880001 2115537.43749 37.789340533487795 -122.41454177659901 (37.7893405334878, -122.414541776599)
92 98091 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
128 212622 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 115 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5991392.0 2089980.0 37.718192344870296 -122.471760605115 (37.7181923448703, -122.471760605115)
131 237033 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 7 : 4 Tree 1 DPW 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
135 237030 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 4 : 4 Tree 1 DPW 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
158 21682 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1830 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:00:00 AM 3 4x4   6003825.2217 2114604.0634 37.7865157709252 -122.43054034167 (37.7865157709252, -122.43054034167)
182 93463 DPW Maintained 3 Prunus x 'Amanogawa' :: Flowering Cherry 57 1739 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 01:05:00 PM 3 3x3   5987772.1588 2098929.0107 37.7425539090053 -122.48492886712098 (37.7425539090053, -122.484928867121)
213 28640 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 2 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.782776612799296 -122.430825656777 (37.7827766127993, -122.430825656777)
233 121240 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 91 Commonwealth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/2016 12:00:00 AM 3 3x5 Permit Number 778926 5996501.4108 2113948.5087 37.7842981813685 -122.45583135787399 (37.7842981813685, -122.455831357874)
270 28098 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 639 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/28/2006 12:00:00 AM 3 3X3   6001577.9698 2110674.4978 37.7755986195101 -122.438033679217 (37.7755986195101, -122.438033679217)
299 196427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 McLea Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010117.0 2109248.0 37.772163696411795 -122.408394314545 (37.7721636964118, -122.408394314545)
303 196320 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 905 Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
343 244298 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 350 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 Width 0ft   6005605.7628 2110511.5277 37.7753793775331 -122.42408895277501 (37.7753793775331, -122.424088952775)
368 18096 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 3008 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.786481285230295 -122.44577068023099 (37.7864812852303, -122.445770680231)
383 181340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5988678.0351 2106085.8063 37.7622572799997 -122.48232089502501 (37.7622572799997, -122.482320895025)
401 235987 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1118 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/20/2000 12:00:00 AM 10 Width 3ft Permit Number 42064 6004405.04081 2102370.6961 37.7529587370629 -122.42766238971399 (37.7529587370629, -122.427662389714)
407 248462 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 130 Beulah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft Permit Number 779787 5997458.097999999 2107812.3026 37.767504613553 -122.45207869525 (37.767504613553, -122.45207869525)
426 21683 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1840 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/1999 12:00:00 AM 6 2x2   6003770.0848 2114594.6383 37.786486768354294 -122.430730428794 (37.7864867683543, -122.430730428794)
450 142159 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 490X Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
457 142162 Undocumented 2 Prunus spp :: Cherry 84 490X Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
482 142326 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1652 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
585 236679 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 682 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM 2 Width 3ft Permit Number 42634 6000886.69016 2100906.56017 37.7487389273654 -122.43972452598301 (37.7487389273654, -122.439724525983)
605 23903 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1600X Webster St 6 Median : Cutout 11 Tree 1 DPW 2     3 6   6003560.4697 2114360.5617 37.7858321751093 -122.431438928251 (37.7858321751093, -122.431438928251)
649 96374 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1315 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008916.2106800005 2117429.1962900003 37.7945599836999 -122.41312655846599 (37.7945599836999, -122.413126558466)
678 237516 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1004 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 Width 3ft Permit Number 779660 6003758.05774 2102389.1689299997 37.752972841143 -122.429901097271 (37.752972841143, -122.429901097271)
695 212430 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 377 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/1999 12:00:00 AM 4 Width 3ft Permit Number 41586 5992705.098540001 2094089.26949 37.7295512799622 -122.467520487584 (37.7295512799622, -122.467520487584)
702 212428 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 384 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/1999 12:00:00 AM 4 Width 3ft Permit Number 41587 5992676.41369 2094100.5394 37.7295805681871 -122.467620472428 (37.7295805681871, -122.467620472428)
711 212429 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 384 San Benito Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/1999 12:00:00 AM 4 Width 3ft Permit Number 41587 5992663.86781 2094081.2472599999 37.7295268723689 -122.467662441966 (37.7295268723689, -122.467662441966)
830 12894 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 255X Larch St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/1990 12:00:00 AM 3 3X3   6006443.29256 2113021.2667 37.7823177635948 -122.421370005133 (37.7823177635948, -122.421370005133)
841 241294 Undocumented 2 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 117 1342 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/19/2017 12:00:00 AM 3 Width 3ft Permit Number 779705 6011123.6651099995 2102080.8508 37.7525406359468 -122.404407584468 (37.7525406359468, -122.404407584468)
853 244350 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 300 Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/20/2017 07:22:00 AM 3 Width 0ft   6005619.219 2110418.7508 37.77512539438639 -122.424035805431 (37.7751253943864, -122.424035805431)
924 214223 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 207 Mangels Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5999983.92895 2095213.9818900002 37.7330570333525 -122.44243762501199 (37.7330570333525, -122.442437625012)
1001 238568 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1300 Noe St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   04/27/2017 12:00:00 AM 3 Width 5ft Permit Number 779731 6003218.5106 2100626.90187 37.7481035005842 -122.431641146931 (37.7481035005842, -122.431641146931)
1012 246499 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 311 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779776 6004393.833380001 2099835.13521 37.7459960419019 -122.427520522551 (37.7459960419019, -122.427520522551)
1087 236728 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1616 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6002564.10416 2100703.66645 37.7482771632622 -122.433909544687 (37.7482771632622, -122.433909544687)
1117 135672 Permitted Site 1 Prunus caroliniana :: Carolina Cherry Laurel 133 2147 Bay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/23/1999 12:00:00 AM 1 Width 3ft Permit Number 41893 6000516.72226 2120270.10752 37.80188525946561 -122.44239382441299 (37.8018852594656, -122.442393824413)
1181 12891 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 255X Larch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/25/2005 12:00:00 AM 3 3X3   6006369.20019 2113010.28335 37.7822834283719 -122.421625551994 (37.7822834283719, -122.421625551994)
1186 244032 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 501X Shrader St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1999 12:00:00 AM 7 Width 0ft Permit Number 41876 5997510.0 2108663.0 37.7698433835647 -122.45196055507601 (37.7698433835647, -122.451960555076)
1190 244029 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 501X Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1999 12:00:00 AM 7 Width 0ft Permit Number 41876 5997510.0 2108663.0 37.7698433835647 -122.45196055507601 (37.7698433835647, -122.451960555076)
1193 244030 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 501X Shrader St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1999 12:00:00 AM 6 Width 0ft Permit Number 41876 5997510.0 2108663.0 37.7698433835647 -122.45196055507601 (37.7698433835647, -122.451960555076)
1200 244033 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 501X Shrader St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1999 12:00:00 AM 8 Width 0ft Permit Number 41876 5997510.0 2108663.0 37.7698433835647 -122.45196055507601 (37.7698433835647, -122.451960555076)
1216 244031 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 501X Shrader St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1999 12:00:00 AM 6 Width 0ft Permit Number 41876 5997510.0 2108663.0 37.7698433835647 -122.45196055507601 (37.7698433835647, -122.451960555076)
1237 103805 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Hemlock St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006953.73656 2114843.50125 37.7873499398897 -122.41973342786999 (37.7873499398897, -122.41973342787)
1252 61532 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 347 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2017 12:00:00 AM 3   Permit Number 772896 5991195.07104 2113068.5037599998 37.781575964268896 -122.474125016615 (37.7815759642689, -122.474125016615)
1259 238460 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 52 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2017 12:00:00 AM 3 Width 3ft Permit Number 779768 6002902.99046 2108581.89909 37.7699281239255 -122.433300551682 (37.7699281239255, -122.433300551682)
1264 212477 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2147 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/06/1991 12:00:00 AM 4 Width 2ft Permit Number 29975 5992562.5652 2100831.93832 37.7480567178444 -122.468503616573 (37.7480567178444, -122.468503616573)
1311 237352 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3186 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 4x4   6008549.69387 2100618.49329 37.7483811527756 -122.413205447889 (37.7483811527756, -122.413205447889)
1472 244877 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1349 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6000105.0 2109153.0 37.7713370947812 -122.443019734512 (37.7713370947812, -122.443019734512)
1495 213442 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2455 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2002 12:00:00 AM 6 Width 3ft Permit Number 45711 5992014.67382 2098752.22599 37.742314697659204 -122.470246761681 (37.7423146976592, -122.470246761681)
1535 28642 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1300 Webster St 4 Median : Cutout 11 Tree 1 DPW 2     10 20   6003705.0759 2113297.4854 37.782921429068395 -122.430862736641 (37.7829214290684, -122.430862736641)
1658 245160 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 101 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6000314.5004 2109304.1699 37.7717641118423 -122.4423059193 (37.7717641118423, -122.4423059193)
1660 245161 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 101 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6000318.8213 2109280.9033 37.7717004738838 -122.442289302515 (37.7717004738838, -122.442289302515)
1661 245154 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 100 Lyon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6000359.4788 2109307.5305 37.771775902629706 -122.44215057779499 (37.7717759026297, -122.442150577795)
1663 251645 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 132 Shipley St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1669 245155 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 100 Lyon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6000354.8127 2109347.659 37.7718858194659 -122.442169599164 (37.7718858194659, -122.442169599164)
1670 251646 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 132 Shipley St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1675 245153 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 100 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6000359.9454 2109295.8652 37.7717438992436 -122.44214812628701 (37.7717438992436, -122.442148126287)
1677 251644 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 132 Shipley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1681 246983 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 38 Clipper St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft Permit Number 779954 6004884.234759999 2101078.02552 37.7494364577399 -122.42591323621201 (37.7494364577399, -122.425913236212)
1684 236727 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1616 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft Permit Number 779934 6002562.04117 2100731.79845 37.7483542900352 -122.43391868899201 (37.7483542900352, -122.433918688992)
1716 236992 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 300x Bennington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007066.0 2096791.0 37.7377883043483 -122.418064736265 (37.7377883043483, -122.418064736265)
1749 251678 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1841 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989656.0 2102823.0 37.7533553254519 -122.478699889248 (37.7533553254519, -122.478699889248)
1884 236583 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 607 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/10/1994 12:00:00 AM 5 Width 4ft Permit Number 779645 6009295.1552099995 2105340.17803 37.7613876608276 -122.41096109620001 (37.7613876608276, -122.4109610962)
1896 236582 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 607 Florida St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft Permit Number 779645 6009292.7773400005 2105398.5203400003 37.7615477221736 -122.410973441191 (37.7615477221736, -122.410973441191)
1998 135937 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 98 Spruce St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2017 12:00:00 AM 3 3x3 Permit Number 780098 5997052.02369 2116054.59656 37.7901125223289 -122.45407860247299 (37.7901125223289, -122.454078602473)
2000 237999 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 4302 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2012 12:00:00 AM 2 Width 4ft Permit Number 769743 6001218.46057 2101752.36044 37.7510801711245 -122.438637864349 (37.7510801711245, -122.438637864349)
2020 40822 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 695 05th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/26/1999 12:00:00 AM 3 3x3 Permit Number 41762 6013323.14167 2110435.9074 37.775604443222704 -122.39738724541901 (37.7756044432227, -122.397387245419)
2028 137540 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1510 Steiner St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6002670.5536 2113409.7602 37.7831710382055 -122.434449780345 (37.7831710382055, -122.434449780345)
2078 12419 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1691 Laguna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/11/1997 12:00:00 AM 3 4X4   6004453.7544 2114557.5752 37.786423711867705 -122.42836245915599 (37.7864237118677, -122.428362459156)
2102 196505 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3536 Jennings St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
2113 2684 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2100 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   6003399.8502 2114890.5748 37.787278352566105 -122.432032487909 (37.7872783525661, -122.432032487909)
2141 18982 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2920 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000616.67404 2115546.70514 37.7889217363036 -122.44170876675699 (37.7889217363036, -122.441708766757)
2150 196171 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 150 Loomis St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 Width 4ft   6010696.4368900005 2097532.57901 37.7400281875625 -122.405564708871 (37.7400281875625, -122.405564708871)
2155 235936 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 900 Hampshire St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 Width 3ft   6010180.29259 2103880.6842099996 37.7574298137383 -122.40779684417 (37.7574298137383, -122.40779684417)
2160 235935 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 900 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 Width 3ft   6010177.7603400005 2103903.055 37.7574910971521 -122.407807179156 (37.7574910971521, -122.407807179156)
2163 235934 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 900 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 Width 3ft   6010177.20863 2103930.96552 37.757567702297294 -122.407811055241 (37.7575677022973, -122.407811055241)
2174 113405 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2120 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006435.39008 2118126.47056 37.796334942346 -122.42176007795901 (37.796334942346, -122.421760077959)
2229 43306 DPW Maintained 3 Prunus caroliniana :: Carolina Cherry Laurel 133 693 Vermont St 12 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/12/2000 12:00:00 AM 22   Permit Number 43072 6011289.47877 2105149.93268 37.7609769197604 -122.404050137204 (37.7609769197604, -122.404050137204)
2396 135722 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2498X Pierce St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2420 135721 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2498X Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2424 239429 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 565 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM 5 Width 2ft Permit Number 51470 6001213.70363 2103034.08129 37.7545991976029 -122.438746149019 (37.7545991976029, -122.438746149019)
2427 23895 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1581 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/30/2006 12:00:00 AM 3 3X3   6003532.7108 2114115.4269999997 37.7851575236987 -122.431517459739 (37.7851575236987, -122.431517459739)
2489 119760 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2492 119762 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2501 119761 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2508 119759 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 101X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       4x4            
2513 138183 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003936.4381 2114774.6580000003 37.7869904804487 -122.43016773530199 (37.7869904804487, -122.430167735302)
2541 138182 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003933.6106 2114790.6807 37.7870343146011 -122.43017866131201 (37.7870343146011, -122.430178661312)
2544 138181 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003932.1968 2114801.9909 37.7870652894849 -122.43018435992599 (37.7870652894849, -122.430184359926)
2550 138186 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1865 Buchanan St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 Width 0ft   6003941.622 2114719.9923 37.786840675810396 -122.43014589889499 (37.7868406758104, -122.430145898895)
2555 138187 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1865 Buchanan St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/1998 12:00:00 AM 6 Width 0ft   6003949.1621 2114685.5907 37.7867466447295 -122.43011735683599 (37.7867466447295, -122.430117356836)
2581 107490 DPW Maintained 3 Prunus spp :: Cherry 84 1306x Montgomery St 19 Median : Cutout 11 Tree 1 DPW 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
2593 155952 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 35 Manor Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   07/20/2017 12:00:00 AM 3     5993448.18795 2093194.64055 37.7271377226027 -122.464886627823 (37.7271377226027, -122.464886627823)
2613 98090 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911)
2617 59596 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1401 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/21/2014 12:00:00 AM 0   Permit Number 770950 6000181.59670606 2113731.76941076 37.7839135947641 -122.443083674123 (37.7839135947641, -122.443083674123)
2636 239448 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 224 Miguel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM 11 Width 4ft Permit Number 38139 6004193.01737 2096717.47365 37.7374242967807 -122.427992792539 (37.7374242967807, -122.427992792539)
2651 253156 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 654 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 40826 6010070.0 2105228.0 37.7611230643779 -122.40827330718099 (37.7611230643779, -122.408273307181)

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