Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 28958: 198810804EXP STREAMNET
Project Number:
Title:
StreamNet
BPA PM:
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
28958
Contract Title:
198810804EXP STREAMNET
Contract Continuation:
Previous: Next:
20518: PI 198810804 STREAMNET (CIS/NED)
  • 34428: 198810804 EXP STREAMNET
Contract Status:
Closed
Contract Description:
StreamNet Project
BPA Project No.:  198810804
FY 2007 Work Statement
October 1, 2006 through September 30, 2007

Note 1:  The StreamNet contract is being revised mid year to incorporate changes in data type and data service priorities as determined through a regional data management workshop and from guidance by CBFWA.  This revision will result in shifts in effort among the various types of data served by the project and services provided to data sources and data users.  There is no change in scope of the project or in the total budget.

Note 2:  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 map applications, 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 189 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 119 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 132 Produce Annual Report.  A detailed annual report will be prepared that describes the specific work accomplished by the project during the preceding fiscal year.  In the past, detailed activities were reported in four quarterly reports.  With the advent of Pisces, however, quarterly reports were converted to the abbreviated Pisces format, eliminating the former detail.  As a result, we are redesigning the annual report to contain summaries of the detailed work done by Work Element and Milestone.

8. WE 185 Periodic Status Reports for BPA.  This work element entails completing and submitting abbreviated quarterly and final status reports in the Pisces system.

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/2006
Contract End Date:
09/30/2007
Current Contract Value:
$2,250,804
Expenditures:
$2,250,804

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

Env. Compliance Lead:
None
Work Order Task(s):
Contract Type:
Contract (IGC)
Pricing Method:
Cost Reimbursement (CNF)
Click the map to see this Contract's location details.

No photos have been uploaded yet for this Contract.

Full Name Organization Write Permission Contact Role Email Work Phone
Stan Allen Pacific States Marine Fisheries Commission No Supervisor sallen@psmfc.org (503) 595-3100
Michael Arredondo Pacific States Marine Fisheries Commission Yes Administrative Contact marredondo@psmfc.org (503) 595-3100
Mike Banach Pacific States Marine Fisheries Commission No Interested Party mike_banach@psmfc.org (503) 595-3152
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
Brodie Cox Washington Department of Fish and Wildlife (WDFW) Yes Technical Contact coxpbc@dfw.wa.gov (360) 902-2776
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
Amy Roberts Pacific States Marine Fisheries Commission Yes amy_roberts@psmfc.org (503) 595-3100
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


Viewing of Work Statement Elements

