sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
160942 249712 2 5 2975 Broadway 1 13 1 1     21     5999372.04623 2116967.23886 37.792751153907204 -122.44611721373998 (37.7927511539072, -122.44611721374)
35242 249713 2 5 2975 Broadway 2 13 1 1     15     5999382.51554 2116973.87968 37.792769985700296 -122.446081467494 (37.7927699857003, -122.446081467494)
34603 249714 2 5 2975 Broadway 3 13 1 1     20     5999388.9274 2116973.5904200003 37.7927695576174 -122.446059261445 (37.7927695576174, -122.446059261445)
155707 203875 2 5 41 Ralston St 3 13 1 1     7     5992168.26739 2088231.33888 37.7134358290799 -122.468950218092 (37.7134358290799, -122.468950218092)
30471 188564 2 5 300 Vermont St 4 13 1 1     21     6011131.87643 2106822.77201 37.7655613532939 -122.404712987912 (37.7655613532939, -122.404712987912)
35303 249715 2 5 2975 Broadway 4 13 1 1     18     5999395.51836 2116974.38878 37.7927721260745 -122.44603651397 (37.7927721260745, -122.44603651397)
161892 203876 2 5 41 Ralston St 4 13 1 1     25     5992169.18145 2088225.46502 37.7134197536892 -122.468946631609 (37.7134197536892, -122.468946631609)
157520 203877 2 5 41 Ralston St 6 13 1 1     23     5992177.10886 2088222.03993 37.7134108072361 -122.468918982843 (37.7134108072361, -122.468918982843)
188029 249872 2 5 230 Greenwich St 8 13 1 1     9 Width 0ft   6011683.12279 2120489.80597 37.8031186185004 -122.403768099014 (37.8031186185004, -122.403768099014)
133552 249874 2 5 230 Greenwich St 10 13 1 1     21 Width 0ft   6011664.0982800005 2120483.35155 37.803099833442296 -122.403833479743 (37.8030998334423, -122.403833479743)
Powered by Datasette · Query took 9.563ms · Data source: data.sfgov.org