Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 60412: 1988-108-04 EXP STREAMNET (CIS-NED) FY13
Project Number:
Title:
StreamNet
BPA PM:
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
60412
Contract Title:
1988-108-04 EXP STREAMNET (CIS-NED) FY13
Contract Continuation:
Previous: Next:
54765: 1988-108-04 EXP STREAMNET (CIS-NED) FY12
  • 63021: 1988-108-04 EXP STREAMNET
Contract Status:
Closed
Contract Description:
1988-108-04 EXP STREAMNET (CIS-NED) FY13

StreamNet is a cooperative, regional scale data compilation and dissemination project that acquires fish related data from the management agencies, standardizes and georeferences them to the hydrography (stream network), and makes them widely available through online data query systems.  This contract covers a 9 month period, which  resulted from a a one time extension to the FY-12 contract to continue FY-12 activities while new plans were developed for FY-13.  This SOW is the result of that planning and covers the contract period from Jan. 1, 2013 through Sept. 30, 2013.

The StreamNet project is undergoing significant changes in response to new regional data priorities.  For FY-2013, data development work on the traditional data types has been deferred until new data priorities are addressed.  The specific new priorities are:

1.  Inventory of fish related data in projects funded by BPA to identify where the resulting data are currently being stored, assess the safety and security of the data in those locations, recommend suitable safe and secure storage locations if the present locations are not adequate, assist project sponsors upload unsecure data sets to the StreamNet Data Store or other appropriate accessible location, and, if the data are of a traditional StreamNet data type but are not yet included in StreamNet determine how to include them in the future.
2.  Initiate flow of data for Coordinated Assessments by obtaining estimates of the four VSP related indicators and supporting metrics from the participating state fisheries agencies (starting with priority populations), organize those data in a database conforming to the CA Data Exchange Standard (DES), publish the data as web services, and establish a process to directly feed these data to the NOAA Fisheries SPS database.  StreamNet will also coordinate with tribal efforts to compile these data and include them in the Coordinated Assessments database as they are made available.
3.  Develop a DES for juvenile abundance estimates and include this data type as part of the traditional data types in StreamNet.
4.  Explore the potential to add fish population productivity estimates to the traditional StreamNet data types.
5.  Develop a Data Sharing Agreement template to facilitate data sharing through StreamNet and other regional scale databases.
6.  Expand use of web services to utilize information from various regional databases such as Taurus, mm.org, monitoringresources.org, etc. to facilitate development of metadata and query capabilities for data in StreamNet, with a goal of increasing efficiency by eliminating the need for data sources to enter the same information more than once.  Explore the use of the common log in capabilities of those regional database.
7.  Assist completion of the Population Crosswalk took being developed by CRITFC.
8.  Prepare to receive and maintain data from the Northwest Habitat Institute as directed by the Northwest Power and Conservation Council.

Any work to update the traditional StreamNet data types will be attempted only when work to address the new priorities has been completed.  Few updates are expected this year due to the new workload.

Ongoing work to support the project will include maintenance of the databases and computer infrastructure needed to manage and disseminate the data, regional coordination to integrate StreamNet efforts with other regional efforts to maximize efficiency of data flow and support regional approaches to data management and sharing, and administration of the project.

Details of the specific tasks to be performed in FY-2013 are presented in this Statement of Work.
Account Type(s):
Expense
Contract Start Date:
01/01/2013
Contract End Date:
09/30/2013
Current Contract Value:
$1,400,436
Expenditures:
$1,400,436

