20518: Contract Summary

SOW Report

Contract 20518: PI 198810804 STREAMNET (CIS/NED)

Last Modified: Sharon Grant-BSA, 10/05/2007 12:12 PM
Basics

Project Number:

1988-108-04

Title:

StreamNet

BPA PM:

Martin Allen

Stage:

Implementation

Area:

Province	Subbasin	%
Basinwide	-	100.00%

Contract Number:

20518

Contract Title:

PI 198810804 STREAMNET (CIS/NED)

Contract Continuation:

Previous:	Next:
4053: 1988-108-04 STREAMNET	28958: 198810804EXP STREAMNET

Contract Status:

Closed

Contract Description:

StreamNet Project
BPA Project No.:  198810804
FY 2006 Work Statement
October 1, 2005 through September 30, 2006

As of July 11, 2006, the contract was amended to adjust to changes in operation of the project.  Some expenditures were handled by PSMFC although budgeted for the subcontractors, and adjustments were made to balance those out.  ODFW had two significant staff vacancies, and PSMFC temporarily covered some expenses normally charged for the PSMFC Computer Center.  Planned work to support the CSMEP project and PNAMP was expanded, and the old database server will be replaced to avoid potential failure and to add capacity.  The Milestones and WE budgets have been adjusted to reflect these changes.

Note:  Project costs have, in most cases, been allocated equally across all individual titles within each Work Element, since it is not possible to accurately separate them for the large number of individual titles and the fact that in some cases given work effort (cost) can address several titles at the same time.

Participants:

Bruce Schmidt, Project Manager, Pacific States Marine Fisheries Commission
Phil Roger, Columbia River Intertribal Fish Commission
Bart Butterfield, Idaho Department of Fish and Game
Janet Hess-Herbert, Montana Fish Wildlife and Parks
Cedric Cooney, Oregon Department of Fish and Wildlife
Steve Pastor, U.S. Fish and Wildlife Service
Dick O'Connor, Washington Department of Fish and Wildlife

Project Description

StreamNet is a cooperative, multi-agency data compilation and data management project authorized by the Northwest Power Planning Council's Fish and Wildlife Program (FWP).  It is funded primarily by the Bonneville Power Administration (BPA) through the FWP as part of its program to protect, mitigate, and enhance fish and wildlife resources affected by the development and operation of hydroelectric facilities on the Columbia River and tributaries.  Other funding has also been obtained in the past from agencies including the Environmental Protection Agency and the National Marine Fisheries Service.

The Pacific States Marine Fisheries Commission (PSMFC) administers the project.  PSMFC staff are also responsible for the regional components of the project, including maintaining the regional database, assuring regional data standardization, making data available in Geographic Information System (GIS) formats, building and operating Internet based data delivery systems, and posting the data for public access.

Three fourths of the project consists of sub-projects within the state fish and wildlife agencies, Columbia River Intertribal Fish Commission and US Fish and Wildlife Service to develop data and databases within the respective agencies and facilitate data transfer in regionally consistent format.  In addition to administratively housing the StreamNet sub-projects, these cooperating agencies also contribute in kind support.  The kind and amount of support varies between agencies.  All agencies provide at least some salary support for their respective StreamNet Project Leader (from one or two months to full time).  Several agencies contribute use of servers or other computer equipment and services that are not covered by charges for indirect costs.  All contribute time by biologists and in some cases data entry staff to provide data to the project.

StreamNet functions to obtain, standardize, georeference and disseminate fish related data.  It focuses on the kinds of data primarily collected by the state, tribal and federal fisheries management agencies for use in management and research programs.  Work is organized around eight BPA defined Work Elements:

1. WE 159 Submit / Acquire Data.  The agency components of the project obtain various specific data sets from within their agencies and other agencies within their respective states or among member agencies.  These data are then converted into regionally consistent formats so that all data are comparable despite agency of origin.  The formats are agreed to by all participating agencies so that all are comfortable that data from different sources are being combined correctly.  These data are then submitted to the regional database at PSMFC.  In addition, source documents for all data are submitted to the StreamNet Library so that all data in the database are tied to source documents that are available through the library.

