Baselight

Saint Croix National Scenic Riverway Invertebrate Data Package By The Great Lakes Inventory And Monitoring Network

Department of the Interior

@usgov.doi_gov_saint_croix_national_scenic_riverway_invertebr_97da3c54

Loading...
Loading...

About this Dataset

Saint Croix National Scenic Riverway Invertebrate Data Package By The Great Lakes Inventory And Monitoring Network

Benthic macroinvertebrates have long been used as an indicator of water quality impairment in streams and rivers. Indices of Biotic Integrity (IBI) calculated from macroinvertebrate diversity and abundance data can be used to assess if stream ecosystems are being subjected to stressors, such as pollution, low dissolved oxygen, high temperatures, excessive sedimentation, or changes in flow. Beginning in 2016, the Great Lakes Inventory and Monitoring Network (GLKN) and park staff have been monitoring macroinvertebrates annually at up to ten sites on the St. Croix and Namekagon rivers within the St. Croix National Scenic Riverway (SACN). In this effort, Hester-Dendy artificial substrate samplers are deployed in July, colonized by macroinvertebrates over a six-week period, and are then retrieved. Samples are cleaned of debris and macroinvertebrates, then preserved and sent to the laboratory. At the laboratory, samples are enumerated and identified to the lowest possible taxonomic level. This dataset contains all GLKN large river macroinvertebrate data collected to date at SACN. At time of publication, all known relevant parameters needed to assess abundance and diversity of macroinvertebrates and calculate relevant IBIs at mainstem Namekagon and St. Croix River sites within SACN are included in the dataset.
Organization: Department of the Interior
Last updated: 2024-11-02T08:48:25.426415
Tags: aquatic-ecosystems, benthos, community, composition, ecology, epifauna, freshwater, glkn, great-lakes-inventory-and-monitoring-network, insects, larvae, long-term-monitoring, macroinvertebrates, namekagon-river, river, sacn, saint-croix-national-scenic-riverway, st-croix-river, stream-ecology

Tables

Glkn Inverts

@usgov.doi_gov_saint_croix_national_scenic_riverway_invertebr_97da3c54.glkn_inverts
  • 108.11 KB
  • 3595 rows
  • 34 columns
Loading...

CREATE TABLE glkn_inverts (
  "abl_nps_lab_record_no" BIGINT,
  "year" BIGINT,
  "waterbody" VARCHAR,
  "station_name" VARCHAR,
  "station_id" VARCHAR,
  "retrieval_date" TIMESTAMP,
  "sample_type" VARCHAR,
  "lab" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "subfamily" VARCHAR,
  "genus" VARCHAR,
  "subgenus" VARCHAR,
  "species" VARCHAR,
  "taxon_id_expert" VARCHAR,
  "taxon_id_notes" VARCHAR,
  "tsn_lookup" VARCHAR,
  "tsn_source" VARCHAR,
  "tsn" VARCHAR,
  "larva" VARCHAR,
  "pupa" VARCHAR,
  "adult" VARCHAR,
  "total" VARCHAR,
  "tval" VARCHAR,
  "tfunct" VARCHAR,
  "ecoftn" VARCHAR,
  "ecoftn_rheophilly" VARCHAR,
  "ecoftn_thermal" VARCHAR,
  "ecoftn_habit" VARCHAR,
  "ecoftn_trophic" VARCHAR,
  "taxonomic_reference" VARCHAR,
  "condition" VARCHAR,
  "notes" VARCHAR
);

Glkn Inverts Geography

@usgov.doi_gov_saint_croix_national_scenic_riverway_invertebr_97da3c54.glkn_inverts_geography
  • 3.22 KB
  • 11 rows
  • 3 columns
Loading...

CREATE TABLE glkn_inverts_geography (
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Share link

Anyone who has the link will be able to view this.