WWDH Reservoir Conditions

Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...

This resource contains some files/folders that have non-preferred characters in their name. Show non-conforming files/folders.

This resource contains content types with files that need to be updated to match with metadata changes. Show content type files that need updating.

Authors:
Owners:		This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource.
Type:	Resource
Storage:	The size of this resource is 4.4 KB
Created:	Jan 29, 2026 at 3:47 a.m. (UTC)
Last updated:	Jan 29, 2026 at 4:02 a.m. (UTC)
Citation:	See how to cite this resource

Sharing Status:	Public
Views:	45
Downloads:	0
+1 Votes:	Be the first one to this.
Comments:	No comments (yet)

Abstract

This resource contains daily statistical summaries of reservoir storage conditions for reservoirs in the Reclamation Information Sharing Environment (RISE) network. Data is generated daily by querying the Western Water Data Hub (WWDH) API's Environmental Data Retrieval (EDR) endpoint for the rise-edr collection. Each daily file includes current storage values along with statistical benchmarks (percentiles, mean, standard deviation) calculated from historical data (1990-10-01 to 2020-09-30).

Subject Keywords

Deleting all keywords will set the resource sharing status to private.

Coverage

Spatial

Coordinate System/Geographic Projection:

WGS 84 EPSG:4326

Coordinate Units:

Decimal degrees

Place/Area Name:

Bureau of Reclamation Regions

North Latitude

50.8085°

East Longitude

-92.2852°

South Latitude

25.2124°

West Longitude

-127.5293°

Content

Learn more about the BagIt download

Select a file to see file type metadata.

readme.md

RISE Reservoir Conditions - Daily Statistics and Historical Archive

The resource maintains two types of files: 1. Daily snapshots: Individual CSV files named reservoir_conditions_YYYY-MM-DD.csv containing conditions for a specific date 2. Historical archive: A cumulative file reservoir_conditions_historical.csv that concatenates all daily snapshots into a continuous time series for trend analysis

Statistical metrics calculated for each reservoir include: - Current storage value (with up to 7-day lookback for most recent valid measurement) - Percentiles: 10th, 25th, 50th (median), 75th, 90th - Mean and standard deviation - Percent of median, percent of average, percent of maximum capacity

This dataset supports water resource monitoring, drought analysis, and reservoir management decision-making across the western United States.

Data Sources

Primary: Western Water Data Hub (WWDH) API - Environmental Data Retrieval endpoint
Collection: rise-edr
API URL: https://api.wwdh.internetofwater.app/collections/rise-edr
Historical Baseline: 1990-10-01 to 2020-09-30

Related Resources

[WWDH Reservoir Conditions Web Portal] (when available
[Original RISE Teacup Visualization Application] (link to GitHub)
Internet of Water Initiative

File Naming Convention

Daily files: reservoir_conditions_YYYY-MM-DD.csv - Example: reservoir_conditions_2025-01-28.csv

Historical archive: reservoir_conditions_historical.csv - Continuously updated with all daily records - Sorted chronologically by date and location

File Structure

Each CSV file contains the following columns:

Column Name	Data Type	Description
`date`	Date (YYYY-MM-DD)	Date of observation
`location_id`	String	WWDH EDR location identifier
`location_name`	String	Human-readable reservoir name
`current_value`	Numeric	Most recent valid storage value (acre-feet)
`percentile_10`	Numeric	10th percentile of historical values
`percentile_25`	Numeric	25th percentile of historical values
`percentile_50`	Numeric	50th percentile (median) of historical values
`percentile_75`	Numeric	75th percentile of historical values
`percentile_90`	Numeric	90th percentile of historical values
`mean`	Numeric	Mean of historical values
`std_dev`	Numeric	Standard deviation of historical values
`percent_median`	Numeric	(current_value / percentile_50) × 100
`percent_average`	Numeric	(current_value / mean) × 100
`percent_full`	Numeric	(current_value / max_capacity) × 100
`max_capacity`	Numeric	Maximum storage capacity (acre-feet)

Missing or unavailable values are represented as NA.

Update Frequency

Daily - Automated updates occur daily at approximately 06:00 Mountain Time via scheduled containerized workflow

Processing Workflow

Data is generated using the rezviz_data_generator.R script, which: 1. Queries WWDH API for current reservoir conditions 2. Retrieves historical data for statistical calculations 3. Computes percentiles and summary statistics 4. Generates daily CSV file 5. Appends to historical archive 6. Posts both files to this HydroShare resource

The workflow runs in a Docker container based on the Rocker R environment and is fully reproducible. Source code and documentation available at: [GitHub repository URL]

Data Quality and Limitations

Current values may lag by up to 7 days if recent data is unavailable
Historical statistics based on 1990-2020 baseline; conditions outside this range may not be representative
RISE data availability varies by reservoir and managing agency
Statistical metrics assume stationarity in historical patterns; climate change may affect baseline relevance
Missing data indicated by NA values; users should check data completeness before analysis

Related Geospatial Features

This HydroShare resource is linked to the following geospatial features

Geoconnex, through the Internet of Water: This field allows you to relate this resource to overlapping geospatial features in order to increase the FAIRness and discoverability of your data. Below, collections of reference features within the United States are provided. Search these collections to find features that overlap with your data, or provide a URL that resolves to a geospatial feature not yet in the Geoconnex collections.
Learn more about Related Geospatial Features

We highly recommend that you add Spatial Coverage to this resource before searching for related geospatial features. Otherwise query times can be excessive.

Please note: your resource spatial extent (${(resSpatialExtentArea * 1e-6).toFixed(0)} square kilometers) is larger than a big US state. You might experience reduced performance during your searches.

${ searchResultString }

${ messageObj.message }

${value.text}

Click a point to search for features that overlap with that location.

Select a feature for more information.

Related Resources

The content of this resource was created by a related App or software program

https://github.com/cgs-earth/teacup-generator/tree/add-R-workflow/R-workflow

Credits

Funding Agencies

This resource was created using funding from the following sources:

Agency Name	Award Title	Award Number
United States Bureau of Reclamation	None	None

Contributors

People or Organizations that contributed technically, materially, financially, or provided general support for the creation of the resource's content but are not considered authors.

Name	Organization	Address	Phone	Author Identifiers
Kyle Onda	Internet of Water;Center for Geospatial Solutions;Lincoln Institute of Land Policy	North Carolina, US

How to Cite

Onda, K. (2026). WWDH Reservoir Conditions, HydroShare, http://www.hydroshare.org/resource/22b2f10103e5426a837defc00927afbd

This resource is shared under the Creative Commons Attribution CC BY.

http://creativecommons.org/licenses/by/4.0/

Comments

There are currently no comments

Notifications (${tasks.length})