Introduction 1Task 1: Expand StreamNet abundance, hatchery, and harvest databases 1Sub-Task 1A: Expand StreamNet Abundance Database 1Sub-Task 1B: Expand StreamNet Hatchery Database 4Sub-Task 1C: Expand StreamNet Harvest Database 6Task 2: Update abundance, hatchery, and harvest data through 1995 7Task 3. Establish a mechanism for regular updates of information 7Task 4. Participate in an interagency workgroup on salmon monitoring and harvest management reform. 8Summary 8Introduction
This is the first annual progress report on the award entitled
Expansion of StreamNet Database to all Anadromous Salmonid
Populations in the States of California, Idaho, Oregon, and Washington.
Two status reports of progress were provided earlier. The
first status report (2/4/97) summarized the status of data to
be processed as part of Task 1 of the contract. The second status
report (4/30/97) updated the status of Tasks 1-4. Both are available
on the StreamNet web site (www.streamnet.org) under Project
Management.
In general, considerable progress was made on this project during
FY 97. However, 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. A considerable amount of the original budget (approximately
$140,000) was not spent during the fiscal year, and has been obligated
as a no-cost extension to continue through FY 98.
All StreamNet data are now available on the world wide web (www) through StreamNet's web page at www.streamnet.org. Ad hoc query systems are in place which provide a variety of selection criteria, and outputs including detailed and summary tables, and graphs, some online mapping capabilities, and download options.
Status: This task is largely complete. A summary by state
is listed below. Table 1 (below) shows the detailed status of
each electronic file submitted to us for inclusion in this contract.
California : NMFS data files contained approximately 140
abundance trends. Of these, 57 were new trends. We have completed
the addition of these trends to the StreamNet database. No further
action is deemed necessary.
Idaho : NMFS data files contained very few new, or updated
abundance trends. The few that are unique are being reviewed by
IDFG StreamNet personnel and will be incorporated if appropriate.
No further action is deemed necessary.
Oregon : NMFS data files contained 960 trends for various
species in Oregon. Of these, approximately 400 were 'new' trends
currently not in the StreamNet database (most in the Oregon coastal
area). We have completed the addition of these trends to the StreamNet
database. No further action is deemed necessary.
Washington: NMFS data files contained nearly 1,500 trends
for various species in Washington. Of these, approximately 600
are 'new' trends currently not in the StreamNet database (most
in Puget Sound and coastal areas). WDFW StreamNet staff are reviewing
these trends and incorporating them as appropriate. Review of
Columbia Basin salmon and steelhead data are complete and new
trends have been incorporated as appropriate. Puget Sound and
Coastal steelhead trends have been reviewed and incorporated as
appropriate. Salmon trends outside the Columbia Basin are not
complete. We anticipate that this task will be completed in the
first half of FY 98 under the no-cost extension.
Table 1. Detailed status of each electronic file submitted to
us by NMFS for inclusion in this project.
| Data Table | |||||
| CN_TREND.DBF | |||||
| CN_DATA.DBF | |||||
| MARCHIN.DBF | |||||
| NFCHIN.DBF | |||||
| REDDCNTS.DBF | |||||
| CDFGSHIN.DBF | |||||
| NMFS_ALL.XLS | |||||
| ADLTSPCK.XLS | |||||
| ADLFTCK.XLS | |||||
| GRANDTAB.WK1 | |||||
| MILLDEER.WK1 | |||||
| DDYRCT.WK1 | |||||
| CM_TREND.DBF | |||||
| CM_DATA.DBF | |||||
| CO_TREND.DBF | |||||
| CO_DATA.DBF | |||||
| KLAMCOHO.XLS | |||||
| WCOAUC.ZIP | |||||
| CT_TREND.DBF | |||||
| CT_DATA.DBF | |||||
| PK_TREND.DBF | |||||
| PK_DATA.DBF | |||||
| Data Table | |||||
| SO_TREND.DBF | |||||
| SO_DATA.DBF | |||||
| ST_TREND.DBF | |||||
| ST_DATA.DBF | |||||
| NMFS_ALL.XLS | |||||
| MILLDEER.WK1 | |||||
| DDYRCT.WK1 | |||||
| MARSST.DBF | |||||
| MATWST. DBF | |||||
| NFSST. DBF | |||||
| NFWST. DBF | |||||
| CDFGSTHD.DBF | |||||
| ELLSTHD.DBF | |||||
| REDD_CIS.DBF | |||||
| STRESINV.ZIP | |||||
| WASTLD.XLS | |||||
| WASTLD2.XLS | |||||
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 cross
checked with existing StreamNet data trends.
Hatchery Releases: As reported in the first and second
status updates, the hatchery release dataset probably poses the
largest challenge to us in completion of this contract. The database
submitted to PSMFC from the NRC consultants contains nearly 112,000
records for the states or OR, ID, WA, and CA. About 27% of these
records came from PSMFC's Coded Wire Tag database which is the
primary source for hatchery release data in StreamNet. That leaves
nearly 82,000 from 'non PSMFC' sources in the NMFS database that
must be processed. It is our basic strategy at this time to use
PSMFC's CWT database for the primary source of release data from
1980 on and to use the data from the NMFS contractors to backfill
the release data prior to 1980. This strategy varies a little
from state to state and is 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 1943). 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 : Incomplete.
Oregon : Utilize information from the CWT database as
the 'official' version of releases for tagged and untagged fish
from 1975 through the present with the exception of unmarked,
unassociated releases prior to 1982. These will be taken from
the NMFS files as they have not been submitted to the CWT database.
Utilize staff at PSMFC to isolate and correct inconsistencies
during this time period. Use data from NMFS files for any years
prior to 1975 (data goes back to 1900). Status : Incomplete.
Washington: Utilize information from the CWT database
as the 'official' version of releases for tagged and untagged
fish from 1975 through the present with the exception of unmarked,
unassociated releases of steelhead for all years. These will be
taken from the NMFS files as they have not been submitted to the
CWT database. Utilize StreamNet staff at WDFW to isolate and
correct inconsistencies during this time period. Use data from
NMFS files for any years prior to 1974 (data goes back to 1913).
Status : Incomplete.
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 (defined as a group of a
particular stock returning to a particular hatchery. The table
below summarizes the status of these data. As you can see, there
are a significant number of trends in the NMFS database that are
either missing altogether in StreamNet or missing some years.
| Not in StreamNet | ||
| Missing Some Years | ||
| Not in StreamNet | ||
| Missing Some Years | ||
| Same as Streamnet | ||
| Not in StreamNet | ||
| Missing Some Years | ||
| Same as Streamnet | ||
| Not in StreamNet | ||
| Missing Some Years | ||
| Same as Streamnet |
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, incomplete for salmon and steelhead outside the basin and steelhead inside the basin.
Marine : Marine harvest data consists primarily of 11 large
data files from various sources. We have reviewed this data and
are in the process of setting up meetings with the appropriate
harvest managers in Oregon and Washington to determine the best
route in incorporating this data. 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: We are in the process of setting up meetings
with the appropriate harvest managers in Oregon and Washington
to determine the most appropriate way to incorporate Columbia
River harvest data and anticipate that this will be fairly easily
accomplished. Status : The meetings have not yet occurred but
data for Columbia River harvest is complete and in the system.
Format changes may occur in the future but no more action on
this item is deemed necessary.
Tributary Sport Harvest: Washington is in the process
of updating sport harvest data for the entire state. We anticipate
that this will supersede the need to review NMFS files for Washington.
Idaho data files for harvest match StreamNet trends one for one
and will be updated only. Oregon has updated sport harvest data
for the entire state. All California data for sport harvest was
obtained from StreamNet and therefore needs no review. Status
: Data is being updated at the state level and will be incorporated
as soon as possible, no more action on this item is deemed necessary.
Treaty Freshwater Harvest: We will review these on a trend
by trend basis and add as appropriate. Status : Incomplete.
I. Work to be Accomplished
This task will update data holdings through 1995 by acquiring
new data from agency contacts and incorporating this information
into the StreamNet database.
Specific work items include:
a. Acquire and incorporate 1995 information for abundance trends
in the StreamNet database resulting from the completion of Task
1A of this proposal.
b. Acquire and incorporate 1995 information for hatchery trends
in the StreamNet database resulting from the completion of Task
1B of this proposal.
c. Acquire and incorporate 1995 information for harvest trends
in the StreamNet database resulting from the completion of Task
1C of this proposal.
Status: With a few exceptions, we have completed this task. We have encountered some delays from our State participants, but most data have been provided and are incorporated in the database.
CONTRACTED TO: Pacific States Marine Fisheries Commission (PSMFC)
TIME FRAME: October 1, 1996 - September 30, 1997
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.
Status: We have not engaged in formal talks with representatives
from California at this time. However, we have established data
contacts. We will continue to explore the options available for
continued updates of information from California.
CONTRACTED TO: Pacific States Marine Fisheries Commission (PSMFC)
TIME FRAME: October 1, 1996 - September 30, 1997
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.
Status: This group has not been formed (to our knowledge)
and we have not done any work on this task.
The majority of effort on this project is contained in Task 1
(expand StreamNet databases with abundance, hatchery, and harvest
data). Most of our progress in FY 97 on this task was within
subtask 1A (abundance data). With the exception of salmon data
outside of the Columbia Basin in Washington, this task is complete.
Subtask 1B (hatchery releases and returns) and 1c (harvest data)
will be the primary focus of our activities in the FY 98 no cost
extension to this contract. These data turned out to be considerably
more complex and involved than we had anticipated, necessitating
the contract extension. We anticipate completion of these tasks
in FY 98.
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 early 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.