cbfish.org - Columbia Basin Fish & Wildlife Program - Proposal NPCC19-1996-019-00

Proposal NPCC19-1996-019-00 - Data Access in Real Time (DART)

View the dynamic Proposal Summary

This Proposal Summary page updates dynamically to always display the latest data from the associated project and contracts. This means changes, like updating the Project Lead or other contacts, will be immediately reflected here.

Download a snapshot PDF

To view a point-in-time PDF snapshot of this page, select one of the Download links in the Proposal History section. These PDFs are created automatically by important events like submitting your proposal or responding to the ISRP. You can also create one at any time by using the PDF button, located next to the Expand All and Collapse All buttons.

Proposal History

Archive	Date	Time	Type	From	To	By
	11/14/2018	7:38 PM	Status		Draft	<System>
	11/14/2018	7:38 PM	Status		Draft	<System>
Download	1/30/2019	9:56 AM	Status	Draft	ISRP - Pending First Review	<System>
	4/19/2019	10:24 AM	Status	ISRP - Pending First Review	ISRP - Pending Final Review	<System>
	5/28/2019	4:14 PM	Status	ISRP - Pending Final Review	Pending BPA Response	<System>
	5/30/2019	2:45 PM	Status	Pending BPA Response	Pending Council Recommendation	<System>

This online form is dynamically updated with the most recent information. To view the content as reviewed by the ISRP and Council for this review cycle, download an archived PDF version using the Download link(s) above.

Basics

Proposal Number:		NPCC19-1996-019-00
Proposal Status:		Pending Council Recommendation
Proposal Version:		Proposal Version 2
Review:		2019-2021 Mainstem/Program Support
Portfolio:		2019-2021 Mainstem/Program Support
Type:		Existing Project: 1996-019-00
Primary Contact:		James Anderson
Created:		11/14/2018 by (Not yet saved)
Proponent Organizations:		University of Washington

Project Title:		Data Access in Real Time (DART)

Proposal Short Description:		The primary and second-tier database, data repository, web-based data reporting and analysis services collectively known as Columbia River DART (Data Access in Real Time) provides direct, timely, flexible, user-controlled public access to integrated Columbia Basin environmental, operational, fishery, riverine, ocean and climatic data resources for informed and adaptive management of the Columbia Basin resources and hydrosystem by federal, state, tribal, public and private entities.

Proposal Executive Summary:		Columbia River Data Access in Real Time (DART)—the second-tier database, data repository, web-based data reporting and analysis services—provides direct, timely, flexible, and user-defined public access to integrated Columbia Basin environmental, operational, fishery, riverine, ocean and climatic data resources for sound management of the Columbia Basin resources and hydrosystem by federal, state, tribal, public and private entities. The DART project contributes to the Columbia River Basin Fish and Wildlife Program’s (FWP) principles of best available scientific information and data management (NPCC 2014) and to the region by delivering increasingly meaningful and cost-effective data services and results (NMFS 2014). The DART database and web-based reporting tools evolved out of a need to organize data used in research on fish passage through the Columbia River hydrosystem and to provide a method for flexible, user-specified querying. In 1992, we developed an in-house relational database including flow data from the U.S. Army Corps of Engineers (USACE) and PIT Tag data from Columbia Basin PIT Tag Information System (PTAGIS). We established our web site in March 1994. In September 1994, we implemented one of the first web accessible query systems that allowed public access to query our in-house database. With the release of the Netscape browser in 1995, we implemented a variety of data selection and graphical display tools. Since that time, the DART system has continued to grow and develop in response to regional data, analysis, forecasting, research questions, and management needs. DART strives to provide real time data and online analytical processing services in accordance with the FWP (NPPC 2000, 2009, 2014) and Supplemental FCRPS Biological Opinion (NMFS 2010a, 2014) and to anticipate reporting and analysis needs of the region at large: both to illustrate hydrosystem and fish population status and to shed light on critical uncertainties. The current scope may be modified as needed, to address requirements of the Action Agencies implementation of NOAA Fisheries Biological Opinions (NMFS 2008b, 2008c, 2010a; NOAA Fisheries 2008; ACOE et al. 2017a) federal court-directed remand of one or more biological opinions, and the regional review of information requirements and services. DART draws on the experience of Columbia Basin Research (CBR), a research group within the School of Aquatic and Fishery Sciences at the University of Washington. CBR has been actively involved in data management and analysis of Columbia River fish passage issues for over 25 years. The main areas of research are in ecological statistical analysis and modeling related to survival and behavior of migratory and resident fishes. DART uses various transfer protocols and programs to obtain data from primary sites disseminating data electronically. Currently, detailed information is retrieved daily from more than fifteen federal, state and tribal databases to provide a comprehensive, integrated regional information tool. DART provides valuable input to data-quality assurance and control feedback loops for many data sites in the region. Systems and databases are backed up through mirrored disks and database backups to ensure service reliability. Daily real time data and historic information is accessible through the website query forms and by direct requests to DART staff. DART complements and enhances services provided by other federal, state, and private entities in the region by providing an independent source of integrated public data for more effective access, consideration, analysis, and application and by providing additional analytical capabilities for evaluating hydrosystem and fishery status and management actions. DART’s real time preliminary and summary analyses provide an instant look into the current status of the resource and provide access to potential early warning triggers on a daily basis. These services are critical to Bonneville Power Administration’s implementation of its fish and wildlife responsibilities under the Endangered Species Act (ESA). The services are available to FWP participants needing integration of data and can be used to implement effective monitoring and evaluation of adaptive management objectives and quantitative goals in real time (NPPC 2014). The DART real time analysis offerings and predictive modeling tools enhance the potential for adaptive management throughout the region. Routine reporting and analysis by DART provides information on the migration status and trends of juvenile and adult fish populations in the mainstem and tributaries. Historical, real time, and predictive passage statistics provide resources for managing the hydrosystem in relation to migrating and resident stocks. The real time analysis and modeling tools facilitate adaptive management for fish passage presenting a comprehensive description of fish passage including: real time inseason analysis and predictions of smolt migration rate, survival, and transportation and adult upstream run size and migration timing. DART provides analytical processing tools of publicly available PTAGIS interrogation dataset for the instream tributary PIT Arrays to observe movement and life history patterns of individual fish in greater detail, to efficiently handle and standardize analysis of these datasets for specific research questions, and to allow comparable, reproducible results across research studies. DART provides status measures for numerous stocks through summary statistics, trends, reach and system survivals, migration patterns, and exposure indices monitored on a daily basis throughout the year. DART also reports stream flows, ocean conditions, and long-term climate trends. Specialized data aggregation and queries provide passage, travel time, and survival information on juvenile and adult ESA-listed PIT-tagged stocks. Specific analyses provided by DART include: • Reach distribution and potential delay events in upstream migration for adult PIT-tagged Chinook during the spring spill period in the Lower Snake River based on DART data aggregations of PTAGIS data reported in real time for inseason management purposes; • Smolt-to-adult return (SAR) estimates for ESA-listed stock migrations based on DART data aggregations of PTAGIS data; • Juvenile and adult migration status monitoring providing reach-specific and system-level passage migration timing and survival information for ESA-listed and non-listed populations; • Detailed status of juvenile and adult ESA-listed stock migrations based on DART data aggregations of PTAGIS data; • Reach conversion rates for adult salmonid stocks based on PTAGIS data; • Tributary status and trend monitoring of juvenile and adult ESA-listed and non-listed stocks based on PTAGIS data; • Detailed and summary statistics and analysis of PTAGIS data for juveniles and adults; • Inseason real time run-timing predictions for juvenile and adult stocks with an annual review of predictions; • Juvenile and adult migrant exposure to environmental conditions. DART conducts quarterly and annual reviews of user query patterns and affiliations to track usage, ensure relevance, and improve reporting and analytical tools. Online surveys and data feedback forms allow for user input on a range of issues. In addition, we solicit direct feedback from users. DART staff respond rapidly and efficiently to analytical needs and specialized data requests from the region and others. DART supports regional efficiency, collaboration, and cost savings through numerous relationships with other BPA funded projects and regional entities (see Relationships section). DART provides specialized, integrated datasets in support of research monitoring efforts of other funded projects. DART provides release, survival and travel time analyses integrated with observed environmental parameters to assist with NOAA's development, calibration and validation of the Comprehensive Salmon Passage Model (COMPASS) for the 2008-2018 Biological Assessment and Biological Opinion scenario analyses, the Pacific Salmon Treaty renewal process, and the current Columbia River System Operations (CRSO) EIS alternatives. DART is the primary publicly accessible repository for a number of projects in the region including the Adult Anadromous Fish Radiotelemetry Project (1996-2004), the cooperative Mid Columbia Status for Juvenile and Adult Salmon, and adult passage counts from Chelan and Grant County PUDs as well as the Tumwater and Zosel dams. In addition, DART provided technical expertise and hosted the Pacific Northwest Aquatic Monitoring Partnership (PNAMP) website on its server from January 2010-May 2011 while PNAMP web services were in transition. From December 2016-March 2017, at the request of U.S. Army Corps of Engineers (USACE), we rapidly developed and implemented special data handling processes to publish USACE adult visual fish counts to the web for continued access by fish managers and the general public during an emergency transition of public hosting from USACE to Fish Passage Center (FPC). Through regional cooperation, DART provides support for monitoring and evaluation of scientific research efforts, implementation plans, and FWP biological objectives; access to spatially and temporally integrated biological and environmental data; and integration and free exchange of information.

Purpose:		Hydrosystem
Emphasis:		Data Management
Species Benefit:		Anadromous: 98.0% Resident: 2.0% Wildlife: 0.0%
Supports 2009 NPCC Program:		Yes
Subbasin Plan:		Asotin, Clearwater, Deschutes, Entiat, Grande Ronde , Hood, Imnaha, John Day, Klickitat, Lower Columbia, Lower Middle Columbia, Lower Snake, Methow, Middle Snake, Okanogan, Salmon, Umatilla, Upper Middle Columbia, Wenatchee, Willamette, Yakima
Biological Opinions:		FCRPS 2008 (RPA 51, RPA 72, RPA 50.2, RPA 50.3, RPA 50.4, RPA 50.5, RPA 50.6, RPA 52.2, RPA 52.3, RPA 52.7, RPA 52.8, RPA 53.2, RPA 53.4, RPA 54.7, RPA 54.11, RPA 55.2, RPA 55.4, RPA 56.3, RPA 61.1, RPA 71.4, RPA 51.1, RPA 72.1, RPA 72.2) Upper Snake River 2007 Willamette 2007 FCRPS

Contacts

Contacts:

Project Significance & Problem Statement

Project Significance to Regional Programs:

DART’s significance to regional programs is providing extensive data integration, web-based reporting, and analytical services that help connect primary databases and environmental and fish monitoring programs to decision makers, managers, researchers and resource users. The DART integrated database, data aggregation, real time analysis offerings, and predictive modeling tools enhance the potential for adaptive management throughout the region and within subbasin plans. DART provides analysis capabilities for evaluating water and fishery status and management actions for a real time look into the current status of the resource and provides access to potential early warning triggers on a daily basis. It also provides information on long-term trends.

The DART data and analysis services help adaptive and future management “respond to new information and strategies” (NPPC 2014, 30). The raw and statistically summarized data and forecasted indicators of salmon and steelhead readily available on DART contribute to the efforts of the “Council working with state and federal agencies and tribes in the region to collect, organize, review and report on quantitative objectives.” (NPPC 2014, 33) Thus, DART can assist in objectives such as the “Coordinated Assessment” (NPPC 2014, 33) by providing a common online resource of standardized data and indicators, including transparent documentation of methods and references. As the Council “encourages collaboration among projects to address the high-level critical uncertainties that cannot be addressed at the project level” and highlights the “need for multi-entity partnerships to develop collaborative approaches to evaluate data from multiple projects and sources” (NPCC 2017, 8), DART continues to be valuable as a common and accessible source of integrated information. DART services support Bonneville Power Administration’s implementation of its fish and wildlife responsibilities under the Endangered Species Act (ESA), the RME Reasonable & Prudent Alternatives (NOAA Fisheries NA; Recommendations 2009; ACOE et al. 2017b, 125); and the FWP elements of best available scientific information (NPPC 2014, 27), quantitative goals (NPPC 2014, 29) and adaptive management principles (NPPC 2014, 101).
 
Status and Trend Monitoring

Salmonid performance standards: DART offers real time analysis tools and reporting based on PIT Tag and other datasets in all three areas of measurable performance standards for salmonids—run size and return rates, dam passage survival, and reach survival—for use by federal, tribal, and state managers and researchers in assessing action implementation and effectiveness and monitoring fish status. 

Life stages (population structure) monitoring: DART provides a suite of adult PIT-tag reporting and analysis products for monitoring the migration timing and distribution of adult population throughout the Columbia Basin. Key to this work is the DART life-stage filter, in development since 2002, which identifies the life-stage of each fish at detection. In addition, DART presents species, basin and subbasin level conversion rate survival estimates of adult upstream migrants through user specified river reaches. The separation of PIT-tag detection into specific life-stages further enhances the value of PIT tag dataset for analysis. DART’s Valid Tag List reporting provides a foundation for spawning population estimates above Lower Granite Dam.
 
ESU/DPS status and trends: DART is the only project directly reporting the real time status of PIT-tagged ESU/DPS juvenile and adult stocks. PIT tag data specific to populations listed as ESU and DPS (NMFS 2010b) are analyzed and basic statistical properties of the stocks are provided on the website. DART provides real time reporting and analysis for 13 listed ESU/DPS populations from the Snake, Columbia and Willamette basins. Online analysis products provide numerical counts, daily trends, basin summaries, travel time estimates, migration timing, and smolt-to-adult return (SAR) estimates. By providing real time information about the status of Upper Willamette River Chinook ESU, DART can assist adaptive management in the Willamette and contribute to the best available information on Willamette species for implementation of the Willamette Biological Opinion and RPA (NMFS 2008a, 2008b).

Tributary status and trends: DART actively develops and implements real time online analytical processing tools that evaluate and summarize the status and trends of juvenile and adult Columbia Basin salmonids at population, stock, and release-specific levels. These tools enhance subbasin fish population status monitoring projects by providing real time migration timing and distribution analyses of stocks and individual releases as they migrate from tributaries through the FCRPS and return to tributaries. DART develops and publishes analysis tools with PTAGIS interrogation and recapture datasets, including identification of life-stage at tagging and detection, that provide real time information about the capture and migration histories for individual populations in the defined major population groups (MPGs). These analysis tools support “fish in”–“fish out” status and trends monitoring, provide CJS survival/detection probabilities, list detailed individual movement and migration histories.

Hydrosystem migration timing and distribution: Leveraging DART’s extensive datasets, technical expertise, and regional partnerships, DART provides multiple real time reporting and analysis tools for examining migration timing, population distribution, and potential hydrosystem operations impacts. The Historical Run Timing analysis tool presents stock specific adult and juvenile migration timing, run size, and water temperature exposure in a historical perspective for the last 10-25 years, available for multiple locations throughout the FCRPS, for examining changes in migration patterns across years. The Columbia Basin Performance Measures Exposure Index tool provides plots and summary tables of adult and juvenile population exposure to Columbia Basin hydrosystem conditions within year and across years. Based on DART PIT Tag Life Stage, ESU/DPS, and Transportation filters that are applied to all releases and detections, calculations of fallback at seven of the eight FCRPS adult fishways are presented for real time and historical monitoring of hydrosystem operations impacts. DART “Adult Ladders Adult PIT Tag Reach Distribution and Delay” tool examines in real time the movement and timing of adults at projects for potential effects of hydrosystem operations integrating PTAGIS, WQM, project operations, and adult visual count datasets. The tool was developed and enhanced with input from BPA, NOAA, and meetings with TMT and Fish Passage Advisory Committee (FPAC) and used during the 2018 spring spill period.

Data Management

Data accessibility and quality: DART participates in and supports the Northwest regional data coordination and collaboration efforts. Through regional cooperation with numerous federal, state, tribal, and private entities, DART provides web-based, public access to spatially and temporally integrated biological and environmental data and facilitates integration and free exchange of information. DART maintains numerous relationships with other BPA funded projects and regional entities (see Relationships section). DART participates in regional data coordination forums such as PNAMP’s Coordinated Assessments. DART provides data publishing portal services to multiple regional entities. DART’s integration of region-wide publicly available datasets places it in a unique position to leverage data publication and analysis for numerous agencies, programs, projects and individuals. DART’s extensive use of regional data repositories allows it to provide valuable QA/QC feedback to primary data management projects.

DART project objectives and deliverables support using the best available science for effective adaptive management of fish and wildlife and the hydrosystem (NPPC 2014, 27). Through regional cooperation with 15 federal, state, tribal, and private entities, DART facilitates data accessibility and quality and enhances best available information. With real time reporting and analysis of fish performance and hydrosystem operations based on integrated datasets, DART provides the region with the timely delivery of increasingly meaningful and cost-effective results (NMFS 2014, 238).

Problem Statement:

