sf-trees

Data source: data.sfgov.org

Custom SQL query returning 15 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29520 32018 1 51 729 Filbert St 1 1 1 1   07/24/1995 12:00:00 AM 11   Permit Number 35411 6009321.52864 2119764.77649 37.800995657295395 -122.41188922351101 (37.8009956572954, -122.411889223511)
53925 68894 1 51 47 Exeter St 1 1 1 1 1 12/29/1993 12:00:00 AM 11   Permit Number 32866 6012572.9149400005 2090991.6774900001 37.722172972090505 -122.39861769156799 (37.7221729720905, -122.398617691568)
60774 67952 1 51 564 24th Ave 1 1 1 1 1 03/22/1993 12:00:00 AM 11   Permit Number 31667 5988466.35449 2112153.3787599998 37.778904841146 -122.48349784875201 (37.778904841146, -122.483497848752)
67427 31660 1 51 1120 Clay St 1 1 1 1   06/05/1995 12:00:00 AM 11   Permit Number 35168 6009328.60385 2117080.0959 37.7936245817471 -122.411674942066 (37.7936245817471, -122.411674942066)
67644 70573 2 51 862 42nd Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 11     5982961.78283 2109923.12422 37.772459289826 -122.502374937437 (37.772459289826, -122.502374937437)
172491 63900 1 51 2584 Filbert St 1 1 1 1   07/22/1987 12:00:00 AM 11   Permit Number 24610 6000600.04945 2118593.6977 37.7972870321295 -122.441985077154 (37.7972870321295, -122.441985077154)
185243 72258 2 51 230 Paris St 1 1 1 1 1 01/06/1996 12:00:00 AM 11     6002786.80425 2092214.2025900001 37.7249796797621 -122.432533160192 (37.7249796797621, -122.432533160192)
29092 242342 2 51 50 Whitney St 1 1 1 1     11 Width 3ft   6004264.15883 2097942.68629 37.740792476382 -122.427834099074 (37.740792476382, -122.427834099074)
153280 180402 2 51 675 Cayuga Ave 2 1 1 1     11 Width 3ft   6001637.22764 2093149.1062200002 37.727481455185 -122.436573998515 (37.727481455185, -122.436573998515)
48324 219420 2 51 1301 Funston Ave 2 1 1 1     11 Width 4ft   5992057.8729 2106495.38821 37.7635779048182 -122.470661252913 (37.7635779048182, -122.470661252913)
166295 242330 2 51 110 28th St 1 1 1 1     11 Width 4ft   6005175.96727 2099631.57497 37.745481319400795 -122.424801526695 (37.7454813194008, -122.424801526695)
168128 219421 2 51 1301 Funston Ave 4 1 1 1     11 Width 4ft   5992063.34343 2106423.60328 37.7633811187784 -122.470637103423 (37.7633811187784, -122.470637103423)
36902 136926 2 51 3835 Scott St 2 1 1 1     11 Width 5ft   6000573.99959 2121502.15962 37.805271409309 -122.442284116143 (37.805271409309, -122.442284116143)
37968 136932 2 51 3825 Scott St 5 1 1 1     11 Width 5ft   6000587.38423 2121403.46977 37.8050011962985 -122.442230708079 (37.8050011962985, -122.442230708079)
163334 136930 2 51 3825 Scott St 3 1 1 1     11 Width 5ft   6000585.214790001 2121429.39855 37.8050722661295 -122.442240078135 (37.8050722661295, -122.442240078135)
Powered by Datasette · Query took 15.23ms · Data source: data.sfgov.org