DART River Environment Metadata & Glossary


|DART| |Metadata & Glossary| |Data Sites Map|
 Graphics&Text  Composite Report

River Environment Metadata

Abbrev Project/Water Quality Monitor Name1 2 River Primary Data Source
ALF |Project Inventory| |Project Information| Albeni Falls Forebay Pend Oreille U.S. Army Corps of Engineers
ANQW |Project Inventory| |Project Information| Anatone WA Snake U.S. Army Corps of Engineers
BON |Project Inventory| |Project Information| Bonneville Forebay Columbia U.S. Army Corps of Engineers
CCIW |Project Inventory| |Project Information| Cascade Island (below BON) Columbia U.S. Army Corps of Engineers
CIBW |Project Inventory| |Project Information| Boundary (US/Canada) Columbia U.S. Army Corps of Engineers
CHJ |Project Inventory| |Project Information| Chief Joseph Forebay Columbia U.S. Army Corps of Engineers
CHQW |Project Inventory| |Project Information| Chief Joseph Tailrace Columbia U.S. Army Corps of Engineers
CWMW |Project Inventory| |Project Information| Camas/Washougal WA Columbia U.S. Army Corps of Engineers
DWR |Project Inventory| |Project Information| Dworshak Tailrace NF Clearwater U.S. Army Corps of Engineers
GCL |Project Inventory| |Project Information| Grand Coulee Forebay Columbia U.S. Army Corps of Engineers
GCGW |Project Inventory| |Project Information| Grand Coulee Downstream Columbia U.S. Army Corps of Engineers
HGH |Project Inventory| |Project Information| Hungry Horse Forebay SF Flathead U.S. Army Corps of Engineers
HGHM |Project Inventory| |Project Information| Hungry Horse Tailrace SF Flathead U.S. Army Corps of Engineers
IHR |Project Inventory| |Project Information| Ice Harbor Forebay Snake U.S. Army Corps of Engineers
IDSW |Project Inventory| |Project Information| Ice Harbor Tailrace Snake U.S. Army Corps of Engineers
JDA |Project Inventory| |Project Information| John Day Forebay Columbia U.S. Army Corps of Engineers
JHAW |Project Inventory| |Project Information| John Day Tailrace Columbia U.S. Army Corps of Engineers
KLAW |Project Inventory| Kalama WA Columbia U.S. Army Corps of Engineers
LEWI |Project Inventory| |Project Information| Lewiston ID Clearwater U.S. Army Corps of Engineers
LIB |Project Inventory| |Project Information| Libby Forebay Kootenai U.S. Army Corps of Engineers
LGS |Project Inventory| |Project Information| Little Goose Forebay Snake U.S. Army Corps of Engineers
LGSW |Project Inventory| |Project Information| Little Goose Tailrace Snake U.S. Army Corps of Engineers
LWG |Project Inventory| |Project Information| Lower Granite Forebay Snake U.S. Army Corps of Engineers
LGNW |Project Inventory| |Project Information| Lower Granite Tailrace Snake U.S. Army Corps of Engineers
LMN |Project Inventory| |Project Information| Lower Monumental Forebay Snake U.S. Army Corps of Engineers
LMNW |Project Inventory| |Project Information| Lower Monumental Tailrace Snake U.S. Army Corps of Engineers
MCN |Project Inventory| |Project Information| McNary Forebay (Washington) Columbia U.S. Army Corps of Engineers
MCQO |Project Inventory| |Project Information| McNary Forebay (Oregon) Columbia U.S. Army Corps of Engineers
MCPW |Project Inventory| |Project Information| McNary Tailrace Columbia U.S. Army Corps of Engineers
PAQW |Project Inventory| |Project Information| Pasco WA Columbia U.S. Army Corps of Engineers
PECK |Project Inventory| Peck ID Clearwater U.S. Army Corps of Engineers
PRD |Project Inventory| |Project Information| Priest Rapids Forebay Columbia U.S. Army Corps of Engineers [1961-1997] and Grant County PUD [1998-present]
PRXW |Project Inventory| |Project Information| Priest Rapids Downstream Columbia U.S. Army Corps of Engineers [1995-1997] and Grant County PUD [1998-present]
RIS |Project Inventory| |Project Information| Rock Island Forebay Columbia U.S. Army Corps of Engineers
RIGW |Project Inventory| |Project Information| Rock Island Tailrace Columbia U.S. Army Corps of Engineers
RRH |Project Inventory| |Project Information| Rocky Reach Forebay Columbia U.S. Army Corps of Engineers
RRDW |Project Inventory| |Project Information| Rocky Reach Tailrace Columbia U.S. Army Corps of Engineers
SKAW |Project Inventory| |Project Information| Skamania WA Columbia U.S. Army Corps of Engineers
TDA |Project Inventory| |Project Information| The Dalles Forebay Columbia U.S. Army Corps of Engineers
TDDO |Project Inventory| |Project Information| The Dalles Tailrace Columbia U.S. Army Corps of Engineers
TDTO |Project Inventory| |Project Information| The Dalles Tailrace Columbia U.S. Army Corps of Engineers
WAN |Project Inventory| |Project Information| Wanapum Forebay Columbia U.S. Army Corps of Engineers [1966-1998] and Grant County PUD [1999-present]
WANW |Project Inventory| |Project Information| Wanapum Downstream Columbia U.S. Army Corps of Engineers [1995-1998] and Grant County PUD [1999-present]
WRNO |Project Inventory| |Project Information| Warrendale OR Columbia U.S. Army Corps of Engineers
WANO |Project Inventory| Wauna Mill OR Columbia U.S. Army Corps of Engineers
WEL |Project Inventory| |Project Information| Wells Forebay Columbia U.S. Army Corps of Engineers
WELW |Project Inventory| |Project Information| Wells Tailrace Columbia U.S. Army Corps of Engineers
WFF |Project Inventory| |Project Information| Willamette Falls (Sullivan Project) Willamette Oregon Department of Fish & Wildlife