2. WE 160 Manage / Maintain Database.  All components of the StreamNet project maintain databases and computer systems to support their work at both the source agency and regional levels.  This work includes maintenance of the hardware systems themselves and maintenance, updating, management and quality control of the data.  Also included is development of various software tools to assist in data management and manipulation, and development of the various standard data formats referred to as Data Exchange Formats (DEF) used to assure data consistency across the region.  StreamNet also maintains a number of regional base data layers that are essential for management and depiction of data, including the PNW 1:100,000 routed hydrography (stream layer), a new interim mixed scale hydrography, and various general GIS layers.

3. WE 161 Disseminate Raw and Summary Data.  Dissemination of data through the StreamNet website (www.streamnet.org) entails development, maintenance and operation of various applications, including a tabular data query system, interactive mappers, a searchable Independent Data Sets archive, and various pre-selected data sets.  Data services include responding to requests for information from individuals, subbasin planners, other FWP supported projects, watershed councils, agencies and regional entities.  The StreamNet Library provides access to data source documents for all data in the StreamNet database, the entire NW Power and Conservation Council document collection, and a major collection of fish and wildlife related agency reports and documents (gray literature).  They also provide various services such as document scanning and Interlibrary Loans to aid patrons in obtaining information.

4. WE 118 Coordination.  StreamNet coordinates with a variety of other database projects and regional initiatives.  Coordination with other databases is for the purpose of avoiding unnecessary duplication of effort and to facilitate data sharing.  Coordination with regional initiatives (such as Subbasin Planning, CSMEP, PNAMP, NED) is to provide data services and share experience and expertise with regional data consolidation and dissemination and assist these initiatives in reaching their goals.

5. WE 99 Outreach and Education.  StreamNet produces occasional documents and brochures that explain the project and how to use it to obtain data.  Project members also participate in professional organization meetings to explain project data services, advertise data availability, and encourage greater flow of data to the project.

6. WE 19 Manage and Administer Projects.  All project participants contribute to management of the project.  Each agency manages its own portion of the project, and PSMFC manages the overall project.  Management tasks include budget development and expenditure tracking, personnel supervision, and management of project activities to accomplish tasks contained in the statement of work.  Participants contribute to project guidance through active participation in the StreamNet Steering Committee and serve as liaisons with their respective agencies

7. WE 141 Produce Status Report and WE 132 Produce Annual Report.  These activities involve reporting project accomplishments to BPA.

Details of the actual tasks performed by the project are detailed in the Milestones under each Work Element.

Account Type(s):

Expense

Contract Start Date:

10/01/2004

Contract End Date:

09/30/2006

Current Contract Value:

$4,494,914

Expenditures:

$4,494,914

* Expenditures data includes accruals and are based on data through 31-Mar-2024.

BPA CO:

Kristi Van Leuven (Inactive)

BPA COR:

John Piccininni (Inactive)

Env. Compliance Lead:

None

Contract Contractor:

Pacific States Marine Fisheries Commission - PACISTAT00

Work Order Task(s):

WO: 00035794, Task: 1

Contract Type:

Contract (IGC)

Pricing Method:

Cost Reimbursement (CNF)

Click the map to see this Contract’s location details.

Photos

No photos have been uploaded yet for this Contract.

Contract Contacts

