Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
Select a work element:
Contract Number:
Contract Title:
2002-013-01 EXP WATER ENTITY - CBWTP
Contract Start Date:
10/1/2023
Contract End Date:
9/30/2024
Title:
P: 157 - QLE - Data Collection
Description:
This work element captures in the field work by QLEs to collect, create, generate, or capture source data. Includes initial entering of data into a computer spreadsheet/database, developing automated data capture programs/routines and related hardware/software (e.g., PDAs, data loggers, thermographs), preparing metadata, and quality assurance/quality control processes. Also includes taking samples for later analysis and any preparations for collecting data if not covered by another work element. It also includes generating secondary/derived data when those data are stored in a database for access and use by other parties for analysis like primary data. Capturing data includes entering data into a computer from historical records, digitizing images, and other methods for converting information to digital format. Information on methodology, protocol, and data storage location, to be used for this work element.
WE Agreement Type:
Contracted
Deliverable Specification:
Data collection and analyses of flow measurements and water quality data for project streams, file annual monitoring report with CBWTP and states as required.
WSE Effective Budget:
$260,662
% of Total WSE Effective Budget:
5.60%
WSE Start:
10/01/2023
WSE End:
09/30/2024
WSE Completion:
WSE Progress:
Other
WSE ID Continued From:
n/a
WSE ID Continued To:
n/a
Finite or Recurring:
Recurring

SOWRevision Planned Updated Contractor Comments (optional) BPA Comments (optional)
1. 93260 (10/01/2023 - 09/30/2024) $297,968 $260,662 updated budget includes final invoice
2. Amendment 001 (10/01/2023 - 09/30/2024) $297,968 $260,662 updated budget includes final invoice
Work Element Budget (Current Performance Period) $292,968 $260,662 updated budget includes final invoice

7 Milestones
Sort Type Title Start End Status Modified By Modified Date
A EC Environmental compliance requirements complete Concluded Matthew Schwartz 11/22/2024 1:23:41 PM
Description: On-the-ground work associated with this work element cannot proceed until this milestone is complete. Milestone is complete when final documentation is received from BPA environmental compliance staff.
B PUBPROTOCOL Review, revise, and finalize study plan sample design protocol and methods in MonitoringResouces.org 10/1/2023 9/30/2024 Active Matthew Schwartz 11/22/2024 1:23:41 PM
Description: The Study Plan's Sample Design, Protocol and Methods for this work element are stored at MonitoringResources.org and need to be completed (i.e., "Finalized" through MonitoringResources.org), preferably prior to data collection. Preparations for contract renewals must include reviewing any previously finalized Sample Designs, Protocols & Methods to ensure that they are consistent with how work will be done in any subsequent contract.
C Develop Monitoring Plan 10/1/2023 9/30/2024 Active Matthew Schwartz 11/22/2024 1:23:41 PM
Description: Coordinate with agencies, organizations, and individuals to develop monitoring plans, collect data, and analyze data in accordance with relevant restoration plans. QLE compliance and implementation monitoring should be carried out via CBWTP's FRAF and other recommendations made by the monitoring consultant. Current, FRAF as well as the DRAFT monitoring workplan underdevelopment are available in CBFish.
D Maintain Existing Flow Gauges 10/1/2023 9/30/2024 Active Matthew Schwartz 11/22/2024 1:23:41 PM
Description: Maintain existing flow gauges.
E Download and Analyze Flow Data 10/1/2023 9/30/2024 Active Matthew Schwartz 11/22/2024 1:23:41 PM
Description: Download, track, and analyze flow data.
F Collect Flow Data 10/1/2023 9/30/2024 Active Matthew Schwartz 11/22/2024 1:23:41 PM
Description: Travel to sites and field time collecting flow measurements.
G DELIV Monitoring Plan and Data Collection Complete 9/30/2024 Active Matthew Schwartz 11/22/2024 1:23:41 PM
Description: Data collection and analyses of flow measurements and water quality data for project streams, file annual monitoring report with CBWTP and states as required.

