sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
18809 5147 3 96 228 Divisadero St 1 1 1 2   04/21/2016 12:00:00 AM 3 3x3   6001883.9625 2108955.9605 37.7708973412472 -122.436852124872 (37.7708973412472, -122.436852124872)
83307 24349 3 96 85 Duboce Ave 3 1 1 2   11/24/2003 12:00:00 AM 3 2x2   6006210.36104 2108383.4741700003 37.769570370002604 -122.421846308181 (37.7695703700026, -122.421846308181)
84527 22821 3 96 64 Turquoise Way 1 1 1 2   01/01/2008 12:00:00 AM 3 3x3   5998921.4611914 2099744.1843889 37.7454352704129 -122.446436637784 (37.7454352704129, -122.446436637784)
88696 16157 3 96 400X Monterey Blvd 3 11 1 2     3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
97527 16188 3 96 460X Monterey Blvd 5 11 1 2     3 5   5999032.780474599 2094728.5162104 37.731669798591 -122.445691084837 (37.731669798591, -122.445691084837)
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)
111934 16186 3 96 460X Monterey Blvd 3 11 1 2     3 5   5999032.780474599 2094728.5162104 37.731669798591 -122.445691084837 (37.731669798591, -122.445691084837)
120553 22818 3 96 60 Turquoise Way 1 1 1 2   06/12/1997 12:00:00 AM 3 3X3   5998904.0126134 2099759.7693507997 37.745477066338 -122.446498092976 (37.745477066338, -122.446498092976)
126834 16155 3 96 400X Monterey Blvd 1 11 1 2     3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
139515 16160 3 96 400X Monterey Blvd 6 11 1 2   02/18/1999 12:00:00 AM 3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
Powered by Datasette · Query took 3.629ms · Data source: data.sfgov.org