The KBFC database provides access to standardized PIT tag data submitted by tribal, state, federal and non-governmental organizations. Membership to KBFC is required to submit and access data, as well as agreement to the Data Sharing Agreement. 

To facilitate the exchange of data between the KBFC Database and the data managers who submit these data, a Representational State Transfer (REST) Application Programming Interface (API) is maintained. The links below provide access to the policies, data and metadata standards, and the KBFC Database API.

KBFC Database

User interface to access and upload data

REST API

Representational State Transfer Application Programming Interface for data exchange

Data Policy and Agreement

Data Sharing Agreement

Data Exchange Standards & Controlled Vocabulary

Formal rules for data elements shared with KBFC

Fish Data Analytics

Species tracking, marking, and recovery data over time

Marked Fish by Species & Year

Chart Info

Shows the number of fish marked (tagged) each year, broken down by species. Stacked bars show species composition and total marking effort over time.

Recaptured Fish by Species & Year

Chart Info

Displays fish that were recaptured alive after initial marking. This data helps track survival rates and fish movement patterns.

Recovered Fish by Species & Year

Chart Info

Shows fish found deceased after marking. Recovery data provides insights into mortality rates and is important for population assessment studies.

Detections by Year

Chart Info

Total PIT tag detections recorded each year by remote detection arrays throughout the Klamath Basin.

Additional documents related to the KBFC Database can be found below.

A subset of these documents appear in the icons above.

FileDescriptionFile Date
KBFC Controlled Vocab and Data Exchange StandardsThe KBFC Data Exchange Standards and Controlled Vocabulary are a set of guidelines that define how data are structured, formatted, and shared between systems.July 10, 2026
KBFC Data Import ETL Toolkit Installation Guide and MySQL scriptsThis file includes the Installation document which outlines how to set up the KBFC Data Import ETL Toolkit on a Windows workstation and the MySQL script package. This package is used for pulling data from ESRI cloud, to an internal data server, then to the KBFC shared datasystem. For inquiries, please contact KBFishC@psmfc.orgJuly 2, 2026
Lessons Learned from Implementing Electronic Field Data Capture Workflow for the Klamath Basin Fisheries Collaborative using Survey123 and Bluetooth Devices (Version 1.0)Lessons learned from the KBFC data modernization project consist of challenges and opportunities associated with implementing an electronic field data capture and data exchange workflow across multiple organizations. While the project successfully demonstrated that Survey123, cloud-based data exchange, APIs, and Bluetooth-enabled devices can support the collection and sharing of KBFC data, the effort also highlighted several considerations that should be addressed by organizations implementing similar workflows.July 2, 2026
Serial Magic Keys Manual 2025 Updated Feb 3, 2026This updated manual provides instructions for downloading and installing SerialMagicKeys software for use with KBFC Survey 123 forms.February 3, 2026
KBFC Survey123 Form – MRR Efforts and RecordsThe MRR (Mark, Recapture or Recovery) Efforts and Records form is used when fish are PIT tagged (i.e., marked), recaptured or recovered. This Esri Survey123 form captures data following KBFC data standards, ensuring seamless integration with the collaborative KBFC database. *Important* - After publishing the survey, copy all media folder contents to the published version's media folder to maintain proper survey functionality.October 20, 2025
KBFC Survey123 Form – Remote Deployments and Event LogThe Remote Deployments and Event Log form is used to document remote deployment (i.e., PIT tag detection) sites that you manage and significant events at these remote detection sites, such as power outages, equipment failures, or data loss events. This Esri Survey123 form captures data following KBFC data standards, ensuring seamless integration with the collaborative KBFC database. *Important* - After publishing the survey, copy all media folder contents to the published version's media folder to maintain proper survey functionality.October 20, 2025
KBFC Operating Guidelines Adopted Sept 2025The emergence of the Klamath Basin Fisheries Collaborative (hereafter, “KBFC” or the “Collaborative”) reflects an ambitious effort by many partners to monitor and evaluate Klamath River restoration opportunities in the face of an ecological system in crisis and several imperiled fish species requiring Endangered Species Act (ESA) protections. The KBFC is primarily focused on development and use of a common database that will broadly enable data sharing and, by extension, inform fisheries management and ecosystem restoration in the Klamath Basin (Basin). The KBFC adopted these operating guidelines on June 13, 2023 during the 2023 KBFC annual meeting held in Yreka, California to guide their collaborative efforts. The Operating Guidelines have been since updated to reflect the current needs of the KBFC in Sept 2025.September 1, 2025
KBFC Database – Data Entry GuideThis Data entry guide is to help users with the process of uploading their standardized data in the KBFC data system.July 15, 2025
KBFC Data Uploading Templates June 9 2025Updated version of the KBFC Data Uploading Templates. These are used to help member agencies standardize their data into a format that can easily be uploaded into the KBFC Data System.July 9, 2025
Python data conversion kitThe Python conversion kit is for entities that received a python script to convert your current data to the KBFC data templates. This folder contains the KBFC data templates, Python and PyCharm download instructions, and the tutorial for running the script to convert your data to the KBFC standardized templates.November 25, 2024
KBFC Data Sharing AgreementThe KBFC Data Sharing Agreement states the purpose of data sharing, summarizes data access at different membership levels, sets standards and informs all parties involved in sharing of their roles and responsibilities.June 11, 2024