Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 55738: 2011-006-00 EXP CHAMP / SITKA TECHNOLOGIES - DATA MANGT
Project Number:
Title:
Columbia Habitat and Monitoring Program - (CHAMP)
BPA PM:
Stage:
Closed
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
55738
Contract Title:
2011-006-00 EXP CHAMP / SITKA TECHNOLOGIES - DATA MANGT
Contract Continuation:
Previous: Next:
52672: 2011-006-00 EXP CHAMP - ENVIR DATA SERVICES
  • 59398: 2011-006-00 EXP CHAMP / SITKA TECHNOLOGIES
Contract Status:
Closed
Contract Description:
******  Aug 2012 amendment (CCR-27904): This amendment expands the SOW for:
         - WE J. Expanded Operational Support ($12,000)
         - WE K. Expanded Technical Support and Training ($8,500)
         - WE L. Expanded System Improvements ($9,500)
The budget is increased by $30,000 to accommodate the expanded SOW. The purpose of the amendment is to increase the capacity of the data system and to support generation of 2012 site-level metrics.

******  April 2012 amendment (CCR-26887): This amendment expands the SOW for WE G. System Improvements and WE I. Handheld Data Logger Improvements. The budget is increased by $50,500 to accommodate the expanded SOW. The purpose of the amendment is to add new functionality to the CHaMPMonitoring.org website that will result in improved program and watershed-level management, update metric creation procedures to support the analytical framework, expand the data quality assurance workflow, support uploading of additional measurement data, and support acquisition of GIS data layers.

******  March 2012 amendment (CCR-26495): This amendment does not involve changes or additions to any work elements. The purpose of the amendment is only to reformat to the line item budget and include the budget category for "Office Services".


This contract is a continuation of work started by Steve Rentmeester of Environmental Data Services to design, build, implement, deploy, and support a data management system to support the Columbia Basin Habitat Monitoring Program (CHaMP). In its first year (calendar year 2011), Steve subcontracted with Sitka Technology Group, to do the majority of the work on the contract (52672). Starting in calendar year 2012 (period covered by this contract), this work will be serviced by Sitka Technology Group directly.  NOTE:  There is no property under the EDS's contract 52672 and therefore, there is no property inventory associated with this SOW.

In this second year of the system, we will continue to support the same functions, however some of these functions we will enhance based on feedback from the first year of implementing CHaMP. We will also add support for a few new functions - for details, see this contract's work elements.

This contract also covers the hosting and management (real-time monitoring, backup, security, etc.) of the champmonitoring.org system.


DATA MANAGEMENT ADVISORY GROUP
This contract requires oversight/insight from the CHaMP Data Management Advisory team. This team is responsible for 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, beta testing (which may require testing in the field). To be clear, 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. This Advisory Group 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 2012, this team is comprised of: Mike Ward, Chris Jordan, Carol Volk, Boyd Bouwes, Andy Hill, and Rueben Miller.  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:
01/01/2012
Contract End Date:
10/31/2012
Current Contract Value:
$326,900
Expenditures:
$326,900

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

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
David Byrnes Bonneville Power Administration Yes COR dmbyrnes@bpa.gov (503) 230-3171
Matt Deniston Environmental Science Associates Yes Contract Manager matt@sitkatech.com (503) 808-1220
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
Paul Krueger Bonneville Power Administration Yes F&W Approver pqkrueger@bpa.gov (503) 230-5723
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
Nicole Rutherford Bonneville Power Administration No Interested Party narutherford@bpa.gov (503) 230-4320
Keith Steele Sitka Technology Group Yes Technical Contact keith@sitkatech.com (503) 808-1205
Kristi Van Leuven Bonneville Power Administration Yes Contracting Officer kjvleuven@bpa.gov (503) 230-3605
Michael Ward Terraqua, Inc. Yes Technical Contact mike@terraqua.biz (509) 486-2426


Viewing of Work Statement Elements

Deliverable Title WSE Sort Letter, Number, Title Start End Complete
Funding Package - Submit draft to COTR B: 119. Manage and Administer Project 10/14/2012 10/14/2012
Attach Progress Report in Pisces C: 132. Submit Progress Report for the period Jan-Dec 2012 10/31/2012 10/31/2012
Ensure champmonitoring.org remains operational during 2012 D: 160. Manage and Host champmonitoring.org 10/31/2012 10/31/2012
Accurate watershed, site, site visit, measurement, and metric data E: 160. Operational Support 08/26/2012 08/26/2012
Technical Support and Training Materials F: 160. Technical Support and Training 08/26/2012 08/26/2012
Functional improvements to champmonitoring.org G: 160. System Improvements 08/26/2012 08/26/2012
Software application that runs on field laptops H: 160. Laptop Data Broker 05/31/2012 06/30/2012
Updated Handheld Data Logger application I: 160. Handheld Data Logger Improvements 06/30/2012 06/21/2012
Accurate watershed, site, site visit, measurement, and metric data J: 160. Expanded Operational Support (relative to WE E) 10/31/2012 10/31/2012
Technical Support and Training Materials K: 160. Expanded Technical Support and Training (relative to WE F) 10/31/2012 10/31/2012
Functional improvements to champmonitoring.org L: 160. Expanded System Improvements (relative to WE G) 10/31/2012 10/31/2012

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 01/01/2012
B 119 Manage and Administer Project 01/01/2012
C 132 Submit Progress Report for the period Jan-Dec 2012 01/01/2012
D 160 Manage and Host champmonitoring.org 01/01/2012
E 160 Operational Support 01/01/2012
F 160 Technical Support and Training 01/01/2012
G 160 System Improvements 01/01/2012
H 160 Laptop Data Broker 01/01/2012
I 160 Handheld Data Logger Improvements 01/01/2012
J 160 Expanded Operational Support (relative to WE E) 01/01/2012
K 160 Expanded Technical Support and Training (relative to WE F) 01/01/2012
L 160 Expanded System Improvements (relative to WE G) 01/01/2012