Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 66822: 2011-006-00 EXP CHAMP - SITKA TECHNOLOGIES
Project Number:
Title:
Columbia Habitat and Monitoring Program - (CHAMP)
BPA PM:
Stage:
Closed
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
66822
Contract Title:
2011-006-00 EXP CHAMP - SITKA TECHNOLOGIES
Contract Continuation:
Previous: Next:
63166: 2011-006-00 EXP CHAMP - SITKA TECHNOLOGIES
  • 70906: 2011-006-00 EXP CHAMP - SITKA TECHNOLOGIES
Contract Status:
Closed
Contract Description:
This contract purpose is to improve and expand the CHaMP data system that has been developed by Sitka Technology Group during the period 2011 - 2014. In this fifth year of the system, we will continue to support critical core system functions and seek to make these system functions more effective and efficient based on feedback from the field crews, program management, analysts, and researchers.  This contract also provides funding to create an integrated metric database and web application that will serve to combine 20 identical and 2 similar CHaMP and PIBO tributary habitat metrics for which crosswalks have been developed in a common data store and graphically display/share those metrics via a web application.  This work will require Sitka to collaborate with BPA Managers and CHaMP Program Managers via lightweight design techniques and broadsheets to define/clarify suitable approaches for rendering CHaMP program outputs.

This contract also funds the FISMA compliant hosting, online data storage, and ongoing technical management (real-time monitoring, penetration testing, backup, security, etc.) of the champmonitoring.org data system itself, the integrated metrics web application, and the procurement of third party elastic compute services to accommodate the high computational needs of running 2D/3D hydraulic models on roughly 2,000 CHaMP topographic surveys.

Finally, this contract provides a basic amount of funding to repair, replace, and actively manage the inventory of iPad data loggers in use by the CHaMP field crews. These iPads were purchased under the FY14 Sitka Technology Group CHaMP contract (#63166).

This contract has an overlapping performance period with contract #63166 during the month of October 2014. With the exception of activities directly related to work element L, "Construct Integrated Metric Database and Web Application", no work is authorized to be performed under this contract until November 1, 2014.  This restriction overrides and supersedes any language in this SOW that may indicate or infer otherwise.

DATA MANAGEMENT ADVISORY GROUP

This contract requires oversight and advice from the CHaMP Data Management Advisory Group (DMAG). This team is responsible for periodically reviewing and providing feedback on the priorities, requirements, and proposed designs of the CHaMP data management system (includes supporting pre-season, in-season, and post-season activities). We also need their engagement in early testing and beta testing (which may require testing in the field). Sitka has an obligation to provide this team regular opportunities for input and efficient processes for collecting that input on early designs and early software versions. The DMAG then has an obligation to provide feedback in a timely fashion in order to give Sitka ample time to address the feedback and make necessary changes. The latter work elements in this contract include milestones that describe these opportunities for collaboration as well as prescribe timelines.

For 2015, this team is composed of Sarah Walker, Chris Jordan, Carol Volk, Boyd Bouwes, Andy Hill, and Steve Fortney. As need arises, we may call upon and require the input from other members of the broader CHaMP team.

To see the actual system, go to:

http://champmonitoring.org  (Production environment)
http://qa.champmonitoring.org  (QA environment)
Account Type(s):
Expense
Contract Start Date:
10/01/2014
Contract End Date:
10/31/2015
Current Contract Value:
$371,900
Expenditures:
$371,900

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

BPA COR:
Env. Compliance Lead:
Contract Contractor:
Work Order Task(s):
Contract Type:
Contract
Pricing Method:
Time and Materials
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
Rossana Callejas Bonneville Power Administration No Interested Party rxcallejas@bpa.gov (503) 230-7558
Joseph Connor Bonneville Power Administration Yes COR jwconnor@bpa.gov (503) 230-3172
Israel Duran Bonneville Power Administration Yes Env. Compliance Lead induran@bpa.gov (503) 230-3967
Chris Jordan National Oceanic and Atmospheric Administration Yes Supervisor chris.jordan@noaa.gov (541) 754-4629
Pamela Nelle Terraqua, Inc. Yes Technical Contact pamela@terraqua.biz (509) 885-8143
Steve Rentmeester Sitka Technology Group Yes Technical Contact steve@sitkatech.com (503) 808-1225
Keith Steele Sitka Technology Group Yes Contract Manager keith@sitkatech.com (503) 808-1205
Kristi Van Leuven Bonneville Power Administration Yes Contracting Officer kjvleuven@bpa.gov (503) 230-3605
Sarah (Terraqua) Walker Terraqua, Inc. Yes Technical Contact sarah.walker@terraqua.biz (509) 662-4142
Michael Ward Terraqua, Inc. Yes Technical Contact mike@terraqua.biz (509) 486-2426
Benjamin Zelinsky Bonneville Power Administration Yes F&W Approver bdzelinsky@bpa.gov (503) 230-4737


Viewing of Work Statement Elements

Deliverable Title WSE Sort Letter, Number, Title Start End Complete
All administrative tasks fulfilled with timely quality products B: 119. Manage and Administer Project 10/31/2015 11/15/2014
Technical Support and Training Materials C: 160. Technical Support and Training 10/31/2015 10/31/2015
Accurate and timely watershed, site, site visit, measurement, and metric data D: 160. Operational Support 10/31/2015 10/31/2015
Ensure champmonitoring.org remains operational during FY 2015 E: 160. Host and Manage Applications and Elastic Cloud Services 10/31/2015 10/31/2015
Functional and usability improvements to champmonitoring.org F: 160. General and Operational System Improvements 10/31/2015 10/31/2015
Better support for analysis and synthesis of CHaMP data G: 160. Modeling, Analysis, and Synthesis System Improvements 10/31/2015 10/31/2015
Improved software application that runs on field laptops H: 160. Laptop Data Broker Improvements 06/01/2015 06/01/2015
Improved iPad Data Logger Application I: 160. iOS Data Logger Application Improvements 10/31/2015 10/31/2015
Properly managed inventory of data loggers available to field crews when needed J: 160. iOS Data Logger Hardware Maintenance 10/31/2015 10/31/2015
Integrated Metric Database and Web Application K: 160. Construct Integrated CHaMP-PIBO Metric Database and Web Application 12/31/2014 12/31/2014
Submit Data Management Content for CY14 L: 202. BiOp RPA Report for CY 2014 07/01/2015 07/01/2015

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Primary Focal Species Work Statement Elements

Sort WE ID WE Title NEPA NOAA USFWS NHPA Has Provisions Inadvertent Discovery Completed
A 185 Periodic Status Reports for BPA 10/01/2014
B 119 Manage and Administer Project 10/01/2014
C 160 Technical Support and Training 10/01/2014
D 160 Operational Support 10/01/2014
E 160 Host and Manage Applications and Elastic Cloud Services 10/01/2014
F 160 General and Operational System Improvements 10/01/2014
G 160 Modeling, Analysis, and Synthesis System Improvements 10/01/2014
H 160 Laptop Data Broker Improvements 10/01/2014
I 160 iOS Data Logger Application Improvements 10/01/2014
J 160 iOS Data Logger Hardware Maintenance 10/01/2014
K 160 Construct Integrated CHaMP-PIBO Metric Database and Web Application 10/01/2014
L 202 BiOp RPA Report for CY 2014
M 132 Data Management Progress Report for 2014 Lessons Learned Report 10/01/2014