 | RESCAT-1996-019-00 | Proposal Version 1 | Existing Project | Pending Council Recommendation | 1996-019-00 | Data Access in Real Time (DART) | 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 effectively addresses the Northwest Power and Conservation Council’s four tiers of implementation criteria of contribution to program success, feasibility, efficiency, and cost savings (NPPC 2010).
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-oriented 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 Pacific States Marine Fisheries Commission (PSMFC). We established our web site in March 1994. In September 1994, we implemented one of the first web accessible query systems that allowed public users to query our in-house database. In 1995, we implemented a variety of data selection and graphical display tools with the release of the Netscape browser. Since that time, the DART system has continued to grow and develop in response to regional data, analysis, forecasting, and management needs.
DART strives to provide real-time data and on-line analytical processing services in accordance with the Columbia River Basin Fish and Wildlife Program (NPPC 2000, 2009) and 2010 Supplemental FCRPS Biological Opinion (NMFS 2010a) and to anticipate reporting and analysis needs of the region at large: both to illustrate 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 2007, 2008b, 2008c, 2010a; NOAA Fisheries 2008) 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 20 years. The main areas of research are in ecological modeling and wildlife statistics.
DART uses various transfer protocols and programs to obtain data from other sites disseminating data electronically. Daily real-time data and historic information is accessible through the website query forms and by direct requests to DART staff. Currently, detailed information is retrieved daily from more than seventeen 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 continued service.
DART compliments 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 analysis capabilities for evaluating water 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 Columbia River Basin Fish and Wildlife Program (FWP) participants needing integration of data and can be used to implement effective monitoring and evaluation of RPAs in real-time. 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 in-season 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:
• 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;
• Monitoring and reporting 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;
• Detail and summary statistics and analysis of PTAGIS data for juveniles and adults;
• In-season real-time run predictions for juvenile and adult stocks with an annual review of run-timing predictions;
• Reports of migrant exposure to environmental conditions.
DART conducts quarterly and annual reviews of user query patterns and affiliations to track, ensure relevance, and improve reporting and analysis tools. Usage of the DART services peaks with the spring and fall adult migration timing. For the past 6 years, DART annually delivers 400,000-600,000 database query results. Online surveys and data feedback forms allow for user input on a range of issues. Direct feedback is solicited from a number of individually identifiable users every quarter. DART staff respond rapidly and effectively to analysis needs and specialized data requests from the region and beyond.
DART supports regional efficiency, collaboration, and cost savings through numerous relationships with other BPA funded projects and regional entities (see Relationships section). 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 servers from January 2010 – May 2011 while PNAMP web services were in transition. DART provides release, survival and travel time analyses integrated with 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 and the current Pacific Salmon Treaty renewal process.
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. | Christine Muongchanh (Inactive) | | | 10/21/2011 | 04/16/2012 | Christine Muongchanh (Inactive) | University of Washington | Hydrosystem | None | Resident Fish, Regional Coordination, and Data Management Category Review | Resident Fish, Regional Coordination, and Data Management Categorical Review | BiOp |
| NPCC19-1996-019-00 | Proposal Version 2 | Existing Project | Pending Council Recommendation | 1996-019-00 | Data Access in Real Time (DART) | 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. | Rasa Keanini (Inactive) | | $293,938 | 11/14/2018 | 05/30/2019 | Rasa Keanini (Inactive) | University of Washington | Hydrosystem | None | 2019-2021 Mainstem/Program Support | 2019-2021 Mainstem/Program Support | BiOp |
Help
Mitigation work
Reporting
Funding
Search
Log in
Follow this via RSS feed. Help setting up RSS feeds?
Go to main Proposals page
