Baselight
Sign In

Fish Community And Associated Habitat Data From The Heartland Inventory And Monitoring Network: 2001-2023 - Data Package

Department of the Interior

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6

Loading...
Loading...

About this Dataset

Fish Community And Associated Habitat Data From The Heartland Inventory And Monitoring Network: 2001-2023 - Data Package

This monitoring dataset consists of fish community data for Buffalo National River, Ozark National Scenic Riverways and multiple prairie stream park units throughout the Midwest. The dataset includes fish species counts, site conditions, water quality and habitat measures, and stream discharge data for fish communities in Heartland Inventory and Monitoring Network Parks. The dataset includes approximately 115,000 individual observations covering over 130 fish species observed at 11 NPS park units taken between 2001 and 2023. The overall goals of Heartland Inventory and Monitoring Network fish community program are to monitor temporal changes in fish communities and relations between the fish 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 fish communities. The specific objectives for fish community monitoring are (1) to determine the status and trends in river, springs and small-stream fish communities by quantifying metrics (e.g. species richness, percent tolerant individuals, percent invertivores, and percent omnivores) that can be used to calculate multi-metric indices and (2) to estimate the spatial and temporal variability of fish community metric values and indices among collection sites, and relations between metrics and indices with various environmental variables (e.g. stream size, riparian characteristics, substrate characteristics, water quality, discharge, and land use).
Organization: Department of the Interior
Last updated: 2025-09-14T19:45:23.946537
Tags: buffalo-national-river, communities, fish, habitat, ozark-national-scenic-riverways, prairie-streams, river, small-stream, spring, stream, stream-discharge, water-quality

Tables

HTLN FishCommunities BankMeasurementInfo Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_bankmeasurementinfo_cleaned
  • 45.93 kB
  • 7,702 rows
  • 21 columns
Loading... 
CREATE TABLE htln_fishcommunities_bankmeasurementinfo_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "channeltype" VARCHAR,
  "transectnumber" BIGINT,
  "samplelocation" VARCHAR,
  "season" BIGINT,
  "bankangle_degrees" VARCHAR,
  "bankvegcover_percent" VARCHAR,
  "bankheight_meters" VARCHAR,
  "banksubstrate" VARCHAR,
  "largetrees_tr" BOOLEAN,
  "smtreesshrubs_sh" BOOLEAN,
  "grassforbes_gr" BOOLEAN,
  "barerocksediment_ba" BOOLEAN,
  "artificial_ar" BOOLEAN,
  "comment" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities CrossSectionInfo Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_crosssectioninfo_cleaned
  • 52.81 kB
  • 5,109 rows
  • 24 columns
Loading... 
CREATE TABLE htln_fishcommunities_crosssectioninfo_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "channeltype" VARCHAR,
  "sitenumber" BIGINT,
  "transectnumber" BIGINT,
  "samplelocation" VARCHAR,
  "channelunit" VARCHAR,
  "poolform" VARCHAR,
  "width_meters" DOUBLE,
  "depth_centimeters" BIGINT,
  "velocity_meterspersecond" DOUBLE,
  "velocity_meterspersecond_flag" VARCHAR,
  "dominantwentworthsubstrate_millimeters" VARCHAR,
  "wentworthmidpoint_millimeters" DOUBLE,
  "embeddedcanopycover" VARCHAR,
  "ecc_midpointvalue1_percent" DOUBLE,
  "canopycover" VARCHAR,
  "ecc_midpointvalue2_percent" DOUBLE,
  "comment" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities DischargeFieldMeasurements Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_dischargefieldmeasurements_cleaned
  • 35.92 kB
  • 6,338 rows
  • 14 columns
Loading... 
CREATE TABLE htln_fishcommunities_dischargefieldmeasurements_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "channeltype" VARCHAR,
  "dischargeno" BIGINT,
  "distancefrombank_meters" DOUBLE,
  "depth_centimeters" BIGINT,
  "velocity_meterspersecond" DOUBLE,
  "velocity_meterspersecond_flag" VARCHAR,
  "comments" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities DischargeGaugeInfo Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_dischargegaugeinfo_cleaned
  • 12.18 kB
  • 17 rows
  • 14 columns
