Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 20318: 199601900 SECOND-TIER DATABASE AND WORLD WIDE WEB SUPPORT SERVICE
Project Number:
Title:
Data Access in Real Time (DART)
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
20318
Contract Title:
199601900 SECOND-TIER DATABASE AND WORLD WIDE WEB SUPPORT SERVICE
Contract Continuation:
Previous: Next:
4124: 1996-019-00 SECOND TIER DATABASE SUPPORT
  • 28555: 199601900EXP SECOND-TIER DATABASE AND WORLD WIDE WEB SUPPORT SERV
Contract Status:
Closed
Contract Description:
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 integrated and direct public access to Columbia Basin environmental, operational, fishery, administrative, and other information essential to sound operational and resource management decisions by the Federal Government. As such, this project has been identified by BPA as a "non-discretionary" work element within the Northwest Power Act's Fish and Wildlife Program (FWP). This work was originally incorporated in Project 8610800 but was separated in 1999 for clarity and potential transfer.  The principle period of service is March through November during the downstream juvenile and upstream adult salmon migrations; however, data services, analysis, preparation, and follow-up activities occur throughout the calendar year.

This work does not duplicate services provided by other federal, state, and private services in the region; rather it integrates public data for more effective access, consideration, analysis, and application.  These services are critical to BPA's implementation of its fish and wildlife responsibilities under the Endangered Species Act (ESA).  The services are available to FWP participants needing integration of data and can be used to implement effective planning, monitoring and evaluation as part of adaptive management practices.

Relevance to Federal Biological Opinions and Regulatory Programs

This contract implements Reasonable and Prudent Actions (RPAs) of the 2000 NOAA Fisheries and USFWS Biological Opinions governing operations of the Federal Columbia River Power System (FCRPS):

1. RPA 180: Develop and implement a basinwide hierarchical monitoring program …
To determine population and environmental status (including assessment of performance measures and standards) and allow ground-truthing of regional databases.

2. RPA 198: Common data management system…
for fish populations, water quality, and habitat data.

This contract also provides data integration and Internet-based information access for monitoring, evaluation, and decision support to systemwide and mainstem-specific strategies of the Northwest Power Conservation Council's Fish and Wildlife Program (FWP), including 2004 mainstem amendments.  These basinwide strategies pertain principally to (1) the  "naturalization" of the mainstem environment, (2) improving juvenile and adult mainstem passage, and (3) dissemination of data and information for research, monitoring, evaluation, decision support, and program oversight.  

Finally, this contract provides (1) Internet-based data integration, management, and presentation services as well as (2) juvenile and adult mainstem passage modeling supporting federal decisions affecting the operation of the FCRPS.  These services compliment but do not replace services provided by the Fish Passage Center, StreamNet, PTAGIS, etc. which, along with services provided by this contract, provide a regional information service to all interested parties.

The DART project provides the region web-based access to specialized fish analysis tools developed at Columbia Basin Research by the research groups of Drs. Anderson and Skalski.  Analysis capabilities provided by these web integrated tools include:

· Analysis of the real-time movement of juvenile salmon and steelhead through the hydrosystem use smolt migrating timing predictions (Realtime) developed by Dr. Skalski and a juvenile passage predictions (CRiSP) developed by Dr. Anderson

· Prediction of adult salmon upstream passage timing and run size uses models developed by Dr. Anderson  

· Web available analysis of smolt-to-adult ratios and flexible querying and analyses of juvenile fish survival identified by stock and release groups uses statistical software (SURPH) developed by Dr. Skalski

· Detailed analysis of adult PIT tag returns including Age Structure, Travel time, Conversion rates of PIT-tagged adult migrants from Bonneville to upstream projects

· Detail and summary statistics of PIT-tagged ESU stocks

These features and others provided by the DART website are not available at other regional facilities such as the Fish Passage Center or PSMFC. Thus, DART provides unique and valuable analysis services for hydrosystem operations planning, real-time monitoring, and post-season analysis of passage conditions.  In providing specialized analysis, DART compliments the Fish Passage Center responsibilities for housing passage data and providing technical assistance to the agencies and tribes.  While the Fish Passage Center is charged with assisting agencies and tribes in developing requests for flow and spill and programs, DART compliments this function by providing regional groups an independent source of integrated information and additional analysis capabilities for evaluating water and fishery actions.

