Show new navigation
On
  • Help
    • Help
    • How Do I?
    • Why Do I?
    • Help Center
    • Data dictionary
    • EF&W Program documents
    • Request support
    • Send feedback
      • View all help topics
Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
  • Mitigation work
    Mitigation work View all mitigation work topics
  • Reporting
    Reporting View all reporting topics
  • Funding
    Funding View all funding topics
  • Search
Back to SOW

This page provides details of the selected work element.

Work Element Summary PDF
Select a work element:

Contract Number:
89673
Contract Title:
2007-397-00 EXP JOHN DAY TRIB/PASS & FLOW
Contract Start Date:
2/1/2022
Contract End Date:
1/31/2023
WE ID:
160. Create/Manage/Maintain Database
Work Element Usage Report
Title:
AE: 160 - Project and Fisheries Data Management
Description:
This work element covers data management for both project and fisheries/habitat information. A project tracker was developed in 2017 and is currently used to store all project data and information. This is application hosts both a public and CTWS interface. Information can be queried and projects, photos, metrics, permits, reports are all accessible. It is an invaluable tool in project management, with multiple projects occurring each year. Projects site visits occur at 1, 3, 5, and 10 year intervals to evaluate effectiveness and ensure that habitat and passage are still functioning. This WE will cover annual application hosting and maintenance. The Tribes intent is to provide hosting and maintenance of the Project Tracker in the future.

Overall data structure and management of fisheries and habitat data is under development. For 2021 it is expected that CTWS will develop efficient strategies for data management, which meet the fishery and natural resources needs. This will provide data steward duties that include the coordination, management, standardization, and improved access of information for decision makers within CTWS. This phase will seek to incorporate information technology as an integral part of decision-making and will further be able to facilitate the understanding of integrated data management and coordinate the development of appropriate data strategies for projects proposed within the CTWS. A cohesive data management strategy will guide the development of data systems and tools for fishery and related natural resource programs; create and maintain spatially and non-spatially based relational databases and related tools; create of customized decision support systems to query information, summarize data and automate reporting. This WE will cover contracted services to develop and implement this data structure.
WE Agreement Type:
Contracted
Deliverable Specification:
Produce Fisheries data management plan and maintain Project Tracker
WSE Effective Budget:
$74,111
% of Total WSE Effective Budget:
3.75%
WSE Start:
02/01/2022
WSE End:
01/31/2023
WSE Completion:
12/31/2022
WSE Progress:
Concluded
WSE ID Continued From:
n/a
WSE ID Continued To:
n/a
Finite or Recurring:
Recurring

Back To Top

Budget History

SOWRevision Planned Updated Contractor Comments (optional) BPA Comments (optional)
Work Element Budget (Current Performance Period) $74,111 $74,111
$74,111 $74,111

Back To Top

Milestones

4 Milestones
Sort Type Title Start End Status Modified By Modified Date
A Develop Fisheries data management structure 2/1/2022 1/31/2023 Concluded Joshua Ashline 12/1/2021 6:15:18 AM
Description: CTWS will work to develop Fisheries data management structure
B Contract with Tetra Tech for Project Tracker hosting 2/1/2022 1/31/2023 Concluded Joshua Ashline 12/1/2021 6:15:18 AM
Description: Contract with Tetra Tech for Project Tracker hosting for 2022. Work towards transition to CTWS hosting Project Tracker in future years.
C Enter 2021 project info into project tracker 2/1/2022 6/30/2022 Concluded Joshua Ashline 12/1/2021 6:15:18 AM
Description: CTWS will enter 2021 project info into project tracker
D DELIV Produce Fisheries data management plan and maintain project tracker 1/31/2023 Concluded Joshua Ashline 12/1/2021 6:15:18 AM
Description: Produce Fisheries data management plan and maintain Project Tracker

Back To Top

Metrics

Implementation Metrics
None

Back To Top

Location

None
Back To Top

Focal Species

This work element does not require Focal Species
Back To Top

Environmental Compliance

This work element does not require Environmental Compliance
Back To Top

RM&E Metadata

Data Repositories:
Title Link
CRITFC Cloud Secure Tribal Repository (CCSTR) http://www.critfc.org/

Back To Top