STReaMS - Endangered Fishes Database
CNHP has partnered with the Upper Colorado River Endangered Fish Recovery Program and San Juan River Basin Recovery Implementation Program to develop an online database supporting the recovery of endangered fishes in the Upper Colorado River basin. The recovery programs are a consortium of partners, from government to industry to non-profits, dedicated to restoring natural and self-sustaining populations of endangered fishes. The programs have collected data on fish locations, monitoring projects, and PIT tag distributions for several decades. With almost 30 years of data in hand, active partners in five states, and an increasing demand for water out West, the need to efficiently manage copious amounts of data and share them with stakeholders became paramount.
CNHP’s Conservation Data Services team delivered a custom database solution called the Species Tagging, Research, and Monitoring System (STReaMS), available at https://streamsystem.org/. To date, STReaMS houses information on millions of PIT tags, individual fish, and fish encounters.
We worked closely with the programs to:
- Design a complex relational database to meet program priorities.
- Develop a web interface to deliver the content securely, intuitively, and quickly.
- Customize quality control and batch import tools to efficiently manage large amounts of data.
Endangered fishes in the basin include humpback chub, bonytail, Colorado pikeminnow, and razorback sucker. Bonytail is the most critically endangered fish in the basin.