Columbia Basin resource management is a complex endeavor requiring cooperation and agreement among numerous state, federal, tribal, and private entities. Basic fisheries related information is an essential component of nearly all research, monitoring and management activities in the Columbia Basin. System-wide data management projects support all those activities, particularly those activities with multi-agency or system-wide scope such as recovery planning, population status monitoring or assessment; activities that rely on information collected by other agencies such as subbasin assessment and habitat restoration planning; or mainstem management decisions such as spill, water releases, and transportation. Spatially and temporally integrated datasets from several critical sources provides a framework for common discussion, analysis and consensus building. Real time analysis tools allow for rapid decision making and inseason management adjustments according to the needs and requirements of the various groups. The second-tier nature of the integrated database allows for peer review and independent reproduction of results.

Database management projects such as the publicly accessible DART second-tier database and services contribute added value to the data collected in the FWP and stored in primary databases or with the primary data collection agencies. The process of compiling data at second-tier sites provides an opportunity for quality control and feedback to the primary data sites. Data collation, integration and aggregation in a second-tier database facilitate efficient data access, multiple viewpoints, independent review, and extensive analysis. Web-based query systems allow users to sort and select the most relevant data to their needs. Web-based analysis tools allow for routine analyses to be performed in an efficient, predictable, and standardized manner saving researchers and decision-makers valuable time and reducing human error by performing repeatable tasks, analyses on complex data aggregations, and simple and complex analyses in a defined and programmatic way. The real time reporting, analysis, and modeling tools facilitate adaptive management for fish passage. Historical, real time, and predictive passage statistics provide information on the status of tributary and mainstem passage and on managing the hydrosystem in relation to migrating stocks.

While the region is working toward better collaboration among databases through the Pacific Northwest Aquatic Monitoring Partnership (PNAMP), DART currently addresses specific data integration and analysis needs. DART integrates data on juvenile and adult salmonid passage with stream flows, water temperatures, dissolved gas levels, and hydrosystem operations. DART performs complex data mining and data aggregation on PIT Tag datasets to identify juvenile and adult life-stages, juvenile and adult ESU / DPS populations, and fish-in fish-out basin analyses. DART provides tools to investigate the status and trends of various salmonid stocks and to quantify the exposure and response of juvenile and adult migrants to river conditions. These tools have been developed in response to regional data and information needs over the 20 year history of the DART program.

Objectives

Objectives:

Monitor status and trends of juvenile Columbia Basin ESA-listed and non-listed fish in real-time (OBJ-1)

Provide researchers and federal, tribal, and state managers capabilities to monitor the status and trends of ESA-listed and non-listed populations of anadromous and resident juvenile fish. Focus is on providing web-based information and tools for real time evaluation of fish migration and timing, project and reach survivals, tributary status, and hydrologic conditions in the mainstem both within the migration season and post-season. Criteria of success will be judged in terms of uninterrupted service of historical and real time information and associated analysis tools on the DART website.

Monitor status and trends of adult Columbia Basin ESA-listed and non-listed fish in real-time (OBJ-2)

Provide researchers and federal, tribal, and state managers capabilities to monitor the status and trends of Columbia Basin ESA-listed and non-listed populations of anadromous adult fish. Focus is on providing web-based information and tools to assess action implementation and effectiveness and monitoring fish status to achieve FWP biological objectives. Capabilities include inseason reporting, analyses, and predictions for monitoring and evaluating stocks in the mainstem and tributaries. Criteria of success will be judged in terms of uninterrupted service of historical and real time information on the DART website.

Integrate hydrological and fishery ecological data from Columbia Basin primary regional data sources (OBJ-3)

Provide an independent source of integrated public data, complementing and enhancing other data services in the region, for more effective access, analysis, and application for evaluating water and fishery status and management actions. Support FWP and ESA research, monitoring and evaluation efforts and adaptive management through integration of Columbia Basin hydrological and fishery ecological datasets. Provide public access to the integrated datasets with standardized, value-added analysis capabilities. Criteria of success will be judged in terms of uninterrupted service of information on the DART website and continued support of requests for assistance from the region.

Promote collaboration, coordination, efficiency, and free exchange of Columbia Basin ecosystem information (OBJ-4)

Promote collaboration, coordination, efficiency, and free exchange of Columbia Basin biological and environmental information through interactions with numerous federal, state, tribal, and private entities. Cultivate new and maintain current relationships with other BPA funded projects and regional entities (see Relationships section). Provide data sharing and exchange for regional entities through data repository services, web-based public access to datasets, and generation of specialized datasets on demand. Criteria of success will be judged in terms of uninterrupted service of DART website and continued interactions with regional organizations and the public.

Address stated requirements of biological opinions and regional agencies through relevant analysis capabilities (OBJ-5)

Rapidly respond to current and future analysis needs of the region as identified by requirements of biological opinions and regional agencies leveraging DART’s integrated database, data reporting and analysis capabilities, and extensive region-wide relationships. Simplify the exploration of correlations and critical uncertainties with relevant and real time analysis capabilities including adult and juvenile survival estimates, migration timing statistics, predictive models, ocean condition indices, tributary escapement, and river environment exposure. Criteria of success will be judged in terms of timely response to requests for analysis and demonstration of improved data extraction, display and analysis tools.

Project History

Financials

The table content is updated frequently and thus contains more recent information than what was in the original proposal reviewed by ISRP and Council.

Summary of Budgets

To view all expenditures for all fiscal years, click "Project Exp. by FY"

To see more detailed project budget information, please visit the "Project Budget" page

Actual Project Cost Share

The table content is updated frequently and thus contains more recent information than what was in the original proposal reviewed by ISRP and Council.

Current Fiscal Year — 2025

Cost Share Partner	Total Proposed Contribution	Total Confirmed Contribution
There are no project cost share contributions to show.

Previous Fiscal Years

Fiscal Year	Total Contributions		% of Budget
2024				(Draft)
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007

Explanation of Financial History:

Our project expenses cover salary and benefits for one principal investigator, data manager, web specialist and administrative staff, including services such as maintenance for server, supplies, equipment if needed, office lease, travel to attend regional meetings and a 26% indirect costs.  

The request for funding in 2007 was higher to include funds for upgrading our server system.

Reporting & Contracted Deliverables Performance

Annual Progress Reports
Expected (since FY2004):	21
Completed:	20
On time:	20

Status Reports
Completed:	80
On time:	35
Avg Days Late:	3

								Count of Contract Deliverables
Earliest Contract	Subsequent Contracts	Title	Contractor	Earliest Start	Latest End	Latest Status	Accepted Reports	Complete	Green	Yellow	Red	Total	% Green and Complete	Canceled
4124	20318, 28555, 34572, 38969, 44402, 49069, 54439, 58849, 62696, 66634, 70375, 74102, 77214, 76910 REL 3, 76910 REL 8, 76910 REL 14, 76910 REL 18, 91129, 84060 REL 2, 84060 REL 6, CR-378234	1996-019-00 EXP DATA ACCESS IN REAL TIME (DART)	University of Washington	03/23/2001	09/30/2026	Pending	80	122	5	0	0	127	100.00%	1
Project Totals							80	122	5	0	0	127	100.00%	1

Selected Contracted Deliverables in CBFish (2004 to present)

The contracted deliverables listed below have been selected by the proponent as demonstrative of this project's major accomplishments.

Contract	WE Ref	Contracted Deliverable Title	Due	Completed
20318	F: 132	Annual report will be delivered to BPA approximately 20 days after federal fiscal year end.	9/30/2005	9/30/2005
20318	B: 161	Provide web-enabled Data Access in Real Time	1/17/2006	1/17/2006
20318	D: 162	Create and maintain web-based analytical tools that are being used by researchers	1/17/2006	1/17/2006
20318	C: 159	Coordination and collection of data with data managers in the region	9/30/2006	9/30/2006
20318	A: 160	Manage and maintain database system	9/30/2006	9/30/2006
28555	G: 132	Annual Report	10/20/2006	10/20/2006
28555	C: 159	Integration of current and historical datasets	9/30/2007	9/30/2007
28555	A: 160	Manage/Maintain Database	9/30/2007	9/30/2007
28555	B: 161	DART Internet Service	9/30/2007	9/30/2007
28555	D: 162	Implementation of web-based data services	9/30/2007	9/30/2007
34572	F: 132	Annual Report	10/15/2007	10/15/2007
28555	H: 160	Preparation of system upgrade	11/30/2007	11/30/2007
34572	C: 159	Integration of current and historical datasets	9/30/2008	9/30/2008
34572	A: 160	Manage/Maintain Database	9/30/2008	9/30/2008
34572	B: 161	DART Internet Service	9/30/2008	9/30/2008
34572	D: 162	Implementation of web-based data services	9/30/2008	9/30/2008
38969	F: 132	Annual Report	10/15/2008	10/15/2008
38969	C: 159	Integration of current and historical datasets	9/30/2009	9/30/2009
38969	A: 160	Manage/Maintain Database	9/30/2009	9/30/2009
38969	B: 161	DART Internet Service	9/30/2009	9/30/2009
38969	D: 162	Implementation of web-based data services	9/30/2009	9/30/2009
44402	E: 132	Annual Report	12/31/2009	12/31/2009
77214	C: 159	Acquire/Integrate Current and Historical Datasets	9/28/2018	9/28/2018
77214	A: 160	Database and System Administration	9/28/2018	9/28/2018
77214	B: 161	Data Access in Real Time (DART) Internet Services	9/28/2018	9/28/2018
77214	D: 162	Regional Monitoring and Evaluation Services	9/28/2018	9/28/2018

View full Project Summary report (lists all Contracted Deliverables and Quantitative Metrics)

Explanation of Performance:

We deliver our work as scheduled in the proposal.  Our Status Reports and Annual Reports are usually delivered on schedule.

Results: Reporting, Accomplishments, and Impact

Please do the following to help the ISRP and Council assess project performance:
List important activities and then report results.
List each objective and summarize accomplishments and results for each one, including the projects previous objectives. If the objectives were not met, were changed, or dropped, please explain why. For research projects, list hypotheses that have been and will be tested.
Whenever possible, describe results in terms of the quantifiable biological and physical habitat objectives of the Fish and Wildlife Program, i.e., benefit to fish and wildlife or to the ecosystems that sustain them. Include summary tables and graphs of key metrics showing trends. Summarize and cite (with links when available) your annual reports, peer reviewed papers, and other technical documents. If another project tracks physical habitat or biological information related to your project’s actions please summarize and expand on, as necessary, the results and evaluation conducted under that project that apply to your project, and cite that project briefly here and fully in the Relationships section below. Research or M&E projects that have existed for a significant period should, besides showing accumulated data, also present statistical analyses and conclusions based on those data. Also, summarize the project’s influence on resource management and other economic or social benefits. Expand as needed in the Adaptive Management section below. The ISRP will use this information in its Retrospective Review of prior year results. If your proposal is for continuation of work, your proposal should focus on updating this section. If yours is an umbrella project, click here for additional instructions. Clearly report the impacts of your project, what you have learned, not just what you did.

All Proposals:

Umbrella Proposals:

DART is a Research, Monitoring and Evaluation (RME) database project providing user-defined web-based data query and analysis tools to river managers, researchers, policy makers, agencies, and the public. DART provides access to temporally and spatially integrated raw and summary data from numerous primary sources in the region. DART integrated data and analysis services rapidly respond to current and future analysis needs of the region as identified by requirements of biological opinions, regional agencies, and individual researchers. DART services support critical uncertainties research themes (D) Hydrosystem flow and passage operations and (F) Population structures of diversity (NPPC 2017). DART services facilitate the exploration of correlations and critical uncertainties with relevant and real time analysis capabilities including adult and juvenile survival estimates, adult migration distribution and potential delay, migration timing statistics, predictive models, ocean condition indices, tributary escapement, and river environment exposure. These services are consistent with the FWP directives to use best-available science (NPPC 2014) to protect, mitigate, and enhance fish and wildlife populations in the Columbia Basin.

DART uses various transfer protocols and programs to obtain data from primary sites disseminating data electronically. Currently, detailed information is retrieved daily from more than fifteen federal, state and tribal databases to provide a comprehensive, integrated regional information tool. DART’s extensive retrieval and consumption of regional data sources creates a unique opportunity for QA/QC feedback to primary repositories. DART staff identifies and consistently reports data availability and accuracy issues to primary data sources and assists with their correction. DART also provides feedback to primary data sources regarding data anomalies, formatting, and omissions.

DART provides many analysis tools to help monitor and evaluate the status and trends of juvenile and adult fish populations including: measuring fish exposure to hydrosystem variables, reach and system survivals, migration timing, stock coverage in tagging efforts, reach conversion rates for adults, and detailed examination of the adult and juvenile Columbia Basin ESU (Evolutionarily Significant Unit) and DPS (Distinct Population Segment) stocks (NMFS 2010b). DART provides predictive tools for juvenile and adult salmonid run timing and adult run size. DART calculates and presents several long term climatic and ocean condition variables.

In support of regional efficiency, collaboration, and cost savings, DART provides complex analysis capabilities and other services. DART provided technical expertise and hosted the Pacific Northwest Aquatic Monitoring Partnership (PNAMP) website on its servers from January 2010-May 2011 while PNAMP web services were in transition. In addition, DART is the public data repository for a number of projects in the region including the Adult Anadromous Fish Radiotelemetry Project (1996-2004), the cooperative Mid Columbia Status for Juvenile and Adult Salmon, and adult passage counts from Chelan County PUD and Grant County PUD, as well as the Tumwater and Zosel dams. DART also provided online access to published historical USACE adult passage data, 1938-present, which was not available in digital form from the USACE until 2010. From December 2016-March 2017, at the request of USACE, we rapidly developed and implemented special data handling processes to publish USACE adult visual fish counts to the web for continued access by fish managers and the general public during an emergency transition of public data hosting from USACE to the Fish Passage Center.

Since the beginning of the project, DART has rapidly developed, deployed, and updated tools in response to user requests and regional RME and adaptive management needs.

In 1996, at the request of BPA to serve the needs of NOAA and Technical Management Team (TMT) inseason management, DART developed aggregation processes to identify and report on the migration of ESU/DPS populations based on PTAGIS data. DART continues identifying, reporting, and developing analysis tools to assess the migration and status of Columbia Basin ESU / DPS juvenile and adult populations. Method: Columbia Basin PIT-Tagged ESU and DPS populations
The Adult PIT Tag Conversion Rate analysis tool, originally developed in response to NOAA in 2002, has been expanded over the years, including the option to include PTAGIS Recapture and Mortality datasets, as requested by Grant County PUD, and the option to identify and exclude minijacks, as requested by Douglas County PUD. Method: Conversion Rates based on PIT Tag dataset
Since 2002, DART provides real time data on reservoir elevations and flows for the NW Power and Conservation Council’s Power Supply Outlook Update web page on a daily basis.
In 2006, DART implemented a life-stage filter to identify and aggregate PIT Tag observations by life-stage, not simply by detection location. The Adult PIT Tag observations presented in web-based tools are based on data filtering--including migration year, release year, release length, observation year, release site, and other criteria--used to determine the stage of the PIT-tagged fish at the time of the detection. Method: PIT Tag Lifestage Filter
In 2007, DART developed and implemented a spatially referenced data inventory and query system using open-source applications and tools to further efforts in providing regionally integrated, publicly accessible datasets.
In 2009, the Span Year query option was developed and added to all appropriate web-based queries in response to Yakima Basin Fish & Wildlife Recovery Board request to be able to examine salmonid winter runs that span calendar years. By default, DART web-based queries are by calendar year.
In 2009, in response to NW River Partners and FCRPS Adaptive Management Implementation Plan (AMIP 2009), DART developed the Adult Passage Project Summary report that includes the comparison by species of the current year cumulative passage to the 4- and 10-year average to date and presents the rolling 4-year geometric mean. http://www.cbr.washington.edu/dart/query/adult_proj_sum
In 2010, in response to a request by the Hood River Production Program Confederated Tribes of Warm Springs, DART developed the PIT Tag Release and Observation Summary with Tag File Selection query for generating survival and travel time estimates, which allows for creating a more specific grouping of PIT Tag Releases for survival and travel time analyses based on release criteria and user-specified Tag Files, to better meet the needs of regional researchers assessing the migration and survival of their PIT-tagged fishes. http://www.cbr.washington.edu/dart/query/pit_sum_tagfiles

Used extensively by researchers throughout the region (States, Tribes, Federal)

