sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
58940 107105 2 20 532 NOE ST 1 1 1 1     12 4x4   6002950.4 2105092.9 37.760350869576705 -122.43288727007901 (37.7603508695767, -122.432887270079)
82096 116726 1 20 180X PERALTA AVE 3 1 1 1       4x4   6009777.0 2100122.0 37.7470867174475 -122.408926407614 (37.7470867174475, -122.408926407614)
83292 56149 1 20 426 16th Ave 1 1 1 1   07/02/1973 12:00:00 AM 18 4x4 Permit Number 12256 5990938.77862 2112472.88916 37.7799257212488 -122.474968166346 (37.7799257212488, -122.474968166346)
90190 59352 1 20 469 Faxon Ave 1 1 1 1   11/19/1980 12:00:00 AM 11 4x4 Permit Number 18701 5994737.99829015 2091686.56057322 37.7230711817022 -122.460318578759 (37.7230711817022, -122.460318578759)
93893 24248 3 20 265X Willow St 2 1 1 2   05/01/1990 12:00:00 AM 3 4x4   6006141.132777 2113311.4044124 37.783097370149 -122.422435967678 (37.783097370149, -122.422435967678)
97590 104767 2 20 1111 CASTRO ST 2 1 1 1     14 4x4   6002562.6 2102271.3 37.7525814287469 -122.434026788658 (37.7525814287469, -122.434026788658)
98059 96209 3 20 201X Diamond St 1 1 1 4 2 05/28/2012 12:00:00 AM 3 4x4   6001762.6 2104666.8 37.759113460692 -122.43696480408701 (37.759113460692, -122.436964804087)
102550 22595 1 20 810X Turk St 1 1 1 1   05/18/1992 12:00:00 AM 6 4x4   6006111.721580001 2112834.13473 37.7817852453704 -122.42250379427601 (37.7817852453704, -122.422503794276)
117337 107106 2 20 532 NOE ST 2 1 1 1     12 4x4   6002950.4 2105092.9 37.760350869576705 -122.43288727007901 (37.7603508695767, -122.432887270079)
118043 107041 2 20 1301 18TH ST 2 1 1 1       4x4   6013691.7 2105657.2 37.7625036896712 -122.39577738754299 (37.7625036896712, -122.395777387543)
144250 53646 1 20 4122 18th St 1 1 1 1   01/21/1970 12:00:00 AM   4x4 Permit Number 6582 6002264.58930584 2105323.26782976 37.760944481879996 -122.435275644763 (37.76094448188, -122.435275644763)
Powered by Datasette · Query took 8.907ms · Data source: data.sfgov.org