sf-trees

Data source: data.sfgov.org

Custom SQL query returning 7 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8439 19025 3 16 3170 Sacramento St 4 5 1 2     8 2X2   5999621.132119999 2115414.4338700003 37.7885017807754 -122.445143681435 (37.7885017807754, -122.445143681435)
54060 91105 1 16 5100 Fulton St   5 1 1   01/08/2009 12:00:00 AM 3   Permit Number 51994 5987471.43657 2109862.78332 37.7725575525108 -122.48677137341002 (37.7725575525108, -122.48677137341)
69774 91104 1 16 5100 Fulton St   5 1 1   01/08/2009 12:00:00 AM 3   Permit Number 51994 5987486.90451 2109863.03961 37.772559157968395 -122.48671788773399 (37.7725591579684, -122.486717887734)
78524 47338 1 16 399X Vernon St 3 5 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45267 5992467.59204583 2090467.76074352 37.7195937916744 -122.468078236027 (37.7195937916744, -122.468078236027)
80317 47339 1 16 399 Vernon St 1 5 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45267 5992467.59204583 2090467.76074352 37.7195937916744 -122.468078236027 (37.7195937916744, -122.468078236027)
92211 47340 1 16 399X Vernon St 2 5 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45267 5992467.59204583 2090467.76074352 37.7195937916744 -122.468078236027 (37.7195937916744, -122.468078236027)
97340 121629 2 16 1X Omar Way 1 5 1 1       3x3   5998187.0 2097555.0 37.7393823228298 -122.448818619019 (37.7393823228298, -122.448818619019)
Powered by Datasette · Query took 10.582ms · Data source: data.sfgov.org