In 2011, DART developed the Valid Sample List and Sample Time reporting for the Integrated Status and Effectiveness Monitoring Program (ISEMP) and the cooperating agencies (Idaho Fish and Game, Nez Perce Tribe, Quantitative Consultants, Inc., NOAA) for its "year-around" PIT tagging operation at the Lower Granite Dam Ladder Trap in support of the project's objective to estimate escapement of adult spring/summer Chinook salmon and steelhead in Snake River tributaries upstream of PIT interrogation sites or collection locations. http://www.cbr.washington.edu/dart/query/pitadult_valid
In 2011, in cooperation with Washington Department of Fish and Wildlife (WDFW) and ISEMP and in response to AMIP (2009), DART developed a report and analysis suite, integrating PTAGIS interrogation and recapture datasets, to address the growing needs for specialized reporting for the PIT Tag Instream Arrays being deployed in Intensively Monitored Watersheds (IMWs) and throughout subbasins in the Columbia Basin. The tool allows observation of movement and life history patterns of individual fish in greater detail, to standardize the efficient handling and analysis of these datasets for specific research questions, and to allow comparable, reproducible results across research studies. http://www.cbr.washington.edu/dart/query/pit_basin
In 2015, DART publicly deployed its upgrade of hardware, operating system, and database management system. This complete overhaul of system services and software allowed DART to redesign its PIT-tag data loads, synchronizing daily with PTAGIS. NOAA’s buoy data, PFEL’s upwelling indices, and FPC’s complete transport, hatchery releases, and Smolt Index datasets were reloaded from the primary sources.
In 2015, DART updated its data aggregation filter for Columbia Basin ESU and DPS populations to match NOAA’s revised (2014) stock definitions, including hatchery propagation efforts.
In 2015, DART developed and implemented Columbia Basin Conditions reporting suite for examining daily river environment conditions—temperature, spill, outflow, dissolved gas metrics—across all years, comparison to average, and across the basin within a year. http://www.cbr.washington.edu/dart/query/basin_conditions
In 2015, in support of Statistical Support for Salmon Project (1989-107-00) software program TribPit, DART developed and implemented a query to generate formatted input files for use with the TribPit allowing the user to easily defined release groups for analysis. Software TribPit was developed specifically to aid states and tribal organizations charged with estimating steelhead and fall Chinook cohort survival in the tributaries for life-cycle modeling and to assess the effects of habitat conservation actions. http://www.cbr.washington.edu/analysis/apps/tribPit
In 2016, with close coordination with NOAA, DART developed the DART PIT Tag Transportation Filter. DART analyzed all of 2000-2016 PTAGIS datasets for transportation at Lower Granite, Little Goose, Lower Monumental, and McNary (until operations stopped) assigning a ‘Most Likely’ transport status to each individual PIT-tag detected at the 4 transportation locations. Analysis is updated at least annually and when triggered by updates of previously submitted PTAGIS datasets by tagging coordinators. Method: PIT Tag Transportation Filter
In 2016, DART developed and implemented DART Columbia Basin ESU & DPS Smolt-to-Adult Return (SAR) Estimates for Snake River and Upper Columbia River for multiple juvenile to adult reaches for 2000 to present. Analyses incorporate information from the DART PIT Tag Transportation, ESU/DPS, and Life Stage filters. http://www.cbr.washington.edu/dart/query/pit_sar_esu
In 2016, DART expanded the PIT Tag Adult Returns Conversion Rate analyses to include transport; species, run, rear type comparison; reach comparison; and transport/in-river comparison.
In 2016, DART expanded the Columbia Basin Historical Run Timing suite to include fish population and hydrosystem status analysis for Adult Passage, ESU and DPS Passage for both juvenile and adult populations, PIT Tag Adult Passage, PIT Tag Juvenile Passage, and Smolt Passage.
In 2016, DART developed and implemented inseason Population Exposure Alerts for Observed and Forecasted Conditions for Snake River and Columbia River Mainstem Juvenile and Adults to total dissolved gas (TDG) and water temperature. It presents current and future water quality conditions, and it extends our real time monitoring of juvenile and adult passage to assess if river conditions reach critical levels during the migration season. The tool supports assessing the impact of passage conditions on juvenile and adult salmon migration and the effects of operations for juveniles on adult upstream migration.
In 2017, in collaboration with Statistical Support for Salmon Project (1989-107-00) and in response to regional requests, DART developed and implemented PIT Tag Adult Fish Ladders Fallback at Bonneville, McNary, and Lower Granite fishways. In 2018, “index of fallback” analysis was developed and implemented for The Dalles, Ice Harbor, Lower Monumental, and Little Goose fishways; these federal projects have limited adult fishway PIT Tag detectors that provide minimal information on fish movement direction through the ladders. John Day “index of fallback” analysis will be added after sufficient data is collected. http://www.cbr.washington.edu/dart/query/pitadult_fallback
In 2018, in response to court mandated spill, regional requests, and concerns regarding future spill experiments, DART developed and implemented PIT Tag Adult Ladders -- Reach Distribution and Delay for Spring/Summer Chinook migrating upstream during the Spring Spill Period (4/3-6/20) at Lower Snake River reaches. The purpose of this tool is to examine in real time the upstream migration distribution and effects of hydrosystem operations on adult passage and potential delay. Daily cohorts are created and tracked separately based on ascent success, and then reach travel time, percent arrival, and percent 'in route' to the next dam are reported. Additional metrics are presented as well as comparisons to the adult visual count population. Analysis will be expanded to the mainstem dams for 2019. http://www.cbr.washington.edu/dart/query/pitadult_reachdist
In 2018, DART staff supported NOAA's development, calibration and validation of the Comprehensive Salmon Passage Model (COMPASS) for the current CRSO EIS breach and other alternatives.

To support research and decision-making processes, DART responds rapidly to specialized data requests. During FY2014-2018, DART provided specialized data services to the following entities.

BioAnalysts	Ellis Ecological Services	ODFW	University of Idaho
BPA	Energy NewsData	Oregon Episcopal School	University Putra Malaysia
CBFC	GCPUD	ORNL	USACE
CCPUD	Henningsen Cold Storage	Paulsen Environmental	USBR
Coast Harbor Engineering	HTI	PNNL	USFWS
Colville Tribes	Iberdrola Renewables	PSU	USGS
CRITFC	IDFG	Qualls Agricultural Laboratory	Utah State University
CWU	Kintama Research	Quantitative Consultants Inc.	UW
Daily Sun News	Morgan Stanley	Redinger, Howard	WDFW
DC Energy	Nez Perce	Sempra Utilities	WA Dept of Ecology
DCPUD	Nisqually Indian Tribe	State of Oregon	WSU
Eastern Oregon University	NOAA	Technical University of Munich	Yakama Nation
EIA	NYFE	Umatilla Tribe	YKFP

DART has contributed to regional research and information sharing. DART is cited as a source in numerous papers and articles. These citations demonstrate DART’s utility to independent research and analysis. Below is a select, wide ranging list of published papers citing DART as a source.

DART is an efficient and cost-effective second-tier database project that effectively leverages hardware and software technologies without expanding personnel costs. We have managed our servers for more than 2 decades while consistently delivering excellent services to the region. To ensure continuity of all database, web, and analysis services, DART successfully completed all phases of a major overhaul of server hardware, operating system, database management system, web server, and backup system in the beginning of 2015 and a production server upgrade in 2018.

Select DART Citations

Abt Associates Inc., Bear Peak Economics (2016) Potential Fishing Impacts and Natural Resource Damages from Worst-Case Discharges of Oil on the Columbia River. Report in the Matter of Application No. 2013-01 Vancouver Energy Distribution Terminal EFSEC Case Number 15-001 Submitted to: Matthew Kernutt, Assistant Attorney General Washington Attorney General’s Office

Adams NS, Plumb JM, Perry RW, Rondorf DW (2014) Performance of a surface bypass structure to enhance juvenile steelhead passage and survival at Lower Granite Dam, Washington. North American Journal of Fisheries Management, 34(3), 576-594.

Baldwin C (2016) Smolt to Smolt Survival and Travel Time CJH 2015. Chief Joseph Hatchery 2016 Annual Program Review.

Barnett LAK, Baskett ML, Botsford LW (2015) Quantifying the potential for marine reserves or harvest reductions to buffer temporal mismatches caused by climate change. Canadian Journal of Fisheries and Aquatic Sciences, 72(3): 376-389. doi:10.1139/cjfas-2014-0243

Benjamin J, Wetzel L, Martens K, Larsen K, Connolly P, Gillanders B (2013) Spatio-temporal variability in movement, age, and growth of mountain whitefish (Prosopium williamsoni) in a river network based upon PIT tagging and otolith chemistry. Canadian Journal of Fisheries and Aquatic Sciences, 71(1): 131-140. doi:10.1139/cjfas-2013-0279

Bracis, C, & Anderson, JJ. 2012. An investigation of the geomagnetic imprinting hypothesis for salmon. Fisheries Oceanography, 21(2-3), 170-181.

Brosnan IG, Welch DW, Rechisky EL, Porter AD (2014) Evaluating the influence of environmental factors on yearling Chinook salmon survival in the Columbia River plume (USA). Mar Ecol Prog SerVol. 496: 181–196.

Brosnan IG, Welch DW, Scott MJ (2016) Survival rates of out-migrating yearling Chinook salmon in the lower Columbia River and plume after exposure to gas-supersaturated water. Journal of Aquatic Animal Health, 28(4): 240-251.

Buchanan RA, Skalski JR, Mackey G, Snow C, Murdoch AR (2015) Estimating cohort survival through tributaries for salmonid populations with variable ages at migration. North American Journal of Fisheries Management. 35: 958–973.

Burke BJ, Peterson WT, Beckman BR, Morgan C, Daly EA, Litz M (2013) Multivariate Models of Adult Pacific Salmon Returns. PLoS ONE 8(1): e54134. doi:10.1371/journal.pone.0054134

Bussanich R, Hyatt K, Wright H, eds (2018) Proceedings of an Expert’s Workshop on Columbia River and Hydro-system Impacts on Migration Success and Production Variations of Anadromous Salmon. Okanagan-Columbia River Sockeye Salmon Management Workshop. Portland, OR, USA Moderated by Okanagan Nation Alliance- Fisheries, 6-7 December, 2017.

Clemens BJ, Beamish RJ, Coates KC, Docker MF, Dunham JB, Gray AE, et al. (2017) Conservation Challenges and Research Needs for Pacific Lamprey in the Columbia River Basin. Fisheries, 42(5): 268-280.

Connor WP, Tiffan KF, Chandler JA, Rondorf DW, Arnsberg BD, Anderson KC (2018) Upstream Migration and Spawning Success of Chinook Salmon in a Highly Developed, Seasonally Warm River System. Reviews in Fisheries Science & Aquaculture. doi: 10.1080/23308249.2018.1477736

Connor WP, K. F. Tiffan KF, Mullins F, Arnsberg B, Cooney TD, Groves PA, Milks DJ, Rosenberger SJ, and Young W (2014) Research, monitoring, and evaluation of emerging issues and measures to recover the Snake River fall Chinook salmon ESU, 1/1/2012 - 12/31/2013 Annual Report, 1991-029-00.

Crozier LG, Bowerman TE, Burke BJ, Keefer ML, Caudill CC (2017) High-stakes steeplechase: A behavior-based model to predict individual travel times through diverse migration segments. Ecosphere, 8(10).

Crozier LG, Scheuerell MD, Zabel RW (2011) Using time series analysis to characterize evolutionary and plastic responses to environmental change: A case study of a shift toward earlier migration date in sockeye salmon. American Naturalist, 178(6), 755-773.

Erhardt JM, Tiffan KF (2016) Ecology of nonnative Siberian prawn (palaemon modestus) in the lower Snake River, Washington, USA. Aquatic Ecology, 50(4), 607-621.

Fisher J, Weitkamp L, Teel D, Hinton S, Orsi J, Farley E, Trudel M (2014) Early Ocean Dispersal Patterns of Columbia River Chinook and Coho Salmon. Transactions of the American Fisheries Society, 143(1), 252-272.

Fullerton AH, Anzalone S, Moran P, Van Doornik DM, Copeland T, Zabel RW (2016) Setting spatial conservation priorities despite incomplete data for characterizing metapopulations. Ecological Applications, 26(8), 2558-2578.

Gingerich A, Kahler T, Bickford S (2013) Wells Project Subyearling Chinook Life History Study Year 3 Wells Hydroelectric Project FERC NO. 2149. Prepared for: Public Utility District No.1 of Douglas County East Wenatchee, Washington.

Gosselin J, Anderson J (2011) Cumulative Experiences and Heterogeneity Affect Fish Survival: Examples from a Model Species (Poecilia Reticulata) and Salmonid Species (Oncorhynchus Spp.), ProQuest Dissertations and Theses.

Gosselin JL, Zabel RW, Anderson JJ, Faulkner JR, Baptista AM, Sandford BP (2018) Conservation planning for freshwater–marine carryover effects on Chinook salmon survival. Ecol Evol. 2018;8:319–332. https://doi.org/10.1002/ece3.3663

Ingraham JM, Deng ZD, Martinez JJ, Trumbo BA, Mueller RP, Weiland MA (2013) Feasibility of Tracking Fish with Acoustic Transmitters in the Ice Harbor Dam Tailrace. Scientific Reports 4, Article number: 4090.

Ingraham JM, Deng ZD, Li X, Fu T, McMichael GA, Trumbo BA (2014) A fast and accurate decoder for underwater acoustic telemetry. Review of Scientific Instruments, 85(7).

Jones RN, Bretz C, Peery C (2013) Annual report of hatchery evaluation activities for spring Chinook salmon at Dworshak and Kooskia national fish hatcheries. Idaho Fishery Resource Office, Dworshak Fishery Complex, U.S. Fish and Wildlife Service.

Keefer ML, Clabough TS, Jepson MA, Bowerman T, Caudill CC (2019) Temperature and depth profiles of chinook salmon and the energetic costs of their long-distance homing migrations. Journal of Thermal Biology, 79, 155-165. doi:10.1016/j.jtherbio.2018.12.011

Kirk M, Caudill C, Johnson E, Keefer M, Clabough T (2015) Characterization of Adult Pacific Lamprey Swimming Behavior in Relation to Environmental Conditions within Large-Dam Fishways. Transactions of the American Fisheries Society, 144(5), 998-1012.

Linley T, Krogstad E, Mueller R, Gill G, Lasorsa B (2016) Mercury concentrations in pacific lamprey (entosphenus tridentatus) and sediments in the Columbia River basin. Environmental Toxicology and Chemistry, 35(10), 2571-2576.

McIlraith BJ, Caudill CC, Kennedy BP, Peery CA, Keefer ML (2015) Seasonal migration behaviors and distribution of adult pacific lampreys in unimpounded reaches of the Snake River basin. North American Journal of Fisheries Management, 35(1), 123-134.

Mendel GW, Mahoney BD, Weldert R, Olsen J, Trump J, Fitzgerald A (2014) Walla Walla River Subbasin Salmonid Monitoring and Evaluation Project. 2013 Annual Report. Contract 60695 to BPA. 69 p.

Miller BL, Arntzen EV, Goldman AE, Richmond MC (2017) Methane ebullition in temperate hydropower reservoirs and implications for US policy on greenhouse gas emissions. Environmental Management, 60(4), 615-629.

NOAA Fisheries, USACE, IDFG (2016) 2015 Adult Sockeye Salmon Passage Report.

Penney Z, Moffitt C (2014) Proximate Composition and Energy Density of Stream-Maturing Adult Steelhead during Upstream Migration, Sexual Maturity, and Kelt Emigration. Transactions of the American Fisheries Society, 143(2), 399-413.

Peven C, Paulsen C, Miller M, Stevenson J, Truscott K (2012) Adult Upper Columbia River and Snake River Spring Chinook Salmon and Steelhead Survival through the Federal Columbia River Power System Hydroelectric Projects Final Phase I Report. Colville Tribes.

Rerecich J, Mackey T (2014) Official Coordination Request for Non-Routine Operations and Maintanence: FGE Program Gatewell Velocity Testing. TMT FPOM Documents.

Richins SM, Skalski JR (2018) Steelhead overshoot and fallback rates in the Columbia/Snake River Basin and the influence of hatchery and hydrosystem operations. North American Journal of Fisheries Management 38:1122–1137. doi:10.1002/nafm.10219

Schaller HA, Petrosky CE, Tinus ES (2014) Evaluating river management during seaward migration to recover Columbia River stream-type Chinook salmon considering the variation in marine conditions Can. J. Fish. Aquat. Sci. 71: 1–13.

Snow C, Murdoch A, Kahler T (2013) Ecological and Demographic Costs of Releasing Nonmigratory Juvenile Hatchery Steelhead in the Methow River, Washington. North American Journal of Fisheries Management, 33(6), 1100-1112.

Snow CG (2016) Survival of age-0 hatchery summer-run Chinook salmon is enhanced by early release. North American Journal of Aquaculture, 78(1), 45-51.

Sol SY, Hanson AC, Marcoe K, Johnson LL (2018) Juvenile Salmonid Assemblages at the Mirror Lake Complex in the Lower Columbia River before and after a Culvert Modification. North Am J Fish Manage. doi:10.1002/nafm.10249

Tatum IA (2013) Body Size and Growth Rate Influence Emigration Timing of Oncorhynchus mykiss. Transactions of the American Fisheries Society 142:1406–1414

Trumbo B (2014) Official Coordination Request for Non-Routine Operations and Maintenance: FGE Program 14 IHR 009 Ice Harbor Dam Study 6.2.1. TMT FPOM Documents

