Proposal for No-Cost Extension of 1996/97 Funding

EXPANSION OF StreamNet DATABASE TO ALL ANADROMOUS SALMONID POPULATIONS IN THE STATES OF CALIFORNIA, IDAHO, OREGON, AND WASHINGTON

submitted by

Pacific States Marine Fisheries Commission

I. Introduction

Due to the complexity and scope of this contract we experienced several start-up delays in the implementation of the agreement. There were hundreds of files involved in the agreement and we spent considerably more time than anticipated reviewing these files and developing strategies for incorporating the data contained in the files into the StreamNet database. This factor caused the delay of establishing sub-contracts with participating agencies as well as the delay of the completion of several of the tasks. PSMFC is anticipating that approximately $140,000 will be available to continue ongoing tasks described in Year 1. This proposal outlines only the tasks started in Year 1 which will be continued by way of a no-cost time extension.

II. Task List - Project Narrative

Task 1. Expand StreamNet abundance, hatchery, and harvest databases

Objective: This task would expand the content and geographic scope of the current StreamNet data holdings to include historical information for all anadromous populations in Washington, Oregon, Idaho, and California by incorporating data from NMFS contract databases to the greatest extent feasible into the StreamNet database system.

Results and Benefits Expected: The StreamNet system is a regional repository for standardized anadromous fish information used to support fishery management decisions within the Columbia Basin and on the Oregon and Washington coasts. The StreamNet database system utilizes standardized geographic and data coding allowing data query, display, reporting, and export for all data types through a single user interface. By expanding the geographic scope to include California, and incorporating longer term historical data currently not present in the StreamNet system (to be incorporated from the NMFS contract databases), the system will provide a more comprehensive and long term information source for west coast fishery managers, in a powerful user-friendly PC based application.

Sub-Task A: Expand StreamNet Abundance Database

Objective: This task would expand the content and geographic scope of the current StreamNet natural adult abundance data holdings to include historical information for all anadromous populations in Washington, Oregon, Idaho, and California by incorporating data from NMFS contract databases to the greatest extent feasible into the StreamNet database system.

Results and Benefits Expected: By expanding the geographic scope and historical contents of this data component, the database will provide a more comprehensive information set of natural spawning ground returns and other adult abundance indices. This information is vital in the assessment of stock status and population trends of Pacific Northwest anadromous salmonids.

Sub-Task B: Expand StreamNet Hatchery Database

Objective: This task would expand the content and geographic scope of the current StreamNet hatchery release and return holdings to include historical information for all anadromous populations in Washington, Oregon, Idaho, and California by incorporating data from NMFS contract databases to the greatest extent feasible into the StreamNet database system.

Results and Benefits Expected: By expanding the geographic scope and historical contents of this data component, the database will provide a more comprehensive information set of hatchery influences in the Pacific Northwest. This information is useful in the determination of wild stock status, as well as in the assessment of the health and status of Pacific Northwest populations of anadromous salmonids.

Sub-Task C: Expand StreamNet Harvest Database

Objective: This task would expand the content and geographic scope of the current StreamNet freshwater and marine harvest data holdings to include historical information for all anadromous populations in Washington, Oregon, Idaho, and California by incorporating data from NMFS contract databases to the greatest extent feasible into the StreamNet database system.

Results and Benefits Expected: By expanding the geographic scope and historical contents of this data component, the database will provide a more comprehensive information set of freshwater and marine harvest. This information is used to monitor harvest trends, and assess the health and status of Pacific Northwest populations of anadromous salmonids.

Task 2. Update abundance, hatchery, and harvest data through 1995

Objective: This task would update the datasets resulting from Task 1 through the 1995 run year where feasible.

Results and Benefits Expected: The completion of this task would result in a comprehensive information source with the most up to date information available.

Sub-Task A: Acquire and incorporate 1995 Abundance Data

Objective: This task would add 1995 run year data to the datasets resulting from task 1A.

Results and Benefits Expected: This task would provide and make accessible the most current data available in this category.

Sub-Task B: Acquire and incorporate 1995 Hatchery Data

Objective: This task would add 1995 run year data to the datasets resulting from task 1B.

Results and Benefits Expected: This task would provide and make accessible the most current data available in this category.

Sub-Task C: Acquire and incorporate 1995 Harvest Data

Objective: This task would add 1995 run year data to the datasets resulting from task 1C.

Results and Benefits Expected: This task would provide and make accessible the most current data available in this category.

Task 3. Establish a mechanism for regular updates of information

Objective: This task would create new or enhance existing mechanisms for acquiring regular, ongoing information updates for the datasets described in tasks 1 and 2.

Results and Benefits Expected: The completion of this task would ensure that the database would be maintained into the future with periodic updates resulting in a comprehensive, up-to-date information system for Pacific Northwest anadromous salmonids.

Task 4. Participate in an interagency workgroup on salmon monitoring and harvest management reform.

Objective: This task would provide PSMFC participation in a workgroup created by NMFS.

Results and Benefits Expected: Participation is at the request of NMFS and will be especially focused at the direct link of information needs of monitoring and harvest management reform discussions and the database efforts.


IV. Task Details

