Metadata

Title

Species Tagging, Research and Monitoring System: A Centralized Database for the Upper Colorado and San Juan River Endangered Fish Recovery Programs.

FGDC File

Download the FGDC-compliant metadata file, streams.txt

Citation

Long Citation:
Species Tagging, Research and Monitoring System (STReaMS). YYYY. Accessed via the internet at https://streamsystem.org on MM/DD/YYYY.

Short Citation:
STReaMS, MM/DD/YYYY

Introduction

This dataset is a repository for fish and PIT tag data collected by the Colorado River Basin Recovery Programs, although other agencies and partners have contributed data. The recovery programs are a consortium of governmental agencies, water interests, and environmental groups working to recover Endangered fishes in the Colorado River basin while water development proceeds in compliance with Federal and State laws.

These data are a compilation of data collected by the programs and partners from a variety of field projects over the past several decades. Data include details of stocking events, field captures, remote detections, passive interrogation arrays, studies, and PIT tag distributions. All attributes are defined in the data dictionary (coming soon).

To learn more about the recovery programs, visit them online at:
San Juan River Basin Recovery Implementation Program Home
Upper Colorado River Recovery Program

Methods

Sampling Design

Sampling designs vary by project. More information about field data collection methods can be found in detailed reports maintained on the recovery program websites:
Upper Colorado River Recovery Program Documents and Publications
San Juan River Basin Recovery Implementation Program Documents and Publications

Collection Protocol

Collection protocols vary by project. More information about field data collection methods can be found in detailed reports maintained on the recovery program websites:
Upper Colorado River Recovery Program Documents and Publications
San Juan River Basin Recovery Implementation Program Documents and Publications

Quality Assurance

MS Excel templates were designed by program personnel to minimize data collection errors. Additionally, some partners use data loggers with built-in field forms derived from the templates. Hatcheries use Biomark software and PitTagIS to automate data collection and minimize errors. Look-up tables are managed by a Database Manager to ensure a consistent vocabulary is used throughout the network.

Quality Control

All data collected before the 2016 field season were sent to database managers at the Upper Colorado recovery program and the San Juan recovery program. Database managers collated the data into MS Access databases at each basin. Fields were checked for invalid values and inconsistencies. Check with Travis and Scott for more QC measures. All data prior to the 2016 field season were retrieved from the recovery programs and imported to STReaMS by the Colorado Natural Heritage Program (CNHP). CNHP reformatted data to meet the new database structure, and checked all fields for invalid values. Records with inconsistencies were flagged and sent to database managers at each program for further investigation. Inconsistencies are noted in the DBANotes fields. Individuals with major discrepancies are marked as invalid.

After the 2015 field season, data will be imported into the STReaMS online database in batches by field personnel and periodically quality controlled by a dedicated Database Manager. STReaMS has control measures in place on each field to accept only valid entries during the upload process. Data that do not meet field requirements will be flagged and reviewed by a Data Administrator prior to import.

Analysis/Data Processing

Stocking events, captures ,and transfers represent "raw" data from the field, with minor fixes applied where needed during the quality control process. Access to the raw data files are available from 2014 on through streamsystem.org. Detections are summarized and reported by antenna down to the minute level, with the earliest detection of any given minute uploaded to STReaMS. This does not represent a literal 60 second interval. For example, a tag detected at 17:16:34, 17:16:52, and 17:17:10 will be reported in STReaMS twice, once at 17:16:34 and once at 17:17:10. Summarizing the detection data provides a consistent way to upload detections across multiple passive interrogation arrays, and ignores large amounts of data accidentally collected during system malfunctions when preset data collection delays have to be reset. Raw data files are available through streamsystem.org for users that need access to all detections.

Results/Discussion

Assumptions, Caveats, Use Considerations

These data are strictly "on loan" and should be considered "works in progress". Under no circumstances are data to be DISTRIBUTED to outside parties. Others interested in STReaMS data should download data directly from https://streamsystem.org

Care should be taken in interpreting these data. Data maintained in the STReaMS database are an integral part of ongoing research and reflect the observations of many scientists, institutions and our current state of knowledge. These data are acquired from various sources, with varying levels of accuracy and completeness, and are continually being updated and revised.

This dataset is a repository for fish and PIT tag data collected by the Colorado River Basin Recovery Programs, although other agencies and partners have contributed data. The data have been collected to meet the needs of the Upper Colorado River Basin recovery programs and may not be appropriate for all uses. Users should refer to detailed reports or contact Principal Investigators to determine appropriate use of the data. Sample designs and collection protocols vary by project. More information about field data collection methods can be found in detailed reports maintained on the recovery program websites:
Upper Colorado River Recovery Program Documents and Publications
San Juan River Basin Recovery Implementation Program Documents and Publications

The absence of data in any particular geographic area does not necessarily mean that species of concern are not present, but rather our files do not currently contain information to document this presence. These data should not be regarded as a substitute for on-site surveys required for environmental assessments.

The data contained herein are provided on an as-is, as-available basis without warranties of any kind, expressed or implied, including (but not limited to) warranties of merchantability, fitness for a particular purpose, and non-infringement. Colorado State University and the U.S. Federal Government further expressly disclaim any warranty that the data are error-free or current as of the date supplied.

Data Organization

All data are stored in an MS SQL Server database and served through an online interface. A database diagram is coming soon.

Acknowledgements

Data have been collected by: Fish and Wildlife Service, Bureau of Reclamation, Utah Department of Wildlife Resources, Colorado Parks and Wildlife, Wyoming Fish and Game, Arizona Game and Fish, New Mexico Department of Game and Fish, Navajo Nation, Colorado State University Larval Fish Lab, Kansas State University, Utah State University, University of Wyoming, University of New Mexico, and others.

Database developed by the Colorado Natural Heritage Program, Colorado State University.