CAP DES Development Team

StreamNet Data Exchange Standards (DES) document version 2024.1.  Contains data structures, definitions, and business rules for fish monitoring data, location coding, age data, fish distribution, barriers, references, hatcheries, and dams.  This version applies to data sent February 1, 2024 and after.

This is the 2nd revision of the Five-Year Plan for Coordinated Assessments Partnership adopted in 2019. This November 2022 revised version incorporates edits discussed and supported during the StreamNet Executive Committee meeting on September 21, 2022.

Revised version of the Five-Year Plan for the Coordinated Assessments Partnership adopted in 2019 and revised in 2021 during the September 9, 2021 Executive Committee meeting. This updated version of the plan describes the hatchery indicator work that is ongoing through the HCAX project, updates the approach for adding new content about the available of data for salmon and steelhead populations without CAP Fish HLIs and /or trends data, and updates the CRITFC ITMD project description.

Frequently asked questions are answered in this CAP FAQ document produced in 2020

Summary of the Coordinated Assessments Partnership, as of December 2020.

Coordinated Assessments Data Exchange Standard, Version 202007015, Effective Date:  7/15/2020.  This ZIP file contains the following file versions of the DES: PDF document, word document, word document with track changes, Access Database template, and Excel template

This Charter describes the functions of the Coordinated Assessments Partnership (CAP) Data Exchange Standard Development Team (DDT) and the processes used, including convening task-specific ad hoc work groups as needed.

Describes process followed when creating a new data exchange standard (DES) or when revising an existing DES used for exchanging standardized data with StreamNet’s fish monitoring data (“trends”) and with Coordinated Assessments Partnership’s fish high level indicators data systems.

The DET Development Team (DDT) will finalize the Data Exchange Template (DET) that will be used to guide sharing of specific defined data as a routine business practice of the Columbia Basin’s state and tribal fisheries management agencies (agencies). The DDT is made up of representatives from three perspectives: biologists and administrators from the data source / primary data using agencies; regional scale (secondary) data users; and data management / IT specialists.  Results and recommendations from the DDT will be shared with and reviewed by a wider DET review group and the CA Planning Group (CAPG).

Sep 2, 2020 Executive Committee Meeting – Five-Year Plan for Coordinated Assessments Partnership (v. 20200902)

These are the ‘top ten’ data management and sharing recommendations condensed from ‘Considerations for Regional Data Collection, Sharing and Exchange’ by StreamNet (www.streamnet.org). This list, in no particular order, represents aspects to consider and address in developing data management and sharing approaches. They are not specific instructions.

This is a general guide, independent of the purpose or use of the data, intended as a “nuts and bolts” description of the steps needed to establish a  comprehensive approach to data sharing. The focus is more on the container than the contents.

Before data is shared with StreamNet, it first undergoes QA/QC procedures at the source. This document is a summary of those processes used in 2019 by our current StreamNet partners: Colville Tribes, IDFG, MFWP, ODFW,  and WDFW.

This DSA, EULA, and policy are intended for use with CA data sets that have passed QA and are ready for dissemination online. The StreamNet Steering and Executive Committees have reviewed this DSA and will remain avenues to discuss any changes or concerns that participants may have about access to these data.

We explore best practices and provide recommendations for including robust metadata attributes within data sets to enable data publication and citation using the CA and SPS data repositories as case studies. From reviewing the current citations possible from the CA and the SPS we recommend at minimum that natural resource monitoring databases contain: metadata to identify organizations that generated the data; contact persons for each organization that contributes data to an aggregated data set; and that metadata be incorporated into databases to enable autogenerated citations that recognize all contributing organizations with time-stamped versions of the data delivered.

Natural origin fish recruit per spawner (RperS) table XML schema for data exchange with the EPA Exchange Network.

Natural origin fish smolt to adult return (SAR) table XML schema data exchange with the EPA Exchange Network.

Natural origin fish spawner abundance (NOSA) table XML schema for data exchange with the EPA Exchange Network.

General schema document for defined types used for data exchange with the EPA Exchange Network.