Tucker S, Thiess ME, Morris JFT, Mackas D, Peterson WT, Candy JR, Trudel M (2015) Coastal Distribution and Consequent Factors Influencing Production of Endangered Snake River Sockeye Salmon. Transactions of the American Fisheries Society, 144(1), 107-123.

USACE (2017) 2017 Fish Passage Plan. [Online] Available: http://pweb.crohms.org/tmt/documents/fpp/2017/

USACE (2018) 2018 Fish Passage Plan. [Online] Available: http://pweb.crohms.org/tmt/documents/fpp/2018/

Wagner P, Nugent J, Lindsey C (2014) Hanford Site Steelhead Redd Monitoring Report for Calendar Year 2013. Mission Support Alliance Prepared for the U.S. Department of Energy under Contract DE-AC06-09RL14728.

Wasser SK, Lundin JI, Ayres K, Seely E, Giles D, Balcomb K, et al. (2017) Population growth is limited by nutritional impacts on pregnancy success in endangered Southern Resident killer whales (Orcinus orca). PLoS ONE 12(6): e0179824. doi:10.1371/journal.pone.0179824.

Widener DL, Faulkner JR, Smith SG, March TM, Zabel RW (2018) Survival Estimates for the Passage of Spring-Migrating Juvenile Salmonids through Snake and Columbia River Dams and Reservoirs, 2017. Report of the National Marine Fisheries Service to the Bonneville Power Administration, Portland, Oregon.

Past Council Recommendations and ISRP Reviews

The table content is updated frequently and thus contains more recent information than what was in the original proposal reviewed by ISRP and Council.

Review: 2019-2021 Mainstem/Program Support

Council Recommendation

Assessment Number:	1996-019-00-NPCC-20210312
Project:	1996-019-00 - Data Access in Real Time (DART)
Review:	2019-2021 Mainstem/Program Support
Proposal:	NPCC19-1996-019-00
Proposal State:	Pending Council Recommendation
Approved Date:	8/25/2019
Recommendation:	Implement
Comments:	Continue implementation through next review cycle. See Programmatic issue for Data Management and Information. [Background: See https:/www.nwcouncil.org/fish-and-wildlife/fish-and-wildlife-program/project-reviews-and-recommendations/mainstem-review]

Independent Scientific Review Panel Assessment

First Round ISRP Comment:
Assessment Number:	1996-019-00-ISRP-20190404
Project:	1996-019-00 - Data Access in Real Time (DART)
Review:	2019-2021 Mainstem/Program Support
Proposal Number:	NPCC19-1996-019-00
Completed Date:	None
First Round ISRP Date:	4/4/2019
First Round ISRP Rating:	Meets Scientific Review Criteria
Comment: The project is to be commended for looking at ways to add value to the database. For example, the project plans to provide information to hatcheries that can be used for managing hatchery practices. 1. Objectives, Significance to Regional Programs, and Technical Background Objectives are clear. The project provides support for the COMPASS life-cycle model. The proposal identifies that this project's significance to regional programs is due to providing data integration, web-based information, and analytical services that help connect primary databases, monitoring programs, decision makers, and resource users. 2. Results and Adaptive Management The proposal states that services provided by this project support critical uncertainties research themes (D) Hydrosystem flow and passage operations and (F) Population structures of diversity identified in the Council's 2017 Research Plan. This project also reports data availability, data anomalies, formatting, and accuracy issues to primary data sources. Evidence of the amount and utility of this feedback to primary sources would be useful for this and future ISRP reviews. Adaptive management is mentioned in the proposal in the sense that this project generates products such as data tools, analysis methods, and predictive models that can be used to support all areas of Fish and Wildlife Program adaptive management. It appears that adaptive management per se is not applied within this project but could be of use to consider the impact of vastly more data from increased detections, more precise detections, and additional methods of tagging. 3. Methods: Project Relationships, Work Types, and Deliverables The proposal documents relationships that this second-tier data base has with many data base projects in the region. This project is a data management work type with data management issues dealt with properly. The interactive web-based query system appears to work very well. Most of the sources for DART data are the entities that provide public access to primary data. This project provides access to its research database through a web-based interface and through delivery of user-requested datasets and metadata. It is not clear how it is decided which data should be stored in DART. The project develops procedures to ensure the quality of all integrated datasets. It also provides feedback to primary data sources on data quality issues.
Documentation Links:	Proponent Presentation

Review: Resident Fish, Regional Coordination, and Data Management Category Review

Independent Scientific Review Panel Assessment

Final Round ISRP Comment:
Assessment Number:	1996-019-00-ISRP-20120215
Project:	1996-019-00 - Data Access in Real Time (DART)
Review:	Resident Fish, Regional Coordination, and Data Management Category Review
Proposal Number:	RESCAT-1996-019-00
Completed Date:	4/16/2012
Final Round ISRP Date:	4/3/2012
Final Round ISRP Rating:	Meets Scientific Review Criteria

First Round ISRP Date:	2/8/2012
First Round ISRP Rating:	Meets Scientific Review Criteria
First Round ISRP Comment:
1. Purpose: Significance to Regional Programs, Technical Background, and Objectives DART provides an important and useful Tier 2 database, data repository, web-based data reporting and analysis services. The proposal provides evidence that DART is used daily by a number of organizations, including the Action Agencies, NOAA, State Agencies, and Tribes. 2. History: Accomplishments, Results, and Adaptive Management (ISRP Review of Results) For the past 6 years, DART annually delivers 400,000-600,000 database query results. DART provides analysis capabilities for evaluating water and fishery status and management actions for a real-time look into the current status of the resource and provides access to potential early warning triggers on a daily basis. 3. Project Relationships, Emerging Limiting Factors, and Tailored Questions for Type of Work (hatchery, RME, tagging) DART is the primary publicly accessible repository for a number of projects in the region including the Adult Anadromous Fish Radiotelemetry Project (1996-2004), the cooperative Mid Columbia Status for Juvenile and Adult Salmon, and adult passage counts from Chelan and Grant County PUDs as well as the Tumwater and Zosel dams. 4. Deliverables, Work Elements, Metrics, and Methods Deliverables, work elements, metrics, and methods were presented. Modified by Dal Marsters on 4/16/2012 8:47:15 PM.
Documentation Links:

Review: Proposals for New FCRPS BiOp work (FY10-July)

Review: FY07-09 Solicitation Review

Council Recommendation

Assessment Number:	1996-019-00-NPCC-20090924
Project:	1996-019-00 - Data Access in Real Time (DART)
Review:	FY07-09 Solicitation Review
Approved Date:	10/23/2006
Recommendation:	Fund
Comments:

Independent Scientific Review Panel Assessment

Final Round ISRP Comment:
Assessment Number:	1996-019-00-ISRP-20060831
Project:	1996-019-00 - Data Access in Real Time (DART)
Review:	FY07-09 Solicitation Review
Completed Date:	8/31/2006
Final Round ISRP Date:	None
Final Round ISRP Rating:	Meets Scientific Review Criteria (Qualified)
This is an exemplary proposal among the database projects, for a project that appears to provide products of widespread use and value. The project title should be probably be changed, however, to reflect the fact that this is DART enhanced with additional analytical functions. The primary significance to regional programs is to the Power Act sections requiring improved passage survival and flows. The proposal includes excellent M&E. The proposal presents a brief but clear background on the utility of the second-tier database provided by this project, although the ultimate value of this data to fish management is not explicitly described. A clear rationale is provided for the need for the integrated environmental data and fish passage data and analysis provided by DART. Detailed lists of the analyses provided by DART are included, as well as a number of analyses for which data and analytical assistance was provided. The project's history is described in an excellent interpretive narrative on actions tied to their accomplishments, the process of their evolution and the reasons why. It discusses the types of internal monitoring performed through post-season analysis of passage predictions. A figure of monthly usage from 1998-2005 is provided, as well as a list of entities using DART between 2004-2005, and the number of hosts served by season. Less clear, however, is how useful this information has been to all the regional entities that tapped it. Also, how is this information accessed? Are the raw data they capture and make available checked for accuracy? Are DART analyses peer-reviewed? Have their second-tier databases been used effectively for adaptive management? A new element includes absorbing some of the routine analysis function of the Fish Passage Center. Part of the proposal is to continue the Fish Passage Consortium, a group of PNW university faculty with expertise in fish passage issues. The Council and Bonneville will need to specifically distinguish which work elements should be funded to fulfill the tasks of the FPC, if the FPC is not funded. There always has been some overlap with FPC, DART and NOAA, but the ISRP has considered this a value added to the program rather than redundant. A long list of measurable objectives relate to the reporting and analysis functions of DART as well as newly added functions. These relate to provision of information to managers to analyze proposed hydro operations on fish (pre-season), tracking fish passage (in-season), and measuring the effect of the hydrosystem on fish (post-season). Fourteen objectives are listed. Methods are presented in detail with an explanatory background section. M&E is built into this project throughout. In the last review the ISRP recommended that the next proposal from this sponsor should include an evaluative summary of usage that indicates the distribution of use across different types of users and products, the details of a plan for how DART assesses demand for current and new products, the type of outreach that is done to assess demand, and methods used to inform and expand the user base. The sponsors have responded to this recommendation in their project operations, the results of which are reported in this proposal. The amount, distribution, and type of use are monitored quarterly for potential improvement in services. Post-season evaluations of pre-season predictions are conducted on a routine basis. Services are reviewed at the end of the year in a series of regional meetings to identify areas of needed modification. The project has excellent provisions for information transfer of data, analysis, support services, and for adaptive modification of information transfer practices on the basis of feedback.
Documentation Links:

Response to past ISRP and Council comments and recommendations:

The ISRP raised several questions in its review of DART. “Less clear, however, is how useful this information has been to all the regional entities that tapped it. Also, how is this information accessed? Are the raw data they capture and make available checked for accuracy? Are DART analyses peer-reviewed? Have their second-tier databases been used effectively for adaptive management?” Our response to these questions follows. It is difficult to directly assess the utility of the DART web-based delivered data products and analyses because it operates independently from the entities using the service. To address this issue, DART conducts usage analysis and includes statistics in all its quarterly and annual reports (2007, 2008, 2009, 2010). DART data deliveries grew by nearly 50% during FY2007-2010. By mapping delivered data and analyses products to identifiable IPs and domain names, we summarize the activities of major user groups. The Action Agencies, NOAA, State Agencies, and Tribal interests are consistently among our largest identifiable users. These groups accounted for an average of 225 data queries per day in FY2010 (Table 1). Table 1. DART Data deliveries to major Columbia basin agencies and interests in FY2010. Entity : Annual Queries : Avg Queries/Day Universities : 10952 : 30 State of Oregon : 9176 : 25 US Fish and Wildlife Service : 7107 : 19 NOAA : 6758 : 19 DOE : 6264 : 17 PUDs : 6134 : 17 State of Washington : 5723 : 16 Pacific Northwest National Laboratory : 5292 : 14 Tribes : 5155 : 14 Bonneville Power Administration : 2256 : 6 United States Army Corps of Engineers : 2173 : 6 US Geological Survey : 1959 : 5 Idaho Power Company : 1833 : 5 K12 Schools : 1828 : 5 Boeing Company : 1755 : 5 Energy Northwest : 1680 : 5 State of Idaho : 1651 : 5 US Forest Service : 1632 : 4 DOI : 1435 : 4 WDFW : 1332 : 4 These usage patterns illustrate the value of the DART project to the region as a whole. Not only does DART provide information to an extremely wide user base, it also provides significant support to the key agencies in the Columbia Basin. The increase in web-based publishing has resulted in increased standardization of citing electronic resources. Thus a number of papers and articles cite DART in their reference sections. These citations demonstrate DART’s utility to independent research and analysis (see Major Accomplishments section for select citation list). The daily data entered electronically into DART from primary sources is periodically checked, updated, and synchronized with the primary source. Many of the data loads are design to update the entire current year from the primary sources to ensure changes made in the source are reflected in DART. Weekly year-to-date updates of PTAGIS are performed to ensure a complete record. Adult passage data is checked daily against the Army Corps’ database to ensure accuracy. Each DART query page provides a link for providing feedback on data issues. All data feedback issues are addressed immediately. DART also provides feedback to primary sources when incoming data issues are encountered. Many of the analytical methods used by DART are peer reviewed but because the methods are applied to user-selected data sets, peer review is rarely appropriate. Instead, DART provides descriptions and references to the methods, caveats about required assumptions, and access to the detailed data that goes into the analyses. This allows researchers a chance for more rigorous examination of the results. This ongoing collaboration and feedback with DART improves the tools and analyses. For example, DART’s conversion rate calculation uses a narrow definition of the percentage of PIT-tagged fish detected at an upstream dam that were initially detected at the downstream location. When the PIT detectors at Wells Dam went offline for period of time, hatchery operations above Wells continued to collect adult fish and record recoveries. Yet these PIT-tag recoveries at Wells Hatchery did not enter the PTAGIS observation dataset for Wells Dam, which the fish must pass to reach the hatchery. Feedback from Grant County PUD led to the development of an improved analysis tool that could include upstream recovery and mortality data in the analysis, if desired.

Adaptive Management

Management Changes:

DART’s flexible, user-controlled, web-based data presentations, summarizing data tools, real time analysis products, and predictive models are geared toward assisting in adaptive management of the region’s resources and supporting all areas of FWP adaptive management principles: monitoring, research, data management, reporting, and evaluation (NPPC 2014). 

Internal changes to DART are a reflection of data needs and research over the 2 decades to provide managers with up-to-date estimates of fish population status and trends and their interaction with hydrologic conditions through numerous capabilities including: real time access to passage statistics, survival and travel time estimates, current and historical run timing, passage predictions, adult run size predictions, detailed juvenile and adult ESU/DPS stock migration characteristics, detailed in-basin and out-of-basin migration and capture histories, and hydrosystem performance measures.

Externally, DART products and services are regularly used in management decisions and cited in online works addressing adaptive management topics.  The TMT meeting minutes frequently refer to using DART for data visualization of current fish status and water conditions (e.g., Halton 2010) and during the 2018 spill spring period, newly developed DART tools were consistently referenced in TMT meetings with regard to adult delay at Snake River dams (e.g., Silverberg 2018). USACE references DART in developing adaptive management plans of engineering projects (Carlson and Johnson 2010) and developing the 2008 FCRPS biological assessment (Corps, BPA, and USBR 2007). NMFS references DART in its “Ocean Ecosystem Indicators of Salmon Marine Survival in the Northern California Current” website for assessing how physical and biological ocean conditions may affect the growth and survival of juvenile salmon in the northern California Current off Oregon and Washington. Hood River Production Program Monitoring and Evaluation annual progress report cites DART as its source for survival estimates and adult run strength and timing at Bonneville Dam (Gerstenberger et al. 2011, 2016). Published research references the contributions of DART to determining the effects of ocean and river conditions on chinook migration timing (Keefer et al. 2008) and in developing cost effective recovery plans (Halsing and Moore 2008). DART products have assisted in optimization modeling for hydropower and total dissolved gas (Witt et al. 2017). See ‘Results: Reporting, Accomplishments, and Impact’ Section for a list of DART citations.

DART provided extensive technical services, integrated datasets, correlated environmental parameters, and survival and travel time analyses to develop, improve, and validate NOAA’s COMPASS Model and provided technical assistance with scenario runs used in completing the FCRPS biological assessments, biological opinions and fish accords (NOAA Fisheries 2008; Corps, BPA, USBR 2007; NMFS 2008c; BPA 2008). These documents represent the historic regional collaboration efforts of states, tribes, and NOAA Fisheries, USACE, USBR, and BPA. DART currently provides technical, data and analysis services to COMPASS modeling efforts in support of the Pacific Salmon Treaty renewal process and the CRSO EIS alternatives.

In response to AMIP 2009 and RPAs 50, 56 and 57 (Recommendations 2010) and in collaboration with WDFW and ISEMP, DART developed data analysis tools for managers and scientists to access information associated with tributary PIT tag releases and subsequent tributary and mainstem detections for juvenile and adult populations. The focus of this development is to address the growing need for specialized reporting and analysis for the PIT Tag Instream Arrays being deployed in IMWs and throughout Columbia Basin tributaries. These analytical processing tools provide the capability to: combine data from multiple detection types (recapture files, instream PIT detection sites, mainstem interrogation sites, etc.); efficiently handle and standardize analysis of these datasets for specific research questions; observe movement and life history patterns of individual fish in greater detail; inform the user of the capture and migration histories, both in-basin and out-of-basin; and allow comparable, reproducible results across research studies. In addition, the tools provide real time information about the individual populations in the defined major population groups (MPG) as identified in the AA/NOAA/NPCC BiOp RM&E Recommendations Report (Recommendations 2010). DART employed rapid prototyping methods and feedback from the researchers to ensure accuracy and relevancy of the tools to research questions.

