sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
32280 129119 2 19 1114 Greenwich St 3 17 1 1     18     6007553.05086 2119913.7987599997 37.8013054611424 -122.418019497203 (37.8013054611424, -122.418019497203)
60867 246724 2 19 1501 Shotwell St 1 17 1 1     9     6008058.52794 2099329.47434 37.744814207710796 -122.41481267936001 (37.7448142077108, -122.41481267936)
62478 247003 2 19 401 Valley St 3 17 1 1     6 Width 8ft   6003236.004319999 2099186.05464 37.744148261529006 -122.431477809352 (37.744148261529, -122.431477809352)
66998 226943 2 19 301 Fairmount St 3 17 1 1     63     6004022.8098 2097135.0105400002 37.7385611270814 -122.42861103418001 (37.7385611270814, -122.42861103418)
148697 227017 2 19 31 Poppy Ln 1 17 1 1     2 Width 2ft   6002132.64017 2096807.6586799999 37.7375551427627 -122.435122918088 (37.7375551427627, -122.435122918088)
149571 226942 2 19 301 Fairmount St 2 17 1 1     61     6004034.48943 2097139.1413599998 37.7385731303523 -122.428570945989 (37.7385731303523, -122.428570945989)
150025 227020 2 19 31 Poppy Ln 5 17 1 1     5 Width 3ft   6002175.423769999 2096803.9702599999 37.7375474445557 -122.43497473141501 (37.7375474445557, -122.434974731415)
172565 227019 2 19 31 Poppy Ln 4 17 1 1     5 Width 3ft   6002163.83641 2096804.20988 37.737547444561 -122.435014811479 (37.737547444561, -122.435014811479)
173063 227018 2 19 31 Poppy Ln 3 17 1 1     5 Width 3ft   6002156.08146 2096805.0262900002 37.7375492458966 -122.435041682346 (37.7375492458966, -122.435041682346)
173605 226941 2 19 300 Fairmount St 1 17 1 1     16     6004051.37428 2097144.63452 37.738589168851206 -122.42851295770399 (37.7385891688512, -122.428512957704)
Powered by Datasette · Query took 4.854ms · Data source: data.sfgov.org