• Log In
Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
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-Oct-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.

Back To Top

Photos

No photos have been uploaded yet for this Contract.

Back To Top

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


Back To Top

Statement Of Work (SOW)

Viewing of Work Statement Elements

Back To Top

Deliverable Status

Deliverable Title WSE Sort Letter, Number, Title Start 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

Back To Top

Metrics

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Back To Top

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

Back To Top

Environmental Compliance

Sort WE ID WE Title NEPA NOAA USFWS NHPA Has Provisions Inadvertent Discovery Completed
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

Back To Top

Reports


Back To Top