sf-trees

Data source: data.sfgov.org

Custom SQL query returning 14 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
66578 70266 2 88 414 23rd Ave 2 1 1 1 1 02/17/1996 12:00:00 AM 8     5988762.33088 2112478.2196299997 37.7798139854521 -122.482497769619 (37.7798139854521, -122.482497769619)
53628 34942 1 88 462 02nd Ave 1 1 1 1   11/25/1997 12:00:00 AM 8   Permit Number 38539 5995310.64413 2112404.55918 37.7799904974934 -122.459839088006 (37.7799904974934, -122.459839088006)
168749 130985 2 88 2098 Jefferson St 2 1 1 1     8 Width 3ft   5999249.259269999 2121180.66389 37.8043130782603 -122.44684538130501 (37.8043130782603, -122.446845381305)
155510 177423 2 88 270 Delano Ave 1 1 1 1     8 Width 3ft   5999939.77666 2092147.8586099998 37.7246356530907 -122.44237022711701 (37.7246356530907, -122.442370227117)
173639 177414 2 88 575 Athens St 1 1 1 1     8 Width 2ft   6003352.2884599995 2089985.19468 37.7188913693287 -122.430419379246 (37.7188913693287, -122.430419379246)
5141 237496 2 88 3927 24th St 1 1 1 1     8 Width 3ft   6003620.49393 2101843.48933 37.751466742003295 -122.430337889878 (37.7514667420033, -122.430337889878)
66618 248252 2 88 110 Lundy's Ln 1 1 1 1     8 Width 3ft   6006810.41598 2098914.4324 37.7436043875329 -122.41909899033999 (37.7436043875329, -122.41909899034)
73049 70606 2 88 1250 Bush St 1 1 1 1 1 08/13/1994 12:00:00 AM 8     6007500.2862599995 2115460.0775 37.7890736803541 -122.41788619879298 (37.7890736803541, -122.417886198793)
134484 34949 1 88 1246 Bush St 2 1 1 1 1 11/18/1995 12:00:00 AM 8   Permit Number 38547 6007519.4935099995 2115461.74269 37.7890793334842 -122.417819862092 (37.7890793334842, -122.417819862092)
36370 130994 2 88 800 Lombard St 4 1 1 1     8 Width 3ft   6008432.69085 2120383.1883 37.8026437557674 -122.41500878732401 (37.8026437557674, -122.415008787324)
23594 230297 2 88 1171 Treat Ave 1 1 1 1     8 Width 3ft   6008685.11737 2101744.284 37.7514799242568 -122.412816735721 (37.7514799242568, -122.412816735721)
147644 230301 2 88 1083 York St 1 1 1 1     8 Width 3ft   6010010.1738 2102926.1510900003 37.754799354323 -122.40831786097999 (37.754799354323, -122.40831786098)
28898 250221 2 88 312 Filbert St 2 17 1 1     8 Width 0ft   6011282.00764 2120080.85256 37.8019733165766 -122.405127362244 (37.8019733165766, -122.405127362244)
34611 45681 1 88 440 Mississippi St 1 1 1 1   09/18/2001 12:00:00 AM 8   Permit Number 44368 6014041.208930001 2105068.9613799998 37.760907951647795 -122.39452736264099 (37.7609079516478, -122.394527362641)
Powered by Datasette · Query took 8.655ms · Data source: data.sfgov.org