* 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
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
John Arterburn Colville Confederated Tribes Yes Administrative Contact john.arterburn@colvilletribes.com (509) 422-7424
Mike Banach Pacific States Marine Fisheries Commission Yes Technical Contact mike_banach@psmfc.org (503) 595-3152
Evan Brown Idaho Department of Fish and Game (IDFG) No Technical Contact evan.brown@idfg.idaho.gov (208) 287-2769
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
Randy Fisher Pacific States Marine Fisheries Commission No Supervisor randy.fisher@psmfc.org (503) 595-3100
Pam Kahut Pacific States Marine Fisheries Commission No Administrative Contact pam_kahut@psmfc.org (503) 595-3100
Bryan Mercier Bonneville Power Administration No Interested Party bkmercier@bpa.gov (503) 230-3991
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
Phillip Roger Columbia River Inter-Tribal Fish Commission (CRITFC) No Technical Contact rogp@critfc.org (503) 731-1301
Donald Rose Bonneville Power Administration Yes 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
Inventory data from BPA funded projects B: 159. BPA Data Capture - Inventory data and secure storage 09/30/2013 09/30/2013
Create database for inventory of BPA funded projects C: 160. BPA Data Capture - Create and manage database for BPA project data inventory 09/30/2013 09/30/2013
Appropriate access provided to BPA funded data sets D: 161. BPA Data Capture - Provide access to data sets 09/30/2013 09/30/2013
Inventory of data sets coordinated among BPA project sponsors E: 189. BPA Data Capture - coordination of inventory of BPA funded data sets 09/30/2013 09/30/2013
Compilation of indicators and metrics for Coordinated Assessments F: 159. Coordinated Assessments - compilation of CA indicators and metrics 09/30/2013 09/30/2013
Create database for Coordinated Assessments G: 160. Coordinated Assessments - Development of CA database to contain and manage indicators and metrics 09/30/2013 09/30/2013
Dissemination of Coordinated Assessments data H: 161. Coordinated Assessments - Design and implement sharing of CA indicators and metrics 09/30/2013 09/30/2013
Coordination of the CA project I: 189. Coordinated Assessments - participate in CA project management 09/30/2013 09/30/2013
Complete Population Crosswalk tool J: 189. Population Crosswalk - coordination with CRITFC to compete 09/30/2013 09/30/2013
Develop DES for Juvenile Abundance K: 160. Juvenile Abundance - create and manage a Data Exchange Standard 09/30/2013 09/30/2013
Initiation of data capture for Juvenile Fish Abundance L: 159. Juvenile abundance - develop data 09/30/2013 09/30/2013
Database management for Juvenile Abundance M: 160. Juvenile abundance - database management 09/30/2013 09/30/2013
Link facilities data to Taurus N: 159. Improve facilities data by exploring links with Taurus 09/30/2013 09/30/2013
Data Sharing Agreement language provided to BPA O: 161. Develop a Data Sharing Agreement template 09/30/2013 09/30/2013
Maintain and update hydrography layer for StreamNet data P: 159. Maintain hydrography data, including stream, lake and reservoir layers 09/30/2013 09/30/2013
Development of other data sets on an ad hoc basis Q: 159. Develop other data sets 09/30/2013 09/30/2013
Standard data sets are updated if time allows R: 159. Update standard StreamNet data types - low emphasis this year 09/30/2013 09/30/2013
Maintenance and submission to the library collection S: 159. Document data sources and help build the library collection 09/30/2013 09/30/2013
Maintenance of computer systems T: 160. System Administration 09/30/2013 09/30/2013
Maintenance and development of applications U: 160. Application and interface development 09/30/2013 09/30/2013
Data maintenance and metadata development V: 160. Data (content) management 09/30/2013 09/30/2013
Maintenance and update of Data Exchange Format W: 160. Data exchange standard development 09/30/2013 09/30/2013
Maintenance and operation of StreamNet Internet sites X: 161. Develop and maintain Internet sites for data dissemination 09/30/2013 09/30/2013
Responses to requests for data and assistance Y: 161. Respond to data/information requests 09/30/2013 09/30/2013
Publicize StreamNet data and services through professional and public activities Z: 161. Promote availability of StreamNet data and encourage participation in the project 09/30/2013 09/30/2013
Support for FWP related activities AA: 189. Support of the NPCC Fish and Wildlife Program 09/30/2013 09/30/2013
Support to data source agencies AB: 189. Coordinate with and support data source agencies 09/30/2013 09/30/2013
Coordination outside the FWP AC: 189. Coordinate with related activities outside of the FWP 09/30/2013 09/30/2013
Perform project management AD: 119. Manage project activities 09/30/2013 09/30/2013
Annual report submitted to BPA AE: 132. Annual report - 01/12 - 12/12 08/30/2013 09/30/2013

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Primary Focal Species Work Statement Elements
Chinook (Oncorhynchus tshawytscha) - All Populations
  • 7 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Deschutes River Summer/Fall ESU
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Lower Columbia River ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Mid-Columbia River Spring ESU
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Snake River Fall ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Snake River Spring/Summer ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Upper Columbia River Spring ESU (Endangered)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Upper Columbia River Summer/Fall ESU
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chinook (O. tshawytscha) - Upper Willamette River ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance 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
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Coho (Oncorhynchus kisutch) - Lower Columbia River ESU (Threatened)
  • 7 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Coho (O. kisutch) - Unspecified Population
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Coastal (Oncorhynchus clarkii clarkii) - All Anadromous Populations
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Sockeye (Oncorhynchus nerka) - All Populations
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (Oncorhynchus mykiss) - All Populations
  • 7 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (O. mykiss) - Lower Columbia River DPS (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (O. mykiss) - Middle Columbia River DPS (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (O. mykiss) - Snake River DPS (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (O. mykiss) - Upper Columbia River DPS (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (O. mykiss) - Upper Willamette River DPS (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Lamprey, Pacific (Entosphenus tridentata)
  • 4 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 4 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)
  • 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) - Lower Columbia River
  • 2 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)
  • 2 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)
  • 4 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)
  • 3 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)
  • 3 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)
  • 2 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]
  • 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)
  • 6 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 5 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)
  • 5 instances of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 4 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
  • 5 instances of WE 161 Disseminate Raw/Summary Data and Results
