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

CREATE TABLE mass_flux_values_2019_2022_updated (
  "site" VARCHAR,
  "treatment" VARCHAR,
  "location" VARCHAR,
  "block" VARCHAR,
  "year" BIGINT,
  "date" BIGINT,
  "days_after_planting" BIGINT,
  "n__total_flux" DOUBLE,
  "n__r_2" DOUBLE,
  "rsqr_cleaned" VARCHAR,
  "parametera" VARCHAR,
  "parameterb" VARCHAR,
  "parameterc" VARCHAR
);

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
);

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
);

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