I. Introduction

This proposal addresses the National Marine Fisheries Service immediate need for accurate, standard and readily available data on salmon and steelhead abundance and production information by incorporating this need into established interagency data efforts.

Salmon abundance and production information gathered during ESA status review activities will be fully incorporated into the Interagency StreamNet database, expanding the geographic coverage (outside of the Columbia River Basin) of the database to include all salmon and steelhead stocks in Washington, Oregon and California. A system will be established for annual updates to the full database.

Work in future years in future years would focus on continued update and expansion of database coverage to Alaska and British Columbia, additional effort on aquatic habitat data, and refining data structure and access techniques.

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

CONTRACTED TO: Pacific States Marine Fisheries Commission (PSMFC)

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

Sub-Task 1A: Expand StreamNet Abundance Database

I. Work to be Accomplished

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):

Data Table	# of Records	Data Type	Year Range	States Included
CHINOOK
CN_TREND.DBF	1,082	Adult Return	Varies	CA, ID, OR, WA
CN_DATA.DBF	20,580	Adult Return	Varies	CA, ID, OR, WA
MARCHIN.DBF	2,018	Marmot Dam Counts	1977-94	OR
NFCHIN.DBF	14,009	NF Clackamas Dam Counts	1957-94	OR
REDDCNTS.DBF	2,969	Redd Counts	1957-94	ID
CDFGSHIN.DBF	81	Carcass Count	1985-94	CA
NMFS_ALL.XLS	900	Redd/Carcass	1968-94	CA
ADLTSPCK.XLS	78	Prosser Dam Counts (Spring)	1983-94	WA
ADLFTCK.XLS	78	Prosser Dam Counts (Fall)	1983-94	WA
GRANDTAB.WK1	2,300	Fall Spawning Estimates	1952-91	CA
MILLDEER.WK1	850	Spawning Estimates	1940-94	CA
DDYRCT.WK1	252	Red Bluff Dam Counts	1967-93
CHUM
CM_TREND.DBF	432	Adult Return	Varies	WA
CM_DATA.DBF	6,695	Adult Return	Varies	WA
COHO
CO_TREND.DBF	742	Adult Return	Varies	WA,OR
CO_DATA.DBF	11,988	Adult Return	Varies	WA,OR
KLAMCOHO.XLS	175	Adult Return/Redds	68-94	CA
WCOAUC.ZIP	1,344	Adult Return	81-94	OR
CUTTHROAT
CT_TREND.DBF	13	Adult Return	Varies	WA,OR
CT_DATA.DBF	231	Adult Return	Varies	WA,OR
PINK
PK_TREND.DBF	73	Adult Return	Varies	WA
PK_DATA.DBF	1,035	Adult Return	Varies	WA
Data Table	# of Records	Data Type	Year Range	States Included
SOCKEYE
SO_TREND.DBF	50	Adult Return	Varies	WA,OR
SO_DATA.DBF	1,072	Adult Return	Varies	WA,OR
STEELHEAD
ST_TREND.DBF	841	Adult Return	Varies	WA,OR,CA,ID
ST_DATA.DBF	9,225	Adult Return	Varies	WA,OR,CA,ID
NMFS_ALL.XLS	See Chinook Section
MILLDEER.WK1	See Chinook Section
DDYRCT.WK1	See Chinook Section
MARSST.DBF	2,606	Marmot Dam Counts	1957-95	OR
MATWST. DBF	1,910	Marmot Dam Counts	1957-95	OR
NFSST. DBF	5,489	NF Clackamas Dam Counts	1957-95	OR
NFWST. DBF	3,381	NF Clackamas Dam Counts	1957-95	OR
CDFGSTHD.DBF	512	Spawning Ground Counts	1985-94	CA
ELLSTHD.DBF	180	Cape Horn Dam Count	1933-94	CA
REDD_CIS.DBF	206	Redd Counts	60-64	ID
STRESINV.ZIP	59 Excel Tables	Spawning Counts, Harvest Data	Varies	WA
WASTLD.XLS	44 Excel Tables	Spawning Counts, Harvest Data	Varies	WA
WASTLD2.XLS	100+	Spawning Counts, Harvest Data	Varies	WA

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).

