Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 54765: 1988-108-04 EXP STREAMNET (CIS-NED) FY12
Project Number:
Title:
StreamNet
BPA PM:
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
54765
Contract Title:
1988-108-04 EXP STREAMNET (CIS-NED) FY12
Contract Continuation:
Previous: Next:
49053: 1988-108-04 EXP STREAMNET (CIS-NED) FY11
  • 60412: 1988-108-04 EXP STREAMNET (CIS-NED) FY13
Contract Status:
Closed
Contract Description:
StreamNet Project
BPA Project No.:  1988-108-04
FY 2012 Work Statement
October 1, 2011 through September 30, 2012

The StreamNet Project, a cooperative data compilation and data management project under the Fish and Wildlife Program (FWP) focused on fish and fish related data, provides regionally standardized, georeferenced fish related data and data services.  Emphasis of the project in FY-12, in addition to routine data acquisition, standardization, georeferencing and update, is to support regional scale reporting of Viable Salmonid Population (VSP) indicators through the Coordinated Assessments effort of Columbia Basin Fish and Wildlife Authority (CBFWA) and Pacific Northwest Aquatic Monitoring Partnership (PNAMP), support reporting of status and trend data through the Status of the Resource (SOTR) report, and to promote and support development of data management capabilities in the data source agencies to improve data flow and efficiency.  

StreamNet is playing a strong role in regional scale collaborative efforts, including PNAMP (Steering Committee, Data Management Leadership Team, Metadata Work Group, etc.) and CBFWA (providing data to the SOTR).  A primary focus is supporting the Coordinated Assessment effort through participation on the planning team, supervising the initial data gathering effort, and providing data management advice and guidance as the fisheries agencies and tribes develop their programs to begin routine sharing of VSP indicators externally.

Key components of planned emphasis in Fiscal Year 2012 include the following:

•  Emphasis on data to feed regional scale reporting at a high level.  High priority will be on the three derived VSP indicators that are the initial focus of the Coordinated Assessments project.  Derived estimates are somewhat of a new direction for StreamNet because most data served through the project have primarily been either basic field data or slightly summarized data.  The project will continue its involvement in the project and begin planning for the potential to add acquisition and dissemination of these VSP indicators through the StreamNet database and online query system.  High Level Indicators (HLI) under the NPCC will also be emphasized if requested.

•  Priority on data to feed regional reporting through the SOTR report.  Priority for updating established data trends will be given to data describing focal species that are reported through the SOTR.

•  Maintenance and update of data sets that constitute the long term data housed in the StreamNet database and disseminated through the StreamNet online data query system and interactive map applications.

•  Establishing automated data flow.  Work will continue toward developing automated processes for sharing data, including for transferring data from the source agencies to the main StreamNet database and for providing routine data to specific data users, such as CBFWA for use in the SOTR.  We see automation as the primary means of increasing efficiency within the project in the future.  We will expand upon the successful tests of automated transfer from the Idaho Department of Fish and Game (IDFG) Idaho Fish and Wildlife Information System (IFWIS) database.  We will also continue to explore means to automate data transfer via Extensible Markup Language (XML) based web services, which will be a prerequisite for any move toward implementing an exchange network approach to regional data sharing.

•  Support development of data systems within agencies.  We will continue to support development of the Idaho Fish and Wildlife Information System within IDFG, and provide assistance as requested with other agency efforts, such as the Juvenile Migrant Exchange (JMX) in WDFW and the Salmon Recovery Tracker in Oregon Department of Fish and Wildlife (ODFW).  These and similar agency systems will greatly improve data sharing within agencies, to StreamNet, to the public, and eventually to automated approaches similar to the EPA Exchange Network.

