environmental_data.RdEnvironmental gage data for each tributary in the SR JPE. Data includes flow and temperature measurements from gages located on tributaries and the Sacramento River mainstem. Data were compiled from CDEC, USGS, and USFWS sources and are summarized by week and statistic type. Interpolation was performed to fill in data gaps where temperature data were missing or the time series was incomplete. For the Feather River and Yuba River, temperature values were interpolated using regression models based on nearby gages and historical data, allowing for consistent estimation across incomplete records. The temporal coverage of flow data ranges from 1930 to 2025, and temperature data ranges from 1994 to 2025.
environmental_datayear: Year associated with environmental measure
week: Week associated with environmental measure
statistic: Summary static used to summarize flow and temperature measures into a single daily reccord (min, mean, max)
value: Flow or temperature measurements
stream: Stream environmental data is collected on
gage_agency: Agency providing flow or temperature data, most data pulled from CDEC or USGS
gage_number: Unique identifier of gage used to query flow and temperature data
parameter: Parameter measured, includes "flow" and "temperature"
site_group: Site group, used to separate traps within the same stream that have unique environmental conditions.
#' @details Gage Information Deer creek
USGS - 11383500
CDEC - DCV
CDEC - DCV
Sacramento River
USGS - 11383500
USGS - 11377100
USGS - 11383500
Battle Creek
USGS - 11376550
USFWS - UBC
USFWS - UBC
Butte Creek
USGS - 11376550
USGS - BCK
Clear Creek
USFWS - UCC
USGS - 11372000
USFWS - LCC
USFWS - UCC
USFWS - LCC
Mill Creek
USGS - 11381500
CDEC - MLM
CDEC - MLM
Feather River
USGS - 11407000
CDEC - TFB
CDEC - GRL
CDEC - FSB
CDEC - FRA
interpolated
CDEC - GRL
CDEC - FRA
interpolated
Yuba River
USGS - 11421000
CDEC - YR7
interpolated
CDEC - YR7
interpolated
USGS/CDEC/FWS. See data-raw/pull_environmental_data.R for more details.