sf-trees

Data source: data.sfgov.org

Custom SQL query returning 19 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29637 247866 2 141 398 Mayflower St 1 17 1 1     24     6009543.35492 2098406.93767 37.7423644418716 -122.40961330563101 (37.7423644418716, -122.409613305631)
30996 247856 2 141 80 Bradford St 5 17 1 1     32     6009566.847130001 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008)
31185 247857 2 141 80 Bradford St 6 17 1 1     8     6009575.64001 2098128.64759 37.7416021270253 -122.409482036966 (37.7416021270253, -122.409482036966)
31946 126123 2 141 2836 Larkin St 6 17 1 1     8     6006504.36606 2120972.74597 37.8041539827815 -122.42172367341001 (37.8041539827815, -122.42172367341)
48633 247854 2 141 80 Bradford St 3 17 1 1     21     6009576.04366 2098148.42798 37.74165646228621 -122.409482036964 (37.7416564622862, -122.409482036964)
50293 189299 2 141 1750 22nd St 11 17 1 1     2     6012797.06573 2103802.01858 37.7573599607159 -122.39874142030399 (37.7573599607159, -122.398741420304)
72898 248187 2 141 216 Esmeralda Ave 6 17 1 1     9     6007416.255969999 2098719.21061 37.7431024507267 -122.416990309471 (37.7431024507267, -122.416990309471)
76682 247868 2 141 397 Mayflower St 1 17 1 1     4     6009691.8921300005 2098418.67435 37.7424049905119 -122.40910053468599 (37.7424049905119, -122.409100534686)
122555 126122 2 141 2833 Larkin St 1 17 1 1     9     6006473.28428 2120942.81763 37.804070054442 -122.42182910722799 (37.804070054442, -122.421829107228)
133758 247986 2 141 495 Peralta Ave 2 17 1 1     30     6009773.63884 2099723.8583400003 37.7459933196391 -122.408909944065 (37.7459933196391, -122.408909944065)
147311 205445 2 141 300 Melrose Ave 1 17 1 1     14     5998069.65907 2095547.09422 37.7338623834248 -122.449079720856 (37.7338623834248, -122.449079720856)
150791 205420 2 141 714 Detroit St 3 17 1 1     12     5999461.8044300005 2095388.23948 37.7335057294051 -122.444255259197 (37.7335057294051, -122.444255259197)
162439 247855 2 141 80 Bradford St 4 17 1 1     35     6009572.47396 2098147.90996 37.741654839898295 -122.409494343289 (37.7416548398983, -122.409494343289)
165904 205419 2 141 714 Detroit St 2 17 1 1     8     5999453.91846 2095387.09878 37.733502147395896 -122.444282441206 (37.7335021473959, -122.444282441206)
170181 248235 2 141 301 Esmeralda Ave 1 17 1 1     29     6006740.56255 2099063.9997900003 37.7440111320042 -122.419351135062 (37.7440111320042, -122.419351135062)
173566 187579 2 141 299 Elliot St 1 17 1 1     19     6008885.34324 2088289.2599799999 37.7145465601547 -122.411173984595 (37.7145465601547, -122.411173984595)
174262 205433 2 141 231 Edna St 4 17 1 1     2     5998775.87477 2095301.89625 37.733229493638 -122.44662049415001 (37.733229493638, -122.44662049415)
182461 205446 2 141 300 Melrose Ave 2 17 1 1     17     5998064.66474 2095546.64669 37.73386086896821 -122.449096955455 (37.7338608689682, -122.449096955455)
188250 245744 2 141 24 Saturn St 2 17 1 1     16 Width 3ft   6000500.5382900005 2106017.92887 37.762751514198705 -122.441426555002 (37.7627515141987, -122.441426555002)
Powered by Datasette · Query took 4.719ms · Data source: data.sfgov.org