1. Click on the |Data Inventory| data inventory icon to view the DART River Environment Data Inventory for All Parameters and All Years. This information is displayed in a new browser window.

2. Click on the |Project Information| project information icon to view additional information about that project, including operating agency, construction dates, DART datasets, and project photo. This information is displayed in a new browser window.

USACE Data Disclaimer: These data are furnished with the understanding that the Corps of Engineers makes no warranties concerning the accuracy, reliability, or suitability of the data for any particular purpose.

Bonneville Dam: Unless specified otherwise, Lamprey is the combined count from the fish counting windows at Bonneville, reported daily. LPS is the count from the Lamprey Passage Systems (LPS) at Bonneville, reported approximately once a week, usually Wednesdays. The fish counting windows and LPS are mutually exclusive. LPS are located at Bradford Island, Washington Shore and Cascades Island. LPS were opened in 2009 and counting started in June 2010.

Inflow, Outflow, Spill, and Temperature (Scroll Case) data are collected at the project (dam). Spill Percent is calculated from the Outflow and Spill values. Temperature (WQM), Barometric Pressure, Dissolved Gas and Dissolved Gas Percent are measured at Water Quality Monitoring stations in the forebay and tailrace of most projects and other key locations in the basin (prior to 1995, these data are from a variety of sources within the U.S. Army Corps of Engineers). Turbidity is measured in the forebay or in the fish ladders at a project. Elevation is measured in the forebay of a project.

The USACE initially reported incorrect hourly Bonneville spillway discharge for 2002-2004. As of 18 July 2006, DART is reporting the USACE's Recalibrated Spillway Discharge at Bonneville for this period. The Water Quality reports for BON, CWMW, CCIW, and WRNO include the recalibrated spill at Bonneville.

River Environment Glossary

Barometric Pressure: Barometric Pressure is atmospheric pressure at the site, given in mm Hg. It represents an average of hourly measures. Barometric Pressure is measured at Water Quality Monitoring stations in the forebay and tailrace of most projects (see Data Sites Map) and other key locations in the basin. Prior to 1995, the data are from a variety of sources within the U.S. Army Corps of Engineers.

Dissolved Gas: Dissolved gas is a measure of the pressure of dissolved gas in the water column. When spillway water plunges into the tailrace nitrogen is forced into the water at higher than normal levels. This condition, called supersaturation, occurs when dissolved gas pressure in the water actually exceeds the atmospheric pressure. The dissolved gas value represents a daily average of hourly meeasures within the range of 600-900 mmHg and is derived from U.S. Army Corps of Engineers gas monitoring efforts. Often collected at irregular intervals, this parameter may be missing values for one or more days, or reported values may be obviously incorrect. Dissolved Gas is measured at Water Quality Monitoring stations in the forebay and tailrace of most projects (see Data Sites Map) and other key locations in the basin. Prior to 1995, the data are from a variety of sources within the U.S. Army Corps of Engineers.

