sf-trees

Data source: data.sfgov.org

Custom SQL query returning 13 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
425 251299 4 15 2190X Market St 3 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
431 251298 4 15 2190X Market St 4 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 4 15 2190X Market St 5 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
446 251296 4 15 2190X Market St 2 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
7556 115529 4 15 101 Polk St 2 1 1 1   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007327.31765 2111347.52577 37.777771876795 -122.418192961161 (37.777771876795, -122.418192961161)
8658 115528 4 15 101 Polk St 1 1 1 1   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007325.8351 2111377.63368 37.77785446243671 -122.418200224953 (37.7778544624367, -122.418200224953)
69564 113240 4 15 329 Brannan St 2 1 1 1   11/10/2015 12:00:00 AM 2 3x4 Permit Number 770912 6014728.70394 2112464.7296599997 37.7812532891345 -122.392666980121 (37.7812532891345, -122.392666980121)
98533 119286 4 15 400 Grove St 2 1 1 1   07/28/2016 12:00:00 AM 3 4x4   6005873.0 2111410.0 37.777861449140204 -122.423228396467 (37.7778614491402, -122.423228396467)
125829 119287 4 15 400 Grove St 3 1 1 1   07/28/2016 12:00:00 AM 3 4x4   6005873.0 2111410.0 37.777861449140204 -122.423228396467 (37.7778614491402, -122.423228396467)
127953 119285 4 15 400 Grove St 1 1 1 1   07/28/2016 12:00:00 AM 3 4x4   6005873.0 2111410.0 37.777861449140204 -122.423228396467 (37.7778614491402, -122.423228396467)
129716 113329 4 15 329 Brannan St 1 1 1 1   11/10/2015 12:00:00 AM 3 3x3 Permit Number 770912 6014656.6559 2112395.64308 37.781059591367296 -122.39291139783701 (37.7810595913673, -122.392911397837)
155460 115559 4 15 2539 Vallejo St 1 1 1 1     18 3x3   6001373.79142 2117611.09107 37.7946331129763 -122.439237274207 (37.7946331129763, -122.439237274207)
157784 113241 4 15 329 Brannan St 3 1 1 1   11/10/2015 12:00:00 AM 3 3x4 Permit Number 770912 6014742.36618 2112476.99378 37.7812877223957 -122.39262057328999 (37.7812877223957, -122.39262057329)
Powered by Datasette · Query took 3.233ms · Data source: data.sfgov.org