National Marine Fisheries Service Contract for Expansion of StreamNet Database

Status Report, FY 1998

Period 10/1/97 - 3/31/98

 

 

Submitted By

Pacific States Marine Fisheries Commission

June 15, 1998

Table of Contents

Introduction *

No Cost Extension of FY97 Contract *

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

Sub-Task 1A: Expand StreamNet Abundance Database *

Sub-Task 1B: Expand StreamNet Hatchery Database *

Sub-Task 1C: Expand StreamNet Harvest Database *

Task 2: Update abundance, hatchery, and harvest data through 1995 *

Task 3. Establish a mechanism for regular updates of information *

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

Summary of Progress on No Cost Extension of FY97 contract *

FY98 Contract *

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

Sub-Tasks A, B, C: Expand StreamNet Abundance, Hatchery, and Harvest Databases to include data for British Columbia. *

Task 2. Update abundance, hatchery, and harvest data through 1996 for the States of California, Idaho, Oregon, and Washington *

FY98 Contract Summary *

Introduction

This is the mid year status report for FY98 for 2 contracts running concurrently. The first is a no-cost extension of a contract originally funded in FY97 and the second was for a continuation of that work in FY98. Both contracts are entitled Expansion of StreamNet Database to all Anadromous Salmonid Populations in the States of California, Idaho, Oregon, and Washington. This status report will detail the progress on the 2 contracts individually. Summaries of earlier statements of work, and status reports are available on the StreamNet web site (www.streamnet.org) under Project Management.

 

No Cost Extension of FY97 Contract

Considerable progress has been made through the first half of FY98 on this contract extension. Most notable was the completion of integrating an enormous amount of pre 1980 hatchery release data from Oregon into StreamNet. Our state sub-contractors have also made progress on key components of the system that required updating. We have working with contacts in California to begin the update process there. Some significant new products and features are now available on StreamNet’s web site (www.streamnet.org) and interactive query system, which are designed to improve data access and service.

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

Sub-Task 1A: Expand StreamNet Abundance Database

Status: This task is largely complete. All files from California, Idaho, and Oregon that were originally submitted have been incorporated and reviewed by the State agency sub-contractors. The only exception to this is the final review of salmon data outside of the Columbia Basin in the State of Washington. We anticipate the completion of this task in the remainder of FY98.

 

Sub-Task 1B: Expand StreamNet Hatchery Database

Status: All 14 files containing hatchery data included in the contract have been pre-processed into 2 consistent databases; hatchery releases and hatchery returns. Data from NMFS files has been re-formatted to meet StreamNet data standards and crosschecked with existing StreamNet data trends.

Hatchery Releases: We made significant progress on this task, particularly in Oregon and Washington. These two states represent the bulk of hatchery release information in the NMFS datasets. Strategies employed by state and status, vary somewhat and are summarized below.

California: Utilize information from the CWT database as the ‘official’ version of releases for tagged fish. Use data from NMFS files for releases of unmarked, unassociated fish and releases prior to data submitted to CWT database (NMFS data goes back to 1957). Establish liaison with CDFG for verification of data. Status: Incomplete.

Idaho: Utilize information from the CWT database as the ‘official’ version of releases for tagged and untagged fish from 1975 through the present. Utilize StreamNet staff at IDFG to isolate and correct inconsistencies during this time period. Use data from NMFS files for years prior to 1975 (data goes back to 1940). Status: Currently incomplete, completion anticipated in second half of FY98.

Oregon: Nearly 10,000 new trends comprised of nearly 75,000 new data records have been added to the StreamNet system for Oregon. This includes all of the records in the original NMFS submission plus additional records gleaned from paper files provided by ODFW. The StreamNet database now probably represents the most complete hatchery release compilation for Oregon in existence. Status: Complete.

Washington: WDFW has provided more complete salmon hatchery releases (back to 1950) to the CWT database. These data will be integrated into StreamNet in the second half of FY98 and account for all of the data in the NMFS files for WDFW hatcheries. Unmarked, unassociated releases of steelhead for all years are still in process in WA, but again the expectation is that these data will be complete in the second half on FY98. Status: Currently incomplete, completion anticipated in second half of FY98.

Hatchery Returns: The database submitted to PSMFC from the NRC consultants contains over 13,000 return records for the states or OR, ID, WA, and CA. We have analyzed these records and grouped them into logical trends. State by state status is shown below.

California: Utilize information from NMFS database and update StreamNet database. Establish liaison with CDFG for verification of data. Status: Incomplete.

Idaho: Utilize StreamNet staff at IDFG to error check and incorporate data from NMFS database that is missing from StreamNet. Status: Complete