DART plans to continue its development of analysis tools for use in adaptive management processes, leveraging DART’s extensive datasets, technical expertise, and regional partnerships. The “Adult Ladders Adult PIT Tag Reach Distribution and Delay” tool is an example of this. In response to observed upstream migration delay events during 2017 spring spill period and court ordered spill, DART developed this tool to examine in real time the movement and timing of adults at projects for potential effects of hydrosystem operations integrating PTAGIS, WQM, project operations, and adult visual count datasets. The tool was developed and enhanced with input from BPA, NOAA, and meetings with TMT and Fish Passage Advisory Committee (FPAC) and used during the 2018 spring spill period.

FY2014-2018 DART web services usage by identifiable agencies and organizations (top 50)
Northwest Power and Conservation Council 
Washington State Department of Fish and Wildlife 
EDU Combined 
City Govt Combined 
NOAA 
Nez Perce Tribe 
State of Oregon Combined 
United States Army Corps of Engineers 
US Fish and Wildlife Service 
Pacific Northwest National Laboratory 
Chelan County PUD 
State of Washington Combined 
Eugene Water and Electric Board 
US Geological Survey 
K12 Combined 
DOE-RL Richland 
Energy Northwest 
Columbia River Inter-Tribal Fish Commission 
Headquarters, USAISC 
Media Combined 
Boeing Company 
Bechtel Engineering 
Idaho National Laboratory 
Idaho Power Company 
Okanagan Nation 
Kalispel Tribe 
Canadian Government 
CH2M Hill, Inc 
Confederated Tribes of the Umatilla Indian Reservation 
Bureau of Land Management 
Health Care Combined 
Salomon Inc 
State of Idaho Combined 
AREVA NP Nuclear Power 
Bonneville Power Administration 
Saranac Group LLC 
PGN 
Non-Corps Military Access 
WaferTech 
Micron Technology 
Department of Corrections 
Confederated Salish & Kootenai Tribes

Project Documents & Reports

The table content is updated frequently and thus contains more recent information than what was in the original proposal reviewed by ISRP and Council.

Public Attachments in CBFish

ID	Title	Type	Period	Contract	Uploaded
00004124-1	Second-Tier Database for Ecosystem Focus	Progress (Annual) Report	10/1999 - 09/2000	4124	11/1/2000 12:00:00 AM
00004124-2	Second-Tier Database for Ecosystem Focus	Progress (Annual) Report	10/2000 - 09/2001	4124	11/1/2001 12:00:00 AM
00004124-3	Second-Tier Database for Ecosystem Focus	Progress (Annual) Report	10/2001 - 09/2002	4124	11/1/2002 12:00:00 AM
00004124-4	Second-Tier Database for Ecosystem Focus	Progress (Annual) Report	10/2002 - 09/2003	4124	11/1/2003 12:00:00 AM
00004124-5	Second-Tier Database for Ecosystem Focus	Progress (Annual) Report	10/2003 - 09/2004	4124	12/1/2004 12:00:00 AM
00020318-1	Second-Tier Database and World Wide Web Support	Progress (Annual) Report	10/2004 - 09/2005	20318	10/1/2005 12:00:00 AM
00020318-2	Second-Tier Database and World Wide Web Support	Progress (Annual) Report	10/2005 - 09/2006	20318	10/1/2006 12:00:00 AM
P102797	DART usage 2nd Quarter FY07	Other	-	28555	7/13/2007 11:34:10 AM
P102798	DART usage 3rd Quarter FY07	Other	-	28555	7/13/2007 11:36:05 AM
P102799	DART usage 1st Quarter FY07	Other	-	28555	7/13/2007 11:37:02 AM
P103815	DART 2006 Annual Report	Progress (Annual) Report	10/2005 - 09/2006	28555	10/1/2007 10:26:30 AM
P104157	DART Annual Report FY2006-2007	Progress (Annual) Report	10/2006 - 09/2007	34572	10/19/2007 4:12:22 PM
P105233	Quarterly Evaluation of DART Services	Other	-	34572	1/15/2008 10:37:47 AM
P106350	DART Web Products/Service Usage for Jan 1, 2008 - March 31, 2008	Progress (Annual) Report Comments	-	34572	4/15/2008 11:40:49 AM
P107302	DART Web Product /Services Usage	Progress (Annual) Report Comments	-	34572	7/15/2008 2:03:24 PM
P108481	DART Web Products/Services Usage July 2008 – September 2008.	Other	-	34572	9/30/2008 3:27:12 PM
P108652	DART FY 2008 Report	Progress (Annual) Report	10/2007 - 09/2008	38969	10/15/2008 11:19:34 AM
P111380	DART Usage Evaluation	Progress (Annual) Report Comments	-	38969	4/15/2009 10:00:46 AM
P112502	Evaluate DART Usage for Q3	Progress (Annual) Report Comments	-	38969	7/15/2009 2:28:24 PM
P113707	Evaluate DART Usage for Q4	Progress (Annual) Report Comments	07/2009 - 09/2009	38969	10/9/2009 4:02:16 PM
P113901	Second-Tier Database and World Wide Web Support	Progress (Annual) Report	10/2008 - 09/2009	44402	10/22/2009 2:44:57 PM
P114883	DART User Evaluation for Oct - Dec 2009	Other	-	44402	1/15/2010 9:20:53 AM
P116030	DART Products/Services Usage January 2010 – March 2010	Progress (Annual) Report Comments	-	44402	4/15/2010 1:01:28 PM
P117008	DART Usage for Apr-June 2010	Other	-	44402	7/8/2010 11:20:33 AM
P118181	DART Usage for July 1-Sept 30, 2010	Other	-	44402	9/30/2010 10:38:13 AM
P118818	DART 2010 Annual Report	Progress (Annual) Report	10/2009 - 09/2010	49069	11/18/2010 10:42:37 AM
P119560	DART Products/Services Usage for Oct-Dec 2010	Progress (Annual) Report Comments	-	49069	1/18/2011 10:54:57 AM
P121100	DART Products/Services Usage for Jan-Mar 2011	Other	-	49069	5/4/2011 12:37:12 PM
P122135	DART Products/Services Usage for April 2011 - June 2011	Progress (Annual) Report Comments	-	49069	7/20/2011 9:36:26 AM
P123149	DART Products/Services Usage for July 2011 – September 2011	Other	-	49069	10/3/2011 10:37:44 AM
P124207	DART Annual Report for 2011	Progress (Annual) Report	10/2010 - 09/2011	54439	12/14/2011 10:59:20 AM
P124843	DART Products/Services Usage	Other	-	54439	1/25/2012 12:05:49 PM
P126196	DART Products/Services Usage for Jan - Mar, 2012	Other	-	54439	4/23/2012 9:40:30 AM
P127405	DART Products/Services Usage for April-June 2012	Other	-	54439	7/19/2012 9:47:23 AM
P128536	DART Usage for July - September 2012	Other	-	54439	10/10/2012 11:39:44 AM
P129050	Second-Tier Database and World Wide Web Support; 10/11 - 9/12	Progress (Annual) Report	10/2012 - 12/2012	58849	11/5/2012 11:57:34 AM
P134621	Second-Tier Database and World Wide Web Support	Progress (Annual) Report	10/2012 - 09/2013	62696	2/12/2014 10:47:39 AM
P142823	Data Access in Real Time (DART) 2014 Annual Report: Second-Tier Database and World Wide Web Support	Progress (Annual) Report	01/2014 - 12/2014	66634	4/7/2015 9:09:20 AM
P149038	Data Access in Real Time (DART) 2015 Annual Report: Second-Tier Database and World Wide Web Support	Progress (Annual) Report	01/2015 - 12/2015		6/7/2016 9:02:30 AM
P154998	Data Access in Real Time (DART) 2016 Annual Report	Progress (Annual) Report	01/2016 - 12/2016	74102	6/14/2017 10:44:27 AM
P159948	Data Access in Real Time (DART) 2017 Annual Report	Progress (Annual) Report	01/2017 - 12/2017	77214	3/30/2018 1:47:13 PM
P164594	Data Access in Real Time (DART) 2018 Annual Report: Second-Tier Database and World Wide Web Support	Progress (Annual) Report	01/2018 - 12/2018	76910 REL 3	3/26/2019 11:45:13 AM
P171643	Data Access in Real Time (DART) 2019 Annual Report	Progress (Annual) Report	01/2019 - 12/2019	76910 REL 8	3/13/2020 10:46:21 AM
P208208	Data Access in Real Time (DART) 2023 Annual Report	Progress (Annual) Report	01/2023 - 12/2023	84060 REL 2	3/29/2024 2:59:18 PM

Project Relationships

The Project Relationships tracked automatically in CBFish provide a history of how work and budgets move between projects. The terms "Merged" and "Split" describe the transfer of some or all of the Work and budgets from one or more source projects to one or more target projects. For example, some of one project's budget may be split from it and merged into a different project. Project relationships change for a variety of reasons including the creation of efficiency gains.

Project Relationships:	None

Additional Relationships Explanation:

• PTAGIS Project# 1990-080-00
DART Services: Collaborate with project to define data file formats for daily data transfer and provide data quality feedback to PTAGIS and Tag Coordinators. Based on NMFS ESU/DPS definitions, DART defines stock composition and aggregates PIT-tagged releases and observations for daily monitoring of ESA stocks. DART also applies a detailed analysis filter of PTAGIS observation to assign detections to specific life-stages.
Products: Publicly accessible comprehensive reporting and analysis tools for PTAGIS dataset, including survival, travel time, passage predictions, adult conversion rates, historical run-timing, and ESU/DPS stock-specific analyses and reports, and in-basin and out-of-basin capture and migration histories.
RME Strategy: Coordination & Data Management
RPA: 51.1, 72.2

• Integrated Status and Effectiveness Monitoring Program (ISEMP) Project# 2003-017-00
DART Services: Provide advanced data mining and dataset aggregation, technical support services, database services, and web access to valid sample list and sample timing and rate information at Lower Granite Adult Trap. These services are scalable to other adult trapping and sampling programs.
Products: Publicly accessible, real time reporting of the adult trapping efforts and sampling time expansion rates at Lower Granite Ladder in support of the status and trend monitoring program for anadromous salmonids and habitat in Snake River, at the subbasin scale, to assess on an annual basis the status of wild Chinook and Steelhead adult populations.
RME Strategy: Coordination & Data Management, Fish Population Status, Tributary Habitat
RPA: 50.6, 51.1, 72.2

• Upper Columbia Spring Chinook and Steelhead Juvenile and Adult Abundance, Productivity and Spatial Structure Monitoring Project# 2010-034-00
DART Services: Provide advanced aggregation of PTAGIS tagging dataset, recapture dataset, and interrogation dataset and develop reporting and analysis tools to address the growing need for specialized reporting for the PIT Tag Instream Arrays being deployed in Intensively Monitored Watersheds (IMWs) and throughout the Columbia Basin tributaries. Employ rapid prototyping methods and feedback from the researchers to ensure the tools are accurate and relevant to the research questions.
Products: Publicly accessible analytical processing tools that provide the capability to observe movement and life history patterns of individual fish, to efficiently handle and standardize analysis of these datasets for specific research questions, and to allow comparable, reproducible results across research studies. These tools provide detail and summary data for subbasins as well as metadata and methods for observation patterns, travel time statistics, straying, kelt migration, and ghost tag identification.
RME Strategy: Fish Population Status, Tributary Habitat, Coordination & Data Management
RPA: 50.6, 72.2

• Monitoring and Evaluation Statistical Support for Life-Cycle Studies Project# 1991-051-00
DART Services: Provide raw data, aggregate data, technical support services, database services, and web access to the statistical tools and RM&E analyses produced by this project.
Products: Analyses produced by this project include: Adult Escapement, PIT Tag Survival and Travel Time Analysis, Coded-Wire-Tag Smolt-to-Adult Ratios, PIT Tag adult fallback, and predictions of smolt out-migration timing.
RME Strategy: Coordination & Data Management, Fish Population Status
RPA: 51.1, 72.2

• Statistical Support for Salmon Project# 1989-107-00
DART Services: Collaborate with project to maintain and enhance the Survival and Travel Time Estimates program.
Products: Publicly accessible online analysis tool to generate survival and travel time estimates of PIT-tagged populations.
RME Strategy: Coordination & Data Management, Fish Population Status
RPA: 51.1, 72.2

• Modeling and Evaluation Support/CRiSP Project# 1989-108-00
DART Services: Provide raw data, technical support services, database services, and web access to analyses produced by this project
Products: Analyses produced by this project include: predictions of smolt out-migration timing, transportation percentages, adult upstream migration timing, and water quality conditions.
RME Strategy: Coordination & Data Management, Hydrosystem, Fish Population Status
RPA: 51.1, 72.2

• Yakama Klickitat Fisheries Management, Data and Habitat Project# 1988-120-25
DART Services: Maintain an Open Database Connectivity (ODBC) connection to project database and provide synchronized reporting of the YKFP adult passage data.
Products: Publicly accessible reporting of adult passage data from the YKFP.
RME Strategy: Coordination & Data Management, Tributary Habitat
RPA: 51.1, 72.2

• Design and Conduct Monitoring and Evaluation Associated with Re-establishment of Okanogan Basin Natural Production Project# 2003-022-00
DART Services: Provide raw data and web access to the datasets provided by this Colville Confederated Tribes, Fish and Wildlife Department project.
Products: Publicly accessible reporting of Okanogan Basin screw traps collected counts and Zosel Dam enumerated adult passage datasets integrated with river conditions and other datasets.
RME Strategy: Coordination & Data Management, Tributary Habitat
RPA: 51.1, 72.2

• Monitor Reproduction in Wenatchee River Basin Project# 2003-039-00
DART Services: Provide raw data and web access to the datasets provided by this Washington Fish and Wildlife Department project.
Products: Publicly accessible reporting of Wenatchee Basin screw traps collected counts and Tumwater Dam enumerated adult passage datasets integrated with river conditions and other datasets.
RME Strategy: Coordination & Data Management, Tributary Habitat
RPA: 51.1, 72.2

• Smolt Monitoring Project# 1987-127-00
DART Services: Provide raw data and web access to the datasets provided by this project.
Products: Publicly accessible reporting of Smolt Indices, Hatchery Releases, and Transportation datasets integrated with river conditions and other datasets.
RME Strategy: Coordination & Data Management
RPA: 51.1, 72.2

• Pacific Northwest Aquatic Monitoring Program (PNAMP) Coordination Project# 2004-002-00
DART Services: Provide technical assistance, support and facilities to host the PNAMP’s web site January 2010 – May 2011.
Products: The PNAMP web site, www.pnamp.org.
RME Strategy: Coordination & Data Management, Fish Population Status
RPA: 72.2

• Mid Columbia Agencies
DART Services: Provide database services, technical support services, and web access to Mid Columbia screw trap collected counts from Chelan PUD, Douglas PUD, Grant PUD, USACE, USFWS, USGS, Washington State Department of Ecology, WDFW, Colville Tribes, and Yakama Nation.
Products: Support and facilitate collaboration of multiple agencies in the Mid Columbia River region to integrate juvenile and adult salmon information with river conditions for improved management of these stocks. Publicly accessible reporting and analysis tools for Mid Columbia smolt passage and adult passage datasets integrated with river conditions.
RME Strategy: Coordination & Data Management
RPA: 51.1, 72.2

• Chelan County PUD, Douglas County PUD, and Grand County PUD
DART Services: Provide database services, technical support services, and web services to Mid Columbia PUDs. Adult passage data is provided directly to DART by the PUDs.
Products: Publicly accessible reporting and analysis tools for Mid Columbia adult passage data for Wells, Rocky Reach, Rock Island, and Priest Rapids dams.
RME Strategy: Coordination & Data Management, Fish Population Status
RPA: 51.1, 72.2

• NOAA COMPASS Regional Juvenile Salmon Passage Model Project
DART Services: Provide database services and technical support services to the COMPASS Project, a regional work group coordinated by NOAA to develop a Columbia Basin smolt passage model. Provide technical support to NOAA hydrosystem scenario analyses for the Columbia-Snake Basin Biological Opinions using the COMPASS model. Provide technical, data and analysis services to COMPASS modeling efforts in support of the Pacific Salmon Treaty renewal process and CRSO EIS alternatives. Participate in regional forum for parameter and submodel selection process for the Upper Columbia.
Products: Provide integrated datasets of survival, travel-time and environmental conditions for statistical modeling and calibration.
RME Strategy: Coordination & Data Management, Hydrosystem
RPA: 50.6, 72.2

• PIT Tag Instream Steering Committee (PTISC)
DART Services: Provide reporting and analysis tools for data from the PIT Tag Instream detectors installed throughout the Columbia Basin as requested by PTISC. DART also applies a detailed analysis filter of PTAGIS observation to assign detections to specific life-stages.
Products: Publicly accessible comprehensive reporting and analysis tools for PIT Tag Instream detectors dataset from PTAGIS.
RME Strategy: Coordination & Data Management, Fish Population Status
RPA: 50.6, 72.2