•  Refine our strategy to compensate for lost staffing.  Inflation over time has eroded staffing capacity, particularly in Washington Department of Fish and Wildlife (WDFW) and ODFW.  As a result, WDFW StreamNet had to limit data acquisition to only the lower Columbia Basin subbasins, and ODFW StreamNet has taken a subbasin by subbasin approach to acquiring data for priority focal species, but may be unable to address all subbasins each year.  Several components of the project have moved some of their staff time to other funding sources, but for other work.  Without funding to restore staffing levels, strategy options may include 1) encouraging data source agencies to emphasize development of agency-wide database approaches, 2) increased automation of data exchange where made possible by the first option, 3) continue or increase reliance on other funding sources to support specialized staff to free up funding to support additional data technicians until automated data exchanges become more feasible, and 4) attempt to identify funding to leverage efforts that meet goals for the project and other funding sources.  Without changes, it will be necessary to update some data types only on an every other year basis or skipping parts of a state, a significant departure from our goal of increasing coverage and speed of data compilation.  As currently budgeted in FY-12 and unless other agency funding can be obtained, data compilation in Washington may be limited to the lower Columbia subbasins and in Oregon all subbasins may not be included in data capture.  We anticipate addressing this need in the FY-13 project proposal.

•  Increase emphasis on acquiring data from tribal programs.  While the Columbia River Inter-Tribal Fish Commission (CRITFC) portion of the StreamNet project is using Accord supported projects to work with their member tribes and improve data flow, we will investigate means of providing internal support to other tribes to assist with internal data system development and flow of data to StreamNet.  This was based on our experience with the Coordinated Assessments which illustrated the tribal desire to improve their data sharing capabilities.  Funding to address this need will be included in the FY-13 project proposal.

The StreamNet statement of work is organized around seven Work Elements, with multiple individual WE Titles and associated milestones for all project participants:

1.  WE 159 Transfer/Consolidate Regionally Standardized Data.  This work element encompasses the acquisition, standardization, georeferencing and consolidation of fish related data by the agencies that participate in the StreamNet project.  This also includes acquisition of source documents for all acquired data and submission of the references to the StreamNet Library at CRITFC.   Specific data types involved are detailed in the milestones in the work statement.

2.  WE 160 Create/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 (PSMFC) levels.  This work includes maintenance and needed upgrade of the hardware and software systems, development of applications to assist in data management and manipulation (including stored procedures for quality assessment of data), development of standard data formats to assure data consistency across the region, and maintenance of regional base data layers essential for management and depiction of data, including the new mixed scale routed hydrography (stream layer) and various general GIS layers.

3.  WE 161 Disseminate Raw/Summary Data and Results.  Data from StreamNet and independent data sets from the Data Store, maps, data references, and various other materials are disseminated primarily through the StreamNet website www.streamnet.org.  Other data services include responding to requests for information from individuals, subbasin planners, other FWP supported projects, watershed councils, recovery teams, agencies and regional entities.

4.  WE 189 Regional Coordination.  StreamNet coordinates with a variety of other database projects and regional initiatives, including CBFWA (SOTR, Data Management Framework Subcommittee), PNAMP (Steering Committee, Data Management Leadership Team, other work groups), Hatchery Scientific Review Group (HSRG), Northwest Power and Conservation Council (NPCC), Integrated Status and Effectiveness Monitoring Program (ISEMP), subbasin planners, recovery planners, data source agencies including states, tribes and federal agencies, etc.  The purpose of coordination is to facilitate flow of data, provide data management expertise, and avoid duplication of effort.  A primary emphasis in FY-12 will be continued activities related to the Coordinated Assessments.

5.  WE 119 Manage and Administer Projects.  All project participants contribute to management of the StreamNet project, including managing their own respective components and through participation in the StreamNet Steering Committee.

6.  WE 132 Produce (Annual) Progress Report.  All project participants contribute to a detailed annual report of activities and accomplishments throughout the fiscal year.

7.  WE 185 Produce Pisces Status Report.  This work element entails completing and submitting abbreviated quarterly and final status reports in the Pisces system.

The bulk of the project consists of sub-projects within four state fish and wildlife agencies (WDFW, ODFW, IDFG and Montana Fish, Wildlife and Parks - MFWP) and US Fish and Wildlife Service (FWS) 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.  Most 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.  

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

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/2011
Contract End Date:
12/31/2012
Current Contract Value:
$2,297,009
Expenditures:
$2,297,009

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