Work Site ID Latitude Longitude State County Province Subbasin
36289 45.2756 -117.9323 Oregon Union Blue Mountain Grande Ronde
86679 45.14623 -118.20761 Oregon Union Blue Mountain Grande Ronde
89737 45.146 -118.208 Oregon Union Blue Mountain Grande Ronde
89740 45.200317 -117.84956 Oregon Union Blue Mountain Grande Ronde

Primary Focal Species:
Chinook (Oncorhynchus tshawytscha) - All Populations; Steelhead (Oncorhynchus mykiss) - All Populations
Secondary Focal Species:
Chum (Oncorhynchus keta) - Columbia River ESU (Threatened); Coho (Oncorhynchus kisutch) - Lower Columbia River ESU (Threatened); Coho (O. kisutch) - Unspecified Population; Cutthroat Trout, Coastal (Oncorhynchus clarkii clarkii) - All Anadromous Populations; Lamprey, Pacific (Entosphenus tridentata); Lamprey, River (L. ayresi); Shad, American (Alosa sapidissima); Sockeye (Oncorhynchus nerka) - All Populations; Sturgeon, Green (Acipenser medirostris); Sturgeon, White (A. transmontanus) - Lower Columbia River; Bass, Largemouth (Micropterus salmoides); Bass, Smallmouth (M. dolomieu); Burbot (Lota lota); Chub, Oregon (Oregonichthys crameri) (Endangered through FY2015); Cutthroat Trout, Coastal (O. clarkii clarkii)- Resident Populations; Cutthroat Trout, Lahontan (O. c. henshawi) (Threatened); Cutthroat Trout, Westslope (O. c. lewisi); Cutthroat Trout, Yellowstone (O. c. bouvieri); Freshwater Mussels; Kokanee (Oncorhynchus nerka); Lamprey, Western Brook (L. richardsoni); Sturgeon, White (Acipenser transmontanus) - All Populations except Kootenai R. DPS; Sturgeon, White (A. transmontanus) - Kootenai River DPS (Endangered); Trout, Brook (Salvelinus fontinalis); Trout, Bull (S. confluentus) (Threatened); Trout, Rainbow (Oncorhynchus mykiss); Trout, Interior Redband (O. mykiss gairdnerii); Whitefish, Mountain (Prosopium williamsoni)

Title Link
Columbia Basin Water Transactions Program http://www.cbwtp.org/jsp/cbwtp/index.jsp
Study Plan Name Study Plan Owner Protocol State Sample Design Name
CBWTP - Flow Restoration Accounting Framework v1.0 rankin holmes Finalized QLEs - Collect, Generate, and Validate Field Data for Water Transactions - National Fish and Wildlife Foundation 2 v1.0

ID Name Type Optional Customized Based On Status
169 Determining effectiveness of passage project structures v1.0 Data Collection Yes N/A Finalized
174 Discharge-Field Measurements v1.0 Data Collection Yes N/A Finalized
853 Site Discharge Calculation v1.0 Data Analysis/Interpretation Yes N/A Finalized
1451 Stream Cross-sectional Discharge Measurement (wading) v1.0 Data Collection Yes N/A Finalized
847 Stream Discharge v1.0 Data Collection Yes N/A Finalized

Title Category Subcategory Subcategory focus 1 Subcategory focus 2
Instream Flow Hydrology/Water Quantity Flow (ID: 104) NA NA
Instream Flow - Velocity Hydrology/Water Quantity Flow (ID: 104) NA NA
Instream Flow - AF Hydrology/Water Quantity Flow (ID: 104) NA NA
Instream Flow - CFS Hydrology/Water Quantity Flow (ID: 104) NA NA
Wetted Width and Depth Hydrology/Water Quantity Flow (ID: 104) NA NA
Instream Flow - Temperature Water Quality Water Temperature (ID: 162) NA NA