sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3214 2529 1 97 1570 Burke Ave 7 1 1 1   08/24/2017 12:00:00 AM 3 3X3   6016429.35383 2099026.76072 37.744449806015204 -122.385846576558 (37.7444498060152, -122.385846576558)
9322 16485 1 97 220 Newhall St 7 1 1 1     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.38421892893899 (37.7425024549748, -122.384218928939)
15581 2519 3 97 1555 Burke Ave 7 1 1 2     6 3X3   6016516.51157 2098877.59586 37.7440450526322 -122.38553480681101 (37.7440450526322, -122.385534806811)
16138 14974 1 97 400X Mendell St 7 1 1 11     12 3X3   6016589.22096 2097595.13367 37.7405276953073 -122.385194050084 (37.7405276953073, -122.385194050084)
16423 2503 3 97 1500 Burke Ave 7 1 1 2     12 3X3   6016672.43224 2098847.72364 37.743971655361705 -122.384993582204 (37.7439716553617, -122.384993582204)
92209 14930 3 97 320X Newhall St 7 1 1 2     6 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
110644 16505 3 97 325 Newhall St 7 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
122367 4918 3 97 195X Newhall St 7 1 1 2     12 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
143682 16516 3 97 330 Newhall St 7 1 1 2     6 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
145072 2511 3 97 1501 Burke Ave 7 1 1 2     12 3X3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
Powered by Datasette · Query took 5.865ms · Data source: data.sfgov.org