sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31206 246759 2 45 70 Waltham St 3 7 1 1     8     6009196.74806 2098886.80636 37.7436626276403 -122.410845655606 (37.7436626276403, -122.410845655606)
38193 246761 2 45 70 Waltham St 5 7 1 1     16     6009235.422669999 2098888.8268 37.7436703438078 -122.410712070303 (37.7436703438078, -122.410712070303)
38403 197339 2 45 696 Amador St 1 7 1 1     24     6016827.1128 2099574.92506 37.745976956489294 -122.384509368331 (37.7459769564893, -122.384509368331)
43322 246767 2 45 70 Waltham St 11 7 1 1     13     6009322.267109999 2098890.11567 37.743678751571295 -122.410411873024 (37.7436787515713, -122.410411873024)
132831 201725 2 45 1915 Quesada Ave 1 7 1 1     2     6013561.8417 2095888.78027 37.735674466103795 -122.39554210998199 (37.7356744661038, -122.395542109982)
149552 246638 2 45 3320 Harrison St 9 7 1 1     20     6009023.34848 2099240.7850900004 37.7446248509555 -122.411470234758 (37.7446248509555, -122.411470234758)
157777 197340 2 45 696 Amador St 2 7 1 1     18     6016813.36643 2099575.53369 37.745977867490204 -122.384556944272 (37.7459778674902, -122.384556944272)
166990 136321 2 45 150 Francisco St 13 7 1 1     7     6010437.78302 2121369.6786 37.8054648831642 -122.408139740375 (37.8054648831642, -122.408139740375)
172123 240382 2 45 200 Kingston St 14 7 1 1     2     6006224.51109 2098080.7337 37.7412822264814 -122.4210657258 (37.7412822264814, -122.4210657258)
185231 197341 2 45 696 Amador St 3 7 1 1     21     6016796.90554 2099573.89089 37.745972446388 -122.384613749949 (37.745972446388, -122.384613749949)
Powered by Datasette · Query took 23.167ms · Data source: data.sfgov.org