Deliverable Title WSE Sort Letter, Number, Title Start End Concluded
Conduct site visits to obtain updated data from biologists A: 159. Conduct site visits to obtain updated data from biologist 08/15/2007 08/15/2007
Anadromous fish distribution data updated and maintained B: 159. Develop anadromous fish distribution data (100K scale) 09/30/2007 09/30/2007
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/2007 09/30/2007
Fish abundance data are maintained and updated D: 159. Develop data for adult abundance in the wild 09/30/2007 09/30/2007
Anadromous fish return to the hatchery data maintained and updated E: 159. Develop hatchery return data 07/31/2007
Data on dam and fish passage facilities maintained and updated F: 159. Develop dam and fish passage facility data (mid-priority, update every three years) 09/30/2007 09/30/2007
Hatchery facilities data maintained and updated G: 159. Develop hatchery facility data (update every three years) 09/30/2007 09/30/2007
The 100K hydrography is maintained and mixed scale hydrography is functional. H: 159. Develop hydrography data 09/30/2007 09/30/2007
Fish barrier data maintained and updated I: 159. Develop fish barrier data 09/30/2007 09/30/2007
Development of fish age data in new format is initiated J: 159. Develop fish age data 09/30/2007
Other data are developed on an ad hoc basis as possible K: 159. Develop other data sets 09/30/2007 09/30/2007
Library collection maintained and increased L: 159. Library: Collection development 09/30/2007 09/30/2007
Computer systems maintained M: 160. System Administration 09/30/2007 09/30/2007
Applications are developed and maintained. N: 160. Application and interface development 09/30/2007 09/30/2007
Data are maintained and updated, metadata are developed, and data timeline is posted. O: 160. Data (content) management 09/30/2007 09/30/2007
Data are maintained and updated. P: 160. Data exchange standard development 09/30/2007 09/30/2007
StreamNet Internet sites maintained and functional Q: 161. Develop and maintain Internet sites for data dissemination 09/30/2007 09/30/2007
Responses to requests are provided rapidly and tracked R: 161. Respond to data/information requests 09/30/2007 09/30/2007
Library access is available all business days S: 161. Library: Provide access to the library collection 09/30/2007 09/30/2007
Data related support is provided to FWP related activities T: 189. Support regional efforts under the Fish and Wildlife Program 09/30/2007 09/30/2007
Support provided to data source agencies U: 189. Coordinate with and support data source agencies 09/30/2007 09/30/2007
Coordination outside the FWP is accomplished as needed V: 189. Coordinate with related activities outside of the FWP 09/30/2007 09/30/2007
Materials prepared and presentations given as needed W: 99. Professional and public involvement 09/30/2007 09/30/2007
Project management accomplished X: 119. Manage project activities 09/30/2007 09/30/2007
Annual report submitted to BPA Y: 132. Annual report 07/18/2007 04/13/2007

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Primary Focal Species Work Statement Elements
All Anadromous Fish
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
All Anadromous Salmonids
  • 5 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Chinook (Oncorhynchus tshawytscha) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Chum (Oncorhynchus keta) - Columbia River ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Coho (O. kisutch) - Unspecified Population
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Coastal (Oncorhynchus clarkii clarkii) - All Anadromous Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Sockeye (Oncorhynchus nerka) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Steelhead (Oncorhynchus mykiss) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Lamprey, Pacific (Entosphenus tridentata)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Lamprey, River (L. ayresi)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Sturgeon, Green (Acipenser medirostris)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Sturgeon, White (A. transmontanus) - Lower Columbia River
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Burbot (Lota lota)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Carp, Common (Cyprinus carpio) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
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)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Yellowstone (O. c. bouvieri)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Kokanee (Oncorhynchus nerka)
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Sturgeon, White (Acipenser transmontanus) - All Populations except Kootenai R. DPS
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Brown (Salmo trutta) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Brook (Salvelinus fontinalis)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Bull (S. confluentus) (Threatened)
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Rainbow (Oncorhynchus mykiss)
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Interior Redband (O. mykiss gairdnerii)
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Wildlife
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results

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 02/09/2007
B 159 Develop anadromous fish distribution data (100K scale) 02/09/2007
C 159 Develop resident fish distribution data (top priority for MFWP, lower priority for others) 02/09/2007
D 159 Develop data for adult abundance in the wild 02/09/2007
E 159 Develop hatchery return data 02/09/2007
F 159 Develop dam and fish passage facility data (mid-priority, update every three years) 02/09/2007
G 159 Develop hatchery facility data (update every three years) 02/09/2007
H 159 Develop hydrography data 02/09/2007
I 159 Develop fish barrier data 02/09/2007
J 159 Develop fish age data 02/09/2007
K 159 Develop other data sets 02/09/2007
L 159 Library: Collection development 02/09/2007
M 160 System Administration 02/09/2007
N 160 Application and interface development 02/09/2007
O 160 Data (content) management 02/09/2007
P 160 Data exchange standard development 02/09/2007
Q 161 Develop and maintain Internet sites for data dissemination 02/09/2007
R 161 Respond to data/information requests 02/09/2007
S 161 Library: Provide access to the library collection 02/09/2007
T 189 Support regional efforts under the Fish and Wildlife Program 02/09/2007
U 189 Coordinate with and support data source agencies 02/09/2007
V 189 Coordinate with related activities outside of the FWP 02/09/2007
W 99 Professional and public involvement 02/09/2007
X 119 Manage project activities 02/09/2007
Y 132 Annual report 02/09/2007
Z 185 Periodic Status Reports for BPA 02/09/2007