sf-trees

Data source: data.sfgov.org

Custom SQL query returning 15 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
52436 31977 1 88 134 02nd Ave 1 1 1 1 1 06/30/1995 12:00:00 AM 7   Permit Number 35376 5995230.64434 2114664.73917 37.7861917443429 -122.460279644251 (37.7861917443429, -122.460279644251)
169003 84840 1 88 1107 Mason St 1 1 1 1   02/20/2007 12:00:00 AM 7   Permit No. 49267 6009440.82091 2117125.31431 37.793755034731795 -122.411289855968 (37.7937550347318, -122.411289855968)
33296 110565 2 88 135 Theresa St 4 1 1 1     7 3x9   6002103.512680001 2093689.48997 37.728991712774295 -122.43500068223301 (37.7289917127743, -122.435000682233)
67154 122918 2 88 336 12th Ave 1 1 1 1     7 Width 3ft   5992182.56375 2113171.96239 37.781917187404794 -122.470716333226 (37.7819171874048, -122.470716333226)
24356 123622 2 88 111 02nd Ave 1 1 1 1     7 Width 3ft   5995179.48554 2114830.2995 37.786643385410706 -122.460468639914 (37.7866433854107, -122.460468639914)
174305 130981 2 88 3001 Buchanan St 3 1 1 1     7 Width 4ft   6003397.35892 2118675.30556 37.797670113634794 -122.43231151328399 (37.7976701136348, -122.432311513284)
53332 131003 2 88 1109 Sansome St 1 1 1 1     7 Width 3ft   6011959.67514 2119544.33527 37.8005380309676 -122.40274454551901 (37.8005380309676, -122.402744545519)
131019 177392 2 88 1654 Sunnydale Ave 1 9 1 1     7 Width 10ft   6006773.14965 2087593.0806 37.7125163163365 -122.41842526053101 (37.7125163163365, -122.418425260531)
160548 177398 2 88 650 France Ave 3 1 1 1     7 Width 4ft   6002590.58454 2089466.88592 37.7174250310079 -122.433015275935 (37.7174250310079, -122.433015275935)
69630 177417 3 88 1x Rolph St 1 11 1 2     7 Width 4ft   6000503.4246 2088653.73075 37.7150736797726 -122.440171325345 (37.7150736797726, -122.440171325345)
164901 230299 2 88 590 York St 5 1 1 1     7 Width 3ft   6009785.6882 2105558.56974 37.762014809365 -122.409279952113 (37.762014809365, -122.409279952113)
164626 230310 2 88 322 Fair Oaks St 1 1 1 1     7 Width 3ft   6005451.16912 2101791.33905 37.7514270756131 -122.424003479091 (37.7514270756131, -122.424003479091)
161292 230324 2 88 14 Chattanooga St 1 1 1 1     7 Width 3ft   6004676.492190001 2103485.42894 37.7560348834086 -122.426803038952 (37.7560348834086, -122.426803038952)
42139 230337 2 88 823 Castro St 3 1 1 1     7 Width 3ft   6002470.86224 2103420.79735 37.7557324674964 -122.43442621241199 (37.7557324674964, -122.434426212412)
33482 230350 2 88 35 Sussex St 1 1 1 1     7 Width 3ft   6002643.63835 2096299.62877 37.7361892128574 -122.433319865541 (37.7361892128574, -122.433319865541)
Powered by Datasette · Query took 8.525ms · Data source: data.sfgov.org