About this Dataset

Data From: Conservation Practices Induce Tradeoffs In Soil Function: Observations From The Northern Great Plains

Cropland expansion and reduced crop rotation diversity throughout the northern Great Plains has negatively impacted soil quality, creating a need to identify conservation practices that can counteract this trend. A study was conducted to quantify soil property responses to crop diversity/intensity, cover crops, and livestock integration under controlled experimental conditions, and land use (dryland cropping, native grassland, untilled pasture) on working farms and ranches, all on a common soil type in southcentral North Dakota, USA. Data from this study included near-surface (0-5 cm) measurements of soil physical, chemical, and biological properties over a 3-yr period for contrasting long-term experimental treatments at the USDA-ARS Northern Great Plains Research Laboratory, Mandan, North Dakota. Soil profile (0-100 cm) assessments of soil physical and chemical properties complemented near-surface measurements. Data were used to generate soil quality index scores using the Soil Management Assessment Framework. Annual spring wheat grain yields for experimental treatments complemented soils data. Similar evaluations were conducted on six on-farm sites in Emmons County, North Dakota, USA, but only for one year and without grain yield data. Data may be used to better understand soil property responses to cropland conservation practices and different land uses. Data are generally applicable to rainfed conditions under a semiarid Continental climate for Temvik-Wilton silt loams (fine silty, mixed, superactive, frigid Typic and Pachic Haplustolls) and associated soil types (i.e., Grassna, Linton, Mandan, and Williams).

Resources in this dataset:

Resource Title: SES_Data Dictionary.

File Name: SES_Data Dictionary.xlsx

Resource Title: SES_On-Farm_Integrative Measures_SMAF.

File Name: SES_On-Farm_Integrative Measures_SMAF.xlsx

Resource Title: SES_On-Farm_Soil Properties_Near Surface.

File Name: SES_On-Farm_Soil Properties_Near Surface.xlsx

Resource Title: SES_On-Farm_Soil Properties_Profile.

File Name: SES_On-Farm_Soil Properties_Profile.xlsx

Resource Title: SES_On Station_Integrative Measures_Crop Yield.

File Name: SES_On-Station_Integrative Measures_Crop Yield.xlsx

Resource Title: SES_On-Station_Integrative Measures_SMAF.

File Name: SES_On-Station_Integrative Measures_SMAF.xlsx

Resource Title: SES_On-Station_Soil Properties_Near Surface.

File Name: SES_On-Station_Soil Properties_Near Surface.xlsx

Resource Title: SES_On-Station_Soil Properties_Profile.

File Name: SES_On-Station_Soil Properties_Profile.xlsx

Resource Title: On-Farm_SMAF.

File Name: SES_On-Farm_Integrative Measures_SMAF.csv

Resource Title: On-Farm_SMAF_Metadata.

File Name: SES_On-Farm_Integrative Measures_SMAF_Metadata.csv

Resource Title: On-Farm_Surface.

File Name: SES_On-Farm_Soil Properties_Near Surface.csv

Resource Title: On-Farm_Surface_Metadata.

File Name: SES_On-Farm_Soil Properties_Near Surface_Metadata.csv

Resource Title: On-Farm_Profile.

File Name: SES_On-Farm_Soil Properties_Profile.csv

Resource Title: On-Farm_Profile_Metadata.

File Name: SES_On-Farm_Soil Properties_Profile_Metadata.csv

Resource Title: On-Station_Crop Yield.

File Name: SES_On-Station_Integrative Measures_Crop Yield.csv

Resource Title: On-Station_Crop Yield_Metadata.

File Name: SES_On-Station_Integrative Measures_Crop Yield_Metadata.csv

Resource Title: On-Station_SMAF.

File Name: SES_On-Station_Integrative Measures_SMAF.csv

Resource Title: On-Station_SMAF_Metadata.

File Name: SES_On-Station_Integrative Measures_SMAF_Metadata.csv

Resource Title: On-Station_Surface.

File Name: SES_On-Station_Soil Properties_Near Surface.csv

Resource Title: On-Station_Surface_Metadata.

