Show new navigation
On
Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 73354 REL 31: 2008-507-00 EXP CRITFC INTER-TRIBAL MONITORING DATA
Project Number:
Title:
CRITFC Inter-Tribal Monitoring Data
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
73354 REL 31
Contract Title:
2008-507-00 EXP CRITFC INTER-TRIBAL MONITORING DATA
Contract Continuation:
Previous: Next:
73354 REL 12: 2008-507-00 EXP CRITFC INTER-TRIBAL MONITORING DATA
  • 73354 REL 47: 2008-507-00 EXP CRITFC INTER-TRIBAL MONITORING DATA
Contract Status:
Closed
Contract Description:
The Inter-Tribal Monitoring Data (ITMD) Project is a Columbia Basin Fish Accords (Accords) project to support data management at the Columbia River Inter-Tribal Fish Commission (CRITFC) and its member tribes, which include the Nez Perce Tribe (NPT), Confederated Tribes and Bands of the Yakama Nation (YN), Confederated Tribes of the Warm Springs Reservation of Oregon (CTWSRO), and the Confederated Tribes of the Umatilla Indian Reservation (CTUIR). The purpose of the ITMD Project is to facilitate decision support for implementation of the Accords, recovery planning under the Endangered Species Act (ESA) and Biological Opinion (BiOp), tribal co-management needs regarding US v. Oregon and the Pacific Salmon Treaty (PST).    The project is focused on, building data sharing and data management capabilities among the tribes.

The primary goal of the ITMD Project is to ensure the availability and efficient and accurate sharing of dat... a among CRITFC and the four CRITFC-member tribes both internally and among state and federal co-managers.  The ITMD Project efforts are intended to help meet tribal resource co-management responsibilities and reporting needs of the Accords and BiOps, while also building capacity within tribes to support informed resource policy management decisions. This has, and continues to be, accomplished through building databases and tools to assist tribal researchers and monitors in the collection, storage, summarization, and dissemination of data in a timely, accurate, and cost-effective fashion. The ITMD Project also serves a coordination function between member tribes and regional co-managers on data management issues and aids in the collection of monitoring datasets for tribal and regional analysts, e.g. Coordinated Assessments.

The long-term strategy of the ITMD Project to address data management and sharing issues at CRITFC and the tribes is based on three objectives:  

1. Identify cost effective data management strategies and architectures and fund the development of pilot projects based on an individual tribal staff and project need.  Pilot systems may include hardware and software tools as well as web applications that help collect, store, summarize, and disseminate fish and habitat data. Pilot projects deemed as “successful” are converted into production systems which are then updated and improved by ITMD staff as resources allow.
2. Provide data management services to the tribes, which includes: a) partial support for tribal data stewards at each of the tribes, b) developing and/or promoting shared data capture, management, and reporting tools for CRITFC and member tribes, c) and offer expertise and coordination of efforts.  
3. Enable tribal participation in regional data management coordination processes, such as the Coordinated Assessments Exchange Network system (CA-XCT or CAX) and the Environmental Protection Agency (EPA) Data Exchange Network (EN), which have regional data sharing nodes.  The ITMD staff attend several regional data management forums, meetings, and processes and report information to the tribes that are unable to attend.
For the tribes and CRITFC, the last 10 years of assistance from the ITMD Project has improved tribal data infrastructure and the capacity to organize, analyze, and share data.  Prior to the Accords, most of the systems at each tribe and CRITFC were organized and stored in individual folders and Excel workbooks, Microsoft Access Databases, or equivalent data storage software.  At the completion of the eleventh year of this project, the ITMD Project is focusing on three main goals:

     a) Establish a pilot centralized data management system with the NPT, CTWSRO, and
         CRITFC, and assist YN with their pilot centralized data management system.
     b) Enable automated upload of relevant data and indicator into regional data repositories, e.g., CAX.
     c) Continue to update the current digital pen technology on which many of our
         production and future pilot data management systems are based. or consider alternative technologies as they appear in the market.
         decision to move to a new technology would be a combination of favorable technical factors and acceptable economics.

