Show new navigation
On
  • Help
    • Help
    • How Do I?
    • Why Do I?
    • Help Center
    • Data dictionary
    • EF&W Program documents
    • Request support
    • Send feedback
      • View all help topics
Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
  • Mitigation work
    Mitigation work View all mitigation work topics
  • Reporting
    Reporting View all reporting topics
  • Funding
    Funding View all funding topics
  • Search
SOW Report
Contract 91129: 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART)

Last Modified: Jennifer Gosselin, 08/01/2022 9:37 PM   
Basics

Project Number:
1996-019-00
Title:
Data Access in Real Time (DART)
BPA PM:
Christine Petersen
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
91129
Contract Title:
1996-019-00 EXP DATA ACCESS IN REAL TIME (DART)
Contract Continuation:
Previous: Next:
76910 REL 18: 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART)
  • 84060 REL 2: 1996-019-00 EXP DATA ACCESS IN REAL TIME (DART)
Contract Status:
Closed
Contract Description:
Contract support maintenance and development of the Data Access in Real Time (DART), a website database that serves to the public real-time information on the status of fish runs in the Columbia River Basin system. The DART site is one of the major database services in the Columbia River System.
Account Type(s):
Expense
Contract Start Date:
10/01/2022
Contract End Date:
09/30/2023
Current Contract Value:
$291,819
Expenditures:
$291,819

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

BPA CO:
Jay Chong
BPA COR:
Christine Petersen
Env. Compliance Lead:
None
Contract Contractor:
University of Washington - WAUNIV00
Work Order Task(s):
WO: 00032381, Task: 1
Contract Type:
Grant
Pricing Method:
Cost Reimbursement (CNF)
300 km
200 mi
Click the map to see this Contract's location details.

Back To Top

Photos

No photos have been uploaded yet for this Contract.

Back To Top

Contract Contacts

Full Name Organization Write Permission Contact Role Email Work Phone
James Anderson University of Washington Yes Technical Contact jjand@uw.edu (206) 543-4772
Jay Chong Bonneville Power Administration Yes Contracting Officer jxchong@bpa.gov (503) 230-4007
Jennifer Gosselin University of Washington Yes Supervisor gosselin@uw.edu (206) 685-7316
Susannah Iltis University of Washington Yes Contract Manager siltis@uw.edu (206) 685-2182
Kristen Jule Bonneville Power Administration Yes F&W Approver krjule@bpa.gov (503) 230-3588
Christine Petersen Bonneville Power Administration Yes COR chpetersen@bpa.gov (503) 230-4695
Jessica Power Bonneville Power Administration No CO Assistant jdpower@bpa.gov (503) 230-4023
Lisa Smith University of Washington No Administrative Contact autumn@uw.edu (206) 616-9939


Back To Top

Statement Of Work (SOW)

