Goodwater Creek Experimental Watershed Caves Herbicide, Nutrient, And Suspended Sediment Data (1991-2010) by US Government | Environmental and Climate Sciences

About this Dataset

Goodwater Creek Experimental Watershed Caves Herbicide, Nutrient, And Suspended Sediment Data (1991-2010)

The Goodwater Creek, Missouri cave stream data file contains nutrient and herbicide concentrations, loads, and daily discharge data for Devils Icebox Cave and Hunters Cave from 1999 to 2002.

The data set contains concentration, load, and daily discharge data for Devils Icebox Cave and Hunters Cave from 1999 to 2002. The data are available in Microsoft Excel 2010 format. Sheet 1 (Cave Streams Metadata) contains supporting information regarding the length of record, site locations, parameters measured, parameter units, method detection limits, describes the meaning of zero and blank cells, and briefly describes unit area load computations. Sheet 2 (Devils Icebox Concentration Data) contains concentration data from all samples collected from 1999 to 2002 at the Devils Icebox site for 12 analytes and two computed nutrient parameters. Sheet 3 (Devils Icebox SS Conc Data) contains 15-minute suspended sediment (SS) concentrations estimated from turbidity sensor data for the Devils Icebox site. Sheet 4 (Devils Icebox Load & Discharge Data) contains daily data for discharge, load, and unit area loads for the Devils Icebox site. Sheet 5 (Hunters Cave Concentration Data) contains concentration data from all samples collected from 1999 to 2002 at the Hunters Cave site for 12 analytes and two computed nutrient parameters. Sheet 6 (Hunters Cave SS Conc Data) contains 15-minute SS concentrations estimated from turbidity sensor data for the Hunters Cave site. Sheet 7 (Hunters Cave Load & Discharge Data) contains daily data for discharge, load, and unit area loads for the Hunters Cave site.

Image credit: Newell Kitchen.

Resources in this dataset:

Resource Title: Data Dictionary.

File Name: LTAR_GCEW_herbicidewater_qual_1.csv

Resource Description: Defines Water Quality and Sediment Load/Discharge parameters, abbreviations, time-frames, and units.

Resource Title: Dataset 1 - Herbicide, nutrient, and suspended sediment data for streams in the Devils Icebox and Hunters Caves.

File Name: doi_10.5061_dryad.bd157bv__v1.zip

Resource Description: The data set contains concentration, load, and daily discharge data for Devils Icebox Cave and Hunters Cave from 1999 to 2002. The data are available in Microsoft Excel 2010 format. Sheet 1 (Cave Streams Metadata) contains supporting information regarding the length of record, site locations, parameters measured, parameter units, method detection limits, describes the meaning of zero and blank cells, and briefly describes unit area load computations. Sheet 2 (Devils Icebox Concentration Data) contains concentration data from all samples collected from 1999 to 2002 at the Devils Icebox site for 12 analytes and two computed nutrient parameters. Sheet 3 (Devils Icebox SS Conc Data) contains 15-minute suspended sediment (SS) concentrations estimated from turbidity sensor data for the Devils Icebox site. Sheet 4 (Devils Icebox Load & Discharge Data) contains daily data for discharge, load, and unit area loads for the Devils Icebox site. Sheet 5 (Hunters Cave Concentration Data) contains concentration data from all samples collected from 1999 to 2002 at the Hunters Cave site for 12 analytes and two computed nutrient parameters. Sheet 6 (Hunters Cave SS Conc Data) contains 15-minute SS concentrations estimated from turbidity sensor data for the Hunters Cave site. Sheet 7 (Hunters Cave Load & Discharge Data) contains daily data for discharge, load, and unit area loads for the Hunters Cave site.
Organization: Department of Agriculture
Last updated: 2025-01-01T22:03:29.593368
Tags: contaminants, crop-yield, earth-science-terrestrial-hydrosphere-surface-water-runoff, goodwater-creek, ltar, lter, nitrogen, np211, nutrients, pollution, soil, watershed

Tables

LTAR GCEW Herbicidewater Qual 1–0

@usgov.usda_gov_goodwater_creek_experimental_watershed_caves__8496a950.ltar_gcew_herbicidewater_qual_1_0

8.81 KB
102 rows
8 columns


CREATE TABLE ltar_gcew_herbicidewater_qual_1_0 (
  "csv_data_file" VARCHAR,
  "element_or_value_display_name" VARCHAR,
  "description_concentration_units" VARCHAR,
  "data_type" VARCHAR,
  "character_length" BIGINT,
  "acceptable_values" VARCHAR,
  "required" VARCHAR,
  "accepts_null_value" VARCHAR
);