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
WAN		Wanapum	Columbia	Grant 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. USACE Dams Video and Live Counting: From November through March, video tape fish counting occurs at 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 resumes 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, The Dalles, John Day, McNary, Ice Harbor, Lower Monumental, Little Goose, and Lower Granite: On March 10, 2011, DART's Adult Passage data from the Army Corps dams--Bonneville, The Dalles, John Day, McNary, Ice Harbor, Lower Monumental, Little Goose, and Lower Granite--were updated in their entirety (1938-2011) to reflect the numbers currently reported by the US Army Corps Portland District. The updates included replacement of manually entered data from printed reports, the inclusion of historical data previously missing from DART, and the correction of counts that have been updated. Willamette Falls Video Counting: Fish counting through Willamette Falls fishway occurs at the main viewing window. Video cameras and time lapsed video recorders are used to record fish passage 24 hrs/day, 365 days/year. The ODFW schedule for reviewing the tapes is Monday through Friday. It takes most of the day to accurately review one day of fish passage on tape when the counts are high. Individual Status Reports Bonneville Dam: 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. 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. NOAA's LPS lamprey counts at Bonneville for 2011 are not available to the public until motion trigger images and data logger tallies can be compared to resolve the status of lamprey passage during data gaps and anomalous data series. This comparison is expected during the winter of 2011-12. 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. Tumwater Dam: Some video counts between 8/22/2011 9:19am to 9/05/2011 9:36am and between 9/23/2011 11:28am to 10/19/2011 7:52pm were not recorded, so passage counts during this period remain incomplete. Spring Chinook daily counts from 8/1/2011 - 9/15/2011 were adjusted to reflect know fallbacks from PIT tag analysis (M.Hughes, pers. com.). 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, 8/26/2008-9/21/2008, 8/23/2010-8/27/2010. Zosel Dam Zosel Dam 2010 data notes. Equipment failure resulted in a loss of data from the right bank ladder (half of the sampling area at Zosel Dam, WA) August 25th through October 31. Linear regression was used to estimate the missed number of sockeye passing through the right bank ladder during the time data were lost (see Miller, BM, JL Panther, and JA Arterburn. 2010. 2010 Annual Report. Confederated Tribes of the Colville Indian Reservation, Omak, WA. located at http://www.cctobmep.com/media/files/2010_OBMEP_Annual_Report.pdf) No steelhead were observed in the left bank ladder during the time of equipment failure; therefore, no estimated number of missed steelhead were generated. Steelhead do not typically pass Zosel Dam during the time equipment failed. A relatively small number of Chinook were observed during the time of equipment failure, and it was not possible to use linear regression analysis to predict missed numbers of fish. Using the proportion of sockeye passing on the left versus the right bank ladders, potentially 127 Chinook passed the right bank ladder during the time equipment failed. However, there is no certainty associated with this number, therefore this estimate was not included in the total number of Chinook reported for 2010. 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. 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. 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.