Full Name	Organization	Write Permission	Contact Role	Email	Work Phone
Bart Butterfield	Idaho Department of Fish and Game (IDFG)	Yes	Technical Contact	bart.butterfield@idfg.idaho.gov	(208) 287-2722
Cedric Cooney	Oregon Department of Fish and Wildlife	Yes	Technical Contact	Cedric.X.Cooney@odfw.oregon.gov	(503) 947-6094
Janet Hess-Herbert	Montana Fish, Wildlife and Parks (MFWP)	Yes	Technical Contact	jhessherbert@mt.gov	(406) 444-7722
Jamae Hilliard	Bonneville Power Administration	Yes	F&W Approver	jlhilliard@bpa.gov	(360) 418-8658
Pam Kahut	Pacific States Marine Fisheries Commission	No	Administrative Contact	pam_kahut@psmfc.org	(503) 595-3100
Dick O'Connor	Washington Department of Fish and Wildlife (WDFW)	Yes	Technical Contact	oconnrjo@dfw.wa.gov	(360) 902-2778
Lenora Oftedahl	Columbia River Inter-Tribal Fish Commission (CRITFC)	Yes	Technical Contact	oftl@critfc.org	(503) 736-3581
Stephen Pastor	US Fish and Wildlife Service (USFWS)	Yes	Technical Contact	stephen_pastor@fws.gov	(360) 604-2538
John Piccininni	Bonneville Power Administration	Yes	COR	jppiccininni@bpa.gov	(503) 230-7641
Phillip Roger	Columbia River Inter-Tribal Fish Commission (CRITFC)	No	Technical Contact	rogp@critfc.org	(503) 731-1301
Bruce Schmidt	Pacific States Marine Fisheries Commission	Yes	Contract Manager	bruce_schmidt@psmfc.org	(503) 595-3113
Kristi Van Leuven	Bonneville Power Administration	Yes	Contracting Officer	kjvleuven@bpa.gov	(503) 230-3605
Nancy Walters	Pacific States Marine Fisheries Commission	No	Administrative Contact	nancy_walters@psmfc.org	(503) 595-3100

Statement Of Work (SOW)

Viewing of Work Statement Elements

Deliverable Status

Deliverable Title	WSE Sort Letter, Number, Title	End	Concluded
Completed site visits to obtain new field data in Montana	A: 159. Conduct site visits to obtain updated data from biologist	01/27/2006	03/31/2006
Anadromous fish distribution data updated and maintained	B: 159. Develop anadromous fish distribution data (100K scale)	09/30/2006	09/29/2006
Resident fish distribution data maintained, updated as possible	C: 159. Develop resident fish distribution data (top priority for MFWP, lower priority for others)	09/30/2006	09/29/2006
Fish abundance data are maintained and updated	D: 159. Develop data for adult abundance in the wild	09/30/2006	09/29/2006
Hatchery release data made available in unrolled format	E: 159. Develop hatchery release data	09/30/2006	09/29/2006
Anadromous fish return to the hatchery data maintained and updated	F: 159. Develop hatchery return data	07/31/2006	09/29/2006
Data on dam and fish passage facilities maintained and updated	G: 159. Develop dam and fish passage facility data (mid-priority)	09/30/2006	09/29/2006
Hatchery facilities data maintained and updated	H: 159. Develop hatchery facility data (key dataset, update once per year)	09/30/2006	09/29/2006
In - river anadromous sport harvest data maintained and updated	I: 159. Develop harvest data	09/30/2006
100K regional hydrography maintained and mixed scale hydrography developed	J: 159. Develop hydrography data	09/30/2006	09/29/2006
Existing habitat restoration/improvement project data maintained	K: 159. Develop data to track habitat restoration / improvement projects	09/30/2006	09/29/2006
Fish barrier data maintained and updated	L: 159. Develop fish barrier data	09/30/2006	09/29/2006
Existing juvenile abundance/outmigration data maintained, additional availability explored	M: 159. Develop juvenile fish data	09/30/2006	09/22/2006
Development of fish age data in new format is initiated	N: 159. Develop fish age data	09/30/2006	09/29/2006
An exploratory review of how to organize this data type is conducted	O: 159. Develop production factor and run reconstruction data	09/30/2006	09/29/2006
Availability of diversion and screening data are explored and determined	P: 159. Develop diversion screening data	09/30/2006	09/29/2006
Other data are developed on ad hoc basis as possible	Q: 159. Develop other data sets	09/30/2006	09/29/2006
Library collection maintained and increased	R: 159. Library: Collection development	09/30/2006	09/29/2006
Computer systems maintained	S: 160. System Administration	09/30/2006	09/29/2006
Applications are developed and maintained.	T: 160. Application and interface development	09/30/2006	09/29/2006
Data are maintained and updated.	U: 160. Data (content) management	09/30/2006	09/29/2006
Data are maintained and updated.	V: 160. Data exchange standard development	09/30/2006	09/29/2006
StreamNet Internet sites maintained and functional	W: 161. Develop and maintain Internet sites for data dissemination	09/30/2006	09/29/2006
Responses to requests are provided rapidly and tracked	X: 161. Respond to data/information requests	09/30/2006	09/29/2006
Requested data and maps provided to planners	Y: 161. Provide data and maps to support Fish and Wildlife Program activities	09/30/2006	09/29/2006
Protected Areas data are available online	Z: 161. Maintain and post Protected Areas data	09/30/2006	09/29/2006
Library access is available all business days	AA: 161. Library: Provide access to the library collection	09/30/2006	09/29/2006
Input into regional FWP development activities is provided	AB: 118. EXPIRED: Support Fish and Wildlife Program development activities	09/30/2006	09/29/2006
Services to subbasin planning are provided as requested	AC: 118. EXPIRED: Support subbasin planning efforts	09/30/2006	09/29/2006
Coordination outside the FWP is accomplished as needed	AD: 118. EXPIRED: Coordinate with related activities outside of the FWP	09/30/2006	09/29/2006
Materials prepared and presentations given as needed	AE: 99. Professional and public involvement	09/30/2006	09/29/2006
Project management accomplished	AF: 119. Manage project activities	09/30/2006	09/29/2006
Four quarterly reports submitted to BPA	AG: 141. Quarterly reports	07/31/2006	07/14/2006
Annual report submitted to BPA	AH: 132. Annual report	04/21/2006	04/21/2006