• Northwest Power and Conservation Council
DART Services: Provide source data and generate daily reports on reservoir elevations and river flow at Columbia Basin dams as requested by the NPCC.
Products: Provide daily reports of elevations for major U.S. reservoirs and river flow at key Lower Snake and Columbia dams for inclusion in the NPCC’s Power Supply Outlook Update web page, https://www.nwcouncil.org/energy/energy-topics/power-supply/power-supply-outlook-update-1.
RME Strategy: Coordination & Data Management
RPA: 72.2

• Energy NewsData
DART Services: Provide source data and generate daily reports of fish runs for Columbia Basin dams as requested by Energy NewsData.
Products: Daily reports of fish runs at key Lower Snake and Columbia dams for inclusion in the Energy NewsData’s Northwest FishWeb, http://www.newsdata.com/fishweb/.
RME Strateg

Focal Species

Primary Focal Species

Chinook (O. tshawytscha) - Deschutes River Summer/Fall ESU

Chinook (O. tshawytscha) - Lower Columbia River ESU (Threatened)

Chinook (O. tshawytscha) - Mid-Columbia River Spring ESU

Chinook (O. tshawytscha) - Snake River Fall ESU (Threatened)

Chinook (O. tshawytscha) - Snake River Spring/Summer (not listed)

Chinook (O. tshawytscha) - Snake River Spring/Summer ESU (Threatened)

Chinook (O. tshawytscha) - Upper Columbia River Spring ESU (Endangered)

Chinook (O. tshawytscha) - Upper Columbia River Summer/Fall ESU

Chinook (O. tshawytscha) - Upper Willamette River ESU (Threatened)

Coho (O. kisutch) - Unspecified Population

Coho (Oncorhynchus kisutch) - Lower Columbia River ESU (Threatened)

Lamprey, Pacific (Entosphenus tridentata)

Sockeye (O. nerka) - Lake Wenatchee ESU

Sockeye (O. nerka) - Okanogan River ESU

Sockeye (O. nerka) - Snake River ESU (Endangered)

Steelhead (O. mykiss) - Lower Columbia River DPS (Threatened)

Steelhead (O. mykiss) - Middle Columbia River DPS (Threatened)

Steelhead (O. mykiss) - Snake River DPS (Threatened)

Steelhead (O. mykiss) - Upper Columbia River DPS (Threatened)

Steelhead (O. mykiss) - Upper Willamette River DPS (Threatened)

Secondary Focal Species

Cutthroat Trout, Westslope (O. c. lewisi)

Pikeminnow, Northern (Ptychocheilus oregonensis) [OBSOLETE]

Shad, American (Alosa sapidissima)

Sturgeon, White (A. transmontanus) - Lower Columbia River

Trout, Brook (Salvelinus fontinalis)

Trout, Rainbow (Oncorhynchus mykiss)

Walleye (Stizostedion vitreum) [OBSOLETE]

Whitefish, Mountain (Prosopium williamsoni)

Threats to program investments and project success:

The focal species and habitats covered by the DART suite of reporting and analysis tools are subject to impacts from constant river management, policy adjustments, climate variation, ocean conditions, predation, harvest, and habitat loss, as well as uncertain impacts from other sources. As correlates of the success of ESA-listed stocks are identified and measured, and as rapid responses to identifiable trigger events become possible, real time analyses become crucial for successful adaptive management. The DART project is predicated on providing real time data and analysis results so that both historical and current conditions can be evaluated. Data integration allows for spotting trends and correlations. Climate changes, ocean conditions, and hydrosystem parameters can all be considered when using DART. Juvenile and adult migrant exposure indices to single and multiple environmental variables can be assessed. Initial estimates of survival, travel time, capture histories in-basin and out-of-basin, and migration timing can be evaluated within, and between, seasons for juvenile and adult listed and unlisted stocks.

Types of Work

Work Classes

Work Elements

RM & E and Data Management:

159. Transfer/Consolidate Regionally Standardized Data
160. Create/Manage/Maintain Database
161. Disseminate Raw/Summary Data and Results
162. Analyze/Interpret Data

Data Management

What tools (e.g., guidance material, technologies, decision support models) are you creating and using that support data management and sharing?

DART develops formal and informal relationships with numerous regional data sources to obtain, integrate, and publish disparate datasets in a common framework. The imported data is stored in an open-source relational database management system that is publicly accessible through user selected, web-based forms and by direct request. There is no restriction to access and all direct requests from all users are addressed in a timely manner. Metadata that is provided directly with imported data are made available through text and query interfaces. Published and peer-reviewed analysis methodologies can be applied by the user to their selected datasets. DART’s automated processes provide repeatable and transparent methods, calculations and results to all users. Underlying datasets used in calculations are available as a subset of the analysis results. Direct links to online primary sources and methods are provided to assist users’ research and validation. The online, real time nature of DART’s data and analysis technologies provide for adaptive management potential by greatly reducing the turn-around time for examining a number of population status metrics that can be calculated from the available data. (NED 2006a, 2006b, 2007; Rentmeester 2010; Schmidt 2009)

Describe the process used to facilitate receiving and sharing of data, such as standardizing data entry format through a template or data steward, including data exchange templates that describe the data collection methods, and the provision of an interface that makes data electronically accessible.

Receiving

DART relies on primary sources for much of the data in the integrated database.  Through communication, consultation, and feedback, DART has developed relationships and processes to automatically obtain datasets that are updated on a regular—daily, weekly, monthly, annual—basis from primary sources via ODBC (Open Database Connectivity), FTP (File Transfer Protocol), HTTP (Hypertext Transfer Protocol), HTTPS (Hypertext Transfer Protocol Secure), as well as manually through email distributions. These datasets are then imported into the DART database in a format that allows comparisons among locations and time periods. Periodic updates are obtained on daily, weekly, monthly, and annual time scales from primary sources to capture changes and updates in the primary datasets. Metadata obtained from primary sources are retained in the DART database in columns associated with the data as well as in text files delivered with query results.

The data obtained by DART is collected by other agencies and researchers. The integration of these data into a single source, publicly accessible database provides a powerful tool for researching the status and trends of fish populations in real time. The majority of the sources are the primary entities responsible for providing public access to the datasets if not the actual primary data collectors. DART performs advanced aggregations of some datasets to provide valued added data, e.g., identifying ESU/DPS populations and identifying adult and juvenile life-stages. 

Sharing

DART provides access to its integrated research database through publicly accessible, web-based interface and through delivery of specialized user-requested datasets and metadata. DART’s web-based queries generate user-specified data files and plots which can be saved to a user's personal computer in a variety of formats and are designed to be compatible with spreadsheet and statistical analysis programs. In addition, we provide a public method for automated retrieval of query results from the database. The DART website proves an online data feedback form associated with all query results to facilitate user feedback on data quality issues. DART personnel respond to direct requests for data and specialized delivery, e.g., providing integrated survival, travel time, and environmental correlate analyses requested by NOAA researchers and providing a compilation of daily reservoir elevations and river flow and elevation at Columbia Basin dams directly to NW Power and Conservation Council.

Please describe the sources from which you are compiling data, as well as what proportion of data is from the primary source versus secondary or other sources?

The data obtained by DART is collected by other agencies and researchers. The integration of these data into a single source, publicly accessible database provides a powerful tool for researching the status and trends of fish populations in real-time. The majority of the sources are the primary entities responsible for providing public access to the datasets if not the actual primary data collectors. DART performs advanced aggregations of some datasets to provide valued added data, e.g., identifying ESU/DPS populations and identifying adult and juvenile life stages.

DART obtains and integrates primary datasets from the following sources:
•	Adult Passage visual counts from: Chelan County PUD, Douglas County PUD, Grant County PUD, U.S. Army Corps of Engineers, Oregon Department of Fish & Wildlife, Washington Department of Fish & Wildlife, Yakima Klickitat Fisheries Project, Colville Tribes Fish & Wildlife (OBMEP)
•	Hydroelectric project data from: U.S. Army Corps of Engineers, Grant County PUD, Chelan County PUD, Douglas County PUD, U.S. Bureau of Reclamation, Oregon Department of Fish & Wildlife
•	Water Quality data from: U.S. Army Corps of Engineers
•	Surface Water data from: U.S. Geological Survey
•	PIT Tag mark, release, interrogation, recapture, and mortality data from: PTAGIS, Pacific States Marine Fisheries Commission
•	Smolt Indices & Collection Counts from: Fish Passage Center
•	Transportation data from: Fish Passage Center
•	Hatchery Release data from: Fish Passage Center
•	Trap Collected Counts from: Washington Department of Fish & Wildlife, Chelan County PUD, Douglas County PUD, U.S. Fish & Wildlife Service, Colville Tribes, Yakama Nation Fisheries
•	Upwelling and Buoy data from: NOAA and Pacific Fisheries Environmental Laboratory
•	Water supply data from NOAA’s Northwest River Forecaster.

Please explain how you manage the data and corresponding metadata you collect.

https://www.monitoringresources.org/Document/Protocol/Details/426

Describe how you distribute your project's data to data users and what requirements or restrictions there may be for data access.

By design, DART provides web-based, public access to regionally integrated monitoring data and analyses. DART provides data, metadata and analyses in the public domain with published methodologies and data details. The current datasets and online analysis products provide access to daily updates of standardized status tools and metrics. By integrating and collating regional data from disparate sources, DART provides for efficient, effective, reproducible access to data relevant to the FWP. The inclusion of complete dataset products from primary sources, e.g., PTAGIS, allows for the creation/generation of crucial information such as the life-stage, transportation, and ESU/DPS category of individual PIT-tagged fish. This value-added information, in turn, allows for higher level analyses such as ESU/DPS population-specific metrics, in-river/transport comparisons, and adult conversion rates. Constant updates to datasets and analysis tools, development of new products requested by users, coordination with other agencies, application of newly developed analysis methodologies to the stated RPAs, and polling of general and specific users allows DART to remain current with the evolving data and analysis needs of the region.

DART’s web-based interface allows access to, and analysis of, a subset of the integrated database through user selected forms that has proven useful to specific regional needs. The entire database, or any subset outlined in a specific request, along with analysis results, is available to the public upon request. Various DART data reporting and analyses may be targeted for specific audiences, e.g., regional managers, scientists, or the general public; however, there are no access restrictions on any of the DART data reporting and analyses products.

DART participates in Northwest regional coordination and collaboration efforts such as the PNAMP Coordinated Assessments and develop specific data analysis products for a multitude of regional entities (see Relationships section) and others.

RM&E

What type(s) of RM&E will you be doing?

Status and Trend Monitoring

Where will you post or publish the data your project generates?

DART - Data Access in Real Time

Location

Loading ...

Layers

Legend

Name (Identifier)	Area Type	Source for Limiting Factor Information
Name (Identifier)	Area Type	Type of Location	Count
Columbia River	Basin		None

Project Deliverables

Project Deliverables:

Regionally Integrated Database in working order (DELV-1)

Provide, maintain, and improve fundamental hardware, software, and procedural systems necessary to maintain the regionally integrated database, DART, in working order. Perform continual database design, tuning, and development work to meet the demands of the increasingly complex, resource-intensive data integration and analysis. Our databases are maintained through scheduled daily database mirroring, backups and daily data uploads that limit public access to 97% of a 24/7 schedule. The services are functional throughout the calendar year. Local area network and system administration operations are maintained daily and as needed to ensure reliability and availability of the database.

Types of Work:

Work Class

Work Elements

Research, Monitoring, and Evaluation + Data Management

160. Create/Manage/Maintain Database

Integrated, regional research and management database (DELV-2)

Provide, maintain, and expand integrated, regional database that spatially and temporally integrates Columbia Basin environmental, operational, fishery, riverine, ocean and climatic data resources for research and sound management of the Columbia Basin resources and hydrosystem by federal, state, tribal, public and private entities. Interact with regional data managers to increase collections of historic datasets not yet available via the Internet, then merge and load data into the database for access via the website. Datasets will be added as directed by BPA, regional needs, and adaptive analysis development. We develop and employ automated and manual processes to acquire, merge and load the data into the database. The data uploads are coordinated with data availability from primary sources in order to provide the most up-to-date data as it is made public. We develop QA/QC procedures and policies for all integrated datasets and coordinate with primary sources to provide feedback on possible data issues.

DART current datasets include:
• Adult Passage visual counts from: Chelan County PUD, Douglas County PUD, Grant County PUD, U.S. Army Corps of Engineers, Oregon Department of Fish & Wildlife, Washington Department of Fish & Wildlife, Yakima Klickitat Fisheries Project, Colville Tribes Fish & Wildlife (OBMEP)
• Hydroelectric project data from: U.S. Army Corps of Engineers, Grant County PUD, Chelan County PUD, Douglas County PUD, U.S. Bureau of Reclamation, Oregon Department of Fish & Wildlife
• Water Quality Monitor (WQM) data from: U.S. Army Corps of Engineers
• Surface Water data from: U.S. Geological Survey
• PIT Tag mark, release, interrogation, recapture, and mortality data from: PTAGIS, Pacific States Marine Fisheries Commission
• Smolt Indices & Collection Counts from: Fish Passage Center
• Transportation data from: Fish Passage Center
• Hatchery Release data from: Fish Passage Center
• Trap Collected Counts from: Washington Department of Fish & Wildlife, Chelan County PUD, Douglas County PUD, U.S. Fish & Wildlife Service, Colville Tribes, Yakama Nation Fisheries
• Upwelling and Buoy data from: NOAA and Pacific Fisheries Environmental Laboratory
• Water supply data from NOAA’s Northwest River Forecaster
• Adult Anadromous Fish Radiotelemetry Project 1996-2004 from NOAA, University of Idaho, and USACE.

Types of Work:

Work Class

Work Elements

Research, Monitoring, and Evaluation + Data Management

159. Transfer/Consolidate Regionally Standardized Data

Web-based, regionally integrated, monitoring and evaluation services (DELV-3)

Provide web-based monitoring, evaluation, and data products and services on single and associated FWP-funded and ESA-mandated activities, especially efforts to predict, track, and evaluate the efficacy of proposed or actual actions.

DART M&E services are functional throughout the calendar year with a focus on providing in-depth support during juvenile and adult migration seasons. The efforts include disseminating information on the Internet and more complex mechanisms that integrate regionally distributed online information into effective monitoring and evaluation products supporting adaptive management of recovery efforts and water utilization.

The DART project also provides a means by which information integration services can be delivered to FWP and ESA participants. With respect to the FWP, these services implement aspects of the adaptive management principles. With respect to ESA, they support federal abilities to independently make and evaluate decisions committing federal resources. Current efforts support research efforts in intensively monitored watersheds and other subbasins, Technical Management Team (TMT), the Mid-Columbia PUDs, and the Yakima-Klickitat Fisheries Project.

A variety of tools are provided to allow independent evaluation of life-stage survival of ESA-listed salmon and steelhead, including hydrosystem survival performance rates required by current biological opinions and as stated in FWP quantitative goals.
DART provides interactive online services for relating impacts of river management and environmental conditions to mainstem and tributary salmon passage and survival, including:
• Elucidating delays of upstream adult migrants between Snake River projects in real time;
• PIT-tagged migrants segregated into explicit adult and juvenile life-stage categories;
• PIT-tagged migrants segregated into distinct Columbia Basin ESU/DPS stocks as defined by NOAA ESA listings;
• PIT-tagged migrants assigned likely transport status as they pass transport projects or are identified as being in transport releases;
• Adult reach conversion rates;
• Age structure of adult returns;
• Status and trends of juvenile and adult Columbia Basin ESU/DPS populations;
• Upstream and tributary escapement;
• Juvenile and adult exposure to hydrosystem conditions;
• Juvenile salmonid survival and travel time estimates;
• Smolt-to-Adult Ratio (SAR) estimates;
• Adult passage 4 year annual rolling mean;
• Daily adult passage and river conditions 10 year averages;
• Ocean/climate conditions; and
• Adult capture and migration histories, both in-basin and out-of-basin, throughout Columbia Basin in support of Intensively Monitored Watersheds (IMWs).

Types of Work:

Work Class

Work Elements

Research, Monitoring, and Evaluation + Data Management

162. Analyze/Interpret Data

Publicly accessible, web-based interface to integrated research database (DELV-4)

Provide the publicly accessible, web-enabled Columbia River DART (Data Access in Real Time) query system and website. The publicly accessible web-based interface permits interactive, user-defined selection of data items, time frame, presentation format, etc., from an integrated subset of historical and current fishery, hydrologic, project operation, oceanic, and environmental information vital to year-round planning and adaptive management of the Federal Columbia River Power System. Raw, summary, detail, and aggregate data is presented in user-selected formats including plots, data tables (spreadsheet compatible), and HTML tables. The web-based query interface allows data users to sort and select the data most relevant to their needs. The interface allows for routine analyses to be performed efficiently and predictably, saving researchers and decision-makers valuable time in performing repeatable tasks in a programmatic way and reducing human error. Provide public method for automated retrieval of query results from the database.

Types of Work:

Work Class

Work Elements

Research, Monitoring, and Evaluation + Data Management

161. Disseminate Raw/Summary Data and Results

Adaptive, issue-driven product development and implementation (DELV-5)

