sf-trees

Data source: data.sfgov.org

Custom SQL query returning 6 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
28127 191847 2 39 2101 Newcomb Ave 1 17 1 1     23 Width 10ft   6012411.60288 2097770.43241 37.7407770404189 -122.39965102878901 (37.7407770404189, -122.399651028789)
43726 247881 2 39 387 Mayflower St 2 17 1 1     15     6009928.32781 2098399.30466 37.742365048010896 -122.4082816417 (37.7423650480109, -122.4082816417)
54010 247872 2 39 388 Mayflower St 2 17 1 1     23     6009895.64631 2098398.03188 37.7423597231243 -122.408394555183 (37.7423597231243, -122.408394555183)
136621 249776 2 39 102 Pfeiffer St 7 17 1 1     25 Width 0ft   6010370.54568 2121149.36884 37.804856202214204 -122.408356876268 (37.8048562022142, -122.408356876268)
169612 247876 2 39 388 Mayflower St 5 17 1 1     22     6009908.43883 2098395.0561 37.742352268652 -122.40835011248001 (37.742352268652, -122.40835011248)
172369 191849 2 39 1998 Revere Ave 1 17 1 1     18     6013048.000580001 2095925.65097 37.735747110629 -122.397321254093 (37.735747110629, -122.397321254093)
Powered by Datasette · Query took 8.469ms · Data source: data.sfgov.org