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

The StreamNet Project, a cooperative data compilation and data management project under the FWP focused on fish and fish related data, provides regionally standardized, georeferenced fish related data and data related services.  Emphasis of the project in FY-11 in addition to routine data acquisition, standardization, georeferencing and update is to support regional scale reporting (e.g., SOTR, HLI, etc.), promote and support development of data management systems in the data source agencies to improve data flow and efficiency, and to assist the basin-wide Coordinated Assessments.  Primary data emphasis is on focal species as identified through subbasin planning.  

StreamNet is continuing its participation in regional scale collaborative efforts, including PNAMP and CBFWA's Status of the Resource report (SOTR).  A primary focus will be supporting the Cooperative Assessment of defined salmon and steelhead populations which is currently being planned.  Initial scoping work is being initiated in FY-10, and the FY-11 work statement includes significant support work to locate, describe and acquire derived Indicators for Viable Salmonid Populations (VSP).  This work will be dependent on more detailed instructions that are currently in development and on additional funding or major revision of existing tasks.

Key components of planned emphasis in fiscal year 2011 include the following:

•  Emphasis on data to feed regional scale reporting at a high level.  High priority will be on the raw or field level data that are needed to provide high level assessments of population trends (abundance and productivity) to regional scale reporting mechanisms, focusing initially on CBFWA’s SOTR.  We anticipate that these same data will also be needed to calculate abundance and productivity metrics under other High Level Indicator efforts.  Emphasis in FY-11 will be on data for the abundance and distribution of focal species (as identified in the Subbasin Plans) in the SOTR.

•  Establishing automated data flow from the StreamNet database to regional scale reporting through the SOTR.  We will maintain the XML data feeds for SOTR and will work to assist CBFWA with additional data types, as possible.

•  Emphasis on automating data flow to improve speed of data delivery from the source agencies to the regionally standardized database at StreamNet.  Speed of updating time series of data was identified as a significant issue at the 2006 Data Workshop and the CBFWA Data Management Framework Subcommittee.  Following a successful test, we will download data from the new Idaho Fish and Wildlife Information System databases in Idaho Fish and Game directly to StreamNet and will continue to provide programming support for further development of the system.  This improves data delivery speed and also automates translation into the regional data format.  Similar efforts will be pursued with other data source agencies, based on their priorities and capabilities, to assist them as they move toward implementing additional information technology, including the JMX juvenile abundance database effort in WDFW and the abundance reporting database in ODFW.  The systems development envisioned would also be required in any regional move toward development of distributed database systems approaches for regional data sharing.

•  Emphasis on data systems and data delivery that support the Basin-wide Cooperative Assessments under recovery planning and the BiOp.  StreamNet partners will work within their agencies, CBFWA, PNAMP and recovery planners to determine BiOp data needs and develop approaches for providing needed data.

•  Refine our strategy to compensate for lost staffing.  The recent COLA is insufficient to offset the many years of level funding that unfortunately led to reduction of data technician staff, particularly in 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 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 speed of data compilation.  As currently budgeted in FY-11, data compilation in Washington will be limited to the lower Columbia subbasins, and in Oregon all subbasins may not be included in data capture.

•  Attempt to acquire data from tribal programs.  Much of the focus on tribal data has shifted to CRITFC under the Accords, but StreamNet partners are increasing contacts with non-CRITFC tribes to assist with data system development and data flow.

The StreamNet statement of work is organized around seven Work Elements, with multiple individual WE Titles:

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, 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 PNW 1:100,000 routed hydrography (stream layer), a new interim mixed scale hydrography, 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), HSRG, NPCC, ISEMP, subbasin planners, recovery planners, data source agencies, etc.  The purpose of coordination is to facilitate flow of data, provide data management expertise, and avoid duplication of efforts.  A primary emphasis in FY-11 will be to support the Region-wide Cooperative Assessments of populations of salmon and steelhead.

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 (WA, OR, ID and MT) 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.  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/2010
Contract End Date:
09/30/2011
Current Contract Value:
$2,179,929
Expenditures:
$2,179,929

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