File Name: SES_On-Station_Soil Properties_Near Surface_Metadata.csv

Resource Title: On-Station_Profile.

File Name: SES_On-Station_Soil Properties_Profile.csv

Resource Title: On-Station_Profile_Metadata.

File Name: SES_On-Station_Soil Properties_Profile_Metadata.csv

Resource Title: SES_Data Dictionary.

File Name: SES_Data Dictionary.csv
Organization: Department of Agriculture
Last updated: 2024-04-10T09:13:18.763553
Tags: ars, data-gov, long-term-research, northern-great-plains, np216, on-farm-research, soil-biological-properties, soil-chemical-properties, soil-management-assessment-framework, soil-physical-properties, soil-quality

Tables

SES Data Dictionary

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_data_dictionary

18.46 kB
997 rows
26 columns

CREATE TABLE ses_data_dictionary (
  "spreadsheet_tab" VARCHAR,
  "element_or_value_display_name" VARCHAR,
  "description" VARCHAR,
  "data_type" VARCHAR,
  "character_length" DOUBLE,
  "acceptable_values" VARCHAR,
  "required" VARCHAR  -- Required?,
  "accepts_null_value" VARCHAR  -- Accepts Null Value?,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25
);

SES On-Farm Integrative Measures SMAF Metadata

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_farm_integrative_measures_smaf_metadata

3.6 kB
21 rows
3 columns

CREATE TABLE ses_on_farm_integrative_measures_smaf_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR
);

SES On-Farm Soil Properties Near Surface

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_farm_soil_properties_near_surface

18.44 kB
24 rows
24 columns

CREATE TABLE ses_on_farm_soil_properties_near_surface (
  "study" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "site" VARCHAR,
  "land_use" VARCHAR,
  "rep" BIGINT,
  "depth" VARCHAR,
  "por" DOUBLE,
  "sorp" DOUBLE,
  "awhc" DOUBLE,
  "wsa" DOUBLE,
  "vess" BIGINT,
  "ph" DOUBLE,
  "slan" DOUBLE,
  "cec" DOUBLE,
  "urease" DOUBLE,
  "phos" DOUBLE,
  "bglu" DOUBLE,
  "tfame" DOUBLE,
  "bacsum" DOUBLE,
  "funsum" DOUBLE,
  "no3n" DOUBLE,
  "wfps" DOUBLE,
  "toc" DOUBLE
);

SES On-Farm Soil Properties Near Surface Metadata

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_farm_soil_properties_near_surface_metadata

3.79 kB
24 rows
3 columns

CREATE TABLE ses_on_farm_soil_properties_near_surface_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR
);

SES On-Farm Soil Properties Profile

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_farm_soil_properties_profile

23.72 kB
144 rows
24 columns

CREATE TABLE ses_on_farm_soil_properties_profile (
  "study" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "site" VARCHAR,
  "land_use" VARCHAR,
  "rep" BIGINT,
  "depth" VARCHAR,
  "sbd" VARCHAR,
  "ec" VARCHAR,
  "ph" VARCHAR,
  "wfps" VARCHAR,
  "no3n" VARCHAR,
  "nh4n" VARCHAR,
  "olsonp" VARCHAR,
  "toc" VARCHAR,
  "tn" VARCHAR,
  "cec" VARCHAR,
  "exca" VARCHAR,
  "exmg" VARCHAR,
  "exk" VARCHAR,
  "exna" VARCHAR,
  "s" VARCHAR,
  "si" VARCHAR,
  "c" VARCHAR
);

SES On-Farm Soil Properties Profile Metadata

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_farm_soil_properties_profile_metadata

3.67 kB
24 rows
3 columns

CREATE TABLE ses_on_farm_soil_properties_profile_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR
);

SES On-Station Integrative Measures Crop Yield

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_integrative_measures_crop_yield

5.96 kB
54 rows
7 columns

CREATE TABLE ses_on_station_integrative_measures_crop_yield (
  "study" VARCHAR,
  "ltexp" VARCHAR,
  "trt" VARCHAR,
  "land_use" VARCHAR,
  "year" BIGINT,
  "rep" BIGINT,
  "yield" VARCHAR
);

