sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9916 173733 3 47 14 Richland Ave 1 17 1 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
34240 247903 2 47 582 Esmeralda Ave 1 17 1 1     31     6009830.823 2098729.7061900003 37.743266798225605 -122.40864208815701 (37.7432667982256, -122.408642088157)
51235 201716 2 47 1 Hawkins Ln 1 17 1 1     17     6017085.9132900005 2095352.6498 37.7343977480421 -122.38332060578001 (37.7343977480421, -122.38332060578)
136128 218153 2 47 22 Ashton Ave 1 17 1 1     20     5994153.71185 2090014.1877400002 37.7184456203604 -122.46221709555 (37.7184456203604, -122.46221709555)
152144 223808 2 47 6 Miguel St 1 17 1 1     37     6003326.01138 2097344.7820099997 37.739097652747205 -122.431035195413 (37.7390976527472, -122.431035195413)
158925 248059 2 47 18 Rutledge St 1 17 1 1     41     6010698.28988 2099365.5413599997 37.7450612101031 -122.40568737459299 (37.7450612101031, -122.405687374593)
166544 176163 2 47 654 Peru Ave 1 17 1 1     23     6005125.75661 2092550.7271200002 37.726036063007705 -122.42447158070601 (37.7260360630077, -122.424471580706)
171449 249865 2 47 1497 Montgomery St 1 17 1 1     24 Width 0ft   6011350.601919999 2120707.91777 37.8036989186248 -122.404934168095 (37.8036989186248, -122.404934168095)
186554 250195 2 47 201 Union St 1 17 1 1     18 Width 0ft   6011875.28376 2119779.56963 37.8011792152183 -122.40305313080401 (37.8011792152183, -122.403053130804)
Powered by Datasette · Query took 4.891ms · Data source: data.sfgov.org