Oregon: Utilize StreamNet staff at ODFW to error check and incorporate data from NMFS database that is missing from StreamNet. Status: Incomplete.

Washington: Utilize StreamNet staff at WDFW to error check and incorporate data from NMFS database that is missing from StreamNet. Status: Complete for Salmon in the Columbia Basin, anticipate completion for all species, all areas by end of FY98.

Sub-Task 1C: Expand StreamNet Harvest Database

Marine: Marine harvest data consists primarily of 11 large data files from various sources. We have reviewed this data but have had difficulty arranging meetings with the appropriate harvest managers in Oregon and Washington to determine the best route in incorporating this data. We will continue to explore this issue. The proposal for future updates would be to acquire this data from the PacFin database. Status: Incomplete.

Freshwater: Freshwater harvest data falls into 3 broad categories: Columbia River mainstem harvest, tributary sport harvest, and tributary tribal harvest. We have reviewed these datasets and will proceed as follows.

Columbia River:

Status: Columbia River harvest is complete and in the system.

Tributary Sport Harvest: Data have been added and reviewed. Status: Complete.

Treaty Freshwater Harvest: We will review these on a trend by trend basis and add as appropriate. Status: Incomplete.

 

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

Status: With a few exceptions, this task is complete. Full completion is anticipated by the end of FY98.

Task 3. Establish a mechanism for regular updates of information

The existing StreamNet project provides a mechanism for data updates for the states of Idaho, Oregon, and Washington. In the first half of FY98 we actively were negotiating an arrangement with the California Department of Fish and Game to provide similar services in CA.

Status: We anticipate that a contract relationship will be established in CA in the second half of FY98.

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

Status: This group has not been formed (to our knowledge) and we have not done any work on this task.

 

Summary of Progress on No Cost Extension of FY97 contract

The majority of effort on this project is contained in Task 1 (expand StreamNet databases with abundance, hatchery, and harvest data). Task 1A is largely complete. Most of our progress in the first half of FY98 on this task was within subtask 1B (hatchery release and return data). We have completed major additions to the hatchery release dataset for Oregon (over 70,000 new records) and Washington (about 15,000 new records). We anticipate completion of incorporation of all historical hatchery return and release data from NMFS submissions with FY98 for OR, ID, and WA. Work in CA may need to be carried into FY99. Task 1C is largely complete with the exception of marine harvest data. We are struggling somewhat with this task and will seek advice from contract contacts on how to proceed.

Task 2 and 3 (update data through 95 and establish regular mechanisms for updates) have largely been completed with the exception of the State of California. We will be pursuing avenues for data capture and update in California with CDFG in late 1998.

Task 4 (Participate in an interagency workgroup on salmon monitoring and harvest management reform) remains incomplete, as the work group has not been formed to our knowledge. If the group is formed, we will participate.

 

FY98 Contract

The continuation contract into FY98 consists of 2 main tasks. The first is to expand StreamNet abundance, hatchery, and harvest databases, and include data from British Columbia and the second is to update abundance, hatchery, and harvest data through 1996 for the States of California, Idaho, Oregon, and Washington.

 

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

Sub-Tasks A, B, C: Expand StreamNet Abundance, Hatchery, and Harvest Databases to include data for British Columbia.

Status: This task is incomplete and we do not anticipate completion during FY98. There are several mitigating circumstances contributing to this problem. The first is the fact that no standardized hydrographic system exists for British Columbia making integration into the StreamNet system considerably more problematic. The second is the fact that processing the hatchery release data took much longer than anticipated. Finally, we are going to lose our PSMFC data compiler on this project in early May and this will cause us some further delay. We would like to propose to either 1) modify the contract and remove this task altogether, or 2) delay the task and ask for a no-cost extension for this task into FY99.

 

Task 2. Update abundance, hatchery, and harvest data through 1996 for the States of California, Idaho, Oregon, and Washington

Status: This task is basically complete and ongoing with the exception of California. As stated earlier, we anticipate the establishment of a formal relationship with CDFG in the second half of FY98 and will make as much progress as possible in that time frame.

 

FY98 Contract Summary

The primary focus of Task 1 of this contract is to add data for British Columbia from the NMFS provided datasets into the StreamNet system. The completion of this task has been delayed by the amount of time spent processing hatchery release data, the fact that we have no standardized hydrologic system in BC to use to georeference this data, and our anticipated loss of our data technician in May. We would like to either modify the contract to remove this task, or, if deemed critical by NMFS, delay the completion of this task through a no-cost extension into FY99. Task 2 of the contract is proceeding as planned for Oregon, Idaho, and Washington with the anticipation that California data updates will begin in the second half of 1998.