sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3203 2528 1 97 1570 Burke Ave 6 1 1 1   08/24/2017 12:00:00 AM 3 3X3   6016517.59351 2098961.55525 37.744275647795604 -122.38553691568998 (37.7442756477956, -122.38553691569)
14232 2518 3 97 1555 Burke Ave 6 1 1 2     6 3X3   6016498.61775 2098890.1921900003 37.7440786495081 -122.38559755790399 (37.7440786495081, -122.385597557904)
16898 2502 3 97 1500 Burke Ave 6 1 1 2     12 3X3   6016691.633780001 2098834.3481 37.743935990943996 -122.38492625536001 (37.743935990944, -122.38492625536)
79948 16484 3 97 220 Newhall St 6 1 1 2     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.38421892893899 (37.7425024549748, -122.384218928939)
102582 16504 3 97 325 Newhall St 6 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
108484 16515 3 97 330 Newhall St 6 1 1 2     6 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
110164 2510 3 97 1501 Burke Ave 6 1 1 2     12 3X3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
118155 14929 3 97 320X Newhall St 6 1 1 2     6 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
127870 4917 3 97 195X Newhall St 6 1 1 2   01/26/2015 05:50:00 AM 3 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
Powered by Datasette · Query took 5.344ms · Data source: data.sfgov.org