About this Dataset

Data From: Integrated Crops And Livestock In Central North Dakota, USA: Agroecosystem Management To Buffer Soil Change

Integrated crop-livestock systems have been identified as having positive agronomic and environmental outcomes, but information documenting their long-term impact on soil properties is lacking. An integrated crop-livestock study was conducted to evaluate the effects of residue management, frequency of hoof traffic, season, and production system (integrated annual cropping vs. perennial grass) on soil properties at the 0-7.5 cm depth from 2001 through 2008. The study was conducted at the USDA-ARS Northern Great Plains Research Laboratory, Mandan, North Dakota, USA. Soil bulk density, electrical conductivity, soil pH, extractable N and P, potentially mineralizable N, soil organic carbon, and total nitrogen were measured 3, 6, and 9 years after treatment establishment. Electrical conductivity and pH were estimated from a 1:1 soil-water mixture. Soil nitrate-N and ammonium-N were determined from 1:10 soil-KCl (2 M) extracts using cadmium reduction followed by a modified Griess-Ilosvay method and indophenol blue reaction. Plant-available soil P was estimated by bicarbonate extraction. Potentially mineralizable N was estimated from the ammonium-N accumulated after a 7-d anaerobic incubation. Total soil carbon and nitrogen were determined by dry combustion. Values for soil properties were incorporated into a soil quality index to assess production system effects on soil condition using the Soil Management Assessment Framework. Data may be used to understand integrated crop-livestock system impacts on near-surface soil properties. Data are generally applicable to cropland under a semiarid continental climate for the following USDA soil types: Grassna, Linton, Mandan, Temvik, Williams, and Wilton.
Organization: Department of Agriculture
Last updated: 2025-08-05T19:05:19.922050
Tags: integrated-agricultural-systems, soil-change, soil-quality

Tables

ICL SQ SMAF Data

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_smaf_data

11.85 KB
120 rows
14 columns


CREATE TABLE icl_sq_smaf_data (
  "year" BIGINT,
  "rep" BIGINT,
  "forage" VARCHAR,
  "grztrt" VARCHAR,
  "zone" VARCHAR,
  "meas" BIGINT,
  "depth" DOUBLE,
  "sbdsc" DOUBLE,
  "ecsc" DOUBLE,
  "phsc" DOUBLE,
  "psc" DOUBLE,
  "pmnsc" DOUBLE,
  "socsc" DOUBLE,
  "sqi" DOUBLE
);

ICL SQ SMAF Metadata

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_smaf_metadata

4.11 KB
14 rows
4 columns


CREATE TABLE icl_sq_smaf_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR,
  "note" VARCHAR
);

ICL SQ Soil Props Time Data

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_soil_props_time_data

16.74 KB
144 rows
17 columns


CREATE TABLE icl_sq_soil_props_time_data (
  "year" BIGINT,
  "time" VARCHAR,
  "rep" BIGINT,
  "forage" VARCHAR,
  "grztrt" VARCHAR,
  "zone" VARCHAR,
  "meas" BIGINT,
  "depth" DOUBLE,
  "sbd" DOUBLE,
  "ec" DOUBLE,
  "ph" DOUBLE,
  "no3n" DOUBLE,
  "nh4n" DOUBLE,
  "p" DOUBLE,
  "pmn" DOUBLE,
  "soc" DOUBLE,
  "tn" DOUBLE
);

ICL SQ Soil Props Time Metadata

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_soil_props_time_metadata

4.03 KB
17 rows
4 columns


CREATE TABLE icl_sq_soil_props_time_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR,
  "note" VARCHAR
);

ICL SQ Soil Props Trts Data

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_soil_props_trts_data

16.08 KB
120 rows
17 columns


CREATE TABLE icl_sq_soil_props_trts_data (
  "year" BIGINT,
  "time" VARCHAR,
  "rep" BIGINT,
  "forage" VARCHAR,
  "grztrt" VARCHAR,
  "zone" VARCHAR,
  "meas" BIGINT,
  "depth" DOUBLE,
  "sbd" DOUBLE,
  "ec" DOUBLE,
  "ph" DOUBLE,
  "no3n" DOUBLE,
  "nh4n" DOUBLE,
  "p" DOUBLE,
  "pmn" DOUBLE,
  "soc" DOUBLE,
  "tn" DOUBLE
);

ICL SQ Soil Props Trts Metadata

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_soil_props_trts_metadata

4.01 KB
17 rows
4 columns


CREATE TABLE icl_sq_soil_props_trts_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR,
  "note" VARCHAR
);

ICL SQ Weather Data

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_weather_data

5.52 KB
120 rows
6 columns


CREATE TABLE icl_sq_weather_data (
  "source" VARCHAR,
  "station" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "airtemp" BIGINT,
  "precip" DOUBLE
);

ICL SQ Weather Metadata

@usgov.usda_gov_data_from_integrated_crops_and_livestock_in_c_932cc916.icl_sq_weather_metadata

3.65 KB
6 rows
4 columns


CREATE TABLE icl_sq_weather_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR,
  "note" VARCHAR
);