Baselight
Sign In

Mojave Desert Network Desert Springs Data Package 2016 - 2023

Department of the Interior

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023

Loading...
Loading...

About this Dataset

Mojave Desert Network Desert Springs Data Package 2016 - 2023

This data package contains discrete data collected for the Mojave Desert Network Inventory and Monitoring Program (MOJN I&M) Desert Springs protocol. This protocol is designed to monitor hydrological and ecological condition at 250 springs in Death Valley National Park (DEVA), Joshua Tree National Park (JOTR), Lake Mead National Recreation Area (LAKE), Mojave National Preserve (MOJA), and Grand Canyon-Parashant National Monument (PARA). Data collected include water quantity and water quality measurements as well as site condition information about dominant vegetation, invasive plants, disturbance, and wildlife evidence.
Organization: Department of the Interior
Last updated: 2024-05-11T00:19:12.691566
Tags: desert-springs, hydrology, mojn, springs

Tables

CalibrationDO

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.calibrationdo
  • 35.81 kB
  • 449 rows
  • 16 columns
Loading... 
CREATE TABLE calibrationdo (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "starttime" VARCHAR,
  "fieldseason" BIGINT,
  "visittype" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "calibrationtime" VARCHAR,
  "doinstrument" VARCHAR,
  "barometricpressure_mmhg" DOUBLE,
  "precalibrationreading_percent" DOUBLE,
  "precalibrationtemperature_c" DOUBLE,
  "postcalibrationreading_percent" DOUBLE,
  "postcalibrationtemperature_c" DOUBLE,
  "notes" VARCHAR
);

CalibrationpH

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.calibrationph
  • 49.34 kB
  • 900 rows
  • 18 columns
Loading... 
CREATE TABLE calibrationph (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "starttime" VARCHAR,
  "fieldseason" BIGINT,
  "visittype" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "calibrationtime" VARCHAR,
  "phinstrument" VARCHAR,
  "standardvalue_ph" BIGINT,
  "temperaturecorrectedstd_ph" DOUBLE,
  "precalibrationreading_ph" DOUBLE,
  "precalibrationtemperature_c" DOUBLE,
  "postcalibrationreading_ph" DOUBLE,
  "postcalibrationtemperature_c" DOUBLE,
  "notes" VARCHAR,
  "phuniqueid" VARCHAR
);

CalibrationSpCond

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.calibrationspcond
  • 28.39 kB
  • 426 rows
  • 14 columns
Loading... 
CREATE TABLE calibrationspcond (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "starttime" VARCHAR,
  "fieldseason" BIGINT,
  "visittype" VARCHAR,
  "calibrationdate" TIMESTAMP,
  "calibrationtime" VARCHAR,
  "spcondinstrument" VARCHAR,
  "standardvalue_micros_per_cm" BIGINT,
  "precalibrationreading_micros_per_cm" BIGINT,
  "postcalibrationreading_micros_per_cm" DOUBLE,
  "notes" VARCHAR
);

DischargeEstimated

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.dischargeestimated
  • 22.34 kB
  • 876 rows
  • 11 columns
Loading... 
CREATE TABLE dischargeestimated (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "flowcondition" VARCHAR,
  "dischargeclass_l_per_s" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR
);

DischargeFlowCondition

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.dischargeflowcondition
  • 149.92 kB
  • 944 rows
  • 18 columns
Loading... 
CREATE TABLE dischargeflowcondition (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "flowcondition" VARCHAR,
  "springbrooktype" VARCHAR,
  "springbrooklengthflag" VARCHAR,
  "springbrooklength_m" DOUBLE,
  "springbrookwidth_m" DOUBLE,
  "discontinuousspringbrooklengthflag" VARCHAR,
  "discontinuousspringbrooklength_m" DOUBLE,
  "visittype" VARCHAR,
  "dpl" VARCHAR,
  "notes" VARCHAR,
  "springbrooknotes" VARCHAR
);

DischargeVolumetric

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.dischargevolumetric
  • 14.98 kB
  • 399 rows
  • 13 columns
Loading... 
CREATE TABLE dischargevolumetric (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "flowcondition" VARCHAR,
  "containervolume_ml" BIGINT,
  "filltime_seconds" DOUBLE,
  "estimatedcapture_percent" DOUBLE,
  "visittype" VARCHAR,
  "dpl" VARCHAR
);

Disturbance

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.disturbance
  • 86.35 kB
  • 944 rows
  • 22 columns
Loading... 
CREATE TABLE disturbance (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "roads" VARCHAR,
  "humanuse" VARCHAR,
  "plantmanagement" VARCHAR,
  "hikingtrails" VARCHAR,
  "livestock" VARCHAR,
  "otheranthropogenic" VARCHAR,
  "fire" VARCHAR,
  "flooding" VARCHAR,
  "wildlife" VARCHAR,
  "othernatural" VARCHAR,
  "overall" VARCHAR,
  "flowmodificationstatus" VARCHAR,
  "visittype" VARCHAR,
  "notes" VARCHAR,
  "dpl" VARCHAR
);

DisturbanceFlowModification

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.disturbanceflowmodification
  • 23.82 kB
  • 1,117 rows
  • 11 columns
Loading... 
CREATE TABLE disturbanceflowmodification (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "flowmodificationstatus" VARCHAR,
  "modificationtype" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR
);

Invasives

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.invasives
  • 40.5 kB
  • 1,323 rows
  • 15 columns
