sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
32032 197020 2 96 2251 Silver Ave 4 4 1 1     7 Width 3ft   6012818.66799 2096282.81423 37.736715035672496 -122.398139200966 (37.7367150356725, -122.398139200966)
45707 197016 2 96 208 Pennsylvania Ave 4 1 1 1     9 Width 3ft   6014268.20228 2105989.76799 37.7634489024704 -122.393806741299 (37.7634489024704, -122.393806741299)
68515 213907 2 96 9 Locksley Ave 4 2 1 1     13 Width 3ft   5994127.50266 2104950.54632 37.759455632884396 -122.463390998614 (37.7594556328844, -122.463390998614)
70404 124499 2 96 2700 Golden Gate Ave 4 1 1 1     9 Width 3ft   5996580.00237 2111310.8837099997 37.7770604701507 -122.45536877021601 (37.7770604701507, -122.455368770216)
71879 197012 2 96 200 Pennsylvania Ave 4 1 1 1     8 Width 3ft   6014262.54318 2106085.39774 37.763711166361105 -122.393833008691 (37.7637111663611, -122.393833008691)
85784 16046 3 96 200X Monterey Blvd 4 11 1 2     12 5   6000746.7708385 2094693.2718477002 37.731670735926 -122.43976296625401 (37.731670735926, -122.439762966254)
109184 16158 3 96 400X Monterey Blvd 4 11 1 2   04/06/1998 12:00:00 AM 3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
110197 110391 2 96 601X JOOST AVE 4 1 1 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
111702 16076 3 96 258X Monterey Blvd 4 11 1 2     12 5   6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
115104 113167 2 96 3902 CLAY ST 4 1 1 1       3x3   5996089.0 2115262.0 37.7878809990319 -122.45735320225701 (37.7878809990319, -122.457353202257)
Powered by Datasette · Query took 2.685ms · Data source: data.sfgov.org