Adult Passage Metadata

Abbrev	Project/Dam1 2		River	Primary Data Source
BON		Bonneville	Columbia	U.S. Army Corps of Engineers
TDA		The Dalles	Columbia	U.S. Army Corps of Engineers
JDA		John Day	Columbia	U.S. Army Corps of Engineers
MCN		McNary	Columbia	U.S. Army Corps of Engineers
IHR		Ice Harbor	Snake	U.S. Army Corps of Engineers
LMN		Lower Monumental	Snake	U.S. Army Corps of Engineers
LGS		Little Goose	Snake	U.S. Army Corps of Engineers
LWG		Lower Granite	Snake	U.S. Army Corps of Engineers
PRO		Prosser	Yakima	Yakima Klickitat Fisheries Project
ROZ		Roza	Yakima	Yakima Klickitat Fisheries Project
PRD		Priest Rapids	Columbia	U.S. Army Corps of Engineers [1962-1998] and Grant County PUD [1999-present]
RIS		Rock Island	Columbia	U.S. Army Corps of Engineers [1977-2000] and Chelan County PUD [2001-present]
RRH		Rocky Reach	Columbia	U.S. Army Corps of Engineers [1977-2000] and Chelan County PUD [2001-present]
TUM		Tumwater	Wenatchee	Washington Department of Fish & Wildlife and Chelan County PUD
WEL		Wells	Columbia	U.S. Army Corps of Engineers [1977-2001] and Douglas County PUD [2002-present]
WFF		Willamette Falls (Sullivan Project)	Willamette	Oregon Department of Fish & Wildlife
ZOS		Zosel	Okanogan	Colville Tribes Fish & Wildlife (OBMEP)
1. Click on the data inventory icon to view the DART Adult Passage Data Inventory for All Species and All Years. This information is displayed in a new browser window. 2. Click on the 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. Early Season Notice Video tape fish counting is now being being made at most US Army Corps of Engineers dams with fish ladders on the Columbia and Snake Rivers. Fish counting by video tape takes at least a few days to process: the fish counters have to make, collect, and read the tapes, and then submit their fish counts. DART retrieves and posts the data as soon as it is made available. On April 1, live fish counting will resume at all 8 Columbia River and Snake River Corps dams with fish ladders: from April through October each year for 16 hours each day, fish counters working at each fish ladder look directly into the fish ladders to count the fish passing by. Bonneville Dam, 1960, 1965, 1966: On 22 January 2009, Bonneville Dam adult passage counts for 1960, 1965, and 1966 were synchronized with the Annual fish passage reports of the U.S. Army Corps of Engineers, North Pacific Division Rocky Reach Dam, June 8-9, 2005: Video was lost at Rocky Reach Dam from 1751 hours on 8 June and was not returned to operation until 0729 hours on 9 June. As a result, the adult passage counts at Rocky Reach Dam are incomplete for both days. Wells Dam, Lamprey Research, 2007-2008: The Lamprey adult passage counts at Wells Dam are not reflective of actual run size during 2007-2008. Trapping, monitoring, and research efforts at Wells Dam artificially lowered the passage numbers for Lamprey; i.e., more fish would have passed without tagging and trapping efforts. Willamette Falls: The Willamette Falls fish ladder was not operational on the following dates: 11/29/2005 - 12/1/2005, 12/6/2005 - 12/8/2005, 12/13/2005 - 12/14/2005, and 8/26/2008 - 9/21/2008. Zosel Dam: Zosel Dam estimated 2008 adult sockeye passage counts missed due to equipment malfunction. 15 May 12:00 - 20 May 12:00 = 0 17 Jul 00:00 - 18 Jul 19:00 = 6678 09 Aug 10:00 - 12 Aug 12:00 = 649 31 Aug 00:00 - 04 Sep 10:00 = 570 Total Missed Sockeye count = 7897 Initial 2008 Sockeye count = 77533 Revised 2008 Sockeye count = 85430 At this time, missed sockeye counts are not reflected in query results. 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. Yakima Klickitat Fisheries Project Data: Historical daily counts for Roza Dam for the years 1940-1967 and 1982-1985 were obtained and loaded from data provided courtesy of the U.S. Bureau of Reclamation's Yakima office. In years where daily counts are not available, the Yakama Nation has provided weekly counts with data assigned to an arbitrary day in the week for which counts are available. This is the case for Prosser Dam for the years 1983-1991 and for Roza Dam for the years 1986-1990. [Text from the Yakima Klickitat Fisheries Project web page, http://ykfp.org/adultcounts.htm.] Tumwater Dam: Adult passage data for Tumwater Dam is the combination of released counts, referring to fish passed upstream of the dam and allowed to spawn naturally, and collected counts, referring to fish retained for hatchery broodstock. The Chinook adult passage counts are the sum of hatchery spring, hatchery summer, wild spring, and wild summer chinook as reported by WDFW and Chelan PUD. The Jack Chinook adult passage counts are the sum of hatchery spring, hatchery summer, wild spring, and wild summer jack chinook as reported by WDFW and Chelan PUD.

