sf-trees

Data source: data.sfgov.org

Custom SQL query returning 12 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29739 187574 2 58 72 Bishop St 1 17 1 1     10     6010842.8913900005 2089488.5588 37.71794917929 -122.404492242147 (37.71794917929, -122.404492242147)
29820 187571 2 58 73 Bishop St 2 17 1 1     7     6010860.52073 2089475.11103 37.7179132396708 -122.40443035886899 (37.7179132396708, -122.404430358869)
36978 187575 2 58 72 Bishop St 2 17 1 1     11     6010832.96557 2089490.7918200002 37.7179547559905 -122.40452670863998 (37.7179547559905, -122.40452670864)
39135 247897 2 58 351 Mayflower St 2 17 1 1     4     6010077.88258 2098386.8429099997 37.7423392041858 -122.407763645688 (37.7423392041858, -122.407763645688)
45007 248046 2 58 38 Rutledge St 3 17 1 1     4     6010555.404680001 2099417.48898 37.745195855721995 -122.406185107956 (37.745195855722, -122.406185107956)
49133 247976 2 58 503 Peralta Ave 2 17 1 1     9     6009801.95016 2099270.17301 37.7447491849331 -122.408780045086 (37.7447491849331, -122.408780045086)
53626 175808 2 58 72 La Grande Ave 1 17 1 1     3     6005234.38829 2091786.48978 37.7239437686747 -122.42404172366001 (37.7239437686747, -122.42404172366)
60035 187570 2 58 73 Bishop St 1 17 1 1     6     6010859.73078 2089462.03095 37.7178772802949 -122.404432169207 (37.7178772802949, -122.404432169207)
116919 175809 2 58 72 La Grande Ave 2 17 1 1     4     6005230.95207 2091785.5880000002 37.7239410985769 -122.424053538037 (37.7239410985769, -122.424053538037)
146973 187576 2 58 72 Bishop St 3 17 1 1     6     6010826.85106 2089479.8583099998 37.7179243930824 -122.40454707471301 (37.7179243930824, -122.404547074713)
162264 187573 2 58 73 Bishop St 4 17 1 1     14     6010858.37792 2089492.3055900002 37.717960332674295 -122.404438975305 (37.7179603326743, -122.404438975305)
173385 175810 2 58 72 La Grande Ave 3 17 1 1     6     6005231.38021 2091782.6619 37.7239330883183 -122.424051850035 (37.7239330883183, -122.424051850035)
Powered by Datasette · Query took 8.726ms · Data source: data.sfgov.org