About this Dataset

Mojave Desert Network (MOJN) Selected Large Springs (SLS) Data Package (2012-2025)

This data package contains discrete data collected for the Mojave Desert Network Inventory and Monitoring Program (MOJN I&M) Selected Large Springs (SLS) protocol from 2012 to June 2025. This protocol is designed to monitor hydrological and ecological condition at five springs in Death Valley National Park (DEVA), three springs and one well in Great Basin National Park, two springs in Joshua Tree National Park (JOTR), two springs and one well in Lake Mead National Recreation Area (LAKE), one spring in Mojave National Preserve (MOJA), and two springs in Parashant National Monument (PARA). Data collected in situ include water quantity, water quality, and depth to water from land surface. Data collected from samples that are shipped to partner laboratories include water chemistry and benthic macroinvertebrates. Benthic macroinvertebrate sample data are published in a separate data package.
Organization: Department of the Interior
Last updated: 2025-06-30T16:50:14.006854
Tags: hydrology, mojn, selected-large-springs, springs, water-quality, wells

Tables

BMISample

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.bmisample

6.15 KB
133 rows
6 columns


CREATE TABLE bmisample (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "subsitecode_bmi" VARCHAR,
  "datetime" TIMESTAMP,
  "bmimethod" VARCHAR,
  "quadratsize_cm" BIGINT
);

ChemResult

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.chemresult

18.07 KB
678 rows
15 columns


CREATE TABLE chemresult (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "subsitecode_chem" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "dateprocessed" TIMESTAMP,
  "sampletype" VARCHAR,
  "analysistype" VARCHAR,
  "characteristic" VARCHAR,
  "unit" VARCHAR,
  "value" DOUBLE,
  "belowdl" BOOLEAN,
  "withinprecision" VARCHAR,
  "precisionnotes" VARCHAR,
  "flag" VARCHAR
);

ChemSample

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.chemsample

10.81 KB
40 rows
11 columns


CREATE TABLE chemsample (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "subsitecode_chem" VARCHAR,
  "datetime" TIMESTAMP,
  "sampletype" VARCHAR,
  "chemmethod" VARCHAR,
  "unfilteredbottles" BIGINT,
  "filteredbottles" BIGINT,
  "labname" VARCHAR,
  "labsampleid" BIGINT,
  "chemnotes" VARCHAR
);

Gage

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.gage

7.62 KB
336 rows
5 columns


CREATE TABLE gage (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "datetime" TIMESTAMP,
  "gagetime" VARCHAR,
  "gageheight_ft" DOUBLE
);

Pool

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.pool

14.47 KB
1310 rows
7 columns


CREATE TABLE pool (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "datetime" TIMESTAMP,
  "poolnumber" BIGINT,
  "poolarea_m_sq" DOUBLE,
  "frogcount" BIGINT,
  "poolnotes" VARCHAR
);

Sites

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.sites

8.94 KB
17 rows
11 columns


CREATE TABLE sites (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitecodeshort" VARCHAR,
  "sitename" VARCHAR,
  "nhd_permanent_id" BIGINT,
  "nhd_permanent_id_type" VARCHAR,
  "status" VARCHAR,
  "siteprotectionstatus" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" VARCHAR
);

Subsites

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.subsites

11.84 KB
35 rows
14 columns


CREATE TABLE subsites (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitecodeshort" VARCHAR,
  "subsitecode" VARCHAR,
  "subsitecodeshort" VARCHAR,
  "sitename" VARCHAR,
  "subsitename" VARCHAR,
  "nhd_permanent_id" BIGINT,
  "nhd_permanent_id_type" VARCHAR,
  "status" VARCHAR,
  "siteprotectionstatus" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" VARCHAR
);

VisitBiennial

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.visitbiennial

11.3 KB
77 rows
4 columns


CREATE TABLE visitbiennial (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "datetime" TIMESTAMP,
  "bminotes" VARCHAR
);

VisitQuarterly

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.visitquarterly

64.74 KB
350 rows
7 columns


CREATE TABLE visitquarterly (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "datetime" TIMESTAMP,
  "flowcondition" VARCHAR,
  "gagenotes" VARCHAR,
  "waterqualitynotes" VARCHAR,
  "overallnotes" VARCHAR
);

VisitWell

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.visitwell

12.03 KB
120 rows
12 columns


CREATE TABLE visitwell (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "datetime" TIMESTAMP,
  "tapetype" VARCHAR,
  "tapeid" VARCHAR,
  "holdmethod" VARCHAR,
  "wlbelowlsd_ft" DOUBLE,
  "tapetype_secondary" VARCHAR,
  "tapeid_secondary" VARCHAR,
  "holdmethod_secondary" VARCHAR,
  "wlbelowlsd_secondary_ft" DOUBLE,
  "wellnotes" VARCHAR
);

VolumetricDischarge

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.volumetricdischarge

7.84 KB
42 rows
8 columns


CREATE TABLE volumetricdischarge (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "datetime" TIMESTAMP,
  "containervolume_l" DOUBLE,
  "percentflowcaptured" DOUBLE,
  "filltime_sec" DOUBLE,
  "discharge_l_per_sec" DOUBLE,
  "discharge_cfs" DOUBLE
);

WaterQuality

@usgov.doi_gov_mojave_desert_network_mojn_selected_large_spri_dce6d93d.waterquality

24.57 KB
482 rows
16 columns


CREATE TABLE waterquality (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "subsitecode" VARCHAR,
  "datetime" TIMESTAMP,
  "isdepthprofile" VARCHAR,
  "measurementdepth_ft" DOUBLE,
  "depthtobottom_ft" DOUBLE,
  "temperature_c" DOUBLE,
  "temperature_flag" VARCHAR,
  "ph" DOUBLE,
  "ph_flag" VARCHAR,
  "spcond_us_per_cm" DOUBLE,
  "spcond_flag" VARCHAR,
  "do_mg_per_l" DOUBLE,
  "do_percent" DOUBLE,
  "do_flag" VARCHAR
);