This page provides a read-only view of a Proposal. The sections below are organized to help review teams quickly and accurately review a proposal and therefore may not be in the same order as the proposal information is entered.
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.
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.
Archive | Date | Time | Type | From | To | By |
10/21/2011 | 12:59 PM | Status | Draft | <System> | ||
10/21/2011 | 12:59 PM | Status | Draft | <System> | ||
Download | 11/30/2011 | 12:40 PM | Status | Draft | ISRP - Pending First Review | <System> |
2/16/2012 | 2:14 PM | Status | ISRP - Pending First Review | ISRP - Pending Final Review | <System> | |
4/16/2012 | 8:47 PM | Status | ISRP - Pending Final Review | Pending Council Recommendation | <System> |
Proposal Number:
|
RESCAT-1996-019-00 | |
Proposal Status:
|
Pending Council Recommendation | |
Proposal Version:
|
Proposal Version 1 | |
Review:
|
Resident Fish, Regional Coordination, and Data Management Category Review | |
Portfolio:
|
Resident Fish, Regional Coordination, and Data Management Categorical Review | |
Type:
|
Existing Project: 1996-019-00 | |
Primary Contact:
|
James Anderson | |
Created:
|
10/21/2011 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 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. |
|
|
||
Purpose:
|
Hydrosystem | |
Emphasis:
|
Data Management | |
Species Benefit:
|
Anadromous: 98.0% Resident: 2.0% Wildlife: 0.0% | |
Supports 2009 NPCC Program:
|
Yes | |
Subbasin Plan:
|
||
Fish Accords:
|
None | |
Biological Opinions:
|
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 in-season 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.
Monitor status and trends of juvenile Columbia Basin ESA listed and non-listed fish in real-time (OBJ-1)
FCRPS 2008 (RPA 50.3, 50.4, 50.6, 51, 52.2, 53.2, 54.7, 55.2, 55.4, 56.3, 71.4) and MERR 2010.
Provide federal, tribal, and state managers and researchers 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, and hydrologic conditions in tributaries and 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)
FCRPS 2008 (50.2, 50.4, 50.5, 50.6, 51, 52.3, 52.7, 52.8, 53.4, 54.11, 55.2, 55.4, 56.3, 71.4) and MERR 2010.
Provide 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 in-season 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)
FCRPS 2008 (RPA 50.2, 50.3, 50.4, 50.5, 50.6, 51, 52.2, 52.3, 52.7, 52.8, 53.2, 53.4, 54.7, 54.11, 55.2, 55.4, 56.3, 61.1, 71.4, 72) and MERR 2010.
Provide an independent source of integrated public data, complimenting 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)
FCRPS 2008 (RPA 50.2, 50.3, 50.4, 50.5, 50.6, 51, 52.2, 52.3, 52.7, 52.8, 53.2, 53.4, 54.7, 54.11, 55.2, 55.4, 56.3, 61.1, 71.4, 72) and MERR 2010.
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 and web-based public access to datasets. 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)
FCRPS 2008 (50.2, 50.3, 50.4, 50.5, 50.6, 51, 52.2, 52.3, 52.7, 52.8, 53.2, 53.4, 54.7, 54.11, 55.2, 55.4, 56.3, 61.1, 71.4, 72).
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. |
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
Expense | SOY Budget | Working Budget | Expenditures * |
---|---|---|---|
FY2019 | $293,938 | $293,938 | $287,662 |
|
|||
BiOp FCRPS 2008 (non-Accord) | $293,938 | $287,662 | |
FY2020 | $293,938 | $293,938 | $247,012 |
|
|||
BiOp FCRPS 2008 (non-Accord) | $293,938 | $247,012 | |
FY2021 | $293,938 | $293,938 | $325,475 |
|
|||
BiOp FCRPS 2008 (non-Accord) | $293,938 | $325,475 | |
FY2022 | $293,938 | $293,938 | $291,311 |
|
|||
BiOp FCRPS 2008 (non-Accord) | $293,938 | $291,311 | |
FY2023 | $293,938 | $293,938 | $298,534 |
|
|||
BiOp FCRPS 2008 (non-Accord) | $293,938 | $298,534 | |
FY2024 | $306,871 | $306,871 | $298,702 |
|
|||
BiOp FCRPS 2008 (non-Accord) | $306,871 | $298,702 | |
FY2025 | $306,871 | $306,871 | $170,218 |
|
|||
BiOp FCRPS 2008 (non-Accord) | $306,871 | $170,218 | |
* Expenditures data includes accruals and are based on data through 31-Mar-2025 |
Cost Share Partner | Total Proposed Contribution | Total Confirmed Contribution |
---|---|---|
There are no project cost share contributions to show. |
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 |
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 |
View full Project Summary report (lists all Contracted Deliverables and Quantitative Metrics)
Explanation of Performance:DART is a Research, Monitoring and Evaluation (RME) database project providing user-defined web-based data query and analysis tools to agencies, governments, researchers and the public. DART provides access to temporally and spatially integrated raw and summary data from numerous primary sources in the region. 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’s ESU and DPS stocks. 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 Army Corps adult passage data, 1938-present, which was not available in digital form from the Army Corps until 2010. In cooperation with ISEMP and WDFW, DART developed web-based 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 standardize the efficient handling and analysis of these datasets for specific research questions, and to allow comparable, reproducible results across research studies.
DART rapidly develops and deploys new and updated tools in response to user requests and regional needs, since the beginning of the project.
DART is an efficient and cost-effective second-tier database project that effectively leverages hardware and software technologies without expanding personnel costs. We managed and maintained our previous database server for nearly a decade while delivering excellent service to the region. To ensure continuity of all database, web, and analysis services, DART successfully completed all phases of a major server hardware, operating system, database management system, web server, and backup system upgrade in the beginning of FY2007. The upgrade process was completed on schedule with virtually no disruption to internal or external users. Due to more rapid cycling of hardware support, the next hardware and system upgrade will be due in FY2012.
The project responds rapidly to specialized data requests. To support regional research and decision-making processes, during FY2007-2010, DART provided specialized data services to the following entities.
Entity |
Entity |
Entity |
Battelle |
Fisher Fisheries |
Qualls Agricultural Laboratory |
Bear Sterns |
Forsgren Assoc. |
Sandia National Laboratories |
Blue Leaf Enviro |
GCPUD |
State of Oregon |
BPA |
Hinrichsen Environmental |
TerraGraphics Environmental Engineering |
Cargill |
Hood River Production Program Confederated Tribes of Warm Springs |
Umatilla Tribe |
CCPUD |
HTI |
University of Idaho |
Center for Biological Diversity |
Idaho Statesman |
USACE |
Colgate University |
IDFG |
USFWS |
Columbia River Crossing |
NOAA |
USGS |
Colville Tribes |
NW River Partners |
UW |
Confederated Tribes of the Warm Springs |
Osbourne Elementary |
UW Climate Group |
CWU |
Pace Global |
WDFW |
DCPUD |
Parametrix |
WDOT |
Eastern Oregon University |
Paulsen Environmental |
Yakima Basin Fish & Wildlife Recovery Board |
ECY |
PNDEngineers |
YKFP |
Energy NewsData |
PNGC Power |
|
EOU |
PNL |
|
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. The following is a selected, wide ranging list of published papers citing DART as a source.
Anderson, JJ, Gurarie, E & Zabel, RW. 2005. Mean free-path length theory of predator-prey interactions: Application to juvenile salmon migration. Ecological Modelling, 186, 196-211.
Bracis, C. & Anderson, JJ. in press. An investigation of the geomagnetic imprinting hypothesis for salmon. Fisheries Oceanography.
Clemens, BJ, Clements, SP, Karnowski, MD, Jepsen, DB, Gitelman, AI & Schreck, CB. 2009. Effects of Transportation and Other Factors on Survival Estimates of Juvenile Salmonids in the Unimpounded Lower Columbia River. Transactions of the American Fisheries Society, 138, 169-188.
Crozier, LG, Hendry, AP, Lawson, PW, Quinn, TP, Mantua, NJ, Battin, J, Shaw, RG & Huey, RB. 2008. Potential responses to climate change in organisms with complex life histories: evolution and plasticity in Pacific salmon. Evolutionary Applications, 1, 252-270.
Haskell, CA, Tiffan, KF & Rondorf, DW. 2006. Food habits of juvenile American shad and dynamics of zooplankton in the lower Columbia River. Northwest Science, 80, 47-64.
Hershberger, PK et al., 2010. Amplification and transport of an endemic fish disease by an introduced species. Biological Invasions, 12, 3665-3675.
Johnson, GE, Anglea, SM, Adams, NS & Wik, TO. 2005. Evaluation of a prototype surface flow bypass for juvenile salmon and steelhead at the powerhouse of Lower Granite Dam, Snake River, Washington, 1996-2000. North American Journal of Fisheries Management, 25, 138-151.
Johnson, LL, Willis, ML, Olson, OP, Pearce, RW, Sloan, CA & Ylitalo, GM. 2010. Contaminant Concentrations in Juvenile Fall Chinook Salmon from Columbia River Hatcheries. North American Journal of Aquaculture, 72, 73-92.
Keefer, ML, Boggs, CT, Peery, C & Caudill, CC. 2008. Overwintering distribution, behavior, and survival of adult summer steelhead: Variability among Columbia River populations. North American Journal of Fisheries Management, 28, 81-96.
Keefer, ML, Moser, ML, Boggs, CT, Daigle, WR & Peery, CA. 2009. Effects of Body Size and River Environment on the Upstream Migration of Adult Pacific Lampreys. North American Journal of Fisheries Management, 29, 1214-1224.
Keefer, ML, Peery, CA & Caudill, CC. 2008. Migration timing of Columbia River spring Chinook salmon: Effects of temperature, river discharge, anti ocean environment. Transactions of the American Fisheries Society, 137, 1120-1133.
Larsen, DA, Beckman, BR, Cooper, KA, Barrett, D, Johnston, M, Swanson, P & Dickhoff, WW. 2004. Assessment of high rates of precocious male maturation in a spring Chinook salmon supplementation hatchery program. Transactions of the American Fisheries Society, 133, 98-120.
Maier, GO & Simenstad, CA. 2009. The Role of Marsh-Derived Macrodetritus to the Food Webs of Juvenile Chinook Salmon in a Large Altered Estuary. Estuaries and Coasts, 32, 984-998.
McLellan, HJ., Hayes, SG & Scholz, AT. 2008. Effects of reservoir operations on hatchery coastal rainbow trout in Lake Roosevelt, Washington. North American Journal of Fisheries Management, 28, 1201-1213.
Meeuwig, MH & Bayer, JM. 2005. Morphology and aging precision of statoliths from larvae of Columbia River basin lampreys. North American Journal of Fisheries Management, 25, 38-48.
Meeuwig, MH, Bayer, JM & Reiche, RA. 2006. Morphometric discrimination of early life-stage Lampetra tridentata and L. richardsoni (Petromyzonidae) from the Columbia River Basin. Journal of Morphology, 267, 623-633.
Meeuwig, MH, Bayer, JM & Seelye, JG. 2005. Effects of temperature on survival and development of early life-stage pacific and western brook lampreys. Transactions of the American Fisheries Society, 134, 19-27.
Mueller, RP, Moursund, RA & Bleich, MD. 2006. Tagging juvenile pacific lamprey with passive integrated transponders: Methodology, short-term mortality, and influence on swimming performance. North American Journal of Fisheries Management, 26, 361-366.
Naughton, GP, Caudill, CC, Keefer, ML, Bjornn, TC, Peery, CA & Stuehrenberg, LC. 2006. Fallback by adult sockeye salmon at Columbia River dams. North American Journal of Fisheries Management, 26, 380-390.
Naughton, GP, Caudill, CC, Peery, CA, Clabough, TS, Jepson, MA, Bjornn, TC & Stuehrenberg, LC. 2007. Experimental evaluation of fishway modifications on the passage behaviour of adult Chinook salmon and steelhead at Lower Granite Dam, Snake River, USA. River Research and Applications, 23, 99-111.
Naughton, GP, Jepson, MA, Peery, CA, Brun, CV & Graham, JC. 2009. Effects of Temporary Tributary Use on Escapement Estimates of Adult Fall Chinook Salmon in the Deschutes River, Oregon. North American Journal of Fisheries Management, 29, 1511-1518.
Paulsen, CM, Hinrichsen, RA & Fisher, TR. 2007. Measure twice, estimate once: Pacific salmon population viability analysis for highly variable populations. Transactions of the American Fisheries Society, 136, 346-364.
Reischel, TS & Bjornn, TC. 2003. Influence of fishway placement on fallback of adult salmon at the Bonneville Dam on the Columbia River. North American Journal of Fisheries Management, 23, 1215-1224.
Salinger, DH, & Anderson, JJ. 2006. Effects of water temperature and flow on adult salmon migration swim speed and delay. Transactions of the American Fisheries Society, 135, 188-199.
Smith, SG, Muir, WD, Hockersmith, EE, Zabel, RW, Graves, RJ, Ross, CV, Connor, WP & Arnsberg, BD. 2003. Influence of river conditions on survival and travel time of Snake River subyearling fall chinook salmon. North American Journal of Fisheries Management, 23, 939-961.
Tiffan, KF, Haskell, CA & Rondorf, DW. 2003. Thermal exposure of juvenile fall chinook salmon migrating through a lower Snake River Reservoir. Northwest Science, 77, 100-109.
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] |
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 |
First Round ISRP Comment: | |
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 BackgroundObjectives 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 ManagementThe 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 DeliverablesThe 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: |
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 |
Final Round ISRP Comment: | |
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: |
|
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: |
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) |
Final Round ISRP Comment: | |
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: |
|
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: | 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 Evolutionarily Significant Unit (ESU) 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.
• 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.
• 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.
• Monitoring and Evaluation Statistical Support for Life-Cycle Studies Project# 1991-051-00
DART Services: Provide raw 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, adult count adjustor rates, and predictions of smolt out-migration timing.
• 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.
• 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.
• Yakama Klickitat Fisheries Management, Data and Habitat Project# 1988-120-25
DART Services: Maintain an 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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. 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.
• 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.
• 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.
Work Classes
![]() |
Work Elements
RM & E and Data Management:
159. Transfer/Consolidate Regionally Standardized Data160. Create/Manage/Maintain Database 161. Disseminate Raw/Summary Data and Results 162. Analyze/Interpret Data |
Name (Identifier) | Area Type | Source for Limiting Factor Information | |
---|---|---|---|
Type of Location | Count | ||
Columbia River | Basin | None |
Work Class | Work Elements | ||||
Research, Monitoring, and Evaluation + Data Management |
|
Work Class | Work Elements | ||||
Research, Monitoring, and Evaluation + Data Management |
|
Work Class | Work Elements | ||||
Research, Monitoring, and Evaluation + Data Management |
|
Work Class | Work Elements | ||||
Research, Monitoring, and Evaluation + Data Management |
|
Work Class | Work Elements | ||||||
Research, Monitoring, and Evaluation + Data Management |
|
Work Class | Work Elements | ||||||
Research, Monitoring, and Evaluation + Data Management |
|
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, 2007; BPA 2008). |
|
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, 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 2011, DART worked closely with ISEMP to develop and implement the publicly accessible, web-based DART PIT Tag Adult Sampling and Tagging at Ladders, specifically Lower Granite Dam Ladder trap, to allow users access to the PIT tagged fish associated the ISEMP steelhead and spring/summer Chinook salmon adult PIT tagging project, otherwise known as the "Valid Sample List.” These tags are used in the generation of escapement estimates in tributary streams upstream of the detection location. This service ensures all users of the adult PIT tagging project have the same valid sample list. The process to determine the valid sample list is complex and requires data mining and data integration of several sources of information from Multimon interrogation files and PTAGIS datasets: • Tagging - From tagging files • Recapture - From tagging files • SbyC fish and period - From Multimon files for Lower Granite Adult Ladder • Sampling Period - From Multimon files for Lower Granite Adult Ladder Before this publicly accessible DART service, the list was created by hand and it was difficult to provide a list in a timely fashion to all cooperators and users, and ensure that users had the most up-to-date version. DART employed rapid prototyping methods and feedback from ISEMP 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 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. |
|
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 compliments 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. |
|
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. |
|
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, addressing RPA 52.3 Monitor and evaluate adult salmonid system survival upstream through the FCRPS, DART will expand functionality of the “PIT Tag Adult Returns Conversion Rate” analysis tool to incorporate information on wander/stray events—integrating PTAGIS recapture, mortality, and tributary and mainstem interrogation datasets into the analyses. 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 10 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 |
|
RM&E Protocol | Deliverable | Method Name and Citation |
DART - Data Analysis v1.0 |
Project Deliverable | Start | End | Budget |
---|---|---|---|
Regionally Integrated Database in working order (DELV-1) | 2013 | 2017 | $262,968 |
Integrated, regional research and management database (DELV-2) | 2013 | 2017 | $438,280 |
Web-based, regionally integrated, monitoring and evaluation services (DELV-3) | 2013 | 2017 | $175,312 |
Publicly accessible, web-based interface to integrated research database (DELV-4) | 2013 | 2017 | $175,312 |
Adaptive, issue-driven product development and implementation (DELV-5) | 2013 | 2017 | $525,936 |
Specialized user-requested datasets and metadata (DELV-6) | 2013 | 2017 | $175,312 |
Total | $1,753,120 |
Fiscal Year | Proposal Budget Limit | Actual Request | Explanation of amount above FY2012 |
---|---|---|---|
2013 | $333,387 | See line item budget for FY 2013. | |
2014 | $341,768 | See line item budget for FY 2014. | |
2015 | $350,384 | See line item budget for FY 2015. | |
2016 | $359,239 | See line item budget for FY 2016. | |
2017 | $368,342 | See line item budget for FY 2017. | |
Total | $0 | $1,753,120 |
Item | Notes | FY 2013 | FY 2014 | FY 2015 | FY 2016 | FY 2017 |
---|---|---|---|---|---|---|
Personnel | Est. salaries and benefits for personnel. FTEs: PI (8%), Data Mgr (100%), Web Mgr (100%), Opr Mgr ( | $235,927 | $241,825 | $247,871 | $254,067 | $260,419 |
Travel | Trips to regional meetings. | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Prof. Meetings & Training | $0 | $0 | $0 | $0 | $0 | |
Vehicles | $0 | $0 | $0 | $0 | $0 | |
Facilities/Equipment | (See explanation below) | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Rent/Utilities | Office lease is prorated between Dr. Skalski's and Dr. Anderson's groups. | $19,000 | $19,950 | $20,948 | $21,995 | $23,095 |
Capital Equipment | $0 | $0 | $0 | $0 | $0 | |
Overhead/Indirect | 26% of MTDC | $62,810 | $64,343 | $65,915 | $67,527 | $69,178 |
Other | Other Contractual Services & Supplies | $3,650 | $3,650 | $3,650 | $3,650 | $3,650 |
PIT Tags | $0 | $0 | $0 | $0 | $0 | |
Total | $333,387 | $341,768 | $350,384 | $359,239 | $368,342 |
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 |
Final Round ISRP Comment: | |
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: |
|
Proponent Response: | |
|