sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
86 119601 6 34 4357x Mission St 3 7 1 1         Permit Number 774415          
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
114 251216 6 1 399X Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 6 1 399X Townsend St 2 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
1025 251425 6 128 5016 Diamond Heights Blvd 2 9 1 1           5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1030 251424 6 47 5016 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1337 251410 6 21 2777 Pine St 1 8 1 1       3x3 Permit Number 779015 6000658.0 2114782.0 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
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)
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)
1623 251613 6 47 60R Amber Dr 2 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
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)
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)
1654 251610 6 47 56R Amber Dr 3 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1674 251651 6 52 3237 Harrison St 1 1 1 1       3x3   6009049.0 2099828.0 37.746238652288106 -122.411423013741 (37.7462386522881, -122.411423013741)
1693 251659 6 41 1050 North Point St 3 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1702 251658 6 41 1050 North Point St 2 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1708 251660 6 3 1050 North Point St 4 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1710 251657 6 3 1050 North Point St 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1717 251661 6 41 3200X Van Ness Ave 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
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)
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)
1947 252825 6 163 3852 17th St 4 7 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)
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)
2059 173596 6 17 200 Howard St 1 9 1 1       3x3 Permit Number 779179 6014439.0 2115766.0 37.790301726009204 -122.393900378517 (37.7903017260092, -122.393900378517)
2151 252916 6 47 101 Gold Mine Dr 1 1 1 1       3x3   6001472.0 2098865.0 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716)
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
2610 253145 6 26 801X Santiago St 1 17 1 1           5990274.0 2099728.0 37.7448931297685 -122.47633667765699 (37.7448931297685, -122.476336677657)
2691 253165 6 180 1451 Bay St 3 7 1 1       3x3   6003691.0 2120547.0 37.802825946660796 -122.431429119577 (37.8028259466608, -122.431429119577)
2712 253178 6 189 4450 24th St 2 8 1 1       Width 0ft   6000289.52403 2101701.02913 37.7508863393389 -122.441846529398 (37.7508863393389, -122.441846529398)
2734 253182 6 143 5157 Diamond Heights Blvd 1 7 1 1           6000788.0 2100195.0 37.7467795353698 -122.44001478039101 (37.7467795353698, -122.440014780391)
2736 253183 6 143 5159 Diamond Heights Blvd 1 7 1 1           6000808.0 2099903.0 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335)
2848 253255 6 47 270 Castenada Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2859 253251 6 3 99X Lopez Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 6 3 99X Lopez Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 6 3 99X Lopez Ave 3 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3037 253283 6 44 673 San Jose Ave 1 1 1 1       3x3   6005929.0 2099335.0 37.7447094953859 -122.422176588207 (37.7447094953859, -122.422176588207)
3138 253254 6 3 270 Castenada Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3204 253366 6 201 20 Laussat St 1 1 1 1       3x3   6004582.0 2109434.0 37.772362894278395 -122.427553605007 (37.7723628942784, -122.427553605007)
3256 253373 6 44 78 Peralta Ave 1 7 1 1       3x3   6010457.0 2100357.0 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174)
3283 253384 6 203 55 Cerritos Ave 1 7 1 1       10x10   5992588.0 2092941.0 37.7263916542788 -122.46784182223999 (37.7263916542788, -122.46784182224)
3361 253428 6 47 3 Valletta Ct 1 18 1 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
3534 253482 6 19 2179 41st Ave 1 7 1 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
3549 253470 6 19 3 Valletta Ct 2 18 1 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
3557 253471 6 212 17 Valletta Ct 1 18 1 1       6x10   5999337.0 2096545.0 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358)
3662 253513 6 216 1545 05th Ave 1 7 1 1   08/14/2012 12:00:00 AM   3x3 Permit Number 768941 5994803.920580001 2105050.88998 37.7597700982665 -122.461058902115 (37.7597700982665, -122.461058902115)
3843 253568 6 103 301X Sargent St 1 8 1 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
4182 253620 6 142 1120 South Van Ness Ave 3 8 1 1       Width 3ft   6007603.98274 2103104.1444200003 37.755153048679205 -122.41665176419201 (37.7551530486792, -122.416651764192)
4283 253621 6 143 200x Montcalm St 1 13 1 1       3x3   6010036.0 2099760.0 37.7461072494139 -122.40800527847799 (37.7461072494139, -122.408005278478)
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4673 253651 6 60 131 Font Blvd 1 5 1 1       3x3   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4747 253677 6 71 199X Kissling St 1 18 1 1       5x10            
4922 253717 6 105 4101 Balboa St 1 13 1 1           5982822.0 2110967.0 37.7753172554615 -122.50293574331002 (37.7753172554615, -122.50293574331)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5144 253807 6 25 2 Garfield St 1 17 1 1       10x2   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5179 253770 6 142 234 Carl St 1 8 1 1       3x3 Permit Number 770677 5997066.0 2107091.0 37.7655016335596 -122.453382820195 (37.7655016335596, -122.453382820195)
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9148 85030 6 17 411 Panama St 1 1 1 1   06/26/2007 12:00:00 AM     Permit Number 49384          
Powered by Datasette · Query took 13.718ms · Data source: data.sfgov.org