sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20744 23006 1 81 766 Valencia St 2 1 1 1   02/23/1994 12:00:00 AM 8 3X3   6006218.84128 2105121.1414400004 37.7606132528131 -122.421585241678 (37.7606132528131, -122.421585241678)
23100 22998 3 81 714 Valencia St 1 1 1 2   02/23/1994 12:00:00 AM 8     6006205.20873 2105402.95089 37.7613862668816 -122.421652406646 (37.7613862668816, -122.421652406646)
29816 236231 2 81 560 Valencia St 3 1 1 1     8 Width 3ft   6006156.6323 2106292.1424 37.7638250385181 -122.42188357737 (37.7638250385181, -122.42188357737)
36268 236248 2 81 3436 18th St 1 1 1 1     8 Width 3ft   6006579.89851 2105554.96639 37.761824787108296 -122.42036729883002 (37.7618247871083, -122.42036729883)
37628 139326 2 81 1360 Geary Blvd 13 1 1 1     8 Width 0ft   6005071.5013 2114164.734 37.785380003834206 -122.42619723103901 (37.7853800038342, -122.426197231039)
53353 236223 2 81 748 Valencia St 1 1 1 1     8 Width 3ft   6006211.88041 2105222.0235900003 37.7608898590889 -122.42161648143299 (37.7608898590889, -122.421616481433)
65262 236229 2 81 582 Valencia St 1 1 1 1     8 Width 3ft   6006153.79144 2106219.79715 37.763626235291206 -122.421888263736 (37.7636262352912, -122.421888263736)
153099 236237 2 81 542 Valencia St 1 1 1 1     8 Width 3ft   6006148.19059 2106430.82622 37.7642053555191 -122.421922626833 (37.7642053555191, -122.421922626833)
155123 236232 2 81 560 Valencia St 2 1 1 1     8 Width 3ft   6006154.39468 2106315.1236900003 37.7638880135333 -122.421892949197 (37.7638880135333, -122.421892949197)
171552 236221 2 81 766 Valencia St 1 1 1 1     8 Width 3ft   6006214.88989 2105148.6562099997 37.7606885791281 -122.42160086200501 (37.7606885791281, -122.421600862005)
Powered by Datasette · Query took 1.645ms · Data source: data.sfgov.org