sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
60482 247587 2 66 800 Tompkins Ave 8 7 1 1     6     6008949.04431 2096428.8077599998 37.7368996080238 -122.41152853331499 (37.7368996080238, -122.411528533315)
63732 247588 2 66 800 Tompkins Ave 9 7 1 1     6     6008943.011630001 2096440.0672900002 37.7369301858647 -122.411550186315 (37.7369301858647, -122.411550186315)
76330 126383 2 66 1116 Greenwich St 3 7 1 1     4     6007504.98606 2119897.57415 37.801258207159 -122.418184672095 (37.801258207159, -122.418184672095)
115431 223053 2 66 701 Church St 13 7 1 1     4 Width 3ft   6004342.543869999 2104435.23189 37.7586239308804 -122.42802562498998 (37.7586239308804, -122.42802562499)
148524 126381 2 66 1022 Vallejo St 1 7 1 1     5     6008596.5256900005 2118672.84077 37.7979567725457 -122.414320748412 (37.7979567725457, -122.414320748412)
156749 126384 2 66 1120 Greenwich St 2 7 1 1     4     6007500.24433 2119896.2377400002 37.8012542708165 -122.418200985801 (37.8012542708165, -122.418200985801)
159806 249677 2 66 2400 Baker St 9 7 1 1     9     5999741.70445 2117184.6990900002 37.79336934518339 -122.444853823654 (37.7933693451834, -122.444853823654)
164342 249691 2 66 2400 Baker St 23 7 1 1     1     5999714.93782 2117284.79533 37.793642655433004 -122.44495363669701 (37.793642655433, -122.444953636697)
177824 249686 2 66 2400 Baker St 18 7 1 1     4     5999708.23219 2117360.34158 37.7938497027636 -122.444982272037 (37.7938497027636, -122.444982272037)
187180 223054 2 66 701 Church St 15 7 1 1     5 Width 3ft   6004339.171130001 2104460.25399 37.758692444824206 -122.42803907256099 (37.7586924448242, -122.428039072561)
Powered by Datasette · Query took 24.633ms · Data source: data.sfgov.org