Mojave Desert Network (MOJN) Benthic Macroinvertebrate (BMI) Data Package (2009-2024) by US Government | Environmental and Climate Sciences

About this Dataset

Mojave Desert Network (MOJN) Benthic Macroinvertebrate (BMI) Data Package (2009-2024)

Benthic macroinvertebrates are an abundant, diverse, and ecologically important component of aquatic ecosystems. They are also widely used to infer water quality and overall ecosystem health because their assemblages are sensitive to changing physical, chemical, and biological conditions over multiple spatial and temporal scales.

Benthic macroinvertebrate taxa and metrics data from two monitoring protocols are included in this publication: Streams and Lakes and Selected Large Springs. For the Streams and Lakes monitoring protocol, samples are collected at nine perennial springs in Great Basin National Park. For the Selected Large Springs protocol, samples are collected at five springs in Death Valley National Park, three springs in Great Basin National Park, two springs in Joshua Tree National Park, one spring in Lake Mead National Recreation Area, and two springs in Grand Canyon-Parashant National Monument.

These data are intended to address the following monitoring objectives: status and trends in the overall ecosystem health of streams and springs, status and trends in benthic macroinvertebrate assemblages in streams, and presence of “stressed or impaired” water quality using regional bioassessment criteria.

Additional data collected for the monitoring protocols, such as water quality and chemistry parameters, are published in separate data packages.
Organization: Department of the Interior
Last updated: 2025-06-05T08:35:21.013656
Tags: macroinvertebrates, mojn, selected-large-springs, springs, streams, streams-and-lakes, water-quality

Tables

BMImetrics

@usgov.doi_gov_mojave_desert_network_mojn_benthic_macroinvert_f293d828.bmimetrics

45.34 KB
18906 rows
11 columns


CREATE TABLE bmimetrics (
  "sampleid" BIGINT,
  "project" VARCHAR,
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "subsitecode" VARCHAR,
  "collectiondate" TIMESTAMP,
  "fieldseason" BIGINT,
  "analysistype" VARCHAR,
  "invasivespecieslist" VARCHAR,
  "attribute" VARCHAR,
  "value" DOUBLE
);

BMIspecies

@usgov.doi_gov_mojave_desert_network_mojn_benthic_macroinvert_f293d828.bmispecies

85.7 KB
8313 rows
20 columns


CREATE TABLE bmispecies (
  "sampleid" BIGINT,
  "project" VARCHAR,
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "subsitecode" VARCHAR,
  "collectiondate" TIMESTAMP,
  "fieldseason" BIGINT,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "subfamily" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "scientificname" VARCHAR,
  "otuname" VARCHAR,
  "lifestage" VARCHAR,
  "notes" VARCHAR,
  "labcount" BIGINT,
  "bigrarecount" BIGINT
);

BMIvisits

@usgov.doi_gov_mojave_desert_network_mojn_benthic_macroinvert_f293d828.bmivisits

23.59 KB
274 rows
23 columns


CREATE TABLE bmivisits (
  "sampleid" BIGINT,
  "laboratory" VARCHAR,
  "project" VARCHAR,
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "subsitecode" VARCHAR,
  "sitename" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "collectiondate" TIMESTAMP,
  "fieldseason" BIGINT,
  "visittype" VARCHAR,
  "analysistype" VARCHAR,
  "sampletype" VARCHAR,
  "samplertype" VARCHAR,
  "habitat" VARCHAR,
  "ecosystem" VARCHAR,
  "area" DOUBLE,
  "fieldsplit" BIGINT,
  "labsplit" DOUBLE,
  "splitcount" BIGINT,
  "fieldnotes" VARCHAR,
  "labnotes" VARCHAR
);