Assess, modify, improve, and develop DART services to adaptively meet the needs of region planners, policy makers and the public on a continual basis. This work is based on evaluations of DART services and usage, in response to user's feedback and data requests, and current biological objectives and research uncertainties. In addition, DART surveys users and agencies to determine DART’s contributions to regional needs and to help identify additional data products and analyses that can be provided by DART. Currently under development are multiple tools addressing status and trend monitoring efforts. This type of forward looking development can continue to address the needs outlined in the biological opinions.

Types of Work:

Work Class

Work Elements

Research, Monitoring, and Evaluation + Data Management

161. Disseminate Raw/Summary Data and Results
162. Analyze/Interpret Data

Specialized user-requested datasets and metadata (DELV-6)

DART provides integrated datasets as requested by river managers, researchers, policy makers and agencies to facilitate regional modeling, monitoring, and evaluation efforts. These services generally involve the generation of datasets and aggregated data based on user requests; generating these datasets may be beyond the scope and resources of individual researchers due to the large amount of input data required for some sets, e.g., PIT Tag observed juvenile to adult survival for all years. In addition, DART provides by request survival analyses and covariate preparation, vitality work, turbine mortality, and COMPASS parameter, validation, and calibration data preparation.

Types of Work:

Work Class

Work Elements

Research, Monitoring, and Evaluation + Data Management

161. Disseminate Raw/Summary Data and Results
162. Analyze/Interpret Data

Objectives & Project Deliverables

Objective: Monitor status and trends of juvenile Columbia Basin ESA-listed and non-listed fish in real-time (OBJ-1)

Project Deliverables	How the project deliverables help meet this objective*


Regionally Integrated Database in working order (DELV-1)	The database in working order (DELV-1) is an essential component of providing real time analyses for Columbia Basin ESA-listed and non-listed juvenile fish status and trends monitoring. DART project Deliverables are interconnected and are essential to each other and to the DART project Objectives. At the core of all deliverables and all objectives is the integrated, regional research and management database (DELV-2) in working order (DELV-1). Without these two deliverables, the other DART project deliverables and all objectives are not possible. All monitoring and evaluation services are predicated on serving live, up-to-date data in “real time.” Without the database in working order, the publicly accessible monitoring and evaluation services that support Objective-1 are not available. Maintaining the database and upgrading the database architecture are essential to efficiently support all aspects of our data services and analyses.

Integrated, regional research and management database (DELV-2)	At the core of all DART deliverables and objectives is the integrated, regional research and management database (DELV-2) in working order (DELV-1). Without these two deliverables, the other DART project deliverables and all objectives are not possible. The DART integrated, regional database (DELV-2) is an essential component of providing real time analyses for juvenile Columbia Basin ESA-listed and non-listed fish status and trends monitoring. It allows for complex, resource-intensive data integration, aggregation, and analyses of datasets from disparate sources. Refer to Deliverable 2 Description for a listing of primary sources and datasets.

Web-based, regionally integrated, monitoring and evaluation services (DELV-3)	Building on DELV-1 and DELV-2, DART provides web-based monitoring and evaluation services of integrated data sources (DELV-3). DART provides managers with up-to-date estimates of juvenile Columbia Basin ESA-listed and non-listed fish population status and trends and their interaction with hydrologic conditions through numerous capabilities, including: real time access to juvenile tributary and mainstem passage statistics, user-selected juvenile survival and travel time estimates, current and historical run timing, juvenile passage predictions, detailed juvenile ESU/DPS stock migration characteristics, detailed in-basin and out-of-basin migration and capture histories, and hydrosystem performance measures. Started in 2006, the DART life-stage filter service is a necessary component of monitoring juvenile PIT Tag mainstem and tributary passage due to the prevalence of both juvenile and adult life-stage detections in common detectors at projects and at instream detection arrays. Since 1996, DART has provided predictions of juvenile passage timing that incorporates real time information about the current status of various Columbia Basin juvenile salmon runs along with current forecasted operational and hydrologic information to predict future progress of the migrating fish through the mainstem projects.

Publicly accessible, web-based interface to integrated research database (DELV-4)	The publicly accessible, web-based interface (DELV-4) is the means by which we provide federal, state, tribal, private, and public entities efficient, real time, and standardized access to data reporting and all analyses. It is an essential component of providing up-to-date, real time analyses for Columbia Basin ESA-listed and non-listed juvenile fish status and trends monitoring.

Adaptive, issue-driven product development and implementation (DELV-5)	Through adaptive, issue-driven product development and implementation (DELV-5), we provide relevant analyses in a timely manner to the region for monitoring the status and trends of Columbia Basin ESA-listed and non-listed fish. Historically, DART analysis tools of the PTAGIS dataset focused on mainstem detections and migration histories. In 2011, DART worked closely with WDFW and ISEMP to provide data queries for managers and scientists to access information associated with tributary PIT tag releases and subsequent tributary and mainstem detections for juvenile and adult populations. The purpose was to provide efficient and standardized analyses combining PTAGIS datasets from multiple detection types (recapture files, instream PIT detection sites, mainstem interrogation sites, etc.) that informed a user of the capture and migration histories of juvenile and adult populations, both in-basin and out-of-basin. DART employed rapid prototyping methods and feedback from the researchers to ensure accuracy, relevancy to research questions, and timeliness.

Specialized user-requested datasets and metadata (DELV-6)	DART provides specialized user-requested datasets, analyses, and metadata services (DELV-6) in support of juvenile Columbia Basin ESA-listed and non-listed fish status and trends monitoring efforts by federal, state, tribal, public, and private entities. For example, DART provided extensive technical services, integrated datasets, correlated environmental parameters, and survival and travel time analyses to develop, improve, calibrate and validate NOAA’s COMPASS Model and provided technical assistance with scenario runs used in completing the FCRPS biological assessments, biological opinions and fish accords (NOAA Fisheries 2008; Corps, BPA, USBR 2007; NMFS 2008c; BPA 2008), Pacific Salmon Treaty process, and CRSO EIS alternatives.

Objective: Monitor status and trends of adult Columbia Basin ESA-listed and non-listed fish in real-time (OBJ-2)

Project Deliverables	How the project deliverables help meet this objective*


Regionally Integrated Database in working order (DELV-1)	The database in working order (DELV-1) is an essential component of providing real time analyses for adult Columbia Basin ESA-listed and non-listed fish status and trends monitoring. DART project deliverables are interconnected and are essential to each other and to the DART project objectives. At the core of all deliverables and all objectives is the integrated, regional research and management database (DELV-2) in working order (DELV-1). Without these two deliverables, the other DART project deliverables and all objectives are not possible. All monitoring and evaluation services are predicated on serving live, up-to-date data in “real time.” Without the database in working order, the publicly accessible monitoring and evaluation services that support Objective-2 are not available. Maintaining the database and upgrading the database architecture are essential to efficiently support all aspects of our data services and analyses.

Integrated, regional research and management database (DELV-2)	At the core of all DART deliverables and objectives is the integrated, regional research and management database (DELV-2) in working order (DELV-1). Without these two deliverables, the other DART project deliverables and all objectives are not possible. The DART integrated, regional database (DELV-2) is an essential component of providing real time analyses for Columbia Basin ESA-listed and non-listed adult fish status and trends monitoring. It allows for complex, resource-intensive data integration, aggregation, and analyses of datasets from disparate sources. For example, the DART quick look service for monitoring adult passage migration timing at key locations throughout the Columbia Basin requires adult passage visual count datasets from the U.S. Army Corps of Engineers, Grant County PUD, and Douglas County PUD to represent the mainstem, Lower Snake, and Upper Columbia. Refer to Deliverable-2 Description for a listing of primary sources and datasets.

Web-based, regionally integrated, monitoring and evaluation services (DELV-3)	Building on DELV-1 and DELV-2, DART provides web-based monitoring and evaluation services of integrated data sources (DELV-3). DART provides managers with up-to-date estimates of adult fish population status and trends for ESA-listed and non-listed fish and their interaction with hydrologic conditions through numerous monitoring and evaluation services, including: real time access to adult passage statistics for PIT Tag and visual counts, reach conversion rates and travel time estimates, SAR estimates, adult passage, current and historical run timing, adult run size and passage predictions, detailed adult ESU/DPS stock migration characteristics, detailed user-defined adult population migration characteristics, detailed in-basin and out-of-basin adult migration and capture histories, and hydrosystem performance measures. Started in 2006, the DART life-stage filter service is a necessary component of monitoring adult PIT Tag mainstem and tributary passage due to the prevalence of both juvenile and adult life-stage detections in common detectors at projects and at instream detection arrays.

Publicly accessible, web-based interface to integrated research database (DELV-4)	The publicly accessible, web-based interface (DELV-4) is the means by which we provide federal, state, tribal, private, and public entities efficient, real time, and standardized access to data reporting and all analysis services. It is an essential component of providing real time analyses for Columbia Basin ESA-listed and non-listed adult fish status and trends monitoring.

Adaptive, issue-driven product development and implementation (DELV-5)	Through adaptive, issue-driven product development and implementation (DELV-5), we provide relevant analyses in a timely manner to the region for monitoring the status and trends of adult Columbia Basin ESA-listed and non-listed fish. For example, in 2018, DART implemented the “Adult Ladders Adult PIT Tag Reach Distribution and Delay” tool. In response to observed upstream migration delay events during 2017 spring spill period and court ordered spill, DART developed this tool to examine in real time the movement and timing of adults at projects for potential effects of hydrosystem operations integrating PTAGIS, WQM, project operations, and adult visual count datasets. The tool was developed and enhanced with input from BPA, NOAA, and meetings with TMT and FPAC and used during the 2018 spring spill period. DART employed rapid prototyping methods and solicited feedback to ensure accuracy, relevancy to management actions, and timeliness.

Specialized user-requested datasets and metadata (DELV-6)	DART provides specialized user-requested datasets, analyses, and metadata services (DELV-6) in support of adult Columbia Basin ESA-listed and non-listed fish status and trends monitoring efforts by federal, state, tribal, public, and private entities. For example, DART provided integrated hatchery release and adult returns data requested by university researchers for vitality and survival modeling.

Objective: Integrate hydrological and fishery ecological data from Columbia Basin primary regional data sources (OBJ-3)

Project Deliverables	How the project deliverables help meet this objective*


Regionally Integrated Database in working order (DELV-1)	The database in working order (DELV-1) is an essential component of integrating hydrological and fishery ecological data from Columbia Basin primary regional data sources. The working database allows for the spatial and temporal integration of datasets from disparate sources.

Integrated, regional research and management database (DELV-2)	The integrated, regional research and management database (DELV-2) is an essential component of providing to the region the service of a publicly accessible, independent source of integrated hydrological and fishery ecological data from Columbia Basin primary data sources. This service complements and enhances other data services in the region, for more effective access, analysis, and application for evaluating water and fishery status and management actions. Data collation, integration and aggregation in a second-tier database facilitates efficient data access, multiple viewpoints, independent review, and extensive, value-added analysis. The process of compiling primary data at second-tier sites provides an opportunity for quality control and feedback to the primary data sites.

Objective: Promote collaboration, coordination, efficiency, and free exchange of Columbia Basin ecosystem information (OBJ-4)

Project Deliverables	How the project deliverables help meet this objective*


Regionally Integrated Database in working order (DELV-1)	The database in working order (DELV-1) is an essential component of supporting collaboration, coordination, efficiency, and free exchange of Columbia Basin ecosystem information. The working database is the primary mechanism by which data repository services are provided to regional entities.

Integrated, regional research and management database (DELV-2)	The integrated, regional database (DELV-2) is an essential component of supporting collaboration, coordination, efficiency, and free exchange of Columbia Basin ecosystem information. The database provides for efficient access to and free exchange of disparate datasets.

Publicly accessible, web-based interface to integrated research database (DELV-4)	The publicly accessible, web-based interface (DELV-4) is the primary mechanism by which we provide public access to Columbia Basin ecosystem information.

Specialized user-requested datasets and metadata (DELV-6)	Fulfilling specialized user-requests for datasets and metadata (DELV-6) further advances Objective-4 for collaboration, coordination, efficiency, and free exchange of Columbia Basin ecosystem information. DART leverages its integrated database to improve efficiency of access and analysis by eliminating the need for individual users to integrate disparate primary sources. Free exchange is enhanced by fulfilling each individual specialized request for data, metadata, analysis and information in a timely manner. Collaboration with numerous research groups and agencies leverages the integrated database ability to assist with providing standardized and reproducible status and trends monitoring from raw data.

Objective: Address stated requirements of biological opinions and regional agencies through relevant analysis capabilities (OBJ-5)

Project Deliverables	How the project deliverables help meet this objective*


Regionally Integrated Database in working order (DELV-1)	The database in working order (DELV-1) is an essential component of providing current and relevant analyses in support of stated requirements of biological opinions and regional agencies. DART project deliverables are interconnected and are essential to each other and to the DART project objectives. At the core of all deliverables and all objectives is the integrated, regional research and management database (DELV-2) in working order (DELV-1). All monitoring and evaluation services are predicated on serving live, up-to-date data in “real time.” Without the database in working order, the publicly accessible monitoring and evaluation services that support Objective-5 are not available. Maintaining the database and upgrading the database architecture are essential to efficiently support all aspects of our data services and analyses.

Integrated, regional research and management database (DELV-2)	At the core of all DART deliverables and objectives is the integrated, regional research and management database (DELV-2) in working order (DELV-1). Without these two deliverables, the other DART project deliverables and all objectives are not possible. The DART integrated, regional database (DELV-2) is an essential component of providing current and relevant analyses in support of stated requirements of biological opinions and regional agencies. It allows for complex, resource-intensive data integration, aggregation, and analyses of datasets from disparate sources. For example, the “DART Adult Ladder Reach Distribution and Delay” tool for examining the upstream timing and distribution of adult migrants during the spring spill period integrates data from PTAGIS, WQM, project operations, and adult visual counts. Refer to Deliverable-2 Description for a listing of primary sources and datasets.

Web-based, regionally integrated, monitoring and evaluation services (DELV-3)	Building on DELV-1 and DELV-2, DART provides web-based monitoring and evaluation services of integrated data sources (DELV-3). For over 15 years, DART has segregated PIT Tag releases and detections into ESU/DPS populations based on NOAA definitions. DART provides managers with up-to-date estimates of status and trends for the juvenile and adult ESA-listed fish populations and their interaction with hydrologic conditions, providing detailed juvenile and adult ESU / DPS stock migration characteristics. Started in 2006, the DART life-stage filter service is a necessary component of monitoring juvenile and adult PIT Tag mainstem and tributary passage due to the prevalence of both juvenile and adult life-stage detections in common detectors at projects and at instream detection arrays.

Publicly accessible, web-based interface to integrated research database (DELV-4)	The publicly accessible, web-based interface (DELV-4) is the means by which we provide federal, state, tribal, private, and public entities efficient, real time, and standardized access to data reporting and all analysis services. It is an essential component of providing real time analyses of status and trends monitoring for Columbia Basin ESA-listed fish.

Adaptive, issue-driven product development and implementation (DELV-5)	Through adaptive, issue-driven product development and implementation (DELV-5), we provide relevant analyses to the region in a timely manner for addressing stated requirements of biological opinions and regional agencies. For example, in 2009, the Span Year query option was developed and implemented on all appropriate web-based queries in response to Yakima Basin Fish & Wildlife Recovery Board request to be able to examine salmonid winter runs. In 2010, DART developed the PIT Tag Release and Observation Summary with Tag File Selection query for generating survival and travel time estimates, which allows for creating a more specific grouping of PIT Tag Releases for survival and travel time analyses based on release criteria and user-specified Tag Files, to better meet the needs of regional researchers assessing the migration and survival of their PIT-tagged fish. This work was in response to a request from the Hood River Production Program Confederated Tribes of Warm Springs for greater specificity in defining release groups for the survival and travel time estimates program.

Specialized user-requested datasets and metadata (DELV-6)	DART provides specialized user-requested datasets, analyses, and metadata services (DELV-6) in support of addressing stated requirements of biological opinions and regional agencies. For example, DART currently provides technical, data and analysis services to NOAA’s COMPASS modeling efforts in support of the Pacific Salmon Treaty renewal process and CRSO EIS alternatives.

*This section was not available on proposals submitted prior to 9/1/2011

RM&E Protocols and Methods

RM&E Protocol	Deliverable	Method Name and Citation
DART - Data Analysis v1.0	Web-based, regionally integrated, monitoring and evaluation services (DELV-3)<br />Adaptive, issue-driven product development and implementation (DELV-5)	Calculating the smolt to adult return rate (SAR) v1.0 (Coordinated Assessments Data Exchange Standard Development Team 2014) Cormack-Jolly-Seber (CJS) Model v1.0 (Burnham, K. P., D. R. Anderson, G. C. White, C. Brownie, and K. H. Pollock. 1987) PIT Tag Lifestage Filter v1.0 (Susannah Iltis) Conversion Rates based on PIT Tag dataset v1.0 (Susannah Iltis) Travel time estimates based on PIT Tag dataset v1.0 (Susannah Iltis 2013) Columbia Basin PIT-Tagged ESU and DPS populations v1.0 (Susannah Iltis) Mean Spring and Fall Upwelling Transition Dates v1.0 (Van Holmes, C 2007) PIT Tag Transportation Filter v1.0 (Susannah Iltis)