Data Table	# of Records	Data Type	Species	Year Range	States Included
CHINREL.DBF	32,258	Releases	Ch	Varies	ID, WA, OR, CA
CHUMREL.DBF	3,207	Releases	Cm	Varies	OR, WA
COHOREL.DBF	36,216	Releases	Co	Varies	WA, OR, CA
CUTTREL.DBF	8,670	Releases	Ct	Varies	WA, OR, CA
PINKREL.DBF	250	Releases	Pk	Varies	OR, WA
SOCKREL.DBF	1,057	Releases	So	Varies	ID, WA, OR
STEELREL.DBF	30,152	Releases	St	Varies	ID, WA, OR, CA
CHINSPSU.DBF	5,445	Returns	Ch	Varies	ID, WA, OR, CA
CHUMSPSU.DBF	907	Returns	Cm	Varies	OR, WA
COHOSPSU.DBF	3,554	Returns	Co	Varies	WA, OR, CA
CUTTSPSU.DBF	170	Returns	Ct	Varies	WA, OR
PINKSPSU.DBF	189	Returns	Pk	Varies	OR, WA
SOCKSPSU.DBF	388	Returns	So	Varies	ID, WA, OR
STEELSPSU.DBF	2,509	Returns	St	Varies	ID, WA, OR, CA

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):

Data Table	# of Records	Data Type	Species	Year Range	States Included
MACA1.DBF	56,583	Marine Comm.	All	1981-93	WA, OR, CA
MACA2.DBF	3,508	Marine Troll	All	1950-69	WA
MACA3.DBF	43,156	Marine Comm.	All	1970-93	WA
MACA4.DBF	2,044	Marine Sport.	All	1950-93	WA
MACA5.DBF	7,888	Marine Sport.	All	1967-93	WA
MACA8.DBF	2,139 3,568	Marine Troll	Co, Cn, Pk	1952-90 1925-91	CA OR
MACA9.DBF	1,752 819	Marine Sport	Co, Cn	1962-90 1974-90	CA OR
O-CP-CHIN.XLS	360	Marine Sport	Cn	1974-93	OR
OCEAN.WK1	480	Marine Comm. & Sport	Cn	1947-91	CA

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):

Data Table	# of Records	Data Type	Year Range	States Included
COMBINED
76FW.XLS (wafwsprt.zip)	19,256	FW Sport	1976-85	WA
86FW.XLS (wafwsprt.zip)	23,408	FW Sport	1986-93	WA
SRTxx Files	Varies	FW Sport and Commercial	Varies	Col. River
CHINOOK
FWCNTRND.DBF	240	FW Sport	Varies	OR
FWCNDATA.DBF	4,202	FW Sport	Varies	OR
WACNFWIN.XLS	1,200	Treaty FW	1935-91	WA
CHUM
OR_FW_SP.XLS	200	FW Sport - Tillamook District	1969-91	OR
CM_TILL.XLS	22	FW Sport/Comm - Tillamook Bay	1969-91	OR
WA_FW_IN.XLS	300	FW Treaty	1982-91	WA
COHO
FWCOTRND.DBF	135	FW Sport	Varies	OR, WA
FWCODATA.DBF	2,352	FW Sport	Varies	OR, WA
WACOFWIN.XLS	876	FW Treaty	1935-91	WA
CUTTHROAT
FWCNTRND.DBF	9	FW Sport	Varies	OR, WA
FWCNDATA.DBF	95	FW Sport	Varies	OR,WA
PINK
N/A
SOCKEYE
WASOFWIN.XLS	870	FW Treaty	1982-91	WA
STEELHEAD
FWSTTRND.DBF	1,292	FW Sport	Varies	CA, ID, OR, WA
FWSTDATA.DBF	16,383	FW Sport	Varies	CA, ID, OR, WA
STRESINV.ZIP	59 Excel Tables	Spawning Counts, Harvest Data	Varies	WA
WASTLD.XLS	44 Excel Tables	Spawning Counts, Harvest Data	Varies	WA
WASTLD2.XLS	100+	Spawning Counts, Harvest Data	Varies	WA
HARV_CIS.DBF	645	FW Sport	Varies	ID

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

CONTRACTED TO: Pacific States Marine Fisheries Commission (PSMFC)

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

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.

Task 3. Establish a mechanism for regular updates of information

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.

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

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.