There is a newer version of the record available.

Published April 30, 2025 | Version 3.2
Dataset Open

WECC ADS 2034 Hydropower Generation Datasets

Description

Every two years the WECC (Western Electricity Coordinating Council) releases an Anchor Data Set (ADS) to be analyzed with a Production Cost Models (PCM) and which represents the expected loads, resources, and transmission topology 10 years in the future from a given reference year. For hydropower resources, the WECC relies on members to provide data to parameterize the hydropower representation in production cost models. The datasets consist of plant-level hydropower generation, flexibility, ramping, and mode of operations and are tied to the hydropower representation in those production cost models. 

In 2022, PNNL supported the WECC by developing the WECC ADS 2032 hydropower dataset [1]. The WECC ADS 2032 hydropower dataset (generation and flexibility) included an update of the climate year conditions (2018 calendar year), consistency in representation across the entire US WECC footprint, updated hydropower operations over the core Columbia River, and a higher temporal resolution (weekly instead of monthly)[1] associated with a GridView software update (weekly hydro logic). Proprietary WECC utility hydropower data were used when available to develop the monthly and weekly datasets and were completed with HydroWIRES B1 methods to develop the Hydro 923 plus (now RectifHydPlus weekly hydropower dataset) [2] and the flexibility parameterization [3]. The team worked with Bonneville Power Administration to develop hydropower datasets over the core Columbia River representative of the post-2018 change in environmental regulation (flex spill). Ramping data are considered proprietary, were leveraged from WECC ADS 2030, and were not provided in the release, nor are the WECC-member hydropower data.

This release represents the WECC ADS 2034 hydropower dataset. The generator database was first updated by WECC. Based on a review of hourly generation profiles, 16 facilities were transitioned from fixed schedule to dispatchable (380.5MW). The operations of the core Columbia River were updated based on Bonneville Power Administration's long-term hydro-modeling using 2020-level of modified flows and using fiscal year 2031 expected operations. The update was necessary to reflect the new environmental regulation (EIS2023). The team also included a newly developed extension over Canada [4] that improves upon existing data and synchronizes the US and Canadian data to the same 2018 weather year. Canadian facilities over the Peace River were not updated due to a lack of available flow data. The team was able to modernize and improve the overall data processing using modern tools as well as provide thorough documentation and reproducible workflows [5,6]. The datasets have been incorporated into the 2034 ADS and are in active use by WECC and the community.

WECC ADS 2034 hydropower datasets contain generation at weekly and monthly timesteps, for US hydropower plants, monthly generation for Canadian hydropower plants, and the two merged together. Separate datasets are included for generation by hydropower plant and generation by individual generator units. Only processed data are provided. Original WECC-utility hourly data are under a non-disclosure agreement and for the sole use of developing this dataset. 

[1] Voisin, N., Harris, K. M., Oikonomou, K., Turner, S., Johnson, A., Wallace, S., Racht, P., et al. (2022). WECC ADS 2032 Hydropower Dataset (PNNL-SA-172734). See presentation (Voisin N., K.M. Harris, K. Oikonomou, and S. Turner. 04/05/2022. "WECC 2032 Anchor Dataset - Hydropower." Presented by N. Voisin, K. Oikonomou at WECC Production Cost Model Dataset Subcommittee Meeting, Online, Utah. PNNL-SA-171897.). 

[2] Turner, S. W. D., Voisin, N., Oikonomou, K., & Bracken, C. (2023). Hydro 923: Monthly and Weekly Hydropower Constraints Based on Disaggregated EIA-923 Data (v1.1.0) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.8212727

[3] Stark, G., Barrows, C., Dalvi, S., Guo, N., Michelettey, P., Trina, E., Watson, A., Voisin, N., Turner, S., Oikonomou, K. and Colotelo, A. 2023 Improving the Representation of Hydropower in Production Cost Models, NREL/TP-5700-86377, United States. https://www.osti.gov/biblio/1993943

[4] Son, Y., Bracken, C., Broman, D., & Voisin, N. (2025). Monthly Hydropower Generation Dataset for Western Canada (1.1.0) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.14984725

[5] https://github.com/HydroWIRES-PNNL/weccadshydro/

[6] Voisin, N., Broman, D., Abernethy-Cannella, K., Bracken, C., Son, Y., & Harris, K. (2025). WECC ADS 2034 Hydropower Generation Code (weccadshydro). Zenodo. https://doi.org/10.5281/zenodo.15417594
 

Dataset Files:

