sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
30779 60998 1 67 340 Brannan St 1 1 1 1   09/20/1991 12:00:00 AM 6 3x3 Permit Number 30085 6014626.949469999 2112460.0438599996 37.7812347712083 -122.393018675278 (37.7812347712083, -122.393018675278)
55311 228360 2 67 680 Florida St 1 1 1 1     6 Width 3ft   6009245.21588 2105144.93329 37.7608487627785 -122.411120024366 (37.7608487627785, -122.411120024366)
73652 190619 2 67 111 Vermont St 1 1 1 1     6 Width 3ft   6011132.200069999 2107975.56033 37.768726666519605 -122.40479303477699 (37.7687266665196, -122.404793034777)
75062 199662 2 67 1375 Donner Ave 1 1 1 1     6 Width 0ft   6015149.5908 2090825.6295 37.7218602555285 -122.389699078768 (37.7218602555285, -122.389699078768)
94572 98483 1 67 531X Franconia St 8 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
95056 98485 1 67 531X Franconia St 10 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
139243 98475 1 67 531X Franconia St 2 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
143298 98479 1 67 531X Franconia St 4 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
143504 98481 1 67 531X Franconia St 6 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
151005 36798 1 67 1355 Donner Ave 3 1 1 1 1 07/17/1999 12:00:00 AM 6   Permit Number 39528 6015230.5975 2090758.0224 37.7216791113631 -122.38941433805701 (37.7216791113631, -122.389414338057)
Powered by Datasette · Query took 2.418ms · Data source: data.sfgov.org