Whitefish, Mountain (Prosopium williamsoni)
  • 2 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 185 Periodic Status Reports for BPA 10/01/2012
B 159 BPA Data Capture - Inventory data and secure storage 10/01/2012
C 160 BPA Data Capture - Create and manage database for BPA project data inventory 01/01/2013
D 161 BPA Data Capture - Provide access to data sets 01/01/2013
E 189 BPA Data Capture - coordination of inventory of BPA funded data sets 01/01/2013
F 159 Coordinated Assessments - compilation of CA indicators and metrics 01/01/2013
G 160 Coordinated Assessments - Development of CA database to contain and manage indicators and metrics 01/01/2013
H 161 Coordinated Assessments - Design and implement sharing of CA indicators and metrics 01/01/2013
I 189 Coordinated Assessments - participate in CA project management 01/01/2013
J 189 Population Crosswalk - coordination with CRITFC to compete 01/01/2013
K 160 Juvenile Abundance - create and manage a Data Exchange Standard 01/01/2013
L 159 Juvenile abundance - develop data 01/01/2013
M 160 Juvenile abundance - database management 01/01/2013
N 159 Improve facilities data by exploring links with Taurus 01/01/2013
O 161 Develop a Data Sharing Agreement template 01/01/2013
P 159 Maintain hydrography data, including stream, lake and reservoir layers 10/01/2012
Q 159 Develop other data sets 10/01/2012
R 159 Update standard StreamNet data types - low emphasis this year 01/01/2013
S 159 Document data sources and help build the library collection 10/01/2012
T 160 System Administration 10/01/2012
U 160 Application and interface development 10/01/2012
V 160 Data (content) management 10/01/2012
W 160 Data exchange standard development 10/01/2012
X 161 Develop and maintain Internet sites for data dissemination 10/01/2012
Y 161 Respond to data/information requests 10/01/2012
Z 161 Promote availability of StreamNet data and encourage participation in the project 10/01/2012
AA 189 Support of the NPCC Fish and Wildlife Program 10/01/2012
AB 189 Coordinate with and support data source agencies 10/01/2012
AC 189 Coordinate with related activities outside of the FWP 10/01/2012
AD 119 Manage project activities 10/01/2012
AE 132 Annual report - 01/12 - 12/12 10/01/2012