Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
RSS Feed for updates to Project 1996-019-00 - Data Access in Real Time (DART) Follow this via RSS feed. Help setting up RSS feeds?

Project Summary

Project 1996-019-00 - Data Access in Real Time (DART)
Project Number:
1996-019-00
Title:
Data Access in Real Time (DART)
Summary:
The second-tier database and World Wide Web services described in this scope of work are collectively known as DART (Data Access in Real Time). DART provides direct and timely public access to integrated Columbia Basin environmental, operational, fishery, riverine, ocean and climactic data resources for sound management of the Columbia Basin resources and hydrosystem by federal, state, public and private entities.
Proposer:
None
Proponent Orgs:
University of Washington (Edu)
Starting FY:
1997
Ending FY:
2024
Stage:
Implementation - Project Status Report
Area:
Province Subbasin %
Basinwide - 100.00%
Purpose:
Hydrosystem
Emphasis:
Data Management
Focal Species:
Bass, Smallmouth
Catfish
Chinook - All Populations
Chinook - Deschutes River Summer/Fall ESU
Chinook - Lower Columbia River ESU
Chinook - Mid-Columbia River Spring ESU
Chinook - Snake River Fall ESU
Chinook - Snake River Spring/Summer
Chinook - Snake River Spring/Summer ESU
Chinook - Upper Columbia River Spring ESU
Chinook - Upper Columbia River Summer/Fall ESU
Chinook - Upper Willamette River ESU
Chum - Columbia River ESU
Coho - Lower Columbia River ESU
Coho - Unspecified Population
Cutthroat Trout, Coastal - All Anadromous Populations
Cutthroat Trout, Coastal - Resident Populations
Cutthroat Trout, Lahontan
Cutthroat Trout, Westslope
Cutthroat Trout, Yellowstone
Lamprey, Pacific
Lamprey, River
Lamprey, Western Brook
Pikeminnow, Northern
Shad, American
Sockeye - All Populations
Sockeye - Lake Wenatchee ESU
Sockeye - Okanogan River ESU
Sockeye - Snake River ESU
Steelhead - All Populations
Steelhead - Lower Columbia River DPS
Steelhead - Middle Columbia River DPS
Steelhead - Snake River DPS
Steelhead - Upper Columbia River DPS
Steelhead - Upper Willamette River DPS
Sturgeon, Green
Sturgeon, White - All Populations except Kootenai R. DPS
Sturgeon, White - Lower Columbia River
Trout, Brook
Trout, Bull
Trout, Rainbow
Walleye
Whitefish, Mountain
Species Benefit:
Anadromous: 100.0%   Resident: 0.0%   Wildlife: 0.0%
Special:
None
BiOp Association:
FCRPS 2008 – view list of FCRPS 2008 BiOp Actions

RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 72.1 Participate & jointly fund support in reg coordination forums ,
RPA 72.1 Participate & jointly fund support in reg coordination forums ,
RPA 72.1 Participate & jointly fund support in reg coordination forums ,
RPA 72.1 Participate & jointly fund support in reg coordination forums ,
RPA 72.1 Participate & jointly fund support in reg coordination forums ,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 72.2 Fund data system components to support info mgmt needs of H?s,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 51.1 Synthesize fish pop metrics thru Regional Data Repositories,
RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 50.6 Review/modify existing fish pop status monitoring projects,
RPA 50.6 Review/modify existing fish pop status monitoring projects

No photos have been uploaded yet for this Project.

Summary of Budgets

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

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

Decided Budget Transfers  (FY2023 - FY2025)

Acct FY Acct Type Amount Fund Budget Decision Date
FY2023 Expense $293,938 From: BiOp FCRPS 2008 (non-Accord) FY23 SOY Budget Upload 06/01/2022
FY2024 Expense $306,871 From: BiOp FCRPS 2008 (non-Accord) FY24 SOY Budget Upload 06/01/2023

Pending Budget Decision?  No


Actual Project Cost Share

Current Fiscal Year — 2024   DRAFT
Cost Share Partner Total Proposed Contribution Total Confirmed Contribution
There are no project cost share contributions to show.

Contracts

