USGS National Trails GeoPackages

python -m pip install requests

import io
import sqlite3
import tempfile
import zipfile
from pathlib import Path
import requests

url = "https://prd-tnm.s3.amazonaws.com/StagedProducts/Tran/GPKG/TRAN_District_of_Columbia_State_GPKG.zip"
response = requests.get(url, timeout=35)
response.raise_for_status()
with zipfile.ZipFile(io.BytesIO(response.content)) as archive:
    member = next(name for name in archive.namelist() if name.endswith(".gpkg"))
    with tempfile.TemporaryDirectory() as directory:
        path = Path(directory) / "trails.gpkg"
        path.write_bytes(archive.read(member))
        with sqlite3.connect(path) as db:
            print(db.execute("SELECT name, lengthmiles FROM Trans_TrailSegment LIMIT 1").fetchone())