sf-trees

Data source: data.sfgov.org

Custom SQL query returning 7 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12092 77648 3 55 1300X Silliman St 9 1 1 4 4 01/01/2011 12:00:00 AM 3 3x3   6006817.147419999 2093142.9824700002 37.727757638780204 -122.418666516263 (37.7277576387802, -122.418666516263)
57285 100977 3 22 450X Chestnut St 9 1 1 4 4   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075)
77610 109992 2 55 501X Shotwell St 9 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
96632 116628 2 41 5732X GEARY BLVD 9 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
98455 97903 2 2 375X Precita Ave 9 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
122481 102195 2 55 3999X Folsom St 9 1 1 4 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
131687 98655 1 55 2110 Greenwich St 9 1 1 4 4   6 5x5   6002650.75991 2119226.56813 37.799141375727295 -122.434934390513 (37.7991413757273, -122.434934390513)
Powered by Datasette · Query took 3.344ms · Data source: data.sfgov.org