sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12077 94990 1 44 48 Leland Ave 1 21 1 1     3     6010713.1186 2087200.5157 37.7116594240627 -122.40477981842301 (37.7116594240627, -122.404779818423)
12485 94989 1 37 44 Leland Ave 1 21 1 1     3     6010751.8878 2087184.0277 37.711616318234206 -122.404644660956 (37.7116163182342, -122.404644660956)
69957 98409 1 66 55 19th Ave 1 21 1 1           5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
78378 93933 1 2 230 Seacliff Ave 1 21 1 1   04/28/2010 12:00:00 AM   37x6 Permit Number 53388 5987086.7 2115743.7 37.7886824393648 -122.488534508212 (37.7886824393648, -122.488534508212)
96749 93115 1 75 397 San Jose Ave 1 21 2 1   02/02/2009 12:00:00 AM   26x6 Permit Number 53167 6006259.6 2100887.6 37.7489912240508 -122.42114365927 (37.7489912240508, -122.42114365927)
100055 94492 1 17 246 29th Ave 1 21 1 1           5986862.8 2114289.3 37.7846760086181 -122.489202186141 (37.7846760086181, -122.489202186141)
117984 91210 3 91 333 Haight St 1 21 1 2   02/15/2008 12:00:00 AM 3     6004540.59043 2109422.99046 37.7723303224715 -122.427696060061 (37.7723303224715, -122.427696060061)
155501 98407 1 237 24 19th Ave 1 21 1 1   02/09/2012 12:00:00 AM 3   Permit Number 768590 5989919.44776 2114906.64899 37.7865490191546 -122.47867248440201 (37.7865490191546, -122.478672484402)
176682 98235 1 237 42 19th Ave 1 21 1 1   01/09/2012 12:00:00 AM 3   Permit Number 768620 5989920.54745 2114876.2625700003 37.7864656504451 -122.47866645673 (37.7864656504451, -122.47866645673)
Powered by Datasette · Query took 1.729ms · Data source: data.sfgov.org