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:
76826 REL 20
Contract Title:
1994-049-00 EXP KOOTENAI RIVER RESIDENT FISH ASSESSMENT
Contract Start Date:
7/1/2020
Contract End Date:
5/31/2021
WE ID:
160. Create/Manage/Maintain Database
Work Element Usage Report
Title:
K: 160 - Kootenai River Ecosystem Project Data Base
Description:
This WE describes work to maintain and further develop a web-based database to store the large volume of data generated by the Kootenai Tribe's Ecosystem Project responsible for monitoring water quality and the biological trophic levels within the river at 10+ sites in any given year. Information generated from the KTOI's monitoring program will be organized and sent to the database manager to the web-based database during and after the field season by project staff. The database management (uploading to web and some Quality Control measures) is conducted by Statistical Consulting Services, Inc. based in Clarkston, WA.

Specific work planned for the Relational Database during this contract period includes:

1. Inclusion and uploading of trophic level and water chemistry data; 2. Implement data censoring and sub-setting (if needed); 3. Create enhanced technical documentation as requested for the use of various WEB application programs; 4. Other data entry/WEB application requests (additions/modifications) as agreed upon between SCS & KTOI; and, 5. provide server company a monthly maintenance fee to house KTOI data.

All database activities will be overseen and reviewed by the KTOI project manager and KTOI Fish and Wildlife Department Administrator as needed.
WE Agreement Type:
Contracted
Deliverable Specification:
This WE provides a database to store, disseminate, and provide an inter-relational forum for KTOI personnel and other key contractors and scientist (includes ISRP & ISAB boards) to review, analyze, and interrelate concerning Kootenai River Ecosystem data.

Under this contract, this WE will produce: storage of trophic level and water chemistry data; Implement data censoring and sub-setting; Provision of security measures and options as well as password controlled access for the relational database; create enhanced technical documentation as requested for the use of various WEB application programs; and, provide the server company a monthly maintenance fee to house KTOI data.

Data will be made available to the International Kootenai River Restoration Team (IKERT) for analyses as needed. Some data, i.e. Report of Findings, will be available to the general public to access.
WSE Effective Budget:
$26,800
% of Total WSE Effective Budget:
1.73%
WSE Start:
07/01/2020
WSE End:
05/31/2021
WSE Completion:
05/31/2021
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) $36,022 $26,800

Back To Top

Milestones

3 Milestones
Sort Type Title Start End Status Modified By Modified Date
A Data Entry and Database Maintenance 7/1/2020 5/31/2021 Concluded Virgil Watts III 5/20/2020 7:57:49 PM
Description: Data Entry of all trophic level and water chemistry information, and Database maintenance and housing costs.
B Develop Technical Documentation for KTOI WEB-based program 7/1/2020 5/31/2021 Concluded Virgil Watts III 5/20/2020 7:57:49 PM
Description: Milestone is to create technical documentation for the use of KTOI WEB-based program.
C DELIV Kootenai River Ecosystem database work complete 5/31/2021 Concluded Virgil Watts III 5/28/2020 2:11:01 PM
Description: This WE provides a database to store, disseminate, and provide an inter-relational forum for KTOI personnel and other key contractors and scientist (includes ISRP & ISAB boards) to review, analyze, and interrelate concerning Kootenai River Ecosystem data. Under this contract, this WE will produce: storage of trophic level and water chemistry data; Implement data censoring and sub-setting; Provision of security measures and options as well as password controlled access for the relational database; create enhanced technical documentation as requested for the use of various WEB application programs; and, provide the server company a monthly maintenance fee to house KTOI data. Data will be made available to the International Kootenai River Restoration Team (IKERT) for analyses as needed. Some data, i.e. Report of Findings, will be available to the general public to access.

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
Kootenai Ecosystem Database http://ktoi.scsnetw.com/

Back To Top