sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
58748 121640 1 18 195 Otsego Ave 3 1 1 1 1   17     6000583.2387 2092221.3848599999 37.724874193767796 -122.440151136477 (37.7248741937678, -122.440151136477)
56597 62492 1 18 61 Otsego Ave 1 1 1 1 1 01/25/1986 12:00:00 AM 17   Permit Number 22663 6000854.65183 2092771.54235 37.726400248862205 -122.43925230995 (37.7264002488622, -122.43925230995)
164246 62478 1 18 19 Delano Ave 1 1 1 1 1 01/25/1986 12:00:00 AM 17   Permit Number 22649 6000701.05589 2093131.58953 37.7273801141826 -122.43980908564501 (37.7273801141826, -122.439809085645)
64555 239531 2 18 122 Wool St 1 1 1 1     17 Width 3ft   6007359.24637 2097609.09568 37.7400511148656 -122.417108790654 (37.7400511148656, -122.417108790654)
136564 238497 2 18 71 Harper St 1 1 1 1     17 Width 4ft   6003696.82285 2098018.95409 37.7409697795215 -122.429801171794 (37.7409697795215, -122.429801171794)
27319 246424 2 18 418 Duncan St 1 4 1 1     17 Width 4ft   6003710.7768 2099847.4001700003 37.7459910605319 -122.429883314964 (37.7459910605319, -122.429883314964)
146982 238159 2 18 536 Diamond St 1 1 1 1     17 Width 3ft   6001813.48692 2102703.50128 37.7537256078766 -122.43664828070101 (37.7537256078766, -122.436648280701)
63678 213381 2 18 1336 04th Ave 1 1 1 1     17 Width 3ft   5994897.17134 2106458.29966 37.7636398474165 -122.46083839709401 (37.7636398474165, -122.460838397094)
54739 238467 2 18 84 Potomac St 1 1 1 1     17 Width 3ft   6003105.62038 2108812.21819 37.77057201691021 -122.43261611365801 (37.7705720169102, -122.432616113658)
Powered by Datasette · Query took 28.194ms · Data source: data.sfgov.org