Welcome to a preview of the new CBFish. Until the new navigation is permanently enabled, you’ll be able to toggle between the old and the new version of the navigation. Learn more
62696: 1996-019-00 EXP SECOND-TIER DATABASE AND WEBSITE
70375: 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART)
Contract Status:
Closed
Contract Description:
Columbia River Data Access in Real Time (DART)—second-tier database, data repository, web-based data reporting and analysis services—provides direct, timely, 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.
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 (see list at end of Introduction section). The DART real-time analysis offerings and predictive modeling tools enhance the potential for adaptive management throughout the region.
To illustrate status and to shed light on critical uncertainties, DART strives to provide real-time data and online analytical processing services in accordance with the Columbia River Basin Fish and Wildlife Program and 2010 Supplemental FCRPS Biological Opinion and to anticipate reporting and analysis needs of the region at large. The current scope may be modified as needed to address requirements of the Action Agencies implementation of NOAA Fisheries Biological Opinions, federal court-directed remand of one or more biological opinions, and the regional review of information requirements and services.
Routine reporting and analysis by DART provides information on the impacts of the hydrosystem on fish passage. 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. In addition, the project presents a comprehensive description of fish passage including: pre-season analyses of the impacts of potential hydrosystem operations on migrants; real-time in-season analysis and predictions of smolt migration rate, survival, and transportation; real-time in-season analysis and predictions of adult upstream run size and migration timing; and post-season assessment of the performance of the pre-season and in-season predictions. Summary statistics, trends, reach and system survivals, migration patterns, and exposure indices are monitored on a daily basis throughout the year and provide status measures for numerous stocks. 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 the ESA listed PIT-tagged stocks. Standardized analyses and enumerative products provide research support for basin-wide and sub-basin projects.
Specific hydrosystem and fish passage analyses provided by DART include:
- Monitoring and reporting detailed status of juvenile and adult ESA listed stock migrations based on DART data aggregations of PTAGIS data;
- Juvenile and adult migration status monitoring within the hydrosystem corridor providing reach-specific and system-level passage migration timing and survival information for ESA-listed and non-ESA stocks;
- Reach conversion rates for adult salmonid stocks based on PTAGIS data;
- Tributary status and trend monitoring of juvenile and adult ESA-listed and non-ESA stocks based on PTAGIS data;
- Detail and summary statistics and analysis of PTAGIS data for juveniles and adults;
- Detail and summary statistics and analysis of SMP data;
- 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; and
- Valid sample list identification at Lower Granite Ladder for escapement and tributary population estimates.
DART supports regional efficiency, collaboration, and cost savings through numerous relationships with other BPA funded projects and regional entities. DART is the primary publicly accessible repository for a number of projects in the region including the Adult Anadromous Fish Radiotelemetry Project (1996-2004 datasets), the cooperative Mid Columbia Status for Juvenile and Adult Salmon, and adult passage counts from Chelan and Grant County PUDs as well as Tumwater and Zosel dams. DART also provides public access to Yakima Klickitat Fisheries Project adult passage counts. Through regional cooperation with numerous federal, state, tribal, and private entities, 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.
The following list presents the major relationships DART maintains with other BPA funded projects (BPA Project Title and Project Number provided where available) and regional entities.
Regional cooperation:
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 outmigration 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. Collaborate with the project to develop and provide the data input for the juvenile temporal branching model.
Products: Publicly accessible online analysis tool to generate survival and travel time estimates of user-defined PIT-tagged populations. Publicly accessible online data input file generation for the branching model based on user-defined 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: Publicly accessible analyses produced by this project which include predictions of smolt outmigration timing, transportation percentages, smolt in-river survival, adult upstream migration timing, adult run size, 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.
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) and Distinct Population Segment (DPS) definitions, DART defines stock composition and aggregates PIT-tagged releases and observations for daily monitoring of juvenile and adult ESA stocks. DART also applies a detailed analysis filter of PTAGIS observations 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, tributary status, and ESU/DPS stock-specific analyses and reports.
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.
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 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.
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.
Mid-Columbia Agencies
DART Services: Provide database services, technical support services, and web access to Mid-Columbia screw trap collected counts and other datasets 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 Grant 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, Priest Rapids, and Wanapum dams.
PIT Tag Instream Steering Committee (PTISC)
DART Services: Collaborate with PTISC to define and develop reporting and analysis tools for data from the PIT Tag Instream detectors installed throughout the Columbia Basin. DART also applies a detailed analysis filter of PTAGIS observation to assign detections to specific life stages.
Products: Publicly accessible comprehensive reporting and analysis tools for PIT Tag Instream detectors dataset from PTAGIS.
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. Assist in parameter development to extend the COMPASS model beyond the Columbia and Snake Mainstem projects and to prepare for potential analyses of drawdown scenarios.
Products: Integrated datasets of survival, travel time and environmental conditions for statistical modeling and calibration. Technical support to NOAA hydrosystem scenario analyses for the Columbia-Snake Basin Biological Opinions.
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: 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.
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.
Account Type(s):
Expense
Contract Start Date:
10/01/2014
Contract End Date:
09/30/2015
Current Contract Value:
$293,938
Expenditures:
$293,938
* Expenditures data includes accruals and are based on data through 31-Mar-2025.
Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria
To filter a column using text, type one or more letters into the filter field
To filter a column using a numerical expression, type numbers and =, <, >, >=, or <= symbols.
To filter a column to a range of values, use n1..n2, where n1 represents the start value, n2 represents the end value, and two periods are used to capture all values in between.
Provide, maintain, and improve fundamental hardware, software, and procedural systems necessary for this scope of work. Database design, tuning, and development work will continue throughout the contract period in order to meet the demands of increasingly complex, resource-intensive data integration and analysis. Maintaining and upgrading the database architecture is essential to efficiently support our expanding data services, both for in-house analysis needs and requests from public and private users. DART services are functional throughout the calendar year with a focus on providing in-depth services and regional support during juvenile out-migration, adult migration, and spill seasons.
After 20 years employing Sun servers and Ingres DBMS, we selected to implement the PostgreSQL database management system on the Linux operating system to best leverage our resources and open source support and development. We will maintain the two systems until a transition to the new systems will result in no loss of access and services. The outdated and unsupported hardware and database system, Sun Fire v445 and Ingres, respectively, will be decommissioned. DART will continue forward solely with Linux based server and PostgreSQL. The majority of migration, conversion, implementation and development occurred in FY13 and FY14.
Continue to provide the publicly accessible, web-enabled Columbia River DART (Data Access in Real Time) query system and website. DART permits interactive selection of data items, time frame, presentation format, etc. from an integrated subset of historical and current fishery, hydraulic, project operation, and environmental information vital to year-round planning and adaptive management of the Federal Columbia River Power System. Data is presented in user-selected formats including graphics, data tables (plain text format), spreadsheet compatible files, and HTML tables. The services are to be functional throughout the calendar year. Scheduled nightly database mirroring, semi-weekly backups and daily data uploads limit access to 97% of a 24/7 schedule. The daily data uploads are coordinated with data availability from primary sources in order to provide the most up-to-date data as it is made available.
We will continue development and implementation of a spatially referenced data inventory and query system using open-source applications and tools to further our efforts to provide regionally integrated, publicly accessible datasets. The addition of regionally supported spatial and temporal formats will allow DART’s analysis products to be used in conjunction with other regional reporting services with a different scope.
We will conduct evaluations of DART services and usage by collecting and summarizing web users’ DART database query actions to illustrate the utilization and usefulness of DART to the region planners, policy makers and public. Evaluation of user affiliations and utilization of all DART services will be performed quarterly and annually. Based on these evaluations and in response to users' feedback, we will continually assess, modify and improve DART services. DART will survey known and potential users and agencies to determine DART’s contributions to regional needs and to help identify additional data products and analyses that can be developed and published by DART.
Interact with regional data managers to increase collections of current and historic datasets not yet available publically via the Internet, then merge and load data into the database for access via the website. Datasets will be added as directed by BPA and regional needs.
We will develop and employ automated and manual processes to acquire, merge and load the data into the database.
Provide monitoring, evaluation, and data products and services (via the Internet) on single and associated Fish and Wildlife Program (FWP) funded and ESA-mandated activities, especially efforts to predict, track, and evaluate the efficacy of proposed or actual actions. A variety of tools are provided to allow independent evaluation of life-stage survival of ESA-listed salmon and steelhead, including hydrosystem survival performance rates required by current biological opinions and as adopted in FWP mainstem plan amendments.
This contract also provides a means by which information integration services can be provided to FWP and ESA participants. With respect to the Fish and Wildlife Program, these services implement aspects of the Research, Monitoring, and Evaluation Strategy. With respect to ESA, they support Federal abilities to independently make and evaluate decisions committing federal resources. Current efforts support the Technical Management Team (TMT), the Mid-Columbia PUDs, and the Yakima-Klickitat Fisheries Project. Additional services can be provided through coordination with FWP project managers and "oversight" organizations. DART is ideally positioned to provide monitoring and analysis support to groups performing intensive monitoring of watersheds. Future services may support monitoring and evaluation of Action Agency implementation of Biological Opinions.
Services will be functional throughout the calendar year with a focus on providing in-depth support during juvenile and adult migration seasons. The efforts include disseminating information on the Internet and more complex mechanisms that integrate regionally distributed online information into effective monitoring and evaluation products in real time, supporting adaptive management of recovery efforts and water utilization.
This contract provides interactive online programs to view juvenile and adult exposure to hydrosystem conditions; analyses of adult escapement for various spawning aggregations; juvenile salmonid survival and travel time estimates; adult conversion rates; Northwest temperature and fish distributions; Mid-Columbia basin salmon passage status; and ocean/climate conditions. These services relate fish passage to environmental conditions and provide resources for evaluating the effects of river management and environmental conditions on salmon passage and survival. In addition, DART provides access to data and informational products of other FWP/ESA projects to support regional decision makers and to inform the general public.
The Contractor shall report on the status of milestones and deliverables in Pisces. Reports shall be completed either monthly or quarterly as determined by the BPA COTR. Additionally, when indicating a deliverable milestone as COMPLETE, the contractor shall provide metrics and the final location (latitude and longitude) prior to submitting the report to the BPA COTR.
At the end of the fiscal year, we will prepare an annual report that summarizes the accomplishments for the year.
For this contract, UW can develop a single RM&E Technical report that also functions as an Annual Progress Report.
Projects that have claimed that they support one or more RM&E RPAs (i.e., RPAs 50-73) under the FCRPS BiOp are required to report their results. To facilitate the summary of these results across the entire Columbia River Basin, and to provide more clarity as to the format required under the BiOp, these reports are required to be completed online. If desired, the required information can be prepared in MS Word, and pasted into Taurus. For more guidance see https://www.cbfish.org/Content/tutorials/Reporting_Guidance_BiOp_2013.pdf.
Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria
To filter a column using text, type one or more letters into the filter field
To filter a column using a numerical expression, type numbers and =, <, >, >=, or <= symbols.
To filter a column to a range of values, use n1..n2, where n1 represents the start value, n2 represents the end value, and two periods are used to capture all values in between.
Viewing of Implementation Metrics
FILTERED
Loading...
Sort Order
WE ID
Work Element Name
Title
Description
Metric ID
Metric
End Fiscal Year
Planned
Actual
Contractor Comments
All Measures
Annual Progress Report Measures
Populations
Using column filters in grids
Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria
To filter a column using text, type one or more letters into the filter field
To filter a column using a numerical expression, type numbers and =, <, >, >=, or <= symbols.
To filter a column to a range of values, use n1..n2, where n1 represents the start value, n2 represents the end value, and two periods are used to capture all values in between.
Help
Mitigation work
Reporting
Funding
Search
Log in
SOW Report
