sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1607 251602 6 108 44R Amber Dr 1 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1608 251603 6 47 44R Amber Dr 2 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 6 47 8R Amethyst Way 2 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 251605 6 108 48R Amber Dr 2 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 6 3 52R Amber Dr 2 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1618 251611 2 47 56R Amber Dr 4 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1619 251617 2 47 64R Amber Dr 4 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
1623 251613 6 47 60R Amber Dr 2 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1624 251624 2 47 76R Amber Dr 2 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1625 251623 2 47 76R Amber Dr 1 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1626 251635 2 47 18R Amethyst Way 1 13 1 1           5999176.0 2100050.0 37.746289501198795 -122.445578473632 (37.7462895011988, -122.445578473632)
1628 251629 6 47 8R Amethyst Way 1 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1629 251631 6 47 8R Amethyst Way 3 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1631 251621 6 47 72R Amber Dr 4 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1632 251628 6 47 2R Amethyst Way 3 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1637 251619 6 47 72R Amber Dr 2 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1638 251620 2 47 72R Amber Dr 3 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1639 251615 2 47 64R Amber Dr 2 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1640 251622 2 47 72R Amber Dr 5 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1641 251627 2 47 2R Amethyst Way 2 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1643 251614 2 47 64R Amber Dr 1 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1645 251626 6 47 2R Amethyst Way 1 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1646 251633 6 47 14R Amethyst Way 2 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1648 251606 6 3 52R Amber Dr 1 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1650 251608 6 47 56R Amber Dr 1 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1651 251609 6 47 56R Amber Dr 2 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1652 251618 2 47 72R Amber Dr 1 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1654 251610 6 47 56R Amber Dr 3 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1703 29682 3 11 1900X Van Ness Ave 5 11 1 2     3     6006057.50051 2117137.8264200003 37.7935990572132 -122.422997353566 (37.7935990572132, -122.422997353566)
1765 45968 1 17   155 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1796 29783 3 11 2000X Van Ness Ave 4 11 1 2   04/18/2008 12:00:00 AM 3     6006016.33701 2117432.70817 37.794406405577 -122.423160753176 (37.794406405577, -122.423160753176)
1804 44554 1 17   41 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
1817 251719 6 116 1301 Clayton St 1 17 1 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
1820 251716 6 47 3929 19th St 1 7 1 1           6003450.0 2104734.0 37.75939373993371 -122.431133769968 (37.7593937399337, -122.431133769968)
1822 251717 3 47 1000X San Jose Ave 1 7 1 2           6004710.0 2096486.0 37.736817957153605 -122.426188866367 (37.7368179571536, -122.426188866367)
1826 31896 1 106 1525 Houston St 1 1 1 1   06/26/1995 12:00:00 AM     Permit Number 35325          
1828 35192 1 12   12 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1846 251738 1 108 859 Prague St 14 1 1 1 1         6002345.06488 2087027.78932 37.7107138789231 -122.433689697349 (37.7107138789231, -122.433689697349)
1854 58389 1 41 1364 Filbert St 1 1 1 1   01/25/2016 12:00:00 AM 3   Permit Number 776620 6006427.83864 2119405.514 37.799846446913705 -122.42187710853999 (37.7998464469137, -122.42187710854)
1863 33121 1 17 2360 Greenwich St 1 1 1 1 1 06/08/2017 12:00:00 AM 3   Permit Number 780047 6001597.15977 2119079.49 37.7986776600995 -122.438569654391 (37.7986776600995, -122.438569654391)
1869 35202 1 12   1 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1885 30481 1 17   1 1 1 1   09/05/1956 12:00:00 AM     Permit Number 147          
1928 252837 7 114 98 Prosper St 5 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1929 252833 7 114 98 Prosper St 1 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1930 252828 6 161 3852 17th St 7 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1932 252826 6 75 3852 17th St 5 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1933 252830 6 75 3852 17th St 9 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1935 252836 6 114 98 Prosper St 4 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1936 252824 6 75 3852 17th St 3 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1938 252827 6 75 3852 17th St 6 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1939 252822 6 114 3852 17th St 1 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1947 252825 6 163 3852 17th St 4 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1948 252834 7 114 98 Prosper St 2 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1950 252823 6 22 3852 17th St 2 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1955 252835 7 114 98 Prosper St 3 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1956 252838 6 114 99 Pond St 1 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1957 252829 6 161 3852 17th St 8 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1959 48104 1 17   213 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1973 66343 1 17   1 1 1 1   12/10/1990 12:00:00 AM     Permit Number 29464          
1977 35358 1 50 861 Rhode Island St 1 1 1 1 1 06/14/2017 12:00:00 AM 3   Permit Number 779956 6011891.4551800005 2104381.4501400003 37.758900452609794 -122.401914128638 (37.7589004526098, -122.401914128638)
1981 35702 1 85   15 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
1994 42166 1 28 354 05th St 5 1 1 1   06/21/2000 12:00:00 AM 4   Permit Number 779305 6011846.02554 2111882.36991 37.77949374398221 -122.402598720465 (37.7794937439822, -122.402598720465)
2014 42165 1 28 354 05th St 4 1 1 1   06/21/2000 12:00:00 AM 4   Permit Number 779305 6011856.41574 2111871.95313 37.7794657219919 -122.40256204342501 (37.7794657219919, -122.402562043425)
2019 48201 1 17   44 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
2023 35053 1 17 700 Peninsula Ave 6 1 1 1   01/22/1998 12:00:00 AM     Permit Number 38613          
2039 45572 1 17 1951 Lyon St 1 1 1 1 1 06/19/2017 12:00:00 AM 3   Permit Number 779446 5999433.18152 2115607.6653299998 37.7890216140951 -122.44580786133999 (37.7890216140951, -122.44580786134)
2080 34119 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37980          
2086 45988 1 17   223 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
2115 44893 1 17   127 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2135 57208 1 7 2238 Divisadero St 1 1 1 1   03/26/2015 12:00:00 AM 3   Permit Number 775007 6000879.71894 2116143.1485 37.7905743988346 -122.440841472269 (37.7905743988346, -122.440841472269)
2153 251201 2 2 2000X Market St 1 5 1 1   06/27/2017 12:00:00 AM 3   Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2154 45014 1 17   86 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2166 43082 1 171 205 Jones St 1 1 1 1 1 08/28/2003 12:00:00 AM 21   Permit Number 46999 6009001.971030001 2113315.3872700003 37.783269275104104 -122.412538876675 (37.7832692751041, -122.412538876675)
2168 118346 3 109 100X Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 3              
2171 43085 1 171 240 Jones St 6 1 1 1 1 07/07/2000 12:00:00 AM 15   Permit Number 42924 6009019.84513 2113517.34513 37.7838248061099 -122.412491319636 (37.7838248061099, -122.412491319636)
2172 43089 1 171 240 Jones St 3 1 1 1 1 07/07/2000 12:00:00 AM 15   Permit Number 42924 6009028.16004 2113458.59755 37.783663965959995 -122.41245839903999 (37.78366396596, -122.41245839904)
2176 103962 1 21 3240 Pacific Ave 2 1 1 1   06/28/2017 12:00:00 AM 3   Permit Number 780028 5998623.05948 2116578.56663 37.7916411629484 -122.448680722253 (37.7916411629484, -122.448680722253)
2177 43088 1 171 240 Jones St 2 1 1 1 1 07/07/2000 12:00:00 AM 14   Permit Number 42924 6009031.2139800005 2113438.72212 37.7836095641737 -122.412446428164 (37.7836095641737, -122.412446428164)
2179 252925 3 71 700 Sanchez St 2 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2182 50728 1 125 3101 Washington St 2 1 1 1   06/28/2017 12:00:00 AM 3   Permit Number 780126 5999807.59177 2116040.97714 37.790232745492894 -122.444543610603 (37.7902327454929, -122.444543610603)
2185 43087 1 171 240 Jones St 5 1 1 1 1 07/07/2000 12:00:00 AM 16   Permit Number 42924 6009022.06951 2113499.20947 37.7837751347655 -122.41248234170601 (37.7837751347655, -122.412482341706)
2186 252924 3 47 700 Sanchez St 1 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2193 46043 1 17   174 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
2195 44993 1 17   105 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
2216 122752 3 94 693 Vermont St 6 1 1 4 2   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066)
2219 122754 3 55 693 Vermont St 4 1 1 4 2   16     6011277.363419999 2105334.1858 37.761482160689894 -122.404105006665 (37.7614821606899, -122.404105006665)
2223 43305 3 94 693 Vermont St 10 1 1 4 2 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601)
2226 61613 1 142 1546 Polk St 1 1 1 1 1 08/12/1995 12:00:00 AM 17   Permit Number 21590 6006691.8914 2116275.8765 37.7912681342545 -122.42074108486 (37.7912681342545, -122.42074108486)
2229 43306 3 133 693 Vermont St 12 1 1 4 2 07/12/2000 12:00:00 AM 22   Permit Number 43072 6011289.47877 2105149.93268 37.7609769197604 -122.404050137204 (37.7609769197604, -122.404050137204)
2231 122750 3 94 693 Vermont St 8 1 1 4 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
2232 122753 3 13 693 Vermont St 5 1 1 4 2   15     6011277.810190001 2105311.62173 37.7614202297665 -122.404101873421 (37.7614202297665, -122.404101873421)
2233 122749 3 94 693 Vermont St 9 1 1 4 2   5     6011285.506709999 2105214.92948 37.761155164510605 -122.404068449214 (37.7611551645106, -122.404068449214)
2240 122755 3 55 693 Vermont St 3 1 1 4 2   14     6011274.22678 2105356.76628 37.7615439863765 -122.40411744427601 (37.7615439863765, -122.404117444276)
2266 253000 1 73 1201 Tennessee St 9 1 1 1   07/10/2017 12:00:00 AM 3     6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
2272 253002 1 73 1201 Tennessee St 11 1 1 1   07/10/2017 12:00:00 AM 3     6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
Powered by Datasette · Query took 116.196ms · Data source: data.sfgov.org