Wadeable Stream Habitat Data Integrated from Multiple Monitoring Programs for the US from 2000-2022

Wadeable stream habitat data from four long-term monitoring programs (AIM, AREMP, NRSA, PIBO MP) were obtained, pre-processed, transformed, and combined using R code following the Stream Habitat Metrics Integration (SHMI) Data Exchange Standard (Scully et al., 2023b). The dataset includes 26 stream habitat metrics collected between 2000 and 2022 across the United States at ~12,000 locations from ~19,000 data collection events for a total of ~200,000 measurements. Measurements include reach characteristics (sampled reach length, channel gradient, sinuosity), channel dimensions (bankfull width and height, average bankfull width to depth ratio, mean thalweg depth, average wetted width), channel substrate particle sizes (percent fines, percent bedrock, fine sediment percentiles), pools (residual pool depth, pool tail fines), bank characterizations (angle), and water quality/chemistry (specific conductance, pH, specific conductance, turbidity, total nitrogen, total phosphorous). The dataset consists of 4 csv files: 'RecordLevel.csv', 'Location.csv', 'Event.csv', and 'MeasurementOrFact.csv'. The 4 csv data tables may be linked in a database structure using the 'entity relationship diagram.jpg' or by linking the following: Join RecordLevel primary key 'datasetID' to Location foreign key 'datasetID'. Join Location primary key 'locationID to Event foreign key 'locationID'. Join Event primary key 'eventID' to MeasurementOrFact foreign key 'eventID'. An analysis-ready file ('AnalysisStreamHabitatMonitoringMetricDataset.csv') is also published for user convenience.