Loading... 
CREATE TABLE htln_fishcommunities_dischargegaugeinfo_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "channeltype" VARCHAR,
  "gaugesiteno" BIGINT,
  "streamname" VARCHAR,
  "gaugelocation" VARCHAR,
  "gaugestationsource" VARCHAR,
  "discharge_centimeterspersecond" DOUBLE,
  "comments" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities FishCountsThru 2023 Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_fishcountsthru_2023_cleaned
  • 468 kB
  • 115,213 rows
  • 32 columns
Loading... 
CREATE TABLE htln_fishcommunities_fishcountsthru_2023_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "samplinggear" VARCHAR,
  "channeltype" VARCHAR,
  "sitenumber" BIGINT,
  "taxafishnumber" BIGINT,
  "totallength_millimeters" BIGINT,
  "weight_grams" DOUBLE,
  "fishanomaly" VARCHAR,
  "vouchered" BOOLEAN,
  "numobs" BIGINT,
  "batchid" BIGINT,
  "batchwt_grams" DOUBLE,
  "comments" VARCHAR,
  "taxoncode" VARCHAR,
  "commonname" VARCHAR,
  "familyname" VARCHAR,
  "verbatimidentification" VARCHAR,
  "tsn" BIGINT,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "scientificnamedatasource" VARCHAR,
  "gbiftaxonid" VARCHAR,
  "taxonrank" VARCHAR,
  "tolerance" VARCHAR,
  "reproductiveclassification" VARCHAR,
  "trophicclassification" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities FishCoverInfo Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_fishcoverinfo_cleaned
  • 35.22 kB
  • 12,349 rows
  • 20 columns
Loading... 
CREATE TABLE htln_fishcommunities_fishcoverinfo_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "transectnumber" BIGINT,
  "samplelocation" VARCHAR,
  "channeltype" VARCHAR,
  "hydromoss_hy" BOOLEAN,
  "boulders_bo" BOOLEAN,
  "artificial_ar" BOOLEAN,
  "smallwooddeb_swd" BOOLEAN,
  "largewooddeb_lwd" BOOLEAN,
  "treesroots_tr" BOOLEAN,
  "overhangveg_ov" BOOLEAN,
  "undercutbank_uc" BOOLEAN,
  "bluff_bl" BOOLEAN,
  "comment" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities FishReachLocations Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_fishreachlocations_cleaned
  • 14.39 kB
  • 110 rows
  • 13 columns
