cbfish.org - Columbia Basin Fish & Wildlife Program - Work Element 159: Transfer/Consolidate Regionally Standardized Data - Published

Work Element 159: Transfer/Consolidate Regionally Standardized Data - Published

Basics

WE Name:

159. Transfer/Consolidate Regionally Standardized Data (Submit/Acquire Data)

Work Category:

RM & E and Data Management

WE Agreement Type:

Contracted

Status:

Active

Owner:

Russell Scranton

Definition:

This work is for transferring or reformatting data from one spreadsheet/database to another, typically primary data from a field or lab site to a higher-level, secondary regional or national database. This may also include derived data if such data are calculated by entities other than the secondary database. It includes both the act of sending and receiving, hardware/software needs for automated uploads/downloads (e.g., transmission and relay links for regular nightly uploads from remote telemonitoring sites), the development and application of data exchange protocols (including QA/QC), and any formatting and documentation required to make the transfer. It does not include initial data entry but it does include manipulating (e.g., reformatting and, if appropriate, georeferencing) data at the receiving end.

This work element explicitly reinforces the importance of transferring data to databases where they will be maintained and accessible. Capturing data above the field or lab level includes acquisition in electronic formats, entering data into a computer from historical records, digitizing images, and other methods for converting information to digital format for later dissemination or analysis. This work element may include generating secondary/derived data when those data are stored in regional databases for access and use by other parties.

WSE Description Template:

Effective Dates:

FY2005 to <no end date>

Work Phase:

monitoring/evaluation

Sort Sequence:

13.05

Focal Species Required:

Yes

RM&E Metadata Required:

Yes

Finite or Recurring:

Recurring

Is BPA Internal:

Is Contracted:

Yes

Is Cost Share:

Is Construction:

Note

None

Associated Work Elements

If the effort/cost of transfer/consolidation of data is small relative to the main effort, then transfer/consolidation can be a milestone under 157. Collect/Generate/Validate Field and Lab Data, 158. Mark/Tag Animals, 160. Create/Manage/Maintain Database, 161. Disseminate Raw/Summary Data and Results, or 162. Analyze/Interpret Data.

Potential Deliverables

Deliverable Status:

Required

Default Deliverable Desc:

Populated Database

Potential Deliverables:

Data transfer/consolidation complete
Data repository name set in http://monitoringmethods.org for this work element

Rules and Examples

Rule 1 (Metrics): Use this work element when the effort/costs of data transfer and consolidation are significant relative to the purpose of the data collection itself. Otherwise, transfer/consolidation could be a milestone under the work element associated with the purpose (usually 157. Collect/Generate/Validate Field and Lab Data).

Examples:

Option 1 (lumping):

WE: 158. Mark/Tag Animals
WE Title: Mark 150,000 hatchery spring Chinook and transfer PIT tag data to PTAGIS
WE Description: PIT tag 150,000 spring Chinook smolts at Cold Creek Hatchery prior to acclimation and release. Upload PIT tag data files to PTAGIS system to allow tracking of smolts downstream.

Option 2 (splitting):

WE: 158. Mark/Tag Animals
WE Title: PIT tag 1.2 million hatchery fish
WE Description: PIT tag 200,000 summer Chinook smolts, 450,000 spring Chinook smolts, and 550,000 steelhead at Cold Creek Hatchery prior to acclimation and release.

WE: 159. Transfer/Consolidate Regionally Standardized Data
WE Title: Upload PIT tag data to PTAGIS
WE Description: Check and upload PIT tag data for 200,000 summer Chinook smolts, 450,000 spring Chinook smolts, and 550,000 steelhead as fish are tagged throughout the year.

Milestones

None

Metrics

2 Metrics Associated With Work Element 159: Transfer/Consolidate Regionally Standardized Data

Metric	Metric Association Status	Last Comment Date	Last Comment By	Unit Type	FY Start	FY End	Required / Optional	Is Activated By Default	Included in PI	Supports PCSRF/PNSHP (Katz)	PNSHP Metric Code	PNSHP Metric
1464: Primary R, M, and E Focal Strategy [Population Status, Hydrosystem, Tributary Habitat, Estuary/Ocean, Harvest, Hatchery, Predation, Multiple Strategies]	Active			RMEFocalAreaList	2022		Required	Yes	No	No
1495: Secondary R, M, and E Focal Strategy [Population Status, Hydrosystem, Tributary Habitat, Estuary/Ocean, Harvest, Hatchery, Predation, Multiple Strategies]	Active			RMEFocalAreaList	2022		Required	Yes	No	No

Measures by Metric

None

CBFish Metric Sets

None

PCSRF/PNSHP (Katz)

Supports PCSRF/PNSHP (Katz):

Location Requirements

Location Requirement Type:

No Location

Environmental Compliance

Applicability and status of the following environmental compliance requirements can be found on the Environmental Compliance tab for that work element in your SOW for all 2007 contracts forward. BPA's Environmental staff will update and maintain this information in CBFish in real time, so that you can check the status of environmental compliance on your project at any time.

Note: Many of the fields are set to auto-load in CBFish, but the settings will be reviewed by BPA's Environmental staff prior to the contract being finalized, and may be revised depending on the specific circumstances.

National Environmental Policy Act (NEPA)

NEPA coverage for this work element will be determined by BPA's Environmental staff and could include an Environmental Impact Statement (EIS), Environmental Assessment (EA), Record of Decision to an existing EIS, or Categorical Exclusion.
Endangered Species Act (ESA)

ESA consultation is typically not required for this work element.
National Historic Preservation Act (NHPA)

NHPA Section 106 consultation is typically not required for this work element.
Public Involvement

Public involvement is typically not required for this work element.

Usage

Reports that Use this Work Element

This work element and its metrics are used in measures in the following reports. These PDF reports are generated dynamically, always showing you the most up to date information. Most of them also have links to download the underlying data sets to structured text or Excel format.

Work Element Usage

Spending By Focal Species

Types of Work Funded

View as PDF

Project Number:

Account:
Province/Subbasin:
Province:
Subbasin:
Work Start Date:
Work End or Concluded Date:

Overview: Rolls up program funding across time by work class such as Habitat, Hatchery, Research Monitoring and Evaluation, Local & Regional Coordination, etc. Includes summary and detail pie charts showing funding levels for various types of work. Provides drill-downs to work element detail.

Dimensions: Work Class, Work Element, Work Element Budget, Account Type (Expense or Capital), NPCC Province, NPCC Subbasin

Stats and Overview

Number of active contracts using Work Element #159 by FY

Top 5 BPA Project Managers using this Work Element:
(by number of current contracts)
	Deborah Docherty (Inactive)	80
	Tracy Hauser	77
	Jonathan McCloud	60
	David Byrnes (Inactive)	56
	Richard Golden Jr (Inactive)	47

Average Work Element Budget:		$27,281
Average Duration:		9 months

Fiscal Year:
Account:

Please correct the errors noted below.

2 Metrics Associated With Work Element 159: Transfer/Consolidate Regionally Standardized Data

Reports that Use this Work Element

Stats and Overview