Street_Tree_List

Data source: data.sfgov.org

6,719 rows where qSpecies = 16 sorted by qLegalStatus

View and edit SQL

Suggested facets: qCareAssistant

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
107509 87402   Prunus cerasifera :: Cherry Plum 16 1300 Webster St 7 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 3x3   6003725.160049 2113179.0694110002 37.7825974263114 -122.430784800607 (37.7825974263114, -122.430784800607)
122843 85018   Prunus cerasifera :: Cherry Plum 16 455 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2007 12:00:00 AM     Permit Number 49374 6002971.0 2099180.0 37.744116613623 -122.43239370297701 (37.744116613623, -122.432393702977)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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          
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)
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)
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)
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)
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)
6896 2469 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1875 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/18/1998 12:00:00 AM 7 5x5   6003922.3005 2114887.2882 37.7872989338532 -122.43022468652201 (37.7872989338532, -122.430224686522)
6904 12893 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 255X Larch St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/1990 12:00:00 AM 3 3X3   6006421.0816 2113018.78056 37.7823096849762 -122.421446668727 (37.7823096849762, -122.421446668727)
7194 106948 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2710 Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2014 12:00:00 AM 1 3x3   5999606.41459 2118186.75395 37.7961130004661 -122.445394018543 (37.7961130004661, -122.445394018543)
7293 31848 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7538 2644 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1911 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6004293.9749 2114957.7562 37.787513465908496 -122.42894379742201 (37.7875134659085, -122.428943797422)
7584 38094 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2624 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM 6   Permit Number 778879 5999853.7645 2114048.6642 37.7847650081627 -122.444240628643 (37.7847650081627, -122.444240628643)
7618 2643 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1911 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6004268.353999999 2114955.8815 37.7875068682146 -122.429032306872 (37.7875068682146, -122.429032306872)
7637 36881 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2515 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/23/2016 12:00:00 AM 3   Permit Number 779178 6002658.18112 2116991.83839 37.7930058086339 -122.434748819925 (37.7930058086339, -122.434748819925)
7944 114576 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 3600 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 6x7   5997488.7199800005 2115765.45327 37.7893436424566 -122.452546800688 (37.7893436424566, -122.452546800688)
8086 106947 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2710 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2014 12:00:00 AM 1 3x3   5999608.44981 2118168.47191 37.796062919022205 -122.445385661119 (37.7960629190222, -122.445385661119)
8099 2468 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1860 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/11/1997 12:00:00 AM 3 4X4   6003974.6503 2114875.8941 37.787270613481205 -122.430042754186 (37.7872706134812, -122.430042754186)
8129 57513 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1534 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/1976 12:00:00 AM 20 3x3 Permit Number 16366 6000152.6691 2114258.7858 37.7853589960394 -122.443221617032 (37.7853589960394, -122.443221617032)
8328 49474 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2612 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/2003 12:00:00 AM 3   Permit Number 778382 6001188.38101 2117426.72551 37.7941163409457 -122.43986559183399 (37.7941163409457, -122.439865591834)
8644 34950 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1928 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/1997 12:00:00 AM 8 3x3 Permit Number 38548 6001980.6841 2115210.0928 37.7880751079735 -122.43696537665501 (37.7880751079735, -122.436965376655)
9510 46857 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2002 12:00:00 AM     Permit Number 44926          
9777 88104 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1247 46th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   4x10 Permit Number 51108 5981754.7 2106590.8 37.763238693975296 -122.50630313344999 (37.7632386939753, -122.50630313345)
9798 32469 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 124 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2016 12:00:00 AM 3   Permit Number 779287 6000593.0 2105649.0 37.7617437934708 -122.441080293978 (37.7617437934708, -122.441080293978)
9952 39131 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 774 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1998 12:00:00 AM   2.5x3 Permit Number 40811 6007313.40469967 2102804.1822591 37.7543130741871 -122.417635411147 (37.7543130741871, -122.417635411147)
10051 122896 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 263 29th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2017 12:00:00 AM 3   Permit Number 779289 6004832.0 2098951.0 37.7435931826557 -122.42594247475901 (37.7435931826557, -122.425942474759)
10053 62845 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 263 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2017 12:00:00 AM 3   Permit Number 779289 6004872.17430855 2098981.93904651 37.7436804045703 -122.425805763528 (37.7436804045703, -122.425805763528)
10056 122897 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 263 29th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2017 12:00:00 AM 3   Permit Number 779289 6004872.17430855 2098981.93904651 37.7436804045703 -122.425805763528 (37.7436804045703, -122.425805763528)
10952 43297 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1501 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2000 12:00:00 AM     Permit Number 43066          
11218 68392 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 240 Cotter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/12/2016 12:00:00 AM 3 3x3 Permit Number 779249 6001623.41455 2093933.0441299998 37.7296331848184 -122.43667784142099 (37.7296331848184, -122.436677841421)
11228 27092 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 717 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   6006103.20931 2093594.9436599999 37.728958403708894 -122.42116669629699 (37.7289584037089, -122.421166696297)
11578 27091 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 717 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   6006120.2550800005 2093595.10299 37.7289598021321 -122.42110777902398 (37.7289598021321, -122.421107779024)
11708 27702 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1140 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/26/2000 12:00:00 AM 6 2X3   6008343.29575 2093842.41085 37.729763925549506 -122.41344002075701 (37.7297639255495, -122.413440020757)
11795 31846 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
11987 50020 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1208 Bowdoin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM 4 2.5x4 Permit Number 46754 6009698.1958800005 2090561.7050599998 37.7208317780481 -122.408524628629 (37.7208317780481, -122.408524628629)
12256 26978 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 532 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6004762.815690001 2093485.8585299999 37.7285832245248 -122.42579277741001 (37.7285832245248, -122.42579277741)
12530 51006 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1262 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2004 12:00:00 AM 3 3x3 Permit Number 770221 5987105.8451 2106709.4716 37.7638781152555 -122.48780425862302 (37.7638781152555, -122.487804258623)
12580 108559 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 247 Theresa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773718 6001785.96966 2094072.85918 37.7300263216596 -122.43612587350701 (37.7300263216596, -122.436125873507)
12968 35485 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1518 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/1998 12:00:00 AM 5 3x3 Permit Number 38896 5985922.1706 2104864.8854 37.7587442786876 -122.49176237341999 (37.7587442786876, -122.49176237342)
13011 121633 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 715 Amazon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2017 12:00:00 AM 3 3x3 Permit Number 778948 6002248.64047 2088586.4317299998 37.7149880967002 -122.43413431136001 (37.7149880967002, -122.43413431136)
13223 33083 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
13393 39264 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 540 Delancey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM 8 3x3 Permit Number 41406 6015215.52427 2113624.4278599997 37.7844645829043 -122.39106388910601 (37.7844645829043, -122.391063889106)
13588 26008 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1625 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6014811.10476 2095618.3620200001 37.7350013613099 -122.391203993568 (37.7350013613099, -122.391203993568)
13630 49513 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1648@3rd ST Shafter Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/2003 12:00:00 AM     Permit Number 46418 6014785.81315318 2094304.60337815 37.731392643231295 -122.391199634158 (37.7313926432313, -122.391199634158)
14318 17462 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2022 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6012632.03621 2096963.3752099997 37.7385733165067 -122.398832221241 (37.7385733165067, -122.398832221241)
14764 31856 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 44 Langton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1995 12:00:00 AM 8 3x3 Permit Number 35302 6009920.26283 2110981.2883599997 37.7769118830094 -122.40919717941401 (37.7769118830094, -122.409197179414)
14881 33084 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14998 44032 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 96 Lafayette St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/06/2014 12:00:00 AM 1 3x3 Permit Number 43568 6007703.80848 2109483.89132 37.7726759646606 -122.41675848404199 (37.7726759646606, -122.416758484042)
15282 39266 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 540 Delancey St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM 8 3x3 Permit Number 41406 6015200.60575 2113640.87265 37.784508908704 -122.39111665233101 (37.784508908704, -122.391116652331)
15400 51397 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 20 Ringold St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/13/2004 12:00:00 AM 5 2x3 Permit Number 47723 6009698.00166 2110029.82687 37.77428693821211 -122.409898870931 (37.7742869382121, -122.409898870931)
15502 119264 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1243 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6013843.6616400005 2105220.96082 37.7613143247043 -122.39522124448798 (37.7613143247043, -122.395221244488)
16626 39265 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 540 Delancey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM 8 3x3 Permit Number 41406 6015189.334319999 2113651.1602 37.78453653049 -122.391156367288 (37.78453653049, -122.391156367288)
16805 25996 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1773 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/22/1997 12:00:00 AM 3 3X3   6014137.90687 2096120.20835 37.7363419456235 -122.39356660700899 (37.7363419456235, -122.393566607009)
16872 42242 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 546x Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM 6 2x2 Permit Number 42491 6010065.33098 2111880.30804 37.779388506222 -122.408758782403 (37.779388506222, -122.408758782403)
17119 32210 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 85 Mullen Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/28/2016 12:00:00 AM 3 3x6 Permit Number 778854 6009682.7318 2099892.2355400003 37.746450553849705 -122.40923616951599 (37.7464505538497, -122.409236169516)
17368 31107 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 237 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/1995 12:00:00 AM 12 2x9 Permit Number 34836 5998741.10559 2093696.6729599999 37.7288199422639 -122.44662524706101 (37.7288199422639, -122.446625247061)
17693 5140 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2922 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2011 12:00:00 AM 3 3x3   6002319.208819999 2095185.9682200002 37.7331129460068 -122.43436195314399 (37.7331129460068, -122.434361953144)
17729 10111 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 817 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2x2   6005691.67507 2104204.22323 37.758065870971706 -122.423343289458 (37.7580658709717, -122.423343289458)

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