sf-trees

Data source: data.sfgov.org

Custom SQL query returning 6 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
86227 112615 2 3 1798x 22ND ST 2 14 1 1   05/02/2016 12:00:00 AM 3     6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
89419 115524 1 17 25 FRANCONIA ST 1 14 1 1   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777451 6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
117756 114584 1 17 3300x HARRISON ST 1 14 1 1   02/04/2016 12:00:00 AM 3   Permit Number 777406 6009042.0 2099449.0 37.745197609352005 -122.411420448228 (37.745197609352, -122.411420448228)
123706 112614 1 41 1799x 22ND ST 2 14 1 1   12/09/2015 12:00:00 AM 3   Permit Number 776524 6012792.0 2103743.0 37.7571976263526 -122.398754797925 (37.7571976263526, -122.398754797925)
139483 115526 1 17 25 FRANCONIA ST 3 14 1 1   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777451 6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
Powered by Datasette · Query took 2.963ms · Data source: data.sfgov.org