BPA COR:
Env. Compliance Lead:
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
Dawn Anderson Montana Fish, Wildlife and Parks (MFWP) Yes Technical Contact dawanderson@mt.gov (406) 444-3373
Michael Arredondo Pacific States Marine Fisheries Commission No Administrative Contact marredondo@psmfc.org (503) 595-3100
Mike Banach Pacific States Marine Fisheries Commission Yes Technical Contact 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
Pam Kahut Pacific States Marine Fisheries Commission No Administrative Contact pam_kahut@psmfc.org (503) 595-3100
Lenora Oftedahl Columbia River Inter-Tribal Fish Commission (CRITFC) No 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
Amy Roberts Pacific States Marine Fisheries Commission Yes Technical Contact 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
Donald Rose Bonneville Power Administration No Env. Compliance Lead dlrose@bpa.gov (503) 230-3796
Bruce Schmidt Pacific States Marine Fisheries Commission Yes Contract Manager bruce_schmidt@psmfc.org (503) 595-3113
Russell Scranton Bonneville Power Administration Yes COR rwscranton@bpa.gov (503) 230-4412
Jason Sweet Bonneville Power Administration Yes F&W Approver jcsweet@bpa.gov (503) 230-3349
Kristi Van Leuven Bonneville Power Administration Yes Contracting Officer kjvleuven@bpa.gov (503) 230-3605
Greg Wilke Pacific States Marine Fisheries Commission No Technical Contact greg_wilke@psmfc.org (503) 595-3157


Viewing of Work Statement Elements

Deliverable Title WSE Sort Letter, Number, Title Start End Concluded
Site visits to obtain updated data from biologists A: 159. Conduct site visits to obtain updated data from biologists 12/31/2012 09/30/2012
Maintained and updated anadromous fish distribution data B: 159. Develop anadromous fish distribution data 12/31/2012 12/28/2012
Maintenance and update of resident fish distribution data C: 159. Develop resident fish distribution data (top priority for MFWP, lower priority for others) 12/31/2012 12/28/2012
Maintenance and update of fish abundance data D: 159. Develop data for adult abundance in the wild 12/31/2012 12/28/2012
Maintenance and update of anadromous fish return to hatchery data E: 159. Develop hatchery return data 12/31/2012 12/28/2012
Maintenance and update of data on dam and fish passage facilities F: 159. Develop dam and fish passage facility data (mid-priority), update on 3 year cycle 12/31/2012 12/28/2012
Hatchery facilities data maintained G: 159. Develop hatchery facility data (key dataset), update on 3 year cycle 12/31/2012 12/28/2012
Maintain and update hydrography layer for StreamNet data H: 159. Develop hydrography data, including stream, lake and reservoir layers 12/31/2012 12/28/2012
Maintenance and update of fish barrier data I: 159. Develop fish barrier data, update on 3 year cycle 12/31/2012 12/28/2012
Maintenance and update of age data J: 159. Develop fish age data 12/31/2012 12/28/2012
Development of other data sets on an ad hoc basis K: 159. Develop other data sets 12/31/2012 12/28/2012
Maintenance and submission to the library collection L: 159. Document data sources and help build the library collection 12/31/2012 12/28/2012
Maintenance of computer systems M: 160. System Administration 12/31/2012 12/28/2012
Maintenance and development of applications N: 160. Application and interface development 12/31/2012 12/28/2012
Data maintenance and metadata development O: 160. Data (content) management 12/31/2012 12/28/2012
Maintenance and update of Data Exchange Format P: 160. Data exchange standard development 12/31/2012 12/28/2012
Maintenance and operation of StreamNet Internet sites Q: 161. Develop and maintain Internet sites for data dissemination 12/31/2012 12/28/2012
Responses to requests for data and assistance R: 161. Respond to data/information requests 12/31/2012 12/28/2012
Publicize StreamNet data and services through professional and public activities S: 161. Promote availability of StreamNet data and encourage participation in the project 12/31/2012 12/28/2012
Support for FWP related activities T: 189. Support of the NPCC Fish and Wildlife Program 12/31/2012 12/28/2012
Support to data source agencies U: 189. Coordinate with and support data source agencies 12/31/2012 12/28/2012
Coordination outside the FWP V: 189. Coordinate with related activities outside of the FWP 12/31/2012 12/28/2012
Support regional scale status and trend data W: 189. Support regional scale reporting on status and trends for HLI, BiOp, etc. 12/31/2012 12/28/2012
Perform project management X: 119. Manage project activities 12/31/2012 01/28/2012
Annual report submitted to BPA Z: 132. Annual report - 10/10 - 9/11 11/30/2011 12/21/2011

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Primary Focal Species Work Statement Elements
Chinook (Oncorhynchus tshawytscha) - All Populations
  • 10 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Chum (Oncorhynchus keta) - Columbia River ESU (Threatened)
  • 9 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Coho (Oncorhynchus kisutch) - Lower Columbia River ESU (Threatened)
  • 10 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Coho (O. kisutch) - Unspecified Population
  • 8 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Coastal (Oncorhynchus clarkii clarkii) - All Anadromous Populations
  • 9 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Sockeye (Oncorhynchus nerka) - All Populations
  • 8 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (Oncorhynchus mykiss) - All Populations
  • 10 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Lamprey, Pacific (Entosphenus tridentata)
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Lamprey, River (L. ayresi)
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 2 instances of WE 161 Disseminate Raw/Summary Data and Results
Shad, American (Alosa sapidissima)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Sturgeon, Green (Acipenser medirostris)
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (A. transmontanus) - Lower Columbia River
  • 5 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Burbot (Lota lota)
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Coastal (O. clarkii clarkii)- Resident Populations
  • 3 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Lahontan (O. c. henshawi) (Threatened)
  • 3 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Westslope (O. c. lewisi)
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Yellowstone (O. c. bouvieri)
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Freshwater Mussels
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Kokanee (Oncorhynchus nerka)
  • 5 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Lamprey, Western Brook (L. richardsoni)
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 2 instances of WE 161 Disseminate Raw/Summary Data and Results
Pikeminnow, Northern (Ptychocheilus oregonensis) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 2 instances of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (Acipenser transmontanus) - All Populations except Kootenai R. DPS
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (A. transmontanus) - Kootenai River DPS (Endangered)
  • 3 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Trout, Brown (Salmo trutta) [OBSOLETE]
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Brook (Salvelinus fontinalis)
  • 2 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Bull (S. confluentus) (Threatened)
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Trout, Lake (S. namaycush) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
Trout, Rainbow (Oncorhynchus mykiss)
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Trout, Interior Redband (O. mykiss gairdnerii)
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Whitefish, Mountain (Prosopium williamsoni)
  • 4 instances 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 biologists 10/01/2011
