sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
107509 87402   16 1300 Webster St 7 11 1 2   04/21/2008 12:00:00 AM 3 3x3   6003725.160049 2113179.0694110002 37.7825974263114 -122.430784800607 (37.7825974263114, -122.430784800607)
122843 85018   16 455 Valley St 1 1 1 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 1 16 4200 23rd St 1 1 1 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 1 16 639 Divisadero St 1 1 1 1   11/28/2006 12:00:00 AM 3 3X3   6001577.9698 2110674.4978 37.7755986195101 -122.438033679217 (37.7755986195101, -122.438033679217)
401 235987 1 16 1118 Church St 1 1 1 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 1 16 130 Beulah St 1 1 1 1     9 Width 0ft Permit Number 779787 5997458.097999999 2107812.3026 37.767504613553 -122.45207869525 (37.767504613553, -122.45207869525)
585 236679 1 16 682 Clipper St 1 1 1 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 1 16 377 San Benito Way 1 1 1 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 1 16 384 San Benito Way 1 1 1 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 1 16 384 San Benito Way 2 1 1 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 1 16 255X Larch St 4 1 1 1   02/02/1990 12:00:00 AM 3 3X3   6006443.29256 2113021.2667 37.7823177635948 -122.421370005133 (37.7823177635948, -122.421370005133)
1001 238568 1 16 1300 Noe St 1 2 1 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 1 16 255X Larch St 1 1 1 1   03/25/2005 12:00:00 AM 3 3X3   6006369.20019 2113010.28335 37.7822834283719 -122.421625551994 (37.7822834283719, -122.421625551994)
1186 244032 1 16 501X Shrader St 4 1 1 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 1 16 501X Shrader St 1 1 1 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 1 16 501X Shrader St 2 1 1 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 1 16 501X Shrader St 5 1 1 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 1 16 501X Shrader St 3 1 1 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 1 16 2147 12th Ave 1 1 1 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 1 16 607 Florida St 1 1 1 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 1 16 695 05th St 3 1 1 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 1 16 1691 Laguna St 3 1 1 1   06/11/1997 12:00:00 AM 3 4X4   6004453.7544 2114557.5752 37.786423711867705 -122.42836245915599 (37.7864237118677, -122.428362459156)
2113 2684 1 16 2100 Bush St 2 1 1 1     8 3X3   6003399.8502 2114890.5748 37.787278352566105 -122.432032487909 (37.7872783525661, -122.432032487909)
2651 253156 1 16 654 Hampshire St 1 1 1 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 1 16 512 Chenery St 1 1 1 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 1 16 3650 17th St 1 1 1 1 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 1 16 1422 GROVE ST 2 1 1 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 1 16 421 Congo St 1 1 1 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 1 16 133 Cresta Vista Dr 1 1 1 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 1 16 421 Congo St 2 1 1 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 1 16 260 Holyoke St 1 1 1 1 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 1 16 12 Woodland Ave 1 1 1 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 1 16 491 Frederick St 1 1 1 1     6 Width 3ft   5997265.5984 2107392.9739200003 37.7663422157406 -122.452714254467 (37.7663422157406, -122.452714254467)
3601 246904 1 16 491 Frederick St 2 18 1 1     6 Width 3ft   5997307.10356 2107397.6585 37.7663574565623 -122.452571034738 (37.7663574565623, -122.452571034738)
3674 32468 1 16 120 Corbett Ave 1 1 1 1 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 1 16 5555 Woodward St 1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39516          
4696 236340 1 16 60 Valley St 1 1 1 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 1 16 207 Clement St 1 1 1 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 1 16 240 Walter St 1 1 1 1   02/02/1998 12:00:00 AM     Permit Number 38700          
5336 2470 1 16 1875 Buchanan St 2 1 1 1   02/18/1998 12:00:00 AM 7 5x5   6003922.7717 2114866.5529 37.787242026635 -122.43022157640499 (37.787242026635, -122.430221576405)
5746 31847 1 16   2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
5916 12892 1 16 255X Larch St 2 1 1 1   02/02/1990 12:00:00 AM 3 3X3   6006398.20739 2113019.98592 37.7823117048675 -122.421525889114 (37.7823117048675, -122.421525889114)
5965 32283 1 16 2242 Steiner St 1 1 1 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 1 16 1875 Union St 2 1 1 1         Permit Number 770851 6004061.8803 2118683.0933 37.7977291534815 -122.43001264475201 (37.7977291534815, -122.430012644752)
6107 110275 1 16 2612 Scott St 2 1 1 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 1 16 1848 Buchanan St 1 1 1 1   09/13/1989 12:00:00 AM 12 4X4   6003976.525 2114838.4 37.7871677703016 -122.430033592456 (37.7871677703016, -122.430033592456)
6599 2653 1 16 1971 Bush St 1 1 1 1   08/18/1992 12:00:00 AM 3 4X4   6004104.0049 2114930.2605 37.78742721503939 -122.42959909363199 (37.7874272150394, -122.429599093632)
6845 88234 1 16 301 Lyon St 2 1 1 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 1 16 1922 Pierce St 1 1 1 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 1 16 1875 Buchanan St 1 1 1 1   02/18/1998 12:00:00 AM 7 5x5   6003922.3005 2114887.2882 37.7872989338532 -122.43022468652201 (37.7872989338532, -122.430224686522)
6904 12893 1 16 255X Larch St 3 1 1 1   02/02/1990 12:00:00 AM 3 3X3   6006421.0816 2113018.78056 37.7823096849762 -122.421446668727 (37.7823096849762, -122.421446668727)
7194 106948 1 16 2710 Baker St 3 1 1 1   07/02/2014 12:00:00 AM 1 3x3   5999606.41459 2118186.75395 37.7961130004661 -122.445394018543 (37.7961130004661, -122.445394018543)
7293 31848 1 16   3 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7538 2644 1 16 1911 Bush St 2 1 1 1     6 4X4   6004293.9749 2114957.7562 37.787513465908496 -122.42894379742201 (37.7875134659085, -122.428943797422)
7584 38094 1 16 2624 Sutter St 1 1 1 1 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 1 16 1911 Bush St 1 1 1 1     6 4X4   6004268.353999999 2114955.8815 37.7875068682146 -122.429032306872 (37.7875068682146, -122.429032306872)
7637 36881 1 16 2515 Fillmore St 1 1 1 1 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 1 16 3600 Washington St 2 1 1 1     5 6x7   5997488.7199800005 2115765.45327 37.7893436424566 -122.452546800688 (37.7893436424566, -122.452546800688)
8086 106947 1 16 2710 Baker St 2 1 1 1   07/02/2014 12:00:00 AM 1 3x3   5999608.44981 2118168.47191 37.796062919022205 -122.445385661119 (37.7960629190222, -122.445385661119)
8099 2468 1 16 1860 Buchanan St 1 1 1 1   06/11/1997 12:00:00 AM 3 4X4   6003974.6503 2114875.8941 37.787270613481205 -122.430042754186 (37.7872706134812, -122.430042754186)
8129 57513 1 16 1534 Baker St 1 1 1 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 1 16 2612 Scott St 1 1 1 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 1 16 1928 Pierce St 1 1 1 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 1 16   1 1 1 1   04/25/2002 12:00:00 AM     Permit Number 44926          
9777 88104 1 16 1247 46th Ave   1 1 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 1 16 124 Corbett Ave 1 1 1 1 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 1 16 774 Capp St 1 1 1 1 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 1 16 263 29th St 2 1 1 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 1 16 263 29th St 1 1 1 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 1 16 263 29th St 3 1 1 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 1 16 1501 Missouri St 1 1 1 1   07/12/2000 12:00:00 AM     Permit Number 43066          
11218 68392 1 16 240 Cotter St 1 1 1 1 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 1 16 717 Silver Ave 2 1 1 1     6 2X3   6006103.20931 2093594.9436599999 37.728958403708894 -122.42116669629699 (37.7289584037089, -122.421166696297)
11578 27091 1 16 717 Silver Ave 1 1 1 1     6 2X3   6006120.2550800005 2093595.10299 37.7289598021321 -122.42110777902398 (37.7289598021321, -122.421107779024)
11708 27702 1 16 1140 Silver Ave 1 1 1 1   09/26/2000 12:00:00 AM 6 2X3   6008343.29575 2093842.41085 37.729763925549506 -122.41344002075701 (37.7297639255495, -122.413440020757)
11795 31846 1 16   1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
11987 50020 1 16 1208 Bowdoin St 1 1 1 1 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 1 16 532 Silver Ave 1 1 1 1     6 3X3   6004762.815690001 2093485.8585299999 37.7285832245248 -122.42579277741001 (37.7285832245248, -122.42579277741)
12530 51006 1 16 1262 29th Ave 1 1 1 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 1 16 247 Theresa St 1 1 1 1 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 1 16 1518 33rd Ave 1 1 1 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 1 16 715 Amazon Ave 1 1 1 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 1 16   2 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
13393 39264 1 16 540 Delancey St 3 1 1 1 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 1 16 1625 Oakdale Ave 1 1 1 1     12 3X3   6014811.10476 2095618.3620200001 37.7350013613099 -122.391203993568 (37.7350013613099, -122.391203993568)
13630 49513 1 16 1648@3rd ST Shafter Ave 1 1 1 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 1 16 2022 Palou Ave 1 1 1 1     6 3X3   6012632.03621 2096963.3752099997 37.7385733165067 -122.398832221241 (37.7385733165067, -122.398832221241)
14764 31856 1 16 44 Langton St 1 1 1 1 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 1 16   1 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14998 44032 1 16 96 Lafayette St 3 1 1 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 1 16 540 Delancey St 2 1 1 1 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 1 16 20 Ringold St 1 1 1 1 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 1 16 1243 19th St 2 1 1 1     5 3x3   6013843.6616400005 2105220.96082 37.7613143247043 -122.39522124448798 (37.7613143247043, -122.395221244488)
16626 39265 1 16 540 Delancey St 1 1 1 1 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 1 16 1773 Oakdale Ave 1 1 1 1   04/22/1997 12:00:00 AM 3 3X3   6014137.90687 2096120.20835 37.7363419456235 -122.39356660700899 (37.7363419456235, -122.393566607009)
16872 42242 1 16 546x Natoma St 1 1 1 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 1 16 85 Mullen Ave 1 1 1 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 1 16 237 Edna St 1 1 1 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 1 16 2922 Diamond St 1 1 1 1   04/26/2011 12:00:00 AM 3 3x3   6002319.208819999 2095185.9682200002 37.7331129460068 -122.43436195314399 (37.7331129460068, -122.434361953144)
17729 10111 1 16 817 Guerrero St 1 1 1 1     6 2x2   6005691.67507 2104204.22323 37.758065870971706 -122.423343289458 (37.7580658709717, -122.423343289458)
17839 45141 1 16 1300 Page St 1 1 1 1 1 05/18/2001 12:00:00 AM     Permit Number 43998 6000329.1714268 2109256.8846269 37.7716351145449 -122.442251776367 (37.7716351145449, -122.442251776367)
Powered by Datasette · Query took 20.342ms · Data source: data.sfgov.org