sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2761 253204 2 40 2253 09th Ave 1 5 1 1       3x3   5993186.0 2100608.0 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971)
2763 253205 2 40 2253 09th Ave 2 5 1 1       3x3   5993186.0 2100608.0 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971)
49634 112391 6 40 2201X LYON ST 2 5 1 1       3x12   5999307.0 2116423.0 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227)
81453 114249 6 40 499x 24TH AVE 1 5 1 1       3x3   5988415.0 2112957.0 37.78110836988721 -122.483734439284 (37.7811083698872, -122.483734439284)
99878 6102 3 40 500X 08th St 4 5 1 2     6 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
101382 108685 3 40 301X CHESTER AVE 1 5 1 2     18     5991720.0 2087146.0 37.7104298409998 -122.47042057923099 (37.7104298409998, -122.470420579231)
119405 6105 3 40 500X 08th St 7 5 1 2     3 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
139051 112390 6 40 2201X LYON ST 1 5 1 1       3x12   5999307.0 2116423.0 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227)
140157 6099 6 40 500X 08th St 1 5 1 1     18 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
141855 10769 3 40 1120X Hudson Ave 41 5 1 2     8 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
Powered by Datasette · Query took 12.71ms · Data source: data.sfgov.org