File Description Timestep Spatial Extent
US_Monthly_Plant.csv Generation data for US plants at a monthly timestep Monthly US
US_Weekly_Plant.csv Generation data for US plants at a weekly timestep Weekly US
US_Monthly_Unit.csv Generation data for US plants by generator units at a monthly timestep Monthly US
US_Weekly_Unit.csv Generation data for US plants by generator units at a weekly timestep Weekly US
Canada_Monthly_Plant.csv Generation data for Canadian plants at a monthly timestep Monthly Canada
Canada_Monthly_Unit.csv Generation data for Canadian plants by generator units at a monthly timestep Monthly Canada
Merged_Monthly_Plant.csv Generation data for US and Canadian plants at a monthly timestep Monthly US and Canada
Merged_Monthly_Unit.csv Generation data for US and Canadian plants by generator units at a monthly timestep Monthly US and Canada
  Overview presentation of the WECC ADS 2034 dataset N/A N/A
PNNL-SA-171897.pdf Overview presentation of the WECC ADS 2032 dataset N/A N/A

Data Description:

Each dataset contains the following column headers:

Column Name Unit Description
Source N/A Indicates the method used to develop the data (see below)
Generator Name N/A Generator name used in WECC PCM (in unit datasets)
EIA ID N/A Energy Information Administration (EIA) plant ID (in plant datasets)
DataTypeName N/A Data type (see below)
DatatypeID N/A Data type ID
Year year Year (not used)
Week1 [Month1] MWh generation MWh value for data type; subsequent week or month columns contain data for each week or month in the dataset period

 

Data Source (Method)

The dataset contains data from four different data sources, developed using different methods:

Source Description
PNNL

Weekly / monthly aggregation performed by PNNL using hourly observed facility-scale generation provided in 2022 by asset owners for year 2018

BPA

BPA long-term hydromodeling (HYDSIM) with 2020-Level Modified Flows for Water Years 1989-2018 Using FY 2031 expected operations (EIS2023). Jan-Sept comes from 2018 and Oct-Dec from year 2007. 
Weekly disaggregation performed by PNNL based on daily observed 2018 flow. Hourly flexibility was evaluated by PNNL using hourly observed facility-scale generation in years 2018, 2019 and 2021. 

CAISO

Weekly / monthly aggregation performed by CAISO using hourly observed facility-scale generation for 2018. Daily flexibility also directly provided by CAISO

Canada

Monthly data developed by PNNL using a scaling and disaggregation method for Canadian hydropower facilities (presented in [5] Son et al., 2025)

Data Type

The 'data types' field in each dataset refers to inputs required by GridView, a grid modeling software platform. Dataset development focused on four variables - MinGen, MaxCap, MonthlyEnergy / WeeklyEnergy, and DailyOpRange. The other variables in these datasets were included for compatibility with GridView but were not developed as part of the ADS 2034.

Data Type Description
MinGen

Minimum hourly generation within the week or month (MW). This is a normal operating range, a zero-value might be considered for studies outside of normal operations. 

MaxCap

Maximum hourly generation within the week or month (MW). This is a normal operating range, an operational capacity might be considered for studies outside of normal operations. 

WeeklyEnergy (in weekly datasets)

Total weekly generation (MW). The weekly targets reflect the coincident wind-solar-load conditions and observed water storage strategies. 

MonthlyEnergy (in monthly datasets)

Total monthly generation (MW). While the most flexible option, this representation might results in violating water management rules in the production cost model stage. 

DailyOpRange

Daily operating range (MW) derived from hourly generation

 

The data were developed using Python code. Requests for this code and lookup tables should be made to: Nathalie Voisin (nathalie.voisin@pnnl.gov). Requests for WECC-member provided hydropower data need to be directed to WECC (https://www.wecc.org/committees/pcds). 

Files

US_Monthly_Unit.csv

Files (8.6 MB)

Name Size Download all
md5:34e82849762d84759a2969b88edcf31d
190.6 kB Preview Download
md5:24c39b8af2d8c02eac07dfded8c06122
296.1 kB Preview Download
md5:654f535cd0ee7a24f8f1967056066c2c
387.7 kB Preview Download
md5:6f929e6fc71419a4218eece09305c081
708.9 kB Preview Download
md5:be9459c88b9566311933a87be412e0b2
4.6 MB Preview Download
md5:5d9ad71c091a76fd66142d3826282098
198.5 kB Preview Download
md5:fc623bde51ca4eb067dd3c502e01faf1
412.9 kB Preview Download
md5:f82f7c42a6d10cfa2c8f51999ef4047c
634.0 kB Preview Download
md5:1cd86292cde7ba0ac24c4077a4a69f7e
1.2 MB Preview Download

Additional details

Related works

Is derived from
Dataset: 10.5281/zenodo.15417594 (DOI)