sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17378 29984 3 99 1622X Guerrero St 5 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005923.58357 2099590.01571 37.7454094051301 -122.422213431617 (37.7454094051301, -122.422213431617)
17470 29703 3 99 1488X Guerrero St 5 11 1 2   03/30/2006 12:00:00 AM 6     6005875.752859999 2100395.2692 37.7476177497694 -122.42243602910901 (37.7476177497694, -122.422436029109)
21879 29710 3 99 1534X Guerrero St 5 11 1 2   03/30/2006 12:00:00 AM 3     6005894.4456400005 2100106.5973900002 37.7468261772965 -122.422350883111 (37.7468261772965, -122.422350883111)
22913 100331 1 99 555 04th St 5 1 1 1     22 3x3   6013371.56305 2111703.84537 37.779088608380206 -122.397308677969 (37.7790886083802, -122.397308677969)
31570 225166 2 99 338 Hoffman Ave 5 1 1 1     8 Width 4ft   6000619.1665199995 2101783.32951 37.7511310943237 -122.440712500502 (37.7511310943237, -122.440712500502)
44500 225198 2 99 3160 21st St 5 1 1 1     9 Width 3ft   6007149.23047 2103831.77129 37.757125358151704 -122.41827602071501 (37.7571253581517, -122.418276020715)
76939 225183 2 99 240 Shotwell St 5 1 1 1     7 Width 3ft   6007749.18821 2106563.04323 37.7646585535855 -122.416394585035 (37.7646585535855, -122.416394585035)
153857 201507 2 99 1001 Innes Ave 5 9 1 1     1 Width 4ft   6018590.61876 2094904.2906900002 37.733249683412296 -122.37808717738599 (37.7332496834123, -122.378087177386)
158218 190007 2 99 700 Arkansas St 5 7 1 1     3     6012984.44615 2103792.30277 37.7573437216454 -122.398092698838 (37.7573437216454, -122.398092698838)
165711 225191 2 99 500 Capp St 5 1 1 1     10 Width 3ft   6007257.73573 2103878.07853 37.7572586143179 -122.41790404944099 (37.7572586143179, -122.417904049441)
Powered by Datasette · Query took 3.351ms · Data source: data.sfgov.org