Viewing 7 of 7 Work Statement Elements
Sort Order
WSEV ID
WE ID
Work Element Name
Title
Description
WSE Effective Budget
% of Total WSE Effective Budget
WSE Start
WSE End
A228597160Create/Manage/Maintain DatabaseDatabase and System AdministrationProvide, 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. Due to increasing project demands with limited resources, we will be hiring a new Computer Support Analyst during this contract period to assist with system administration and website maintenance and development. In order to maintain functionality and reliability of our aging hardware, we will extend the warranty on our hardware server to cover this contract period. We will also purchase and build the replacement which involves operating system and software upgrades.$97,72133.49%10/01/202209/30/2023
B228598161Disseminate Raw/Summary Data and ResultsData Access in Real Time (DART) Internet ServicesContinue 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, hydrology, project operation, and environmental information vital to year-round planning and adaptive management of the Federal Columbia River Power System. Data are presented in user-selected formats including graphics, spreadsheet-compatible files, and HTML tables. The services are to be functional throughout the calendar year. Scheduled 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 they are made available. We will continue to develop and implement 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 objectives. We will conduct evaluations of DART services and usage by collecting and summarizing web users’ DART database query actions to analyze the utilization by region planners, policy makers and the 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.$56,54619.38%10/01/202209/30/2023
C228599159Transfer/Consolidate Regionally Standardized DataAcquire/Integrate Current and Historical DatasetsInteract with regional data managers to increase collections of current and historic datasets not yet available publicly via the Internet, then merge and load data into the database for access via the website. Datasets will be added as directed by BPA, Action Agencies, and regional needs. We will develop and employ automated and manual processes to acquire, merge and load the data into the database.$36,21512.41%10/01/202209/30/2023
D228600162Analyze/Interpret DataRegional Monitoring and Evaluation ServicesProvide 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. DART also provides a means by which data 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), Fish Passage Advisory Committee (FPAC), 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. DART 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; 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.$76,43626.19%10/01/202209/30/2023
E228601119Manage and Administer ProjectsProject ManagementManage the project work flow, financial management and other administrative functions related to the project.$6,9072.37%10/01/202209/30/2023
F228596185Produce CBFish Status ReportPeriodic Status Reports for BPAThe 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.$7,2712.49%01/01/202309/30/2023
G228602132Produce Progress (Annual) ReportAnnual Progress ReportAt the end of the calendar 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.$10,7233.67%01/01/202303/31/2023
      
$291,819
   

Back To Top

Deliverable Status

Deliverable Title WSE Sort Letter, Number, Title Start End Concluded
Deliverables A: 160. Database and System Administration 09/30/2023 09/28/2023
Deliverables B: 161. Data Access in Real Time (DART) Internet Services 09/30/2023 09/28/2023
Deliverables C: 159. Acquire/Integrate Current and Historical Datasets 09/30/2023 09/28/2023
Deliverables D: 162. Regional Monitoring and Evaluation Services 09/30/2023 09/28/2023
Effective implementation management and timely contract administration E: 119. Project Management 09/30/2023 09/28/2023
Completed Annual Report G: 132. Annual Progress Report 03/31/2023 03/31/2023

Back To Top

Metrics

Viewing of Implementation Metrics
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
    Viewing of Environmental Metrics Customize
    Loading...
    WSE ID
    WSE Start
    WSE End
    WE ID
    Title
    WSE Progress
    Study Plan
    Protocol
    Category
    Subcategory
    Focus 1
    Focus 2
    Specific Metric Title

              Back To Top

              Focal Species

              Primary Focal Species Work Statement Elements
              Chinook (O. tshawytscha) - Deschutes River Summer/Fall ESU
              • 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
              Chinook (O. tshawytscha) - 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
              Chinook (O. tshawytscha) - Mid-Columbia River Spring ESU
              • 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
              Chinook (O. tshawytscha) - Snake River Fall 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
              Chinook (O. tshawytscha) - Snake River Spring/Summer 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
              Chinook (O. tshawytscha) - Upper Columbia River Spring ESU (Endangered)
              • 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
              Chinook (O. tshawytscha) - Upper Columbia River Summer/Fall ESU
              • 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
              Chinook (O. tshawytscha) - Upper Willamette 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 (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
              Sockeye (O. nerka) - Lake Wenatchee ESU
              • 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
              Sockeye (O. nerka) - Okanogan River ESU
              • 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 (O. mykiss) - Lower Columbia River DPS (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
              Steelhead (O. mykiss) - Middle Columbia River DPS (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
              Steelhead (O. mykiss) - Snake River DPS (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
              Steelhead (O. mykiss) - Upper Columbia River DPS (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
              Steelhead (O. mykiss) - Upper Willamette River DPS (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
              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

              Back To Top

              Environmental Compliance

              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 Services
              C 159 Acquire/Integrate Current and Historical Datasets
              D 162 Regional Monitoring and Evaluation Services
              E 119 Project Management
              F 185 Periodic Status Reports for BPA
              G 132 Annual Progress Report

              Back To Top

              Reports


              Back To Top