BPA COR:
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 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
Anne Creason Bonneville Power Administration Yes COR amcreason@bpa.gov (503) 230-3859
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
Rosemary Mazaika Bonneville Power Administration Yes F&W Approver rxmazaika@bpa.gov (503) 230-5869
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
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
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
Conduct site visits to obtain updated data from biologists A: 159. Conduct site visits to obtain updated data from biologist 09/30/2011 06/30/2011
Anadromous fish distribution data maintained and updated as needed B: 159. Develop anadromous fish distribution data 09/30/2011 09/30/2011
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/2011 09/30/2011
Fish abundance data are maintained and updated D: 159. Develop data for adult abundance in the wild 09/30/2011 09/30/2011
Data on return of anadromous fish to the hatcheries are maintained and updated E: 159. Develop hatchery return data 09/30/2011 09/30/2011
Data on dam and fish passage facilities are maintained and updated. F: 159. Develop dam and fish passage facility data (mid-priority), update on 3 year cycle 09/30/2011 09/30/2011
Hatchery facilities data maintained G: 159. Develop hatchery facility data (key dataset), update on 3 year cycle 09/30/2011 09/30/2011
The 100K hydrography is archived, emphasis is shifted to the mixed scale hydrography. H: 159. Develop hydrography data, including stream, lake and reservoir layers 09/30/2011 09/30/2011
Fish barrier data are maintained I: 159. Develop fish barrier data, update on 3 year cycle 09/30/2011 09/30/2011
Age data are available on the StreamNet query system J: 159. Develop fish age data 09/30/2011 09/30/2011
Other data are developed on an ad hoc basis, as possible K: 159. Develop other data sets 09/30/2011 09/30/2011
Library collection maintained and increased L: 159. Document data sources and help build the library collection 09/30/2011 09/30/2011
Availability of three key VSP Indicators is described; easily available indicators are provided M: 159. Obtain key salmon and steelhead VSP Indicators to support the Basin-wide Coordinated Assessments 09/30/2011 09/30/2011
Computer systems are maintained N: 160. System Administration 09/30/2011 09/30/2011
Applications are developed and maintained. O: 160. Application and interface development 09/30/2011 09/30/2011
Data are maintained and updated, metadata are developed, and data timeline is posted. P: 160. Data (content) management 09/30/2011 09/30/2011
The Data Exchange Format is maintained and used for data transfer Q: 160. Data exchange standard development 09/30/2011 09/30/2011
StreamNet Internet sites are maintained and functional R: 161. Develop and maintain Internet sites for data dissemination 09/30/2011 09/30/2011
Responses to requests are provided rapidly and tracked S: 161. Respond to data/information requests 09/30/2011 09/30/2011
StreamNet data and services are made more widely known T: 161. Promote availability of StreamNet data and encourage participation in the project 09/30/2011 09/30/2011
Data related support is provided to FWP related activities U: 189. Support regional efforts under the Fish and Wildlife Program 09/30/2011 09/30/2011
Support provided to data source agencies V: 189. Coordinate with and support data source agencies 09/30/2011 09/30/2011
Coordination outside the FWP is accomplished as needed W: 189. Coordinate with related activities outside of the FWP 09/30/2011 09/30/2011
Regional scale status and trend data are supported X: 189. Support regional scale reporting on status and trends for HLI, BiOp, etc. 09/30/2011 09/30/2011
Project management accomplished Y: 119. Manage project activities 09/30/2011 09/30/2011
Annual report submitted to BPA Z: 132. Annual report 11/30/2010 11/30/2010

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Primary Focal Species Work Statement Elements
Chinook (Oncorhynchus tshawytscha) - All Populations
  • 11 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 2 instances of WE 161 Disseminate Raw/Summary Data and Results
Chum (Oncorhynchus keta) - Columbia River ESU (Threatened)
  • 6 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
  • 11 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
  • 5 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
  • 10 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
  • 11 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 3 instances of WE 161 Disseminate Raw/Summary Data and Results
Lamprey, Pacific (Entosphenus tridentata)
  • 3 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, Green (Acipenser medirostris)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (A. transmontanus) - Lower Columbia River
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 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
Cutthroat Trout, Lahontan (O. c. henshawi) (Threatened)
  • 3 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
Cutthroat Trout, Westslope (O. c. lewisi)
  • 5 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)
  • 5 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 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
Sturgeon, White (Acipenser transmontanus) - All Populations except Kootenai R. DPS
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (A. transmontanus) - Kootenai River DPS (Endangered)
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance 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)
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 2 instances of WE 161 Disseminate Raw/Summary Data and Results
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
Whitefish, Mountain (Prosopium williamsoni)
  • 3 instances of WE 159 Transfer/Consolidate Regionally Standardized Data

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 10/01/2010
B 159 Develop anadromous fish distribution data 10/01/2010
C 159 Develop resident fish distribution data (top priority for MFWP, lower priority for others) 10/01/2010
D 159 Develop data for adult abundance in the wild 10/01/2010
E 159 Develop hatchery return data 10/01/2010
F 159 Develop dam and fish passage facility data (mid-priority), update on 3 year cycle 10/01/2010
G 159 Develop hatchery facility data (key dataset), update on 3 year cycle 10/01/2010
H 159 Develop hydrography data, including stream, lake and reservoir layers 10/01/2010
I 159 Develop fish barrier data, update on 3 year cycle 10/01/2010
J 159 Develop fish age data 10/01/2010
K 159 Develop other data sets 10/01/2010
L 159 Document data sources and help build the library collection 10/01/2010
M 159 Obtain key salmon and steelhead VSP Indicators to support the Basin-wide Coordinated Assessments 10/01/2010
N 160 System Administration 10/01/2010
O 160 Application and interface development 10/01/2010
P 160 Data (content) management 10/01/2010
Q 160 Data exchange standard development 10/01/2010
R 161 Develop and maintain Internet sites for data dissemination 10/01/2010
S 161 Respond to data/information requests 10/01/2010
T 161 Promote availability of StreamNet data and encourage participation in the project 10/01/2010
U 189 Support regional efforts under the Fish and Wildlife Program 10/01/2010
V 189 Coordinate with and support data source agencies 10/01/2010
W 189 Coordinate with related activities outside of the FWP 10/01/2010
X 189 Support regional scale reporting on status and trends for HLI, BiOp, etc. 10/01/2010
Y 119 Manage project activities 10/01/2010
Z 132 Annual report 10/01/2010
AA 185 Periodic Status Reports for BPA 10/01/2010