Project Deliverables & Budget

Project Deliverable	Start	End	Budget
Regionally Integrated Database in working order (DELV-1)	2020	2023	$176,363
Integrated, regional research and management database (DELV-2)	2020	2023	$293,938
Web-based, regionally integrated, monitoring and evaluation services (DELV-3)	2020	2023	$117,575
Publicly accessible, web-based interface to integrated research database (DELV-4)	2020	2023	$117,575
Adaptive, issue-driven product development and implementation (DELV-5)	2020	2023	$352,725
Specialized user-requested datasets and metadata (DELV-6)	2020	2023	$117,575
		Total	$1,175,751

Requested Budget by Fiscal Year

Fiscal Year	Proposal Budget Limit	Actual Request	Explanation of amount above FY2019
2020	$293,938	$293,939	rounding error
2021	$293,938	$293,939	rounding error
2022	$293,938	$293,939	rounding error
2023	$293,938	$293,934	rounding error
Total	$1,175,752	$1,175,751

There are no Line Item Budget entries for this proposal.

Major Facilities and Equipment explanation:
We are a group of staff, students, and faculty in the University of Washington, School of Aquatic and Fishery Sciences. We maintain offices in downtown Seattle and are an integral part of the University. We maintain our computing facilities; the University computing services maintains our internet connection and oversees internet operations. On campus, the facilities and administrative costs (i.e., indirect cost or overhead rate) is 56%; off campus, it is 26%. The indirect cost rates are negotiated between UW and the federal government for contracts across the university. In lieu of the campus overhead rate, this contract must pay for leased office space. The lease rates negotiated for this project range from $30.00/sq ft in 2018 to $33.00/sq ft in 2020. Currently, we co-occupy 3,553 sq ft of office space with another UW faculty member, John Skalski, and his staff, who are also supported by BPA and the Fish and Wildlife Program; this lease expires during FY2021. The database management system, Columbia Basin Research web site, and all related file systems reside on a Dell server, an off-site network attached storage device, and off-site backup service. Our program services are functional throughout the calendar year with a focus on providing in-depth services and regional support during juvenile and adult migration and spill seasons. We will continue assessments of hardware purchased and supported in-house vs. off-site hardware and hosting services options to best utilize our limited resources and ensure program services availability and continuity. Next expected hardware/hosting services upgrade date is FY2021 or FY2022. Our program services are functional throughout the calendar year with a focus on providing in-depth services and regional support during juvenile and adult migration and spill seasons.

Cost Share

None

Project References or Citations

ACOE (U.S. Army Corps of Engineers Northwestern Division), Bureau of Reclamation Pacific Northwest Region, and Bonneville Power Administration. 2017a. Endangered Species Act. Federal Columbia River Power System, 2016 Comprehensive Evaluation: Section 1. https://www.salmonrecovery.gov/doc/default-source/default-document-library/fcrps2016comprehensiveevaluationsection1.pdf [18 January 2019].

ACOE (U.S. Army Corps of Engineers Northwestern Division), Bureau of Reclamation Pacific Northwest Region, and Bonneville Power Administration. 2017b. Endangered Species Act. Federal Columbia River Power System, 2016 Comprehensive Evaluation: Section 2. https://www.salmonrecovery.gov/doc/default-source/default-document-library/fcrps-2016-comprehensive-evaluation-section-2.pdf [18 January 2019].

AMIP. 2009. FCRPS Adaptive Management Implementation Plan. 2008-2018 Federal Columbia River Power System Biological Opinion. [Online]. Available: http://www.salmonrecovery.gov/Files/BiologicalOpinions/AMIP_09%2010%2009.pdf [18 January 2019].

BPA (Bonneville Power Administration). 2008. Administrator’s Record of Decision 2008 Columbia Basin Fish Accords. [Online]. Available: http://www.salmonrecovery.gov/Files/BiologicalOpinions/MOA_ROD.pdf [18 January 2019].

BPA (Bonneville Power Administration). 2010. 2008 FCRPS BiOp RPA By Approach, Strategy. [Online]. Available http://www.cbfish.org/Reports/ReportViewer.aspx?RptName=2008FCRPSBiOp&rs%3aFormat=PDF [18 January 2019].

Carlson, T.J., G.E. Johnson. 2010. Columbia River Channel Improvement Project Rock Removal Blasting: Monitoring Plan. Final Plan. PNNL-19076. [Online]. Available: http://www.pnl.gov/main/publications/external/technical_reports/PNNL-19076.pdf [18 January 2019].

CBR (Columbia Basin Research). 2011. DART PIT Tag Subbasins - Interrogation Sites, Recapture Locations, and Year Ranges. [Online]. Available http://www.cbr.washington.edu/dart/pit_basin_years_all [18 January 2019].

Corps (U.S. Army Corps of Engineers), BPA (Bonneville Power Administration), and USBR (U.S. Bureau of Reclamation). 2007. Biological Assessment for Effects of Federal Columbia River Power System and Mainstem Effects of Other Tributary Actions on Anadromous Salmonid Species Listed Under the Endangered Species Act. [Online]. Available: http://www.salmonrecovery.gov/Files/BiologicalOpinions/BA_MAIN_TEXT_FINAL_08-20-07_Updated_08-27.pdf [18 January 2019].

Gerstenberger, R., L. Brewer, and B. Eineichner. 2011. “Hood River Production Program Monitoring and Evaluation”, 2009-2010 Annual Report, Project No. 198805303, 78 electronic pages, (BPA Report DOE/BP-P122923). [Online]. Available: https://www.cbfish.org/Document.mvc/Viewer/P122923 [18 January 2019].

Gerstenberger, R., M. McKim, and B. Eineichner. 2016. “Hood River Production Program Monitoring and Evaluation”, 2014-2015 Annual Report, Project No. 198805303, 50 electronic pages. [Online]. Available: http://docs.streamnetlibrary.org/BPA_Fish_and_Wildlife/P150184.pdf [18 January 2019].

Halsing, D.L., M.R. Moore. 2008. Cost-Effective Management Alternatives for Snake River Chinook Salmon: a Biological-Economic Synthesis. Conservation Biology. 22(2):338-350.

Halton, E. 2010. Columbia River Regional Forum Technical Management Team. April 28, 2010. Facilitator’s summary notes. [Online]. Available: http://pweb.crohms.org/tmt/agendas/2010/TMT_2010_Jan-Jun.pdf  [18 January 2019].

Keefer, M.L., C.A. Peery, C.C. Caudill. 2008. Migration Timing of Columbia River Spring Chinook Salmon: Effects of Temperature, River Discharge, and Ocean Environment. Transactions of the American Fisheries Society. 137(4):1120-1133.

Logerwell, E.A., N. Mantua, P. Lawson, R.C. Francis, V. Agostini. 2003. Tracking environmental processes in the coastal zone for understanding and predicting Oregon coho (Oncorhynchus kisutch) marine survival. Fisheries Oceanography 12:554-568. 

MERR. 2010. See NPPC 2010.

NED (Northwest Environmental Data Network). 2006a. Best Practices for Data Dictionary Definitions and Usage.

NED (Northwest Environmental Data Network). 2006b. Check List for Organizing Field Collection and Management of Data.

NED (Northwest Environmental Data Network). 2007. Best Practices for Reporting Location and Time Related Data.

NMFS (National Marine Fisheries Service). 2008a. Executive Summary 2008 Willamette Project Biological Opinion. [Online]. Available https://www.westcoast.fisheries.noaa.gov/publications/hydropower/willamette/will-exsum.pdf [18 January 2019].

NMFS (National Marine Fisheries Service). 2008b. Endangered Species Act - Section 7(a)(2) consultation. Biological Opinion & Magnuson-Stevens Fishery Conservation & Management Act Essential Fish Habitat Consultation. Consultation on the "Willamette River Basin Flood Control Project".

NMFS (National Marine Fisheries Service). 2008c. Endangered Species Act Section 7(a)(2) Consultation Biological Opinion and Magnuson-Stevens Fishery Conservation and Management Act Essential Fish Habitat Consultation: Consultation on Remand for Operation of the Federal Columbia River Power System, 11 Bureau of Reclamation Projects in the Columbia Basin and ESA Section 10(a)(I)(A) Permit for Juvenile Fish Transportation Program (Revised and reissued pursuant to court order, NWF v. NMFS, Civ. No. CV 01-640-RE (D. Oregon)).

NMFS (National Marine Fisheries Service). 2010a. Endangered Species Act - Section 7(a)(2) consultation. Supplemental Biological Opinion. Supplemental Consultation on Remand for Operation of the Federal Columbia River Power System, 11 Bureau of Reclamation Projects in the Columbia Basin and ESA Section 10(a)(I)(A) Permit for Juvenile Fish Transportation Program.

NMFS (National Marine Fisheries Service). 2010b. West Coast Salmon & Steelhead Listings . [Online]. Available: https://www.westcoast.fisheries.noaa.gov/protected_species/salmon_steelhead/salmon_and_steelhead_listings/salmon_and_steelhead_listings.html [18 January 2019].

NMFS (National Marine Fisheries Service). 2014. Endangered Species Act Section 7(a)(2). Supplemental Biological Opinion. Consultation on Remand for Operation of the Federal Columbia River Power System. [Online]. Available: https://www.westcoast.fisheries.noaa.gov/publications/hydropower/fcrps/2014_supplemental_fcrps_biop_final.pdf [18 January 2019].

NOAA Fisheries. NA. Reasonable and Prudent Alternative Table: Adaptive Management Actions. [Online]. Available: https://www.nwcouncil.org/sites/default/files/RPA.pdf [18 January 2019].

NOAA Fisheries. 2008. Supplemental Comprehensive Analysis of the Federal Columbia River Power System and Mainstem Effects of the Upper Snake and other Tributary Actions. [Online]. Available: https://www.westcoast.fisheries.noaa.gov/publications/hydropower/fcrps/final-sca.pdf  [18 January 2019].

NPPC (Northwest Power and Conservation Council). 2000. Columbia River Basin Fish and Wildlife Program (2000-19). [Online]. Available: https://www.nwcouncil.org/fish-and-wildlife/previous-programs/columbia-river-basin-fish-and-wildlife-program-2000 [18 January 2019].

NPPC (Northwest Power and Conservation Council). 2009. Columbia River Basin Fish and Wildlife Program: 2009 Amendments (2009-09). [Online]. Available: https://www.nwcouncil.org/fish-and-wildlife/previous-programs/columbia-river-basin-fish-and-wildlife-program-2009 [18 January 2019].

NPPC (Northwest Power and Conservation Council). 2010. Draft Columbia River Basin Monitoring, Evaluation, Research and Reporting (MERR) Plan. Version: 4 November 2010 (2010-17).

NPPC (Northwest Power and Conservation Council). 2014. Columbia River Basin Fish and Wildlife Program (2014-12). [Online]. Available: https://www.nwcouncil.org/reports/2014-columbia-river-basin-fish-and-wildlife-program  [18 January 2019].

NPPC (Northwest Power and Conservation Council). 2017. Columbia River Basin Fish and Wildlife Program: 2017 Research Plan (Pre-publication version) (2017-4). [Online]. Available: https://www.nwcouncil.org/sites/default/files/2017-4.pdf [18 January 2019].

Peterson, W.T., Hooff, R.C., Morgan, C.A., Hunter, K.L., Casillas, E. and Ferguson, J.W. 2006. Ocean Conditions and Salmon Survival in the Northern California Current.

Recommendations. 2010. Recommendations for Implementing Research, Monitoring and Evaluation for the 2008 NOAA Fisheries FCRPS BiOp. Based on AA/NOAA/NPCC RM&E Workgroup Assessments.

Rentmeester, S., ed. 2010. Regional Guidance on Metadata for Environmental Data. [Online]. Available: https://s3.us-west-2.amazonaws.com/org-pnamp-assets/prod/PNAMP%202010-001_MetadataGuidance.pdf [18 January 2019].

Schmidt, B. 2009. Considerations for Regional Data Collection, Sharing and Exchange. [Online]. Available: https://s3.us-west-2.amazonaws.com/org-pnamp-assets/prod/Data_Sharing_Guide_2009-06-01.pdf  [18 January 2019].

Silverberg, D. 2018. Columbia River Technical Management Team, May 16, 2018, Facilitator’s Summary. [Online] Available: http://pweb.crohms.org/tmt/agendas/2018/0516_Minutes_Revised.pdf [18 January 2019].

Van Holmes, C. 2007. Mean Spring and Fall Upwelling Transition Dates off the Oregon and Washington Coasts. [Online]. Available: http://www.cbr.washington.edu/sites/default/files/papers/trans.cbrmean.pdf  [18 January 2019].

Witt, A., Magee T., Stewart, K., Hadjerioua, B., Neumann, D.,  Zagona, E., Politano, M. 2017. Development and Implementation of an Optimization Model for Hydropower and Total Dissolved Gas in the Mid-Columbia River System. Journal of Water Resources Planning and Management. Volume 143 Issue 10.

Notes

DART has been in continuous operation as a database service for the Columbia River since 1992. The budget has been fixed for a decade so to maintain the level of services we have implemented cost saving measures including fixed salaries, reduced staff, delayed equipment purchases, downsizing our space and eliminating administration support. The project has been sustained by expanding the DART services to the Sacramento River system under funding from the Bureau of Reclamation. In spited of these efforts our basic cost continue to increase and so we anticipate additional reduction in DART services. The level reductions to a degree depend on future BOR funding which extends through 2020. If we are not able to maintain a basis level of funding after 2020 I anticipate DART would be absorbed by an environmental consulting firm. In this move DART could potentially expand nationally or globally and services to Columbia River would be significantly reduced for the current level of funding.

2019-2021 Mainstem/Program Support Assessments

Review: 2019-2021 Mainstem/Program Support

Independent Scientific Review Panel Assessment

First Round ISRP Comment:
Assessment Number:	1996-019-00-ISRP-20190404
Project:	1996-019-00 - Data Access in Real Time (DART)
Review:	2019-2021 Mainstem/Program Support
Proposal Number:	NPCC19-1996-019-00
Completed Date:	None
First Round ISRP Date:	4/4/2019
First Round ISRP Rating:	Meets Scientific Review Criteria
Comment: The project is to be commended for looking at ways to add value to the database. For example, the project plans to provide information to hatcheries that can be used for managing hatchery practices. 1. Objectives, Significance to Regional Programs, and Technical Background Objectives are clear. The project provides support for the COMPASS life-cycle model. The proposal identifies that this project's significance to regional programs is due to providing data integration, web-based information, and analytical services that help connect primary databases, monitoring programs, decision makers, and resource users. 2. Results and Adaptive Management The proposal states that services provided by this project support critical uncertainties research themes (D) Hydrosystem flow and passage operations and (F) Population structures of diversity identified in the Council's 2017 Research Plan. This project also reports data availability, data anomalies, formatting, and accuracy issues to primary data sources. Evidence of the amount and utility of this feedback to primary sources would be useful for this and future ISRP reviews. Adaptive management is mentioned in the proposal in the sense that this project generates products such as data tools, analysis methods, and predictive models that can be used to support all areas of Fish and Wildlife Program adaptive management. It appears that adaptive management per se is not applied within this project but could be of use to consider the impact of vastly more data from increased detections, more precise detections, and additional methods of tagging. 3. Methods: Project Relationships, Work Types, and Deliverables The proposal documents relationships that this second-tier data base has with many data base projects in the region. This project is a data management work type with data management issues dealt with properly. The interactive web-based query system appears to work very well. Most of the sources for DART data are the entities that provide public access to primary data. This project provides access to its research database through a web-based interface and through delivery of user-requested datasets and metadata. It is not clear how it is decided which data should be stored in DART. The project develops procedures to ensure the quality of all integrated datasets. It also provides feedback to primary data sources on data quality issues.
Documentation Links:	Proponent Presentation
Proponent Response:

Map Visibility:
Map Name:
Description:

Please correct the errors noted below.

View the dynamic Proposal Summary

Download a snapshot PDF

Summary of Budgets

Actual Project Cost Share

Current Fiscal Year — 2025

Previous Fiscal Years

Selected Contracted Deliverables in CBFish (2004 to present)

Council Recommendation

Independent Scientific Review Panel Assessment

Comment:

1. Objectives, Significance to Regional Programs, and Technical Background

2. Results and Adaptive Management

3. Methods: Project Relationships, Work Types, and Deliverables

Independent Scientific Review Panel Assessment

Council Recommendation

Independent Scientific Review Panel Assessment

Public Attachments in CBFish

Other Project Documents on the Web

Independent Scientific Review Panel Assessment

Comment:

1. Objectives, Significance to Regional Programs, and Technical Background

2. Results and Adaptive Management

3. Methods: Project Relationships, Work Types, and Deliverables