sf-trees

Data source: data.sfgov.org

Custom SQL query returning 41 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
93028 115827 6 1 60X CHUMASERO DR 1 5 1 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
102326 104898 6 1 310 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
118620 104908 6 1 500 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
107866 112769 6 1 1X HOWTH ST 1 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111205 112771 6 1 1X HOWTH ST 3 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111811 112770 6 1 1X HOWTH ST 2 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
112482 112773 6 1 1X HOWTH ST 5 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
115212 112774 6 1 1X HOWTH ST 6 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
121815 112772 6 1 1X HOWTH ST 4 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
67557 100121 6 1 690 Miramar Ave 1 7 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
93352 112398 6 1 246 CRESCENT AVE 1 2 1 1           6006552.0 2095759.0 37.7349257177289 -122.419768681192 (37.7349257177289, -122.419768681192)
9912 173731 6 1 484 Chenery St 1 7 1 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
102950 105540 6 1 2694 47TH AVE 1 7 1 1     12     5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
91613 88453 6 1 2801 Oakdale Ave 2 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
106407 88454 6 1 2801 Oakdale Ave 3 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
111585 88455 6 1 2801 Oakdale Ave 4 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
78781 121184 6 1 1000x Duncan St 5 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
79242 121190 6 1 1000x Duncan St 11 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
80352 121187 6 1 1000x Duncan St 8 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
89056 121188 6 1 1000x Duncan St 9 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
90930 121191 6 1 1000x Duncan St 12 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91506 121193 6 1 1000x Duncan St 14 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
95270 121186 6 1 1000x Duncan St 7 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
100978 121192 6 1 1000x Duncan St 13 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
102605 121181 6 1 1000x Duncan St 2 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104617 121185 6 1 1000x Duncan St 6 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104788 121183 6 1 1000x Duncan St 4 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
123005 121182 6 1 1000x Duncan St 3 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
106634 121195 6 1 255x Red Rock Way 2 7 1 1       3x3 Permit Number 775289 5999917.0 2099808.0 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589)
142656 121196 6 1 255x Red Rock Way 3 7 1 1       3x3 Permit Number 775289 5999917.0 2099808.0 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589)
13301 187651 6 1 175 Raccoon Dr 1 13 1 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
119856 85365 6 1 66 Clarendon Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.758871479144396 -122.45053809231199 (37.7588714791444, -122.450538092312)
109657 98303 6 1 6 Locksley Ave 3 7 1 1           5994194.0 2104902.7 37.7593280901784 -122.463157548093 (37.7593280901784, -122.463157548093)
143633 121087 6 1 1443 47th Ave 1 1 1 1       3x3 Permit Number 778784 5981521.320719999 2105258.5458 37.7595669638281 -122.507011468719 (37.7595669638281, -122.507011468719)
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)
Powered by Datasette · Query took 10.035ms · Data source: data.sfgov.org