SES On-Station Integrative Measures Crop Yield Metadata

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_integrative_measures_crop_yield_metadata

3.2 kB
7 rows
3 columns

CREATE TABLE ses_on_station_integrative_measures_crop_yield_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR
);

SES On-Station Integrative Measures SMAF

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_integrative_measures_smaf

18.31 kB
72 rows
21 columns

CREATE TABLE ses_on_station_integrative_measures_smaf (
  "study" VARCHAR,
  "ltexp" VARCHAR,
  "trt" VARCHAR,
  "land_use" VARCHAR,
  "year" BIGINT,
  "rep" BIGINT,
  "depth" VARCHAR,
  "tocs" DOUBLE,
  "aggs" DOUBLE,
  "mbcs" DOUBLE,
  "pmns" DOUBLE,
  "phs" DOUBLE,
  "ps" DOUBLE,
  "qco2s" BIGINT,
  "sbds" DOUBLE,
  "ecs" DOUBLE,
  "awcs" DOUBLE,
  "bgs" DOUBLE,
  "ks" BIGINT,
  "wfpss" DOUBLE,
  "smafsqi" DOUBLE
);

SES On-Station Integrative Measures SMAF Metadata

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_integrative_measures_smaf_metadata

3.7 kB
21 rows
3 columns

CREATE TABLE ses_on_station_integrative_measures_smaf_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR
);

SES On-Station Soil Properties Near Surface

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_soil_properties_near_surface

23.14 kB
72 rows
25 columns

CREATE TABLE ses_on_station_soil_properties_near_surface (
  "study" VARCHAR,
  "ltexp" VARCHAR,
  "trt" VARCHAR,
  "land_use" VARCHAR,
  "year" BIGINT,
  "rep" BIGINT,
  "depth" VARCHAR,
  "sbd" DOUBLE,
  "por" DOUBLE,
  "sorp" DOUBLE,
  "awhc" DOUBLE,
  "wsa" DOUBLE,
  "vess" VARCHAR,
  "ph" DOUBLE,
  "slan" DOUBLE,
  "cec" DOUBLE,
  "urease" DOUBLE,
  "phos" DOUBLE,
  "bglu" DOUBLE,
  "tfame" DOUBLE,
  "bacsum" DOUBLE,
  "funsum" DOUBLE,
  "no3n" DOUBLE,
  "wfps" DOUBLE,
  "toc" VARCHAR
);

SES On-Station Soil Properties Near Surface Metadata

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_soil_properties_near_surface_metadata

3.8 kB
24 rows
3 columns

CREATE TABLE ses_on_station_soil_properties_near_surface_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR
);

SES On-Station Soil Properties Profile

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_soil_properties_profile

23.73 kB
144 rows
23 columns

CREATE TABLE ses_on_station_soil_properties_profile (
  "study" VARCHAR,
  "ltexp" VARCHAR,
  "trt" VARCHAR,
  "land_use" VARCHAR,
  "rep" BIGINT,
  "depth" VARCHAR,
  "sbd" DOUBLE,
  "ec" DOUBLE,
  "ph" DOUBLE,
  "wfps" DOUBLE,
  "no3n" DOUBLE,
  "nh4n" DOUBLE,
  "olsonp" DOUBLE,
  "toc" DOUBLE,
  "tn" DOUBLE,
  "cec" DOUBLE,
  "exca" DOUBLE,
  "exmg" DOUBLE,
  "exk" DOUBLE,
  "exna" DOUBLE,
  "s" BIGINT,
  "si" BIGINT,
  "c" BIGINT
);

SES On-Station Soil Properties Profile Metadata

@usgov.usda_gov_data_from_conservation_practices_induce_trade_bc6c9d1d.ses_on_station_soil_properties_profile_metadata

3.71 kB
23 rows
3 columns

CREATE TABLE ses_on_station_soil_properties_profile_metadata (
  "attribute" VARCHAR,
  "description" VARCHAR,
  "units" VARCHAR
);