About this Dataset

Data From: Crop- And Weather-dependent Yield And Wind Erosion Benefits From A Conservation Practices System

This dataset records several responses in a large-scale field south of Mandan, ND to two agricultural management systems, aspirational (ASP; cover crops, and retained wheat straw) and business-as-usual (BAU; no cover crops, wheat straw harvested). Measurements were collected over one full cropping sequence corn-soybean-spring wheat from 2020-2022. Measurements included sediment mass flux, grain yield, grain crop aboveground biomass, grain crop harvest index, and cover crop biomass.

Full details about the data files including variable definitions are provided in the Read Me file.
Organization: Department of Agriculture
Last updated: 2024-08-02T04:42:57.657808
Tags: corn, cover-crops, maize, sediment-mass-flux, soybean, spring-wheat

Tables

H5-i2–2016-2021 Daily-weather

@usgov.usda_gov_data_from_crop_and_weather_dependent_yield_an_afffeaa0.h5_i2_2016_2021_daily_weather

200.52 KB
4384 rows
12 columns


CREATE TABLE h5_i2_2016_2021_daily_weather (
  "location" VARCHAR,
  "year" BIGINT,
  "field" VARCHAR,
  "crop" VARCHAR,
  "date" BIGINT,
  "doy" BIGINT,
  "sol_rad_mj_m2_d" DOUBLE,
  "t_min_c" DOUBLE,
  "t_max_c" DOUBLE,
  "pcpn_mm_d" DOUBLE,
  "rh_f" DOUBLE,
  "wind_spd_m_s" DOUBLE
);

H5 I2–2019-2022 Hand Harvest

@usgov.usda_gov_data_from_crop_and_weather_dependent_yield_an_afffeaa0.h5_i2_2019_2022_hand_harvest

18.62 KB
260 rows
15 columns


CREATE TABLE h5_i2_2019_2022_hand_harvest (
  "date" TIMESTAMP,
  "doy" BIGINT,
  "year" BIGINT,
  "crop" VARCHAR,
  "site" VARCHAR,
  "treatment" VARCHAR,
  "rep" BIGINT,
  "sample" BIGINT,
  "site_rep" VARCHAR,
  "percent_h2o" DOUBLE,
  "agb_g_m2" BIGINT,
  "grain_yield_g_m2" BIGINT,
  "grain_yield_kg_ha" DOUBLE,
  "stover_g_m2" BIGINT,
  "harvest_index" DOUBLE
);

I2 CC AGB 2020-2022

@usgov.usda_gov_data_from_crop_and_weather_dependent_yield_an_afffeaa0.i2_cc_agb_2020_2022

4.45 KB
31 rows
6 columns


CREATE TABLE i2_cc_agb_2020_2022 (
  "study" VARCHAR,
  "site" VARCHAR,
  "siteid" VARCHAR,
  "date" VARCHAR,
  "trt" VARCHAR,
  "cc_agb" VARCHAR
);