sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
124788 104692 2 96 2201 SUTTER ST   1 1 1     11 3x3   6001996.0 2114241.0 37.7854150975946 -122.436842984948 (37.7854150975946, -122.436842984948)
9761 122592 4 96 72 Townsend St 1 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
11816 56918 1 96 757 Athens St 1 1 1 1   08/14/1974 12:00:00 AM 8 3x3 Permit Number 14160 6002721.67474 2088983.8970400002 37.716106284944 -122.432527678806 (37.716106284944, -122.432527678806)
11975 105023 2 96 761 Athens St 1 1 1 1     9 3x3   6002706.48951 2088960.92893 37.7160423584316 -122.432578526497 (37.7160423584316, -122.432578526497)
18809 5147 3 96 228 Divisadero St 1 1 1 2   04/21/2016 12:00:00 AM 3 3x3   6001883.9625 2108955.9605 37.7708973412472 -122.436852124872 (37.7708973412472, -122.436852124872)
23233 5150 3 96 243 Divisadero St 1 1 1 2   04/21/2016 12:00:00 AM 2 3x3   6001815.3824 2108971.2006 37.7709352888143 -122.437090436044 (37.7709352888143, -122.437090436044)
81486 103328 3 96 242 Divisadero St 1 1 1 2     4 3x3   6001866.0 2109053.0 37.7711627667236 -122.436921205648 (37.7711627667236, -122.436921205648)
82169 103330 3 96 1600X McAllister St 1 1 1 2       3x3   6001400.4 2111522.1 37.7779158216762 -122.438708684362 (37.7779158216762, -122.438708684362)
84527 22821 3 96 64 Turquoise Way 1 1 1 2   01/01/2008 12:00:00 AM 3 3x3   5998921.4611914 2099744.1843889 37.7454352704129 -122.446436637784 (37.7454352704129, -122.446436637784)
92010 18658 3 96 7 Richards Ct 1 1 1 2     12 3x3   6016334.44824 2095879.1633400002 37.7358018906208 -122.38595537929599 (37.7358018906208, -122.385955379296)
92915 84676 1 96 25 Josiah Ave 1 1 1 1   10/04/2007 12:00:00 AM   3x3 Permit Number 49727 5996908.75152474 2089951.72351373 37.718432356708796 -122.45268961212099 (37.7184323567088, -122.452689612121)
94639 110388 2 96 601X JOOST AVE 1 1 1 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
100542 103326 3 96 224 Divisadero St 1 1 1 2       3x3   6001907.0 2108933.4 37.7708367050105 -122.43677082248301 (37.7708367050105, -122.436770822483)
102585 103332 3 96 245 Divisadero St 1 1 1 2       3x3   6001802.8 2109052.7 37.7711583507176 -122.43713979494301 (37.7711583507176, -122.437139794943)
120532 103325 3 96 200 Divisadero St 1 1 1 2       3x3   6001895.0 2108750.0 37.7703324520775 -122.436799199856 (37.7703324520775, -122.436799199856)
143218 103327 3 96 234 Divisadero St 1 1 1 2       3x3   6001874.0 2108997.0 37.771009459311706 -122.43688952378 (37.7710094593117, -122.43688952378)
89794 103329 1 96 1194X Fell St 2 1 1 1       3x3   6001718.9 2110136.9 37.7741305241547 -122.437507661432 (37.7741305241547, -122.437507661432)
114263 18659 3 96 7 Richards Ct 2 1 1 2     12 3x3   6016312.43294 2095882.6817 37.7358103329414 -122.386031740711 (37.7358103329414, -122.386031740711)
124276 110389 2 96 601X JOOST AVE 2 1 1 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
139919 103333 3 96 243 Divisadero St 2 1 1 2       3x3   6001783.9 2108958.2 37.7708978028329 -122.43719840332399 (37.7708978028329, -122.437198403324)
141020 103331 3 96 1600X McAllister St 2 1 1 2       3x3   6001400.4 2111522.1 37.7779158216762 -122.438708684362 (37.7779158216762, -122.438708684362)
143071 110390 2 96 601X JOOST AVE 3 1 1 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
110197 110391 2 96 601X JOOST AVE 4 1 1 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
115104 113167 2 96 3902 CLAY ST 4 1 1 1       3x3   5996089.0 2115262.0 37.7878809990319 -122.45735320225701 (37.7878809990319, -122.457353202257)
79435 113168 2 96 3902 CLAY ST 5 1 1 1       3x3   5996089.0 2115262.0 37.7878809990319 -122.45735320225701 (37.7878809990319, -122.457353202257)
120421 110392 2 96 601X JOOST AVE 5 1 1 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
Powered by Datasette · Query took 2.301ms · Data source: data.sfgov.org