Dissolved Gas Percent: Gas percent reflects the degree of total dissolved gas supersaturation in the river at the given location. Gas percent is the daily mean of hourly observations. When gas pressure is exactly the same as the atmospheric pressure, the water is considered to be 100% saturated. If the gas pressure value is higher than atmospheric pressure, gas percent values rise above 100%. Daily averages are calculated from hourly values within the range of 90% to 200%. Gas percent data is often found to be quite noisy due to rapid fluctuations in spill volumes and atmospheric pressures. Dissolved Gas Percent is measured at Water Quality Monitoring stations in the forebay and tailrace of most projects (see Data Sites Map) and other key locations in the basin. Prior to 1995, the data are from a variety of sources within the U.S. Army Corps of Engineers.

Elevation: Elevation is given in feet above mean sea level and is a daily average of hourly measures. At most sites this will change less than a fraction of a foot over normal operations. Elevation is measured in the forebay of a project.

Elevation 10 Year Average: Daily average of elevation for a selected 10 year range. For each month and day, the data is summed for the selected 10 years and divided by the number of non-null data points available during that 10 year span.

Inflow: Inflow measurements represent the 24-hour average of hourly measures, reported by the U.S. Army Corps of Engineers. Inflow is given in kcfs, thousands of cubic feet per second.

Outflow: Outflow measurements represent the 24-hour average of hourly measures, reported by the U.S. Army Corps of Engineers. Outflow is given in kcfs, thousands of cubic feet per second. This represents the total outflow at any project, including spill and fish ladder flow.

Outflow 10 Year Average: Daily average of outflow for a selected 10 year range. For each month and day, the data is summed for the selected 10 years and divided by the number of non-null data points available during that 10 year span.

Spill: Spill also is given as a daily average of 24 hourly measures taken by the U.S. Army Corps of Engineers. It is also given in kcfs.

Spill 10 Year Average: Daily average of spill for a selected 10 year range. For each month and day, the data is summed for the selected 10 years and divided by the number of non-null data points available during that 10 year span.

Spill Percent: Spill Percent is calculated by DART from the daily averaged value for Spill divided by the daily averaged value for Outflow at a project.

Temperature (Scroll Case): Temperature (Scroll Case) is water temperature in degrees Celsius. This data is measured at the scroll case (part of the powerhouse) at a project. If provided values are in Fahrenheit, they are converted to Celsius. Temperature records are typically not collected outside the salmon migration season, so they are not usually 365 days long. Values above 0 C and below 35 C are averaged for a daily value.

Temperature (Scroll Case) 10 Year Average: Daily average of scroll case temperature for a selected 10 year range. For each month and day, the data is summed for the selected 10 years and divided by the number of non-null data points available during that 10 year span.

Temperature (WQM): Temperature (WQM) is water temperature in degrees Celsius. This data is measured at Water Quality Monitoring stations in the forebay and tailrace of most projects (see Data Sites Map) and other key locations in the basin. Temperature records are typically not collected outside the salmon migration season, so they are not usually 365 days long. Daily averages are calculated from hourly values above 0 C and below 35 C. Temperature at water quality monitoring stations was not collected prior to 1995.

Temperature (WQM) 10 Year Average: Daily average of water quality monitor temperature for a selected 10 year range. For each month and day, the data is summed for the selected 10 years and divided by the number of non-null data points available during that 10 year span.

Turbidity: Turbidity measures the water clarity, and by inference, the amount of particulate matter present. Turbidity is measured in the forebay or in the fish ladders of a project. Turbidity is reported in feet and measured with a Secchi Disk. In general, the Secchi disk is a 20 cm circular black and white plate. The Secchi disk is attached to a calibrated line and lowered into the water to the depth at which it disappears. The disk is then lifted until it reappears. The arithmetic mean of the two depths is considered the Secchi disk transparency or limit of visibility.

Calculating 10 Year Averages

The 10 Year Averages are calculated by DART for each calendar day of data at each project. For the current year and any given project/month/day, the data from the previous 10 years on that calendar day is summed and divided by the number of non-null data points available. Calendar day averaging was chosen because, historically, data observations begin on a specific calendar day. Calendar day averaging gives different results than day of year averaging.


Home | Columbia R. DART | Status & Trends | Inseason Forecasts | Tools & Models | Research & Publications | Library | Site Map | Search
Please use Data Feedback to report data quality control issues.
 
Please direct questions, suggestions and/or problems to the DART Coordinator,
cvh@uw.edu.
Columbia Basin Research,
School of Aquatic & Fishery Sciences,
University of Washington
Wednesday, 28-Jan-2009 13:50:35 PST