80678: Rev 1: WE F: Work Element Summary

Work Element Summary PDF

Select a work element:

Basics

Contract Number:

80678

Contract Title:

2008-104-00 EXP COLVILLE LAND & WATER ACQUISITION ADMIN

Contract Start Date:

10/1/2018

Contract End Date:

9/30/2019

WE ID:

157. Collect/Generate/Validate Field and Lab Data

Work Element Usage Report

Title:

F: 157 - NFWF - Collect, Generate, and Validate Field and Lab Data

Description:

This work element captures the National Fish and Wildlife Foundation (NFWF) work to collect, create, generate, or capture data during FY2019. 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, installing data loggers, 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. Capturing data includes entering data into a computer from historical records, scanning photos, and other methods for converting visual and field information to digital format. NFWF will explore existing open source options for storing, organizing, and analyzing collected data. Provide information on methodology, protocol, data storage location to be used for this work element is relevant for FY2019.

WE Agreement Type:

Contracted

Deliverable Specification:

Validate and compile new data, review reports.

WSE Effective Budget:

$600

% of Total WSE Effective Budget:

0.70%

WSE Start:

10/01/2018

WSE End:

09/30/2019

WSE Completion:

09/29/2019

WSE Progress:

Concluded

WSE ID Continued From:

n/a

WSE ID Continued To:

n/a

Finite or Recurring:

Recurring

Budget History

SOWRevision	Planned	Updated	Contractor Comments (optional)	BPA Comments (optional)
Work Element Budget (Current Performance Period)	$1,990	$600

Milestones

9 Milestones

Sort	Type	Title	Start	End	Status	Modified By	Modified Date
A	EC	Environmental compliance requirements complete	10/1/2018	12/31/2018	Concluded	Maura Eagan Moody (Inactive)	9/4/2018 5:50:51 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 publish Protocol and Methods in MonitoringResources.org	10/1/2018	9/30/2019	Concluded	Maura Eagan Moody (Inactive)	8/1/2018 3:43:29 PM
		Description: The Protocol (including temporal and spatial design) and Methods for this work element are stored at MonitoringResources.org and need to be finalized (i.e., "Published" through MonitoringResources.org), preferably prior to data collection. Preparations for contract renewals must include reviewing any previously published Protocols/Methods to ensure that they are consistent with how work will be done in any subsequent contract.
C		Obtain and assemble updated flow targets	10/1/2018	9/30/2019	Concluded	Maura Eagan Moody (Inactive)	8/1/2018 3:43:29 PM
		Description: Update flow targets by stream, methodology used, entity that established the target reported by Subbasin (or smaller HUC if available), and incorporate this information into database. Include hydrologic data on priority stream reaches (where available) at key points with amount of flow added by water transactions.
D		National Fish and Wildlife staff collect data in field with Qualified Local Entity on Tier 3 streams	10/1/2018	9/30/2019	Concluded	Maura Eagan Moody (Inactive)	8/1/2018 3:46:06 PM
		Description: Work with Qualified Local Entities (QLEs) to collect monitoring data on Tier 3 streams in the field as appropriate.
E		Effectiveness monitoring	10/1/2018	9/30/2019	Concluded	Maura Eagan Moody (Inactive)	6/12/2018 3:36:05 PM
		Description: Deploy Water Temperature Translation Tool (W3T) on 3-5 priority Tier 3 stream reaches, collect and analyze data, and review for lessons learned.
F		Monitoring program implementation	10/1/2018	9/30/2019	Concluded	Maura Eagan Moody (Inactive)	8/1/2018 3:46:06 PM
		Description: The National Fish and Wildlife Foundation (NFWF) will coordinate with Qualified Local Entities (QLEs), contractors, state agencies, and academic institutions to coordinate, collect, and analyze QLE obtained flow data and continue developing a strategy for Columbia Basin Water Transaction Program (CBWTP) to demonstrate the habitat and biological response in tributary from program transactions as scientifically defensible. NFWF will coordinate, collect, and analyze QLE obtained flow data.
G		Obtain compliance monitoring data from Qualified Local Entities	10/1/2018	9/30/2019	Concluded	Maura Eagan Moody (Inactive)	6/12/2018 3:36:05 PM
		Description: Obtain Tier 1 and Tier 2 data from Qualified Local Entities (QLEs).
H		Explore creation of a repository for collected data	10/1/2018	9/30/2019	Concluded	Maura Eagan Moody (Inactive)	8/1/2018 3:46:06 PM
		Description: National Fish and Wildlife Foundation (NFWF) will explore existing open source options for storing, organizing, and analyzing collected data so it can be updated, queried, and built into a report as needed.
I	DELIV	Monitoring information obtained		9/30/2019	Concluded	Maura Eagan Moody (Inactive)	6/12/2018 3:36:05 PM
		Description: Validate and compile new data, review reports.

Metrics

Implementation Metrics

Metric	Planned	Actual	Contractor Comments	Measures	HLIs
1464. Primary R, M, and E Focal Strategy [Population Status, Hydrosystem, Tributary Habitat, Estuary/Ocean, Harvest, Hatchery, Predation, Multiple Strategies]	Tributary Habitat	Tributary Habitat
1472. Primary R, M, and E Type [Status and Trend Monitoring, Action Effectiveness Research, Uncertainties Research, Project Implementation/ Compliance Monitoring]	Project Implementation/Compliance Monitoring	Project Implementation/Compliance Monitoring

Location

Work Site ID	Latitude	Longitude	State	County	Province	Subbasin
59106	48.930463	-119.420433	Washington	Okanogan	Columbia Cascade	Okanogan
68992	48.130365324	-119.677467675	Washington	Okanogan	Columbia Cascade	Okanogan
70808	48.360201	-119.582631	Washington	Okanogan	Columbia Cascade	Okanogan
85582	48.979103	-119.352936	Washington	Okanogan	Columbia Cascade	Okanogan
85589	48.751322	-119.343109	Washington	Okanogan	Columbia Cascade	Okanogan
86538	48.543864	-119.582942	Washington	Okanogan	Columbia Cascade	Okanogan
86542	48.529054	-119.502325	Washington	Okanogan	Columbia Cascade	Okanogan
86544	48.651964	-119.47478	Washington	Okanogan	Columbia Cascade	Okanogan
86546	48.363225	-119.584031	Washington	Okanogan	Columbia Cascade	Okanogan
89434	48.400061	-119.757113	Washington	Okanogan	Columbia Cascade	Okanogan
89443	48.398209	-119.333496	Washington	Okanogan	Columbia Cascade	Okanogan

Focal Species

Primary Focal Species:

Steelhead (O. mykiss) - Upper Columbia River DPS (Threatened)

Secondary Focal Species:

None

Environmental Compliance

None

RM&E Metadata

Data Repositories:

Title	Link
Columbia Basin Water Transactions Program	http://www.cbwtp.org/jsp/cbwtp/index.jsp

Study Plan:

Study Plan Name	Study Plan Owner	Protocol State	Sample Design Name
CBWTP - Flow Restoration Accounting Framework v1.0	rankin holmes	Finalized	NFWF Collect/Generate/Validate Field and Lab Data - National Fish and Wildlife Foundation v1.0

Methods:

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

Metrics:

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

Please correct the errors noted below.

Implementation Metrics