The table below contains contracts with the following statuses: Active, Closed, Complete, History, Issued.
* "Total Contracted Amount" column includes contracted amount from both capital and expense components of the contract.
Expense Contracts:
Number Contractor Name Title Status Total Contracted Amount Dates
639 REL 2 SOW University of Washington 1996-019-00 SECOND-TIER DATABASE SUPPORT Terminated $191,084 10/1/2000 - 9/30/2001
4124 SOW University of Washington 1996-019-00 SECOND TIER DATABASE SUPPORT Closed $943,540 3/23/2001 - 9/30/2004
20318 SOW University of Washington 199601900 SECOND-TIER DATABASE AND WORLD WIDE WEB SUPPORT SERVICE Closed $528,141 10/1/2004 - 9/30/2006
28555 SOW University of Washington 199601900EXP SECOND-TIER DATABASE AND WORLD WIDE WEB SUPPORT SERV Closed $331,279 10/1/2006 - 11/30/2007
34572 SOW University of Washington 199601900EXP SECOND-TIER DATABASE AND WORLD WIDE WEB SUPPORT SERV Closed $277,279 10/1/2007 - 9/30/2008
38969 SOW University of Washington 1996-019-00 EXP DART - DATA ACCESS IN REAL TIME Closed $277,279 10/1/2008 - 9/30/2009
44402 SOW University of Washington 1996-019-00 EXP SECOND-TIER DATABASE AND WORLD WIDE WEB SUPPORT Closed $284,187 10/1/2009 - 9/30/2010
49069 SOW University of Washington 1996-019-00 EXP SECOND-TIER DATABASE & WORLDWIDE WEB SUPPORT FY11 Closed $291,315 10/1/2010 - 9/30/2011
54439 SOW University of Washington 1996-019-00 EXP SECOND-TIER DATABASE & WORLDWIDE WEB SUPPORT FY12 Closed $293,904 10/1/2011 - 9/30/2012
58849 SOW University of Washington 1996-019-00 EXP SECOND-TIER DATABASE AND WEBSITE Closed $293,851 10/1/2012 - 9/30/2013
62696 SOW University of Washington 1996-019-00 EXP SECOND-TIER DATABASE AND WEBSITE Closed $293,938 10/1/2013 - 9/30/2014
66634 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $293,938 10/1/2014 - 9/30/2015
70375 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $293,938 10/1/2015 - 9/30/2016
74102 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $293,118 10/1/2016 - 9/30/2017
77214 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $293,938 10/1/2017 - 9/30/2018
76910 REL 3 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $293,011 10/1/2018 - 9/30/2019
76910 REL 8 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $286,694 10/1/2019 - 9/30/2020
76910 REL 14 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $291,311 10/1/2020 - 9/30/2021
76910 REL 18 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $293,389 10/1/2021 - 9/30/2022
91129 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Closed $291,819 10/1/2022 - 9/30/2023
84060 REL 2 SOW University of Washington 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) Issued $306,871 10/1/2023 - 9/30/2024



Annual Progress Reports
Expected (since FY2004):20
Completed:18
On time:18
Status Reports
Completed:75
On time:33
Avg Days Late:4

                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 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART) University of Washington 03/23/2001 09/30/2024 Issued 75 115 6 0 0 121 100.00% 1
Project Totals 75 115 6 0 0 121 100.00% 1


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

Review: 2019-2021 Mainstem/Program Support

Council Recommendation

Assessment Number: 1996-019-00-NPCC-20210312
Project: 1996-019-00 - Data Access in Real Time (DART)
Review: 2019-2021 Mainstem/Program Support
Proposal: NPCC19-1996-019-00
Proposal State: Pending Council Recommendation
Approved Date: 8/25/2019
Recommendation: Implement
Comments: Continue implementation through next review cycle. See Programmatic issue for Data Management and Information.

[Background: See https:/www.nwcouncil.org/fish-and-wildlife/fish-and-wildlife-program/project-reviews-and-recommendations/mainstem-review]

Independent Scientific Review Panel Assessment

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 Background

Objectives are clear. The project provides support for the COMPASS life-cycle model.

The proposal identifies that this project's significance to regional programs is due to providing data integration, web-based information, and analytical services that help connect primary databases, monitoring programs, decision makers, and resource users.

2. Results and Adaptive Management

The proposal states that services provided by this project support critical uncertainties research themes (D) Hydrosystem flow and passage operations and (F) Population structures of diversity identified in the Council's 2017 Research Plan. This project also reports data availability, data anomalies, formatting, and accuracy issues to primary data sources. Evidence of the amount and utility of this feedback to primary sources would be useful for this and future ISRP reviews.

Adaptive management is mentioned in the proposal in the sense that this project generates products such as data tools, analysis methods, and predictive models that can be used to support all areas of Fish and Wildlife Program adaptive management. It appears that adaptive management per se is not applied within this project but could be of use to consider the impact of vastly more data from increased detections, more precise detections, and additional methods of tagging.

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

The proposal documents relationships that this second-tier data base has with many data base projects in the region. This project is a data management work type with data management issues dealt with properly. The interactive web-based query system appears to work very well. Most of the sources for DART data are the entities that provide public access to primary data. This project provides access to its research database through a web-based interface and through delivery of user-requested datasets and metadata. It is not clear how it is decided which data should be stored in DART.

The project develops procedures to ensure the quality of all integrated datasets. It also provides feedback to primary data sources on data quality issues.

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

Independent Scientific Review Panel Assessment

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:
Review: Proposals for New FCRPS BiOp work (FY10-July)
Review: FY07-09 Solicitation Review

Council Recommendation

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

Independent Scientific Review Panel Assessment

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:

Legal Assessment (In-Lieu)

Assessment Number: 1996-019-00-INLIEU-20090521
Project Number: 1996-019-00
Review: FY07-09 Solicitation Review
Completed Date: 10/6/2006
In Lieu Rating: No Problems Exist
Cost Share Rating: None
Comment: DART database management with additional analytical functions addressing FCRPS operational questions.

Capital Assessment

Assessment Number: 1996-019-00-CAPITAL-20090618
Project Number: 1996-019-00
Review: FY07-09 Solicitation Review
Completed Date: 2/27/2007
Capital Rating: Does Not Qualify for Capital Funding
Capital Asset Category: None
Comment: None

Project Relationships: None

Name Role Organization
Christine Petersen Project Manager Bonneville Power Administration
James Anderson Technical Contact University of Washington
Susannah Iltis Project Lead University of Washington
Jay Chong Administrative Contact Bonneville Power Administration
Jennifer Gosselin Supervisor University of Washington
Russell Scranton Interested Party Bonneville Power Administration