The ITMD Project also helps CTUIR promote their centralized data management system (CDMS) created by the GIS Program and their software developers at CTUIR. Three of the four tribes and CRITFC are now ready to adopt this system, or something similar, for data management needs.  The CDMS is a web-based open source software application, developed over the last 10 years to store fisheries Research, Monitoring, and Evaluation (RM&E) and habitat data. The CDMS provides an enterprise solution for secure, centrally located data management to efficiently use data to inform decisions and policies related to tribal natural resource management.  The CDMS also develops capacity for data sharing agreements and allows the tribes the ability to define the quality and quantity of information shared to other state and federal agencies.  CTUIR have created many CDMS modules for datasets collected by tribal biologists, which can be shared and customized to promote standardization of each tribes’ project datasets. See the 2016 Annual Progress Report (posted to BPA under contract 73789) for  more details of expectations and planned work for the tenth year of funding.

Early in the Accord funding cycle, the ITMD Project invested in thirty Anoto digital pens for field data collection and a SharePoint-based pen data management system developed by Adapx, Inc. ITMD staff in partnership with NPT, YN, and CRITFC field crews and project managers successfully developed four data management systems on the Adapx platform. Adapx, Inc went out of business in 2015 shortly after Microsoft announced plans to discontinue support of its Silverlight web browser plug-in, a key component of the Adapx product. In 2016, ITMD invested in Anoto Live Forms: a second-generation digital pen system with a more stable PHP/HTML5 technical foundation. In 2017 and finishing in 2018, project staff converted all the systems developed on the obsolete Adapx platform to the new Anoto Live platform.  In 2018, the CTWSRO joined the digital pen data management system to collect and report data for their screw trap project  (wild Chinook and Coho salmon, steelhead, and Pacific Lamprey are trapped on several streams and rivers in the Warm Springs River Basin).

Please see the document store for this project to see two brief white paper explaining the project's approach to adaptive management and the use of specific metrics to characterize project progress.  The papers are:

    - Project Approach to Adaptive Management
    - Project Approach to Providing Progress Metrics
  
Account Type(s):
Expense
Contract Start Date:
09/15/2019
Contract End Date:
09/14/2020
Current Contract Value:
$425,366
Expenditures:
$425,366

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

Env. Compliance Lead:
None
Work Order Task(s):
Contract Type:
Release
Pricing Method:
Cost Reimbursement (CNF)
300 km
200 mi
Click the map to see this Contract's location details.

No photos have been uploaded yet for this Contract.

