Aquatic Invertebrate Monitoring Data For Buffalo National River, Ozark National Scenic Riverways And Multiple Small Stream Park Units Throughout The Midwest, 2005-2024 - Raw Data by US Government | Environmental and Climate Sciences

About this Dataset

Aquatic Invertebrate Monitoring Data For Buffalo National River, Ozark National Scenic Riverways And Multiple Small Stream Park Units Throughout The Midwest, 2005-2024 - Raw Data

This monitoring dataset consists of aquatic invertebrate community data for Buffalo National River, Ozark National Scenic Riverways and multiple small stream park units throughout the Midwest. The dataset includes invertebrate counts, site conditions, water quality and habitat measures, and stream discharge data for aquatic invertebrate communities in Heartland Inventory and Monitoring Network Parks. The dataset includes approximately 70,000 individual observations covering approximately 330 taxa of aquatic invertebrates observed at 11 NPS park units taken between 2005 and 2024. The overall goals of Heartland Inventory and Monitoring Network aquatic invertebrate community program are to monitor temporal changes in aquatic invertebrate communities and relations between the invertebrate communities and environmental factors. This monitoring information can be used by park managers to evaluate the effects of past and future activities and management decisions (either by park managers or others) on aquatic invertebrate communities. The specific objectives for aquatic invertebrate community monitoring are to assess the natural and anthropogenic processes influencing invertebrate communities, and to incorporate the spatial relationship of benthic invertebrates with their local habitat, including discharge rates, substrate size and embeddedness and water quality parameters (temperature, dissolved oxygen, pH, specific conductance, and turbidity).
Organization: Department of the Interior
Last updated: 2025-06-01T07:20:44.280255
Tags: aquatic-invertebrate, aquatic-invertebrate-habitat, buff, buffalo-national-river, emleditor, heartland-network, htln, imd, invertebrate, monitoring, ozar, ozark-national-scenic-riverways, river-aquatic-invertebrate-communities, small-stream-aquatic-invertebrate-communities, small-streams, spring-aquatic-invertebrate-communities, stream, stream-discharge, water, water-quality

Tables

HTLN Aqinvert Riffle Sampling

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_1af48058.htln_aqinvert_riffle_sampling

42.71 KB
3355 rows
24 columns


CREATE TABLE htln_aqinvert_riffle_sampling (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "riffleno" BIGINT,
  "replicate" VARCHAR,
  "width_m" DOUBLE,
  "depth_cm" BIGINT,
  "velocity_ms" DOUBLE,
  "substrate" BIGINT,
  "substrate_mm" DOUBLE,
  "embeddedness" BIGINT,
  "embeddedness_pct" DOUBLE,
  "vegetation" BIGINT,
  "vegetation_pct" DOUBLE,
  "algae" BIGINT,
  "algae_pct" DOUBLE,
  "periphyton" BIGINT,
  "periphyton_pct" DOUBLE,
  "deposition" BIGINT,
  "deposition_pct" DOUBLE,
  "organic" BIGINT,
  "organic_pct" DOUBLE
);

HTLN Aqinvert Counts Thru2024

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_1af48058.htln_aqinvert_counts_thru2024

641.36 KB
71943 rows
26 columns


CREATE TABLE htln_aqinvert_counts_thru2024 (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "streamname" VARCHAR,
  "tributaryname" VARCHAR,
  "eventid" VARCHAR,
  "riffleno" BIGINT,
  "replicate" VARCHAR,
  "taxon_eml" VARCHAR,
  "taxoncode" VARCHAR,
  "tsn" DOUBLE,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "subfamily" VARCHAR,
  "genus" VARCHAR,
  "tolerancevalue" DOUBLE,
  "functionalfeedinggroup" VARCHAR,
  "largerare" BIGINT,
  "repcount" BIGINT,
  "persample_lreq1" DOUBLE,
  "persample_inv" DOUBLE,
  "repcount_calc" DOUBLE,
  "note" VARCHAR
);

HTLN Aqinvert Discharge Gauge

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_1af48058.htln_aqinvert_discharge_gauge

10.03 KB
121 rows
9 columns


CREATE TABLE htln_aqinvert_discharge_gauge (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "gaugesiteno" BIGINT,
  "gaugelocation" VARCHAR,
  "discharge_cms" DOUBLE,
  "comments" VARCHAR
);

HTLN Aqinvert Reaches Locations

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_1af48058.htln_aqinvert_reaches_locations

10.23 KB
103 rows
8 columns


CREATE TABLE htln_aqinvert_reaches_locations (
  "reachid" VARCHAR,
  "invertlocationid" VARCHAR,
  "fishlocationid" VARCHAR,
  "parkcode" VARCHAR,
  "parkname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "notes" VARCHAR
);

HTLN Aqinvert Measured Discharge

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_1af48058.htln_aqinvert_measured_discharge

21.67 KB
3589 rows
10 columns


CREATE TABLE htln_aqinvert_measured_discharge (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "dischargeno" BIGINT,
  "distancefrombank_m" DOUBLE,
  "depth_cm" BIGINT,
  "velocity_ms" DOUBLE,
  "comments" VARCHAR
);

HTLN Aqinvert Water Quality

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_1af48058.htln_aqinvert_water_quality

24.41 KB
877 rows
13 columns


CREATE TABLE htln_aqinvert_water_quality (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "riffleno" BIGINT,
  "rifflelength" DOUBLE,
  "temperature" DOUBLE,
  "specificconductance" DOUBLE,
  "ph" DOUBLE,
  "do" DOUBLE,
  "turbidity" BIGINT,
  "note" VARCHAR
);