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:
87583
Contract Title:
2008-307-00 EXP DESCHUTES RIVER SOCKEYE DEVELOPMENT
Contract Start Date:
4/1/2021
Contract End Date:
8/15/2022
WE ID:
160. Create/Manage/Maintain Database
Work Element Usage Report
Title:
D: 160 - Rotary Screw Trap Database.
Description:
Develop databases for 2009 - 2019 Suttle Lake and Lake Creek O. nerka smolt studies as follows: 1) rotary screw trap O. nerka smolt migration abundance and timing, other fish species captured, tagging (PIT and radio-telemetry), fish handling survival; 2) PIT tag antenna array tagged fish detections, antenna operating periods, performance and testing for multiple sites; 3) radio-telemetry tagged fish detections for multiple fixed station sites and mobile tracking; 4) Lake Creek water temperature data at rotary screw trap. Data will be stored in a CTWSRO database.
WE Agreement Type:
Contracted
Deliverable Specification:
The working database will consist of an excel spreadsheet and be the local primary database maintained on desktop computer of the project biologist. The database will be backed up by cloud storage service and on organizational computer servers.
WSE Effective Budget:
$22,000
% of Total WSE Effective Budget:
14.91%
WSE Start:
04/01/2021
WSE End:
08/15/2022
WSE Completion:
WSE Progress:
Other
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)
1. 87583 (04/01/2021 - 08/15/2022) $22,000 $22,000
2. Amendment 001 (04/01/2021 - 06/30/2022) $22,000 $22,000
Work Element Budget (Current Performance Period) $22,000 $22,000

Back To Top

Milestones

2 Milestones
Sort Type Title Start End Status Modified By Modified Date
A Lake Creek (Suttle Lake outlet stream) Rotary Screw Trap database. 4/1/2021 8/15/2022 Active Joshua Ashline 6/3/2022 7:06:11 AM
Description: From 2009 - 2019, a rotary screw trap was deployed and operated during springtime Suttle Lake O. nerka smolt migration to determine abundance and timing of migration. The eleven year trapping period of time will have 40,000 - 50,000 records with fields including: record number, trap name, day, week, year, date, trapping hours per day, count, species, year class, fork length (mm), total length (mm), weight (g), recapture, mark present, mark given, tag type (PIT, radio telemetry) tag code, release location, comments, mortality, mortality type, genetic tissue sample, tagged fish release date, comments, utilized for 24 hour handling survival test, and survival test result. Currently this database exists in the spreadsheet form and is maintained on a project biologists desktop. The work will focus on data QA/QC, refinement of fields to eliminate redundancy as well as metadata input.
B DELIV Database in working order. 8/15/2022 Active Joshua Ashline 6/3/2022 7:06:11 AM
Description: The working database will consist of an excel spreadsheet and be the local primary database maintained on desktop computer of the project biologist. The database will be backed up by cloud storage service and on organizational computer servers.

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
Confederated Tribes of Warm Springs Reservation of Oregon Data Repository http://gisctws.maps.arcgis.com/home/index.html

Back To Top