sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
46601 84938 6 40 145 Guerrero St 1 7 1 1         Permit Number 49347 6005480.0 2108218.0 37.769074802262395 -122.42436083172 (37.7690748022624, -122.42436083172)
49634 112391 6 40 2201X LYON ST 2 5 1 1       3x12   5999307.0 2116423.0 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
81453 114249 6 40 499x 24TH AVE 1 5 1 1       3x3   5988415.0 2112957.0 37.78110836988721 -122.483734439284 (37.7811083698872, -122.483734439284)
85476 112374 6 40 1247 Bosworth St 1 7 1 1       20x20 Permit Number 775819 6000424.1100699995 2096055.79143 37.735393525896704 -122.44097617665199 (37.7353935258967, -122.440976176652)
107396 112485 6 40 1275 Columbus Ave 5 7 1 1   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209)
108486 107550 6 40 198X Jennings St 3 7 1 2           6018784.70414 2097136.12526 37.739388557233205 -122.377570991407 (37.7393885572332, -122.377570991407)
112521 98951 6 40 401 Grove St 11 7 1 1           6005778.2 2111279.0 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313)
117944 104432 6 40 1601X PORTOLA DR 1 7 1 1     14     5991823.0 2096240.0 37.73540567927029 -122.47072655808 (37.7354056792703, -122.47072655808)
122611 112487 6 40 1275 Columbus Ave 7 7 1 1           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209)
122658 112488 6 40 1275 Columbus Ave 8 7 1 1           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209)
124450 112484 6 40 1275 Columbus Ave 4 7 1 1   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209)
126530 98952 6 40 302 Ivy St 18 7 1 1           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433)
139051 112390 6 40 2201X LYON ST 1 5 1 1       3x12   5999307.0 2116423.0 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227)
140157 6099 6 40 500X 08th St 1 5 1 1     18 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
140881 107539 6 40 198X JENNINGS ST 1 7 1 2           6018784.0 2097136.0 37.739388174499 -122.377573417349 (37.739388174499, -122.377573417349)
Powered by Datasette · Query took 13.316ms · Data source: data.sfgov.org