Loading... 
CREATE TABLE invasives (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "invasivesobserved" VARCHAR,
  "inriparianvegbuffer" VARCHAR,
  "usdaplantscode" VARCHAR,
  "scientificname" VARCHAR,
  "visittype" VARCHAR,
  "protectedstatus" VARCHAR,
  "dpl" VARCHAR,
  "notes" VARCHAR
);

Riparian

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.riparian
  • 93.33 kB
  • 4,367 rows
  • 15 columns
Loading... 
CREATE TABLE riparian (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "isvegetationobserved" VARCHAR,
  "mistletoepresent" VARCHAR,
  "lifeform" VARCHAR,
  "rank" DOUBLE,
  "dominantspecies" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR,
  "notes" VARCHAR
);

Site

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.site
  • 53.38 kB
  • 495 rows
  • 21 columns
Loading... 
CREATE TABLE site (
  "park" VARCHAR,
  "subunit" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "sitedescription" VARCHAR,
  "ecologicaldescription" VARCHAR,
  "logisticaldescription" VARCHAR,
  "drivedescription" VARCHAR,
  "hikedescription" VARCHAR,
  "hikedistance_m" VARCHAR,
  "hiketime_min" VARCHAR,
  "grtsdraw" VARCHAR,
  "grtsorder" BIGINT,
  "sitestatus" VARCHAR,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "siteprotectedstatus" VARCHAR,
  "lat_wgs84" DOUBLE,
  "lon_wgs84" DOUBLE,
  "x_utm_nad83_11n" BIGINT,
  "y_utm_nad83_11n" BIGINT
);

Visit

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.visit
  • 103.15 kB
  • 944 rows
  • 12 columns
Loading... 
CREATE TABLE visit (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "visittype" VARCHAR,
  "monitoringstatus" VARCHAR,
  "springtype" VARCHAR,
  "notes" VARCHAR,
  "dpl" VARCHAR
);

VisitActivity

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.visitactivity
  • 55.12 kB
  • 944 rows
  • 19 columns
Loading... 
CREATE TABLE visitactivity (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "springtype" VARCHAR,
  "flowcondition" VARCHAR,
  "wqdatacollected" VARCHAR,
  "invasivesobserved" VARCHAR,
  "riparianobserved" VARCHAR,
  "mistletoepresent" VARCHAR,
  "wildlifeobserved" VARCHAR,
  "springbrooklength_class" VARCHAR,
  "springbrookwidth_m" DOUBLE,
  "springbrooklength_m" DOUBLE,
  "sampleframe" VARCHAR,
  "visittype" VARCHAR,
  "monitoringstatus" VARCHAR,
  "waterqualitynotes" VARCHAR
);

WaterQualityDO

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.waterqualitydo
  • 63.42 kB
  • 1,888 rows
  • 16 columns
Loading... 
CREATE TABLE waterqualitydo (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "wqdatacollected" VARCHAR,
  "dissolvedoxygen_percent" DOUBLE,
  "dissolvedoxygen_mg_per_l" DOUBLE,
  "dataqualityflag" VARCHAR,
  "dataqualityflagnote" VARCHAR,
  "doinstrument" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR,
  "monitoringstatus" VARCHAR
);

WaterQualitypH

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.waterqualityph
  • 55.73 kB
  • 1,926 rows
  • 15 columns
Loading... 
CREATE TABLE waterqualityph (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "wqdatacollected" VARCHAR,
  "ph" DOUBLE,
  "dataqualityflag" VARCHAR,
  "dataqualityflagnote" VARCHAR,
  "phinstrument" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR,
  "monitoringstatus" VARCHAR
);

WaterQualitySpCond

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.waterqualityspcond
  • 58.16 kB
  • 1,862 rows
  • 15 columns
Loading... 
CREATE TABLE waterqualityspcond (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "wqdatacollected" VARCHAR,
  "specificconductance_micros_per_cm" DOUBLE,
  "dataqualityflag" VARCHAR,
  "dataqualityflagnote" VARCHAR,
  "spcondinstrument" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR,
  "monitoringstatus" VARCHAR
);

WaterQualityTemperature

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.waterqualitytemperature
  • 56.66 kB
  • 1,948 rows
  • 15 columns
Loading... 
CREATE TABLE waterqualitytemperature (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "wqdatacollected" VARCHAR,
  "watertemperature_c" DOUBLE,
  "dataqualityflag" VARCHAR,
  "dataqualityflagnote" VARCHAR,
  "temperatureinstrument" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR,
  "monitoringstatus" VARCHAR
);

Wildlife

@usgov.doi_gov_mojave_desert_network_desert_springs_package_2016_2023.wildlife
  • 54.48 kB
  • 1,299 rows
  • 19 columns
Loading... 
CREATE TABLE wildlife (
  "park" VARCHAR,
  "sitecode" VARCHAR,
  "sitename" VARCHAR,
  "visitdate" TIMESTAMP,
  "fieldseason" BIGINT,
  "sampleframe" VARCHAR,
  "panel" VARCHAR,
  "iswildlifeobserved" VARCHAR,
  "wildlifetype" VARCHAR,
  "directobservation" VARCHAR,
  "scat" VARCHAR,
  "tracks" VARCHAR,
  "shelter" VARCHAR,
  "foraging" VARCHAR,
  "vocalization" VARCHAR,
  "otherevidence" VARCHAR,
  "notes" VARCHAR,
  "visittype" VARCHAR,
  "dpl" VARCHAR
);

Share link

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