A composite of U.S. federal-agency-managed trails in a single harmonized table:
Total: 127,619 segments. One row per published trail segment, harmonized schema, recomputed length_miles, and a nts_designation column flagging the 11 National Scenic Trails, 19 National Historic Trails, and National Recreation Trails where applicable.
Do not
SUM(length_miles)on the hex asset. Each segment'slength_milesis repeated on every hex cell it touches after circumradius buffering, so SUM overcounts by the cell-per-segment factor.
Highlight the National Scenic Trails:
mapservices.nps.gov/arcgis/rest/services/NationalDatasets/NPS_Public_Trails_Geographic/FeatureServer/0. U.S. federal-government work; public domain. Filtered to DATAACCESS='Unrestricted' AND PUBLICDISPLAY='Public Map Display' to respect agency visibility flags.services1.arcgis.com/KbxwQRRfWyEYLgp4/arcgis/rest/services/BLM_Natl_GTLF_Public_Managed_Trails/FeatureServer/2. U.S. federal-government work; public domain (with BLM "as is" disclaimer in the dataset license).Pipeline source: https://github.com/boettiger-lab/data-workflows/tree/main/catalog/trails
s3://public-trails/raw/.ogr2ogr -t_srs EPSG:4326 -lco GEOMETRY_NAME=geometry.admin_agency, nts_designation, source_dataset added.NATIONAL_TRAIL_DESIGNATION integer code is mapped (1 = not designated, 2 = NRT, 3 = NST/NHT). For all three sources, trail-name patterns (%PACIFIC CREST%, %CONTINENTAL DIVIDE%, %APPALACHIAN%, etc.) identify the specific named NST/NHT. BLM uses ROUTE_SCNDRY_SPCL_DSGNTN_NM for the canonical designation name, which carries the same patterns.length_miles recomputed by reprojecting to EPSG:5070 (USA Contiguous Albers Equal Area, meters) and dividing ST_Length by 1609.344. CONUS-accurate; AK/HI/PR/VI lengths are approximate.NATIONAL_TRAIL_DESIGNATION numeric code. The 11 National Scenic Trails are matched by name; non-PCT/AT-class connectors that share part of an NST name may be tagged with that NST's code (rare).