Viewing 8 of 8 Work Statement Elements
Sort Order
WSEV ID
WE ID
Work Element Name
Title
Description
WSE Effective Budget
% of Total WSE Effective Budget
WSE Start
WSE End
A194627185Produce CBFish Status ReportPeriodic Status Reports for BPAThe Contractor shall report on the status of milestones and deliverables in Pisces. Reports shall be completed either monthly or quarterly as determined by the BPA COTR. Additionally, when indicating a deliverable milestone as COMPLETE, the contractor shall provide metrics and the final location (latitude and longitude) prior to submitting the report to the BPA COTR.$4,0000.94%01/01/202009/14/2020
B194628119Manage and Administer ProjectsAdminister ContractAll administrative tasks shall be fulfilled on time and with quality products. Timely responses to requests for more information are required. Proactive communication between the contractor and BPA's Contracting Officer (CO) and Contracting Officer Technical Representative (COTR) is required if a significant lag in scheduled delivery is expected.$20,0004.72%09/15/201909/14/2020
C197388122Provide Technical Review and RecommendationPilot the usage of the DM-CMM to measure project progressWe will pilot the use of the Data Management Capability Mature Model to provide metrics characterizing the maturity of the datasets under management in CDMS. This will provide an objective metric on the progress of the project toward the implementation of effective data management. At the end of the year, we will produce a report recommending a usage model for the DM-CMM, including a list of specific metrics. This report will also include analytics on the maturity of CRTIFC's DM process. In the documents store of this project, there is a small white paper describing the DM-CMM (data management capability maturity model). Please review this for more information on the CMM and proposed metrics.$50,00011.81%09/15/201909/14/2020
D194629122Provide Technical Review and RecommendationTest and Evaluate New Technologies to Improve Data ManagementThe fields of computer hardware and software and field data collection are evolving very rapidly at the current time. It is important for the ITMD Project to identify new technologies that can improve accuracy or velocity of research and/or provide economic advantages to CRITFC and the tribes. For these reasons, the ITMD staff will investigate technologies and tools that will help in data management and disseminate the information we find to the tribes and other Accords project leads at CRITFC. Investigations will include: • The structure, advantages, and economics of moving data centers into cloud technologies • The use of integrating R scripts directly in SQL Server • Other tools and technologies as, and if, we identify them during the fiscal year$45,00010.63%09/15/201909/14/2020
E194630132Produce Progress (Annual) ReportProduce (Annual) Progress Report for CY 2019The progress report summarizes the project goals, objectives, hypotheses, completed and uncompleted deliverables, problems encountered, lessons learned, and long-term planning. Examples of long-term planning include future improvements, new directions, or level of effort for contract implementation, including any ramping up or ramping down of contract components or of the whole project. The report will include details of accomplishments for each work element in the contract and will succinctly document contract performance for the public record. Progress reports must conform to BPA guidelines. See the ''formatting guidelines'' link at the Technical Reports and Publications page: https://www.cbfish.org/Help.mvc/GuidanceDocuments.$8,0001.89%09/15/201905/15/2020
F194631160Create/Manage/Maintain DatabaseCreate/Manage/Maintain Tools, Applications, and Databases for Pilot and Production ProjectsContinue updating and developing tools, applications, and databases to build capacity within member tribes and CRITFC to better manage monitoring data from field collection to computer entry (from stream to screen). Updating and developing successful tools and applications for field operations improves the speed, accuracy, and ease of data entry, aggregation, and reporting within the tribal programs and for data sharing with co-managers.$171,30140.47%09/15/201909/14/2020
G194632160Create/Manage/Maintain DatabaseContinued support of the data capture and management system using the Anoto digital pen and other technologies.Over the past several years, the ITMD Project has developed and deployed field data capture systems based on the Anoto digital pen technology. NPT, YN, and WS tribes and CRITFC use these systems to capture, manage, and report on data during the fish and habitat field seasons. These systems will continue to evolve and new applications of the technology will likely occur. Hence, the ITMD Project will continue to support these tools and likely build more applications as needed by projects.$100,02723.63%09/15/201909/14/2020
H194635189Coordination-Columbia BasinwideCoordination-Columbia Basinwide - attend/hold regional and tribal meetings and workshopsThe ITMD Project will host at least one annual Tribal Data Workshop for member tribes after Calendar Year 2019 ends. Provide briefings and summaries to relevant CRITFC and tribal staff about meetings attended with the Pacific Northwest Aquatic Monitoring Partnership (PNAMP), StreamNet, National Oceanic and Atmospheric Administration (NOAA), Bonneville Power Administration (BPA), Northwest Power and Conservation Council (NPCC), and the Tribal Data Workshop; or meetings with staff of other relevant entities related to discussions on regional data management directly associated with CRITFC member tribes’ Fish and Wildlife programs.$25,0005.91%09/15/201909/14/2020
      
$423,328
   

Deliverable Title WSE Sort Letter, Number, Title Start End Concluded
Effective implementation management and timely contract administration B: 119. Administer Contract 09/14/2020 09/14/2020
Create final report C: 122. Pilot the usage of the DM-CMM to measure project progress 09/14/2020 09/14/2020
Deliverables D: 122. Test and Evaluate New Technologies to Improve Data Management 09/14/2020 09/14/2020
Deliverable: Annual Progress Report to BPA for Calendar Year 2018 Jan-Dec E: 132. Produce (Annual) Progress Report for CY 2019 05/15/2020 05/15/2020
Deliverables F: 160. Create/Manage/Maintain Tools, Applications, and Databases for Pilot and Production Projects 09/14/2020 09/14/2020
Deliverables G: 160. Continued support of the data capture and management system using the Anoto digital pen and other technologies. 08/31/2020 08/31/2020
Deliverables H: 189. Coordination-Columbia Basinwide - attend/hold regional and tribal meetings and workshops 09/14/2020 09/14/2020

Viewing of Implementation Metrics
Loading...
Sort Order
WE ID
Work Element Name
Title
Description
Metric ID
Metric
End Fiscal Year
Planned
Actual
Contractor Comments
All Measures
Annual Progress Report Measures
Populations
Viewing of Environmental Metrics Customize
Loading...
WSE ID
WSE Start
WSE End
WE ID
Title
WSE Progress
Study Plan
Protocol
Category
Subcategory
Focus 1
Focus 2
Specific Metric Title

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
B 119 Administer Contract
C 122 Pilot the usage of the DM-CMM to measure project progress
D 122 Test and Evaluate New Technologies to Improve Data Management
E 132 Produce (Annual) Progress Report for CY 2019
F 160 Create/Manage/Maintain Tools, Applications, and Databases for Pilot and Production Projects
G 160 Continued support of the data capture and management system using the Anoto digital pen and other technologies.
H 189 Coordination-Columbia Basinwide - attend/hold regional and tribal meetings and workshops