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 - Data Package

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-09-14T20:42:55.620374
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 CountsThru2024

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_e5ef3b8c.htln_aqinvert_countsthru2024

676.88 kB
71,943 rows
28 columns

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

HTLN Aqinvert GaugeDischarge

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_e5ef3b8c.htln_aqinvert_gaugedischarge

11.7 kB
121 rows
11 columns

CREATE TABLE htln_aqinvert_gaugedischarge (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "gaugesiteno" BIGINT,
  "gaugelocation" VARCHAR,
  "discharge_incubicmeterspersecond" DOUBLE,
  "comments" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR
);

HTLN Aqinvert MeasuredDischarge

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_e5ef3b8c.htln_aqinvert_measureddischarge

23.73 kB
3,589 rows
12 columns

CREATE TABLE htln_aqinvert_measureddischarge (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "dischargeno" BIGINT,
  "distancefrombank_inmeters" DOUBLE,
  "depth_incentimeters" BIGINT,
  "velocity_inmeterspersecond" DOUBLE,
  "comments" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR
);

HTLN Aqinvert ReachLocations

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_e5ef3b8c.htln_aqinvert_reachlocations

12.54 kB
103 rows
11 columns

CREATE TABLE htln_aqinvert_reachlocations (
  "reachid" VARCHAR,
  "invertlocationid" VARCHAR,
  "fishlocationid" VARCHAR,
  "parkcode" VARCHAR,
  "parkname" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "notes" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR
);

HTLN Aqinvert RiffleSampling

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_e5ef3b8c.htln_aqinvert_rifflesampling

45.71 kB
3,355 rows
26 columns

CREATE TABLE htln_aqinvert_rifflesampling (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "riffleno" BIGINT,
  "replicate" VARCHAR,
  "width_inmeters" DOUBLE,
  "depth_incentimeters" BIGINT,
  "velocity_inmeterspersecond" DOUBLE,
  "substrate" BIGINT,
  "substrate_inmillimeters" DOUBLE,
  "embeddedness" BIGINT,
  "embeddedness_inpercent" DOUBLE,
  "vegetation" BIGINT,
  "vegetation_inpercent" DOUBLE,
  "algae" BIGINT,
  "algae_inpercent" DOUBLE,
  "periphyton" BIGINT,
  "periphyton_inpercent" DOUBLE,
  "deposition" BIGINT,
  "deposition_inpercent" DOUBLE,
  "organic" BIGINT,
  "organic_inpercent" DOUBLE,
  "type" VARCHAR,
  "basisofrecord" VARCHAR
);

HTLN Aqinvert WaterQuality

@usgov.doi_gov_aquatic_invertebrate_monitoring_for_buffalo_na_e5ef3b8c.htln_aqinvert_waterquality

26.91 kB
877 rows
15 columns

CREATE TABLE htln_aqinvert_waterquality (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "season" BIGINT,
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "riffleno" BIGINT,
  "rifflelength_inmeters" DOUBLE,
  "temperature_incelsius" DOUBLE,
  "specificconductance_inmicrosiemenspercentimeter" DOUBLE,
  "ph" DOUBLE,
  "do_inmilligramsperliter" DOUBLE,
  "turbidity_inntu" BIGINT,
  "note" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR
);