This scope may be modified in the future subject to requirements of Action Agency implementation of the 2000 NOAA Fisheries and USFWS Biological Opinions, Federal court-directed remand of one or more biological opinions, and the regional review of Information requirements and services.
Account Type(s):
Expense
Contract Start Date:
10/01/2004
Contract End Date:
09/30/2006
Current Contract Value:
$528,141
Expenditures:
$528,141

* Expenditures data includes accruals and are based on data through 31-Mar-2024.

BPA CO:
Env. Compliance Lead:
None
Contract Contractor:
Work Order Task(s):
Contract Type:
Contract (IGC)
Pricing Method:
Cost Reimbursement (CNF)
Click the map to see this Contract’s location details.

No photos have been uploaded yet for this Contract.

Full Name Organization Write Permission Contact Role Email Work Phone
James (UW) Anderson University of Washington Yes Contract Manager was-jjand@uw.edu (206) 543-4772
David Askren Bonneville Power Administration Yes Interested Party draskren@bpa.gov (503) 230-5624
Jamae Hilliard Bonneville Power Administration Yes F&W Approver jlhilliard@bpa.gov (360) 418-8658
Christine Muongchanh University of Washington Yes Administrative Contact cket@u.washington.edu (206) 543-7848
John Piccininni Bonneville Power Administration Yes COR jppiccininni@bpa.gov (503) 230-7641
Karen Wolfe Bonneville Power Administration Yes Contracting Officer ktwolfe@bpa.gov (503) 230-3448


Viewing of Work Statement Elements

Deliverable Title WSE Sort Letter, Number, Title Start End Complete
Manage and maintain database system A: 160. Database and System Administration 09/30/2006 09/30/2006
Provide web-enabled Data Access in Real Time B: 161. Data Access in Real Time (DART) Internet Service 09/30/2006 01/17/2006
Coordination and collection of data with data managers in the region C: 159. Acquire/Integrate Current and Historical Datasets 09/30/2006 09/30/2006
Create and maintain web-based analytical tools that are being used by researchers D: 162. Regional Monitoring and Evaluation Services 09/30/2006 01/17/2006
Manage day-to-day operations of the project E: 119. Project Management 09/30/2006 09/30/2006
Annual report will be delivered to BPA approximately 20 days after federal fiscal year end. F: 132. Summary of work accomplishments 10/28/2005 09/30/2005

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Primary Focal Species Work Statement Elements
Chinook (Oncorhynchus tshawytscha) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Chum (Oncorhynchus keta) - Columbia River ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Coho (Oncorhynchus kisutch) - Lower Columbia River ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Coho (O. kisutch) - Unspecified Population
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Cutthroat Trout, Coastal (Oncorhynchus clarkii clarkii) - All Anadromous Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Sockeye (Oncorhynchus nerka) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Steelhead (Oncorhynchus mykiss) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Lamprey, Pacific (Entosphenus tridentata)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Lamprey, River (L. ayresi)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Shad, American (Alosa sapidissima)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Cutthroat Trout, Coastal (O. clarkii clarkii)- Resident Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Lahontan (O. c. henshawi) (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Westslope (O. c. lewisi)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Yellowstone (O. c. bouvieri)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Pikeminnow, Northern (Ptychocheilus oregonensis) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Trout, Brook (Salvelinus fontinalis)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Bull (S. confluentus) (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data
Trout, Rainbow (Oncorhynchus mykiss)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
  • 1 instance of WE 162 Analyze/Interpret Data

Sort WE ID WE Title NEPA NOAA USFWS NHPA Has Provisions Inadvertent Discovery Completed
A 160 Database and System Administration
B 161 Data Access in Real Time (DART) Internet Service
C 159 Acquire/Integrate Current and Historical Datasets
D 162 Regional Monitoring and Evaluation Services
E 119 Project Management
F 132 Summary of work accomplishments
G 185 Quarterly reports based on federal fiscal year