Adult Passage Glossary

Chinook Run: Chinook runs (referring to the season when adults migrate upstream) are based on run schedules by project as established by the U.S. Army Corps of Engineers and Yakima Klickitat Fisheries Project. Sp = Spring, Su = Summer, Fa = Fall

Chinook: This field represents the total number of adult chinook (Oncorhynchus tshawytscha) counted at the dam (project). This includes only fish judged to be fully mature (age 3 to 5). This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Chinook 10 year average: This field represents the calendar day 10 year average for adult chinook.¹

Jack Chinook: This field represents subadult but reproductively mature chinook counted at the dam. Jacks return after one year in the ocean, two to three years before typical adults. The fraction of the population that returns early may be fairly constant, which means that jack counts could give an indication of how strong the adult return will be in two or three years. USACE designates jack chinook salmon as fish between 12 and 22 inches in length. Salmonids under 12 inches in length are not identified as to species. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Jack Chinook 10 year average: This field represents the calendar day 10 year average for jack chinook.¹

Steelhead: This field represents the total count of adult steelhead (Oncorhynchus mykiss), both wild and hatchery. A few steelhead adults may spawn and survive to return to the ocean, unlike other salmonid stocks. The Steelhead field includes both hatchery and wild counts. Prior to 1995, wild steelhead data was not published on a daily basis. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Steelhead 10 year average: This field represents the calendar day 10 year average for steelhead.¹

Steelhead Wild: This field represents adult wild steelhead (subset of the Steelhead field) and may include unmarked hatchery fish. Prior to 1995, wild steelhead data was not published on a daily basis. The wild steelhead column (SthdW) is a subset of the total steelhead column (Sthd). This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Sockeye: Adult sockeye (Oncorhynchus nerka) typically return to spawn after spending two or more years in the ocean; their counts are represented in this field. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Sockeye 10 year average: This field represents the calendar day 10 year average for sockeye.¹

Coho: This field represents the total number of adult coho (Oncorhynchus kisutch) observed at the dam; only mature individuals are counted in this field. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Jack Coho: This field represents the total number of jack coho, usually two-year-old, returning early to the river. USACE designates jack coho salmon as fish between 12 and 18 inches in length. Salmonids under 12 inches in length are not identified as to species. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Coho 10 year average: This field represents the calendar day 10 year average for coho.¹

Shad: This field represents total counts of adult shad (Alosa sapidissima). Shad were introduced on this coast in 1871 and have since become quite abundant; they support a substantial fishery in their native habitat on the east coast of North America. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Lamprey: This field represents total counts of lamprey. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

Bulltrout: This field represents total counts of adult bulltrout. Bulltrout daily is currently reported at three projects in the Upper Columbia region: Rock Island, Rocky Reach, and Wells. This field is the daily total passage count for the Graphics & Text and Composite query types, the monthly total passage count for the Monthly Summary query type, and the annual total passage count for the Annual Summary query type.

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.