R1: Aquatic Monitoring for Climate Change - Fish Assemblage and Habitat - Tabular and Relational Datasets

Description

This reference contains relational and tabular datasets for Aquatic Monitoring for Climate Change - Fish Assemblage and Habitat survey (PRIMR IDs: FF01RKTN00-035, FF01RLPO00-089, FF01RMLH00-125, FF01RWLP00-108, FF01RWMF00-084).
These datasets represent ongoing long-term aquatic health and climate change monitoring at Refuges, and incorporates all continuous measures from the pilot project.

Service programs (Refuges, Fish and Aquatic Conservation, and Water Resources) are collaborating to implement a long-term aquatic monitoring program for evaluating effects of climate change at National Wildlife Refuges (NWRs) in the Columbia-Pacific Northwest Region (IR9). The goal is to evaluate evidence of climate change on physical and habitat variables, and potentissociations al associations with changes in fish assemblages in wadeable streams. The program relies on two site specific protocols (SSPs), one addressing habitat and fish surveys (this SSP) and another addressing temperature and stream flow. For habitat and fish, objectives are to: establish a survey reach within a stream at each of five NWRs across the range of ecoregions in IR9; describe habitat in each survey reach once every five years or less; describe fish assemblages in each survey reach once every five years or less; analyze for temporal changes in habitat and fish assemblages, and assess potential temporal associations between habitat and fish assemblages. Data collected at survey reach are based on a subset of protocols developed by the U.S. Environmental Protection Agency for the Environmental Monitoring and Evaluation Program (EMAP; Peck et al. 2006).

Resources

Name Format Description Link
CURRENT-Fish Temp Class 2020-11-16.xlsx XLS Temperature Class Index: Excel workbook calculates Temperature Class Index on worksheet for each survey reach. Survey Protocol for Habitat and Fish, Long-term Aquatic Monitoring Program, SOP10. The current file in use (as of 10/01/2021) is, CURRENT-Fish Temp Class 2020-11-16.xlsx Last current version: S. Lohr 2020-12-02. Open resource
CURRENT-Morisita-Jaccard 2020-12-02.xlsx XLS Assemblage Similarity Indices: Excel workbook to calculate assemblage similarity indices (Jaccard’s, Morisita’s) between all pairs of surveys at each sentinel site. Survey Protocol for Habitat and Fish, Long-term Aquatic Monitoring Program, SOP11. The current file in use (as of 10/01/2021) is, CURRENT-Morisita-Jaccard 2020-12-02.xlsx Last current version: S. Lohr 2020-12-02. Open resource
Table 1 Channel.xlsx XLS EMAP PHAB - Channel Summary (Table 1). Excel workbook used for Channel Summary for all Sites. Compiles channel characteristics in a table (mean values on row of entry, SD in row below mean). Open resource
Table 2 Riparian.xlsx XLS EMAP PHAB - Riparian Summary (Table 2). Excel workbook used for Riparian Summary for all Sites. Compiles riparian vegetation characteristics in a table (mean values on row of entry, SD in row below mean). Open resource
PHAB Table 2 Riparian.xml XML Metadata for Excel workbook, EMAP PHAB - Riparian Summary for all Sites (XML). Open resource
PHAB Table 1 Channel.xml XML Metadata for Excel workbook, EMAP PHAB - Channel Summary for all Sites (XML). Open resource
CURRENT-FILE_SL-NWR FishData mod-2018-03-09.zip ZIP [OLD VERSION] Fish Data - Access database for fish survey (zipped) - 2018 Archive Open resource
CURRENT-EMAP PHAB 2021-06-18.xls XLS EMAP PHAB - Excel workbook, produces worksheets for each of four categories of habitat variables (channel, substrate, fish cover, riparian) for habitat tables in final report Open resource
CURRENT-FILE_BK-NWR FishData mod-2021-06-25.zip ZIP Fish Data - Access database for fish survey (zipped) - 2021 Archive Open resource
CURRENT-UPDATED_FishData instructions 2017_03_06.docx Doc Fish Data - Instructions for using Access database for fish survey Open resource
SOP11_Instructions_Excel_AssemblageSimilarityIndices_20210915.docx Doc Assemblage Similarity Indices: Instructions for use of Excel workbook to calculate assemblage similarity indices (Jaccard’s, Morisita’s) between all pairs of surveys at each sentinel site. Survey Protocol for Habitat and Fish, Long-term Aquatic Monitoring Program, SOP11. Open resource
SOP10_Instructions_Excel_TemperatureClassIndex_20210915.docx Doc Temperature Class Index: Instructions for use of Excel workbook to calculate Temperature Class Index on worksheet for each survey reach. Survey Protocol for Habitat and Fish, Long-term Aquatic Monitoring Program, SOP10. Open resource
SOP8_Instructions_Excel_CURRENT-EMAP PHAB_20210915.docx Doc EMAP PHAB - Instructions for use of Excel workbook, produces worksheets for each of four categories of habitat variables (channel, substrate, fish cover, riparian) for habitat tables in final report Open resource

Tags

Topics

Categories