Loading... 
CREATE TABLE htln_fishcommunities_fishreachlocations_cleaned (
  "status" VARCHAR,
  "reachid" VARCHAR,
  "activedates" VARCHAR,
  "startutmzone" VARCHAR,
  "xstartutm" DOUBLE,
  "ystartutm" DOUBLE,
  "startutmdatum" VARCHAR,
  "xstartdd" DOUBLE,
  "ystartdd" DOUBLE,
  "startdddatum" VARCHAR,
  "locationid" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities LocationDetails Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_locationdetails_cleaned
  • 20.23 kB
  • 118 rows
  • 15 columns
Loading... 
CREATE TABLE htln_fishcommunities_locationdetails_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "locationnumber" BIGINT,
  "locationtype" VARCHAR,
  "locationdescription" VARCHAR,
  "streamname" VARCHAR,
  "tributaryname" VARCHAR,
  "county" VARCHAR,
  "stretchnumber" BIGINT,
  "reachid" VARCHAR,
  "reachlength_meters" BIGINT,
  "streamwatershedarea_squarekilometers" BIGINT,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities ReachConditions Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_reachconditions_cleaned
  • 35.16 kB
  • 596 rows
  • 15 columns
Loading... 
CREATE TABLE htln_fishcommunities_reachconditions_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "cloudcover_percent" BIGINT,
  "windintensity" VARCHAR,
  "precipitationtype" VARCHAR,
  "precipitationintensity" VARCHAR,
  "sh_springs_present" BOOLEAN,
  "sh_streamflow_description" VARCHAR,
  "weathercomments" VARCHAR,
  "additionalcomments" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities ReachMeasurements Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_reachmeasurements_cleaned
  • 47.69 kB
  • 1,495 rows
  • 17 columns
Loading... 
CREATE TABLE htln_fishcommunities_reachmeasurements_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "sitenumber" BIGINT,
  "beginning_ending" VARCHAR,
  "timesampled_hhmm_mil" VARCHAR,
  "watertemp_celcius" DOUBLE,
  "airtemp_celcius" DOUBLE,
  "ph" DOUBLE,
  "specificconductance_microsiemenspercentimeter" DOUBLE,
  "conductivity_microsiemenspercentimeter" DOUBLE,
  "dissolvedoxygen_milligramsperliter" DOUBLE,
  "secchitube_centimeters" DOUBLE,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities SamplingPeriodsAndEvents Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_samplingperiodsandevents_cleaned
  • 17.43 kB
  • 72 rows
  • 12 columns
Loading... 
CREATE TABLE htln_fishcommunities_samplingperiodsandevents_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "periodid" VARCHAR,
  "season" BIGINT,
  "samplingperiods_startdate" TIMESTAMP,
  "samplingperiods_enddate" TIMESTAMP,
  "eventid" VARCHAR,
  "samplingevents_startdate" TIMESTAMP,
  "samplingevents_enddate" TIMESTAMP,
  "eventcomments" VARCHAR,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities SeineRiparianCorridor Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_seineripariancorridor_cleaned
  • 17.65 kB
  • 1,412 rows
  • 16 columns
Loading... 
CREATE TABLE htln_fishcommunities_seineripariancorridor_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "channeltype" VARCHAR,
  "sitenumber" BIGINT,
  "samplelocation" VARCHAR,
  "ripariancover_0to25_meters" VARCHAR,
  "ripariancover_26to50_meters" VARCHAR,
  "ripariancover_51to75_meters" VARCHAR,
  "ripariancover_76to100_meters" VARCHAR,
  "ripariancover_gt100_meters" VARCHAR,
  "streambankerosioncover" BIGINT,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities SeineStreamSubstrate Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_seinestreamsubstrate_cleaned
  • 20.55 kB
  • 1,091 rows
  • 19 columns
Loading... 
CREATE TABLE htln_fishcommunities_seinestreamsubstrate_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "channeltype" VARCHAR,
  "sitenumber" BIGINT,
  "muck" BIGINT,
  "detritus" BIGINT,
  "silt" BIGINT,
  "sand" BIGINT,
  "pea_gravel" BIGINT,
  "coarse_gravel" BIGINT,
  "cobble" BIGINT,
  "boulder" BIGINT,
  "bedrock" BIGINT,
  "hardpan_shale" BIGINT,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

HTLN FishCommunities TransectSpacingInterval Cleaned

@usgov.doi_gov_fish_community_and_associated_habitat_from_the_8697d9c6.htln_fishcommunities_transectspacinginterval_cleaned
  • 15.35 kB
  • 490 rows
  • 11 columns
Loading... 
CREATE TABLE htln_fishcommunities_transectspacinginterval_cleaned (
  "parkname" VARCHAR,
  "parkcode" VARCHAR,
  "locationid" VARCHAR,
  "periodid" VARCHAR,
  "eventid" VARCHAR,
  "channeltype" VARCHAR,
  "channeltypesampledlength_meters" BIGINT,
  "numberoftransects" BIGINT,
  "transectspacinginterval_meters" DOUBLE,
  "dwctype" VARCHAR,
  "dwcbasisofrecord" VARCHAR
);

Share link

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