Viewing of Implementation Metrics

Viewing of Environmental Metrics Customize

Focal Species

Primary Focal Species	Work Statement Elements
All Anadromous Fish	2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data 2 instances of WE 161 Disseminate Raw/Summary Data and Results
All Anadromous Salmonids	14 instances of WE 159 Transfer/Consolidate Regionally Standardized Data 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Coastal (O. clarkii clarkii)- Resident Populations	1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Lahontan (O. c. henshawi) (Threatened)	1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Westslope (O. c. lewisi)	2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Yellowstone (O. c. bouvieri)	2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Kokanee (Oncorhynchus nerka)	3 instances of WE 159 Transfer/Consolidate Regionally Standardized Data 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Trout, Bull (S. confluentus) (Threatened)	5 instances of WE 159 Transfer/Consolidate Regionally Standardized Data 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Trout, Rainbow (Oncorhynchus mykiss)	2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Interior Redband (O. mykiss gairdnerii)	4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Wildlife	1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data

Environmental Compliance

Sort	WE ID	WE Title
A	159	Conduct site visits to obtain updated data from biologist
B	159	Develop anadromous fish distribution data (100K scale)
C	159	Develop resident fish distribution data (top priority for MFWP, lower priority for others)
D	159	Develop data for adult abundance in the wild
E	159	Develop hatchery release data
F	159	Develop hatchery return data
G	159	Develop dam and fish passage facility data (mid-priority)
H	159	Develop hatchery facility data (key dataset, update once per year)
I	159	Develop harvest data
J	159	Develop hydrography data
K	159	Develop data to track habitat restoration / improvement projects
L	159	Develop fish barrier data
M	159	Develop juvenile fish data
N	159	Develop fish age data
O	159	Develop production factor and run reconstruction data
P	159	Develop diversion screening data
Q	159	Develop other data sets
R	159	Library: Collection development
S	160	System Administration
T	160	Application and interface development
U	160	Data (content) management
V	160	Data exchange standard development
W	161	Develop and maintain Internet sites for data dissemination
X	161	Respond to data/information requests
Y	161	Provide data and maps to support Fish and Wildlife Program activities
Z	161	Maintain and post Protected Areas data
AA	161	Library: Provide access to the library collection
AB	118	EXPIRED: Support Fish and Wildlife Program development activities
AC	118	EXPIRED: Support subbasin planning efforts
AD	118	EXPIRED: Coordinate with related activities outside of the FWP
AE	99	Professional and public involvement
AF	119	Manage project activities
AG	141	Quarterly reports
AH	132	Annual report
AI	185	Periodic Status Reports for BPA

Reports

SOW Report

Please correct the errors noted below.

Last Modified: Sharon Grant-BSA, 10/05/2007 12:12 PM Basics

Last Modified: Sharon Grant-BSA, 10/05/2007 12:12 PM
Basics