sf-trees

Data source: data.sfgov.org

Custom SQL query returning 8 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
37992 87842 1 72 150 Golden Gate Ave 3 1 1 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008797.68605 2112863.51271 37.7820170689709 -122.41321365958099 (37.7820170689709, -122.413213659581)
144327 87840 1 72 150 Golden Gate Ave 1 1 1 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008834.949469999 2112868.30248 37.78203231246879 -122.413085083511 (37.7820323124688, -122.413085083511)
169961 87841 1 72 150 Golden Gate Ave 2 1 1 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008821.92164 2112867.3350299997 37.782028924727705 -122.41313008558599 (37.7820289247277, -122.413130085586)
84232 105709 2 72 739 10th Ave 1 1 1 1     10 3x3   5992855.21688 2110425.97288 37.7744163192706 -122.468189464852 (37.7744163192706, -122.468189464852)
186984 113952 2 72 1416 Powell St 5 1 1 1     11 3x3   6009764.02998 2118627.67395 37.7978982689348 -122.410277642896 (37.7978982689348, -122.410277642896)
2707 14854 3 72 1357 McAllister St 1 1 1 2   05/21/1992 12:00:00 AM 6 3x3   6002671.377 2111611.0853 37.7782323757584 -122.43431829621201 (37.7782323757584, -122.434318296212)
15860 26103 3 72 1557 Oakdale Ave 1 1 1 2   07/22/1988 12:00:00 AM 12 3x3   6015264.4135 2095277.0122 37.734089230154204 -122.38961289841002 (37.7340892301542, -122.38961289841)
17124 29888 3 72 1126 Guerrero St 1 1 1 2     25 3x3   6005721.57126 2102405.52669 37.7531287556897 -122.42311204680901 (37.7531287556897, -122.423112046809)
Powered by Datasette · Query took 3.767ms · Data source: data.sfgov.org