Street_Tree_List

Data source: data.sfgov.org

6,719 rows where qSpecies = 16

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
2835 236764 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 512 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/2005 12:00:00 AM 7 Width 2ft Permit Number 48087 6003424.25631 2095995.5606900002 37.735398565789 -122.43059925984801 (37.735398565789, -122.430599259848)
2949 32064 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 3650 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 6   Permit Number 35439 6004539.0 2106054.0 37.76307979631979 -122.427461511029 (37.7630797963198, -122.427461511029)
2993 141648 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1422 GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2004 12:00:00 AM 1 Width 0ft Permit Number 47297 6000944.4007 2110734.0282 37.7757260239796 -122.440229613929 (37.7757260239796, -122.440229613929)
3019 20034 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
3039 236868 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 101 Downey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5998866.62555 2107543.5611799997 37.7668472992937 -122.44718746183901 (37.7668472992937, -122.447187461839)
3165 214224 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 421 Congo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2002 12:00:00 AM 8 Width 2ft Permit Number 45666 6000080.90634 2095085.6574799998 37.7327102116098 -122.44209314151001 (37.7327102116098, -122.44209314151)
3169 213107 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 133 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/06/1988 12:00:00 AM 4 Width 3ft Permit Number 25333 5995889.82515 2096226.1637400002 37.7356020292943 -122.456665111108 (37.7356020292943, -122.456665111108)
3171 214225 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 421 Congo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2002 12:00:00 AM 7 Width 2ft Permit Number 45666 6000080.6032300005 2095071.0529599998 37.7326700937324 -122.44209314147899 (37.7326700937324, -122.442093141479)
3324 113956 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1441 Powell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/25/2016 12:00:00 AM 3 3x3   6009720.54591 2118583.26701 37.7977739007953 -122.410424973449 (37.7977739007953, -122.410424973449)
3446 245003 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1201 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6000711.7175 2109261.453 37.771669453199294 -122.440928858006 (37.7716694531993, -122.440928858006)
3472 47233 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 260 Holyoke St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM 9 3x3 Permit Number 45176 6009527.90676 2093167.0180900001 37.7279758826708 -122.40929702843701 (37.7279758826708, -122.409297028437)
3513 247938 Planning Code 138.1 required 4 Prunus cerasifera :: Cherry Plum 16 29 Joy St 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
3523 253474 Planning Code 138.1 required 4 Prunus cerasifera :: Cherry Plum 16 134 Lunado Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3541 253472 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 134 Lunado Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3548 253473 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 134 Lunado Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3592 236822 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 12 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/13/1988 12:00:00 AM 10 Width 3ft Permit Number 25632 5997059.6674 2106561.87629 37.764048431899205 -122.453366518365 (37.7640484318992, -122.453366518365)
3600 246903 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 491 Frederick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997265.5984 2107392.9739200003 37.7663422157406 -122.452714254467 (37.7663422157406, -122.452714254467)
3601 246904 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 491 Frederick St 2 Side Yard : Cutout 18 Tree 1 Private 1     6 Width 3ft   5997307.10356 2107397.6585 37.7663574565623 -122.452571034738 (37.7663574565623, -122.452571034738)
3644 196082 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 701 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6015721.57305 2103923.0720900004 37.7578548576382 -122.388635680008 (37.7578548576382, -122.388635680008)
3674 32468 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 120 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/15/2017 12:00:00 AM 3   Permit Number 36977 6000626.3294 2105651.6556 37.7617529834407 -122.44096521177099 (37.7617529834407, -122.440965211771)
3675 237732 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 4059 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001898.0 2105817.0 37.7622793253591 -122.436578855242 (37.7622793253591, -122.436578855242)
3712 196122 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 714 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/19/2017 12:00:00 AM 3 Width 3ft   6011517.6969 2105021.50044 37.7606370219096 -122.40325179104299 (37.7606370219096, -122.403251791043)
3951 20035 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
4158 253614 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1959x Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006418.0 2117595.0 37.794874677003605 -122.421782481899 (37.7948746770036, -122.421782481899)
4351 36746 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 5555 Woodward St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39516          
4486 235699 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 301 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004133.22198 2109878.38027 37.773557659984895 -122.42913766099 (37.7735576599849, -122.42913766099)
4558 142520 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4605 142542 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
4611 142519 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4622 142543 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4696 236340 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 60 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/16/1993 12:00:00 AM 11 Width 3ft Permit Number 31569 6005504.459869999 2099359.7250599996 37.7447534297269 -122.423646325024 (37.7447534297269, -122.423646325024)
4731 237544 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 25 Ford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 7x8   6003442.2831 2105633.6495 37.76186352451221 -122.43122467539801 (37.7618635245122, -122.431224675398)
5189 50319 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 207 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/09/2017 12:00:00 AM 3   Permit Number 780459 5994858.57459 2113511.06459 37.7830026560888 -122.461483229537 (37.7830026560888, -122.461483229537)
5249 243309 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 780 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   6007491.9091300005 2105126.68883 37.760700186689796 -122.41718265916799 (37.7607001866898, -122.417182659168)
5254 253839 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 94 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6006239.0 2097690.0 37.740210176126794 -122.42098789234 (37.7402101761268, -122.42098789234)
5302 35167 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 240 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/1998 12:00:00 AM     Permit Number 38700          
5336 2470 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1875 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/18/1998 12:00:00 AM 7 5x5   6003922.7717 2114866.5529 37.787242026635 -122.43022157640499 (37.787242026635, -122.430221576405)
5717 115706 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 3055 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   5999536.24333 2116655.51656 37.7919046220513 -122.445526661347 (37.7919046220513, -122.445526661347)
5746 31847 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
5916 12892 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 255X Larch St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/1990 12:00:00 AM 3 3X3   6006398.20739 2113019.98592 37.7823117048675 -122.421525889114 (37.7823117048675, -122.421525889114)
5965 32283 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2242 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/2011 12:00:00 AM 8 3x3 Permit Number 768378 6002362.300419999 2115970.86289 37.7901856704892 -122.435699503149 (37.7901856704892, -122.435699503149)
6090 105252 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1875 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 770851 6004061.8803 2118683.0933 37.7977291534815 -122.43001264475201 (37.7977291534815, -122.430012644752)
6107 110275 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2612 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2016 12:00:00 AM 3   Permit Number 778382 6001183.56283 2117454.33561 37.794191876798 -122.43988424377 (37.794191876798, -122.43988424377)
6439 2463 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1826 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/23/1997 12:00:00 AM 3 4X4   6003987.7732 2114755.2881 37.7869402029829 -122.429988745219 (37.7869402029829, -122.429988745219)
6513 2467 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1848 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/13/1989 12:00:00 AM 12 4X4   6003976.525 2114838.4 37.7871677703016 -122.430033592456 (37.7871677703016, -122.430033592456)
6599 2653 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1971 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/18/1992 12:00:00 AM 3 4X4   6004104.0049 2114930.2605 37.78742721503939 -122.42959909363199 (37.7874272150394, -122.429599093632)
6845 88234 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 301 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM 5 3x3 Permit Number 51223 6000216.1332 2109974.0504 37.77359782768 -122.442694284612 (37.77359782768, -122.442694284612)
6855 30870 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1922 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/02/2013 12:00:00 AM 22 3x3 Permit Number 770521 6001989.3306 2115172.0478 37.787971137606895 -122.436932736614 (37.7879711376069, -122.436932736614)

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