Task 1: Expand StreamNet abundance, hatchery, and harvest databases

ADMINISTERED BY: Pacific States Marine Fisheries Commission (PSMFC)

TIME FRAME: October 1, 1997 - September 30, 1998

I. Work to be Accomplished

Subtask 1A:

This sub-task will expand the scope of adult abundance data in the StreamNet database to include all of the populations in California, Idaho, Oregon, and Washington by incorporating existing information from the NMFS contract databases into the StreamNet database.

Specific work items include:

a. Examine and incorporate as appropriate into StreamNet database adult abundance records from NMFS contract datasets. Process will included 1) comparison with existing data in StreamNet to prevent duplication and validation of new data added to system, 2) reformatting and coding of data to meet StreamNet standards, 3) addition of standardized geographic reference codes (EPA reach numbers) to all trends incorporated and 4) addition of reference information into StreamNet reference system. The following NMFS contract datasets will be processed (from Catch, Escapement, and Historical Data reports for Chinook Salmon, Chum Salmon, Coho Salmon, Cutthroat Trout, Pink Salmon, Sockeye Salmon, and Steelhead Trout; reports for Northwest Fisheries Center, prepared by Big Eagle & Associates and LGL Limited, record counts are for target states only, original databases may contain additional records for Alaska and British Columbia):

Sub-Task 1B: Expand StreamNet Hatchery Database

I. Work to be Accomplished

This sub-task will expand the scope of hatchery data in the StreamNet database to include all of the populations in California, Idaho, Oregon, and Washington by incorporating existing information from the NMFS contract databases into the StreamNet database.

Specific work items include:

a. Examine and incorporate as appropriate into StreamNet database hatchery records from NMFS contract datasets. Process will included 1) comparison with existing data in StreamNet to prevent duplication and validation of new data added to system, 2) reformatting and coding of data to meet StreamNet standards, 3) addition of standardized geographic reference codes (EPA reach numbers) to all trends incorporated and 4) addition of reference information into StreamNet reference system. The following NMFS contract datasets will be processed (from hatchery production data submitted to PSMFC by Greg Ruggerone of Natural Resources Consultants on 3/11/96, record counts are for target states only, original databases may contain additional records for Alaska and British Columbia).

Sub-Task 1C: Expand StreamNet Harvest Database

I. Work to be Accomplished

This sub-task will expand the scope of harvest data in the StreamNet database to include all of the populations in California, Idaho, Oregon, and Washington by incorporating existing information from the NMFS contract databases into the StreamNet database.

Specific work items include:

a. Examine and incorporate as appropriate into StreamNet database marine harvest records from NMFS contract datasets. Process will included 1) comparison with existing data in StreamNet to prevent duplication and validation of new data added to system; 2) reformatting and coding of data to meet StreamNet standards; 3) addition of standardized geographic reference codes (EPA reach numbers) to all trends incorporated; and 4) addition of reference information into StreamNet reference system. The following NMFS contract datasets will be processed (from Marine Commercial and Sport Catch Databases with Information on Salmon and Steelhead, a report for Northwest Fisheries Center, prepared by Big Eagle & Associates and LGL Limited, record counts are for target states only, original databases may contain additional records for Alaska and British Columbia).

b. Examine and incorporate as appropriate into StreamNet database freshwater harvest records from NMFS contract datasets. Process will included 1) comparison with existing data in StreamNet to prevent duplication and validation of new data added to system, 2) reformatting and coding of data to meet StreamNet standards, 3) addition of standardized geographic reference codes (EPA reach numbers) to all trends incorporated and 4) addition of reference information into StreamNet reference system. The following NMFS contract datasets will be processed (from Catch, Escapement, and Historical Data reports for Chinook Salmon, Chum Salmon, Coho Salmon, Cutthroat Trout, Pink Salmon, Sockeye Salmon, and Steelhead Trout; reports for Northwest Fisheries Center, prepared by Big Eagle & Associates and LGL Limited, record counts are for target states only, original databases may contain additional records for Alaska and British Columbia).


Task 3. Establish a mechanism for regular updates of information

ADMINISTERED BY: Pacific States Marine Fisheries Commission (PSMFC)

TIME FRAME: October 1, 1997 - September 30, 1998

I. Work to be Accomplished

The existing StreamNet project provides a mechanism for data updates for the states of Idaho, Oregon, and Washington. Data compilers and coordinators in each state work together with the regional data manager to insure regular updates of information in a standardized format. This infrastructure is not in place in California, however, because California is outside the geographic scope of the current StreamNet project. This task would focus on establishing similar mechanisms in California, as currently exist in the StreamNet states of Idaho, Oregon, and Washington.

Task 4. Participate in an interagency workgroup on salmon monitoring and harvest management reform.

ADMINISTERED BY: Pacific States Marine Fisheries Commission (PSMFC)

TIME FRAME: October 1, 1997 - September 30, 1998

I. Work to be Accomplished

This task will provide for PSMFC and StreamNet participation in the interagency workgroup on salmon monitoring and harvest management reform. Participation will be especially focused on the information needs of managers and how those needs can be met by the various data activities coordinated through PSMFC.