B 159 Develop anadromous fish distribution data 10/01/2011
C 159 Develop resident fish distribution data (top priority for MFWP, lower priority for others) 10/01/2011
D 159 Develop data for adult abundance in the wild 10/01/2011
E 159 Develop hatchery return data 10/01/2011
F 159 Develop dam and fish passage facility data (mid-priority), update on 3 year cycle 10/01/2011
G 159 Develop hatchery facility data (key dataset), update on 3 year cycle 10/01/2011
H 159 Develop hydrography data, including stream, lake and reservoir layers 10/01/2011
I 159 Develop fish barrier data, update on 3 year cycle 10/01/2011
J 159 Develop fish age data 10/01/2011
K 159 Develop other data sets 10/01/2011
L 159 Document data sources and help build the library collection 10/01/2011
M 160 System Administration 10/01/2011
N 160 Application and interface development 10/01/2011
O 160 Data (content) management 10/01/2011
P 160 Data exchange standard development 10/01/2011
Q 161 Develop and maintain Internet sites for data dissemination 10/01/2011
R 161 Respond to data/information requests 10/01/2011
S 161 Promote availability of StreamNet data and encourage participation in the project 10/01/2011
T 189 Support of the NPCC Fish and Wildlife Program 10/01/2011
U 189 Coordinate with and support data source agencies 10/01/2011
V 189 Coordinate with related activities outside of the FWP 10/01/2011
W 189 Support regional scale reporting on status and trends for HLI, BiOp, etc. 10/01/2011
X 119 Manage project activities 10/01/2011
Y 185 Periodic Status Reports for BPA 10/01/2011
Z 132 Annual report - 10/10 - 9/11 10/01/2011