About this Dataset

Data From: Runoff Water Quantity And Quality Data From Native Tallgrass Prairie And Crop-livestock Systems In Oklahoma Between 1977 And 1999

Historic data from the Water Resources and Erosion (WRE) watersheds at Grazinglands Research Laboratory (GRL), USDA-ARS, El Reno, OK. The WRE watersheds are eight 1.6 ha experimental watersheds established and instrumented in 1976 to measure precipitation and surface runoff quantity and quality. Data was collected from 1977 through 1999 and includes precipitation, runoff, sediment loads, water quality (N, P, suspended sediments), and land management data. These datasets are valuable resources to improve modeling in relation to land use and management changes, climate variability, and other environmental factors and may be useful in developing strategies to mitigate environmental impacts of agricultural systems.

Resources in this dataset:

Resource Title: WRE Daily Water Quality Data.

File Name: WRE daily water quality.csv

Resource Description: Daily runoff and sediment load values from the WRE experimental watersheds.

Resource Title: WRE Water Quality Event Data.

File Name: WRE event water quality_import.csv

Resource Description: Event data for WRE watersheds including: sediment, rainfall, runoff, nitrogen species, phosphorus species, chlorine, sulfate, pH, conductivity, sodium, potassium, calcium, and magnesium.

Resource Title: WRE Grazing.

File Name: WRE Grazing.csv

Resource Description: Grazing data for WRE watersheds. Dates on, off, cattle variety and number, and crop.

Resource Title: WRE Tillage.

File Name: WRE Tillage.csv

Resource Description: Tillage data for the WRE watersheds. Includes date, tillage implement, min and max depths, and additional comments.

Resource Title: WRE Harvest.

File Name: Harvest.csv

Resource Description: Harvest data for the WRE watersheds including date, crop, harvest type, yield, units, and additional comments.

Resource Title: WRE Management Activities.

File Name: WRE Misc Management Import.csv

Resource Description: Other management activities known for the WRE watersheds with date and comments where given.

Resource Title: WRE Planting.

File Name: WRE Planting.csv

Resource Description: Planting data for the WRE watersheds including date, crop, variety, seed rate, unit, spacing, and comments.

Resource Title: WRE Pesticides.

File Name: WRE Pesticides_import.csv

Resource Description: Pesticide use data for the WRE watersheds including date, application rate, units, application method, and comment.

Resource Title: WRE Fertilizer.

File Name: WRE Fertilizer.csv

Resource Description: Fertilizer application data for the WRE watersheds including date, crop, fertilizer used, rate, units, application method, and comments.
Organization: Department of Agriculture
Last updated: 2024-03-30T11:24:11.137560
Tags: agroecosystem, agroecosystem-environment-erosion, agroecosystems-environment-water, ars, data-gov, earth-science-terrestrial-hydrosphere-water-quality-water-chemistry, rainfall

Tables

Harvest

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.harvest

7.79 kB
108 rows
7 columns

CREATE TABLE harvest (
  "siteid" VARCHAR,
  "date" TIMESTAMP,
  "crop" VARCHAR,
  "harvest" VARCHAR,
  "yield" DOUBLE,
  "unit" VARCHAR,
  "comment" VARCHAR
);

WRE Daily Water Quality

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.wre_daily_water_quality

251.12 kB
69,392 rows
4 columns

CREATE TABLE wre_daily_water_quality (
  "siteid" VARCHAR,
  "date" TIMESTAMP,
  "runoff_in" DOUBLE  -- Runoff (in),
  "sediment_pounds" DOUBLE  -- Sediment (pounds)
);

WRE Event Water Quality Import

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.wre_event_water_quality_import

52.93 kB
719 rows
20 columns

CREATE TABLE wre_event_water_quality_import (
  "siteid" VARCHAR,
  "date" VARCHAR,
  "sediment_kg_ha" DOUBLE,
  "rainfall_mm" VARCHAR,
  "runoff_cm" DOUBLE,
  "nitrate_nitrogen_mg_l" DOUBLE,
  "ammonium_mg_l" DOUBLE,
  "total_kjeldahl_nitrogen_mg_l" DOUBLE,
  "soluble_organic_phosphorus_ug_l" DOUBLE,
  "soluble_inorganic_reactive_phosphorus_ug_l" DOUBLE,
  "total_phosphorus_ug_l" DOUBLE,
  "chlorine_mg_l" DOUBLE,
  "sulfate_mg_l" DOUBLE,
  "ph" DOUBLE,
  "conductivity_umhos_cm_100" DOUBLE,
  "comment" VARCHAR,
  "sodium_mg_l" DOUBLE,
  "potassium_mg_l" DOUBLE,
  "calcium_mg_l" DOUBLE,
  "magnesium_mg_l" DOUBLE
);

WRE Grazing

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.wre_grazing

7.57 kB
128 rows
7 columns

CREATE TABLE wre_grazing (
  "siteid" VARCHAR,
  "date_on" TIMESTAMP,
  "date_off" TIMESTAMP,
  "number_of_cows" DOUBLE,
  "variety_of_cows" VARCHAR,
  "crop" VARCHAR,
  "comment" VARCHAR
);

WRE Misc Management Import

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.wre_misc_management_import

5.5 kB
64 rows
5 columns

CREATE TABLE wre_misc_management_import (
  "siteid" VARCHAR,
  "date" TIMESTAMP,
  "crop" VARCHAR,
  "activity" VARCHAR,
  "comment" VARCHAR
);

WRE Pesticides Import

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.wre_pesticides_import

7.08 kB
128 rows
7 columns

CREATE TABLE wre_pesticides_import (
  "siteid" VARCHAR,
  "date" TIMESTAMP,
  "pesticide" VARCHAR,
  "rate_per_acre" DOUBLE,
  "unit" VARCHAR,
  "application_method" VARCHAR,
  "comment" VARCHAR
);

WRE Planting

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.wre_planting

7.82 kB
118 rows
8 columns

CREATE TABLE wre_planting (
  "siteid" VARCHAR,
  "date" TIMESTAMP,
  "crop" VARCHAR,
  "variety" VARCHAR,
  "seedrate" DOUBLE,
  "unit" VARCHAR,
  "spacing" DOUBLE,
  "comment" VARCHAR
);

WRE Tillage

@usgov.usda_gov_data_from_runoff_water_quantity_and_quality_f_3e6b89d6.wre_tillage

7.32 kB
213 rows
6 columns

CREATE TABLE wre_tillage (
  "siteid" VARCHAR,
  "date" TIMESTAMP,
  "tillage" VARCHAR,
  "mindepth" DOUBLE,
  "maxdepth" DOUBLE,
  "comment" VARCHAR
);