Soil organic carbon and nutrient dynamics in response to anaerobic digestate application to farm fields

Author(s): Sebastian Villarino, Marshall McDaniel, Megan Blauwet, Bryan Sievers, Lisa Sievers, Lisa Schulte, Fernando Miguez

Abstract:

This dataset documents a long-term, field-scale study of anaerobic digestate application on commercial croplands in eastern Iowa, USA. It includes detailed records of digestate composition, application rates, and timing, as well as soil test results collected over a 12-year period (2011–2023) from 14 agricultural fields. The dataset supports analysis of soil organic carbon (SOC), nutrient dynamics, and isotopic composition in response to digestate inputs. It contains 421 geo-referenced soil samples, digestate nutrient profiles, field management histories, and spatial boundaries. The data were collected as part of a collaborative effort between researchers at Iowa State University and Sievers Family Farms to evaluate the agronomic and environmental implications of integrating anaerobic digestion into row crop and livestock systems.

Funder: USDA NIFA

Award Title:

Consortium for Cultivating Human And Naturally reGenerative Enterprises: Grass2Gas

Award Number: 2020-68012-31824

Keywords:

anaerobic digestion, biogas, cattle, corn belt, manure

Project (Abbreviated name):

G2G_Villarino_digestate_field_application

Team: Grass2Gas

Geographic Location:

Region surrounding Glenora Feed Yard, near Stockton, Iowa.

Families:

Bovidae, Fabaceae, Poaceae

Species:

Bos taurus, Glycine max, Zea mays

Full Metadata:

G2G_Villarino_digestate_field_application Metadata v1.0.pdf (382.35 KB)

Data Mirror:

Data Table Column Names and Descriptions

Table name	Column name	Data type	Units	Column description
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	Glenora Feed Yard all parts 2011 2022 raw pkey	integer	dimensionless	A unique primary key for this table.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2011	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2012	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2013	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2014	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2015	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2016	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2017	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2018	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2019	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2020	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2021	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars 2022	float	NA	The total amount spent on this product in this year, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	amount dollars all years	float	NA	The total amount spent on this product across all years, in US dollars.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2011	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2012	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2013	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2014	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2015	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2016	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2017	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2018	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2019	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2020	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2021	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price 2022	float	NA	The amount quantity divided by the quantity for this part in this year.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	average price all years	float	NA	The total amount spent on this product divided quantity of this product fed to the cattle across all years, in US dollars per ton.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	part	string	NA	The product purchased.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	parts or service	string	NA	A grouping variable for distinguishing parts and services. This table only contains parts.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2011	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2012	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2013	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2014	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2015	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2016	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2017	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2018	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2019	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2020	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2021	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity 2022	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	quantity all years	float	ton	The total quantity of this product fed to the cattle across all years, in tons.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2011	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2012	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2013	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2014	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2015	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2016	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2017	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2018	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2019	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2020	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2021	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent 2022	float	NA	The proportion of total sales in this year for this part.
data.Glenora_Feed_Yard_all_parts_2011_2022_raw	sales percent all years	float	NA	The proportion of total sales for this part across all years.
data.cattle_feed_2011_2022_raw	amount dollars 2011	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2012	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2013	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2014	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2015	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2016	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2017	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2018	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2019	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2020	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2021	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	amount dollars 2022	float	NA	The total amount spent on this product in this year, in US dollars.
data.cattle_feed_2011_2022_raw	cattle feed	string	NA	The cattle feed or feed additive.
data.cattle_feed_2011_2022_raw	cattle feed 2011 2022 raw pkey	integer	dimensionless	A unique primary key for this table.
data.cattle_feed_2011_2022_raw	parts or service	string	NA	A grouping variable for distinguishing parts and services. This table only contains parts.
data.cattle_feed_2011_2022_raw	quantity tons 2011	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2012	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2013	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2014	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2015	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2016	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2017	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2018	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2019	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2020	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2021	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.cattle_feed_2011_2022_raw	quantity tons 2022	float	ton	The amount of this product fed in this year. All units are tons unless noted otherwise in the 'cattle_feed' column.
data.dataset_digestate_inputs_T1	Ci Mg ha	float	tonnePerHectare	Cumulative digestate carbon input
data.dataset_digestate_inputs_T1	Ci liq	float	tonnePerHectare	Cumulative carbon input from liquid digestate
data.dataset_digestate_inputs_T1	Ci sol	float	tonnePerHectare	Cumulative carbon input from solid digestate
data.dataset_digestate_inputs_T1	Date T1	dateTime	YYYY-MM-DD	The date used as the T1 timestep for this field.
data.dataset_digestate_inputs_T1	Date T2	dateTime	YYYY-MM-DD	The date used as the T2 timestep for this field.
data.dataset_digestate_inputs_T1	Fnum	string	NA	The number assigned to this field by ISU researchers.
data.dataset_digestate_inputs_T1	Ki Mg ha	float	tonnePerHectare	Cumulative digestate potassium input
data.dataset_digestate_inputs_T1	Ni Mg ha	float	tonnePerHectare	Cumulative digestate nitrogen input
data.dataset_digestate_inputs_T1	Ni liq	float	tonnePerHectare	Cumulative nitrogen input from liquid digestate
data.dataset_digestate_inputs_T1	Ni sol	float	tonnePerHectare	Cumulative nitrogen input from solid digestate
data.dataset_digestate_inputs_T1	Pi Mg ha	float	tonnePerHectare	Cumulative digestate phosphorus input
data.dataset_digestate_inputs_T1	dataset digestate inputs T1 pkey	integer	dimensionless	A unique primary key for this table.
data.dataset_digestate_inputs_T1_T2	Ci Mg ha	float	tonnePerHectare	Cumulative digestate carbon input
data.dataset_digestate_inputs_T1_T2	Ci liq	float	tonnePerHectare	Cumulative carbon input from liquid digestate
data.dataset_digestate_inputs_T1_T2	Ci sol	float	tonnePerHectare	Cumulative carbon input from solid digestate
data.dataset_digestate_inputs_T1_T2	Date T1	dateTime	YYYY-MM-DD	The date used as the T1 timestep for this field.
data.dataset_digestate_inputs_T1_T2	Date T2	dateTime	YYYY-MM-DD	The date used as the T2 timestep for this field.
data.dataset_digestate_inputs_T1_T2	Fnum	string	NA	The number assigned to this field by ISU researchers.
data.dataset_digestate_inputs_T1_T2	Ki Mg ha	float	tonnePerHectare	Cumulative digestate potassium input
data.dataset_digestate_inputs_T1_T2	Ni Mg ha	float	tonnePerHectare	Cumulative digestate nitrogen input
data.dataset_digestate_inputs_T1_T2	Ni liq	float	tonnePerHectare	Cumulative nitrogen input from liquid digestate
data.dataset_digestate_inputs_T1_T2	Ni sol	float	tonnePerHectare	Cumulative nitrogen input from solid digestate
data.dataset_digestate_inputs_T1_T2	Pi Mg ha	float	tonnePerHectare	Cumulative digestate phosphorus input
data.dataset_digestate_inputs_T1_T2	dataset digestate inputs T1 T2 pkey	integer	dimensionless	A unique primary key for this table.
data.dataset_digestate_inputs_T1_T3	Ci Mg ha	float	tonnePerHectare	Cumulative digestate carbon input
data.dataset_digestate_inputs_T1_T3	Ci liq	float	tonnePerHectare	Cumulative carbon input from liquid digestate
data.dataset_digestate_inputs_T1_T3	Ci sol	float	tonnePerHectare	Cumulative carbon input from solid digestate
data.dataset_digestate_inputs_T1_T3	Date T1	dateTime	YYYY-MM-DD	The date used as the T1 timestep for this field.
data.dataset_digestate_inputs_T1_T3	Date T2	dateTime	YYYY-MM-DD	The date used as the T3 timestep for this field. SHOULD THIS BE CHANGED TO T3?
data.dataset_digestate_inputs_T1_T3	Fnum	string	NA	The number assigned to this field by ISU researchers.
data.dataset_digestate_inputs_T1_T3	Ki Mg ha	float	tonnePerHectare	Cumulative digestate potassium input
data.dataset_digestate_inputs_T1_T3	Ni Mg ha	float	tonnePerHectare	Cumulative digestate nitrogen input
data.dataset_digestate_inputs_T1_T3	Ni liq	float	tonnePerHectare	Cumulative nitrogen input from liquid digestate
data.dataset_digestate_inputs_T1_T3	Ni sol	float	tonnePerHectare	Cumulative nitrogen input from solid digestate
data.dataset_digestate_inputs_T1_T3	Pi Mg ha	float	tonnePerHectare	Cumulative digestate phosphorus input
data.dataset_digestate_inputs_T1_T3	dataset digestate inputs T1 T3 pkey	integer	dimensionless	A unique primary key for this table.
data.dataset_field_ID_names_numbers	Field	string	NA	The name of this farm field.
data.dataset_field_ID_names_numbers	Fnum	string	NA	The number assigned to this field by ISU researchers.
data.dataset_field_ID_names_numbers	ID	string	NA	The ID code Pinnacle uses for this farm field.
data.dataset_field_ID_names_numbers	Notes	string	NA	Important notes about this field name.
data.dataset_field_ID_names_numbers	dataset field ID names numbers pkey	integer	dimensionless	A unique primary key for this table.
data.digestate_application_raw	Amonium N	float	percent	Nitrogen in the form of ammonium in the digestate
data.digestate_application_raw	C	float	percent	Carbon in the digestate
data.digestate_application_raw	Ca	float	NA	Calcium in the digestate
data.digestate_application_raw	Ci Mg ha	float	NA	Digestate carbon input
data.digestate_application_raw	Cu	float	NA	Copper in the digestate
data.digestate_application_raw	DM	float	percent	Dry matter of digestate
data.digestate_application_raw	Date ap	dateTime	YYYY-MM-DD	Date the digestate was applied.
data.digestate_application_raw	Date dig comp	dateTime	YYYY-MM-DD	Date of the digestate chemical analysis report
data.digestate_application_raw	Fe	float	NA	Iron in the digestate
data.digestate_application_raw	Fnum	string	NA	Field number
data.digestate_application_raw	K2O	float	percent	Potassium as potassium oxide in the digestate
data.digestate_application_raw	Ki Mg ha	float	NA	Digestate potassium input
data.digestate_application_raw	Manganese	float	NA	Manganese in the digestate
data.digestate_application_raw	Max rate	float	NA	Maximum allowable digestate application rates. Gallons per acre for liquid digestate and Mg per acre for solid digestate.
data.digestate_application_raw	Mg	float	NA	Magnesium in the digestate
data.digestate_application_raw	Moisture	float	percent	Digestate moisture
data.digestate_application_raw	N	float	percent	Total nitrogen in the digestate
data.digestate_application_raw	N Org	float	percent	Organic nitrogen in the digestate
data.digestate_application_raw	Na	float	NA	Sodium in the digestate
data.digestate_application_raw	Ni Mg ha	float	NA	Digestate nitrogen input
data.digestate_application_raw	P2O5	float	percent	Phosphorus as phosphorus pentoxide in the digestate
data.digestate_application_raw	Pi Mg ha	float	NA	Digestate phosphorus input
data.digestate_application_raw	Rate	float	NA	Application Rate
data.digestate_application_raw	Rate unit	string	NA	The units for the values listed in 'Max_rate' and 'Rate'.
data.digestate_application_raw	S	float	NA	Sulfur in the digestate
data.digestate_application_raw	Zinc	float	NA	Zinc in the digestate
data.digestate_application_raw	digestate application raw pkey	integer	dimensionless	A unique primary key for this table.
data.digestate_application_raw	type	string	NA	Liquid or solid digestate.
data.digester_sales_2013_2023_raw	amount dollars 2013	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2014	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2015	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2016	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2017	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2018	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2019	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2020	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2021	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2022	float	NA	The total amount received from this product in this year, in US dollars.
data.digester_sales_2013_2023_raw	amount dollars 2023 through nov 20	float	NA	The total amount received from this product in this year (through Nov 20), in US dollars.
data.digester_sales_2013_2023_raw	digester sales 2013 2023 raw pkey	integer	dimensionless	A unique primary key for this table.
data.digester_sales_2013_2023_raw	feed tons unless noted otherwise	string	NA	The organic waste product fed to the digester. If the units in the 'quantity' columns are not tons, the unit will also be listed here.
data.digester_sales_2013_2023_raw	parts or service	string	NA	A grouping variable for distinguishing parts and services. ARE SERVICES RECURRING "PARTS" IN THIS CONTEXT?
data.digester_sales_2013_2023_raw	quantity 2013	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2014	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2015	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2016	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2017	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2018	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2019	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2020	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2021	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2022	float	ton	The amount of this product received in this year. All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.digester_sales_2013_2023_raw	quantity 2023 through nov 20	float	ton	The amount of this product received in this year (through Nov 20). All units are tons unless noted otherwise in the 'feed_tons_unless_noted_otherwise' column.
data.off_farm_ag_waste_received_2011_2022_raw	off farm ag waste received 2011 2022 raw pkey	integer	dimensionless	A unique primary key for this table.
data.off_farm_ag_waste_received_2011_2022_raw	tons	float	ton	The total mass of off-farm agricultural waste the digester recieved in this year, in tons.
data.off_farm_ag_waste_received_2011_2022_raw	year	integer	number	The calendar year.
spatial.dataset_soil_tests	BD	float	percent	Soil bulk density
spatial.dataset_soil_tests	Ci Mg ha	float	tonnePerHectare	Cumulative digestate carbon input
spatial.dataset_soil_tests	Ci liq	float	tonnePerHectare	Cumulative carbon input from liquid digestate
spatial.dataset_soil_tests	Ci sol	float	tonnePerHectare	Cumulative carbon input from solid digestate
spatial.dataset_soil_tests	Ci sol prop	float	NA	Proportion of cumulative digestate carbon from solid digestate
spatial.dataset_soil_tests	Date T1	dateTime	YYYY-MM-DD	The sample date used for timestep T1.
spatial.dataset_soil_tests	Date T2	dateTime	YYYY-MM-DD	The sample date used for timestep T2.
spatial.dataset_soil_tests	Date T3	dateTime	YYYY-MM-DD	The sample date used for timestep T3.
spatial.dataset_soil_tests	Depth in	string	NA	The depth range of the soil core segment, in inches.
spatial.dataset_soil_tests	Field	string	NA	The name of the farm field from which the sample was taken. HOW DO THESE NAMES RELATE TO YOUR "OFFICIAL" NAMES?
spatial.dataset_soil_tests	Fines20	float	NA	Particles < 20 Î¼m
spatial.dataset_soil_tests	Fnum	string	NA	The number assigned to this field by ISU researchers.
spatial.dataset_soil_tests	ID	string	NA	The ID code Pinnacle uses for the farm field from which this sample was taken.
spatial.dataset_soil_tests	Ki Mg ha	float	tonnePerHectare	Cumulative digestate potassium input
spatial.dataset_soil_tests	Lab	string	NA	The laboratory that did the soil carbon/soil organic matter analysis
spatial.dataset_soil_tests	Ni Mg ha	float	tonnePerHectare	Cumulative digestate nitrogen input
spatial.dataset_soil_tests	Ni liq	float	tonnePerHectare	Cumulative nitrogen input from liquid digestate
spatial.dataset_soil_tests	Ni sol	float	tonnePerHectare	Cumulative nitrogen input from solid digestate
spatial.dataset_soil_tests	Pi Mg ha	float	tonnePerHectare	Cumulative digestate phosphorus input
spatial.dataset_soil_tests	Rec K2O lb	integer	poundPerAcre	Included in data from Pinnacle, presumed to be Potassium oxide recommendation, but was not used for this project
spatial.dataset_soil_tests	Rec Lime	float	NA	Included in data from Pinnacle, presumed to be Lime needs, but was not used for this project
spatial.dataset_soil_tests	Rec Lime 1	float	NA	Included in data from Pinnacle, presumed to be Lime needs, but was not used for this project
spatial.dataset_soil_tests	Rec Lime l	integer	poundPerAcre	Included in data from Pinnacle, presumed to be Lime needs, but was not used for this project
spatial.dataset_soil_tests	Rec P2O5 l	float	poundPerAcre	Included in data from Pinnacle, presumed to be Diphosphorus pentoxide recommendation, but was not used for this project
spatial.dataset_soil_tests	SOC SOM r	float	tonnePerHectare	Soil organic carbon to soil organic matter ratio
spatial.dataset_soil_tests	SOC p41	float	percent	Soil organic carbon percent using a conversion factor of 0.41 to convert soil organic matter to soil organic carbon
spatial.dataset_soil_tests	SOC p45	float	percent	Soil organic carbon percent
spatial.dataset_soil_tests	SOC p5	float	percent	Soil organic carbon percent using a conversion factor of 0.5 to convert soil organic matter to soil organic carbon
spatial.dataset_soil_tests	SOC p58	float	percent	Soil organic carbon percent using a conversion factor of 0.58 to convert soil organic matter to soil organic carbon
spatial.dataset_soil_tests	SOC stock41	float	NA	Soil organic carbon stock using a conversion factor of 0.41 to convert soil organic matter to soil organic carbon
spatial.dataset_soil_tests	SOC stock45	float	gramPerCentimeterCubed	Soil organic carbon stock
spatial.dataset_soil_tests	SOC stock5	float	NA	Soil organic carbon stock using a conversion factor of 0.5 to convert soil organic matter to soil organic carbon
spatial.dataset_soil_tests	SOC stock58	float	NA	Soil organic carbon stock using a conversion factor of 0.58 to convert soil organic matter to soil organic carbon
spatial.dataset_soil_tests	SOM p	float	percent	Soil organic matter percent
spatial.dataset_soil_tests	SON p	float	percent	Soil organic nitrogen percent
spatial.dataset_soil_tests	Soil BpH	float	NA	Buffer index
spatial.dataset_soil_tests	Soil CA pp	integer	milligramPerKilogram	Calcium, it was not used for this project
spatial.dataset_soil_tests	Soil CEC m	float	NA	Cation exchange capacity
spatial.dataset_soil_tests	Soil K ppm	integer	milligramPerKilogram	Soil test potassium determined by ammonium acetate extraction
spatial.dataset_soil_tests	Soil MG pp	integer	milligramPerKilogram	Magnesium, it was not used for this project
spatial.dataset_soil_tests	Soil P1 pp	integer	milligramPerKilogram	Soil test phosphorus determined by the Mehlich III method
spatial.dataset_soil_tests	Soil pH 1	float	NA	Acidity (pH)
spatial.dataset_soil_tests	T1 T2 yr	float	tonnePerHectare	Time elapsed between first (T1) and second (T2) soil sampling
spatial.dataset_soil_tests	T1 T3 yr	float	tonnePerHectare	Time elapsed between sample T1 and T3, in years.
spatial.dataset_soil_tests	Time factor	string	NA	Fields were sampled at three different times: first sampling time (T1), second sampling time (T2), and third sampling time (T3)
spatial.dataset_soil_tests	Time yr	float	tonnePerHectare	Time elapsed since the initial sampling date
spatial.dataset_soil_tests	cC	float	percent	Coarse Clay (1 - 6 Î¼m)
spatial.dataset_soil_tests	cS	float	percent	Coarse Sand (500 - 1000 Î¼m)
spatial.dataset_soil_tests	calendar date	dateTime	YYYY-MM-DD	The date the sample was taken.
spatial.dataset_soil_tests	clay	float	percent	The percent of the sample composed of clay.
spatial.dataset_soil_tests	d13C	float	percent	Delta carbon 13 isotope (VPDB)
spatial.dataset_soil_tests	d15N	float	percent	Delta nitrogen 15 isotope (Air)
spatial.dataset_soil_tests	fS	float	percent	Fine Sand (125 - 250 Î¼m)
spatial.dataset_soil_tests	fT	float	NA	Fine Silt (6 - 25 Î¼m)
spatial.dataset_soil_tests	fT2	float	dimensionless	Fine Silt 2 (6 - 20 Î¼m)
spatial.dataset_soil_tests	mS	float	percent	Medium Sand (250 - 500 Î¼m)
spatial.dataset_soil_tests	pkey	integer	dimensionless	A unique primary key for this table.
spatial.dataset_soil_tests	point ID	string	NA	Sample point identifier. The first part, before the point, contains the field code, and the second part, after the point, contains the sample point number.
spatial.dataset_soil_tests	sand	float	percent	The percent of the sample composed of sand.
spatial.dataset_soil_tests	silt	float	percent	The percent of the sample composed of silt.
spatial.dataset_soil_tests	vcS	float	percent	Very Coarse Sand (1000 - 2000 Î¼m)
spatial.dataset_soil_tests	vfS	float	percent	Very Fine Sand (50 - 125 Î¼m)
spatial.field_boundaries_pinnacle_raw	Dataset	dateTime	YYYY-MM-DD	Date
spatial.field_boundaries_pinnacle_raw	Field	string	NA	The name of this farm field.
spatial.field_boundaries_pinnacle_raw	Fnum	string	NA	The number assigned to this field by ISU researchers.
spatial.field_boundaries_pinnacle_raw	ID	string	NA	The ID code Pinnacle uses for this farm field.
spatial.field_boundaries_pinnacle_raw	pkey	integer	dimensionless	A unique primary key for this table.
spatial.soil_test_data_pinnacle_raw	Date	dateTime	YYYY-MM-DD	The date the sample was taken.
spatial.soil_test_data_pinnacle_raw	Field	string	NA	The name Pinnacle uses for the farm field from which the sample was taken. These have no relation to naming schemes in other tables.
spatial.soil_test_data_pinnacle_raw	ID	string	NA	The ID code Pinnacle uses for the farm field from which this sample was taken.
spatial.soil_test_data_pinnacle_raw	Name	string	NA	Synonymous with "Sample_ID"
spatial.soil_test_data_pinnacle_raw	Obj Id	string	NA	Appears to be a primary key unique within each "Field".
spatial.soil_test_data_pinnacle_raw	Product	string	NA	The type of spatial feature depicted. All features in this table are points.
spatial.soil_test_data_pinnacle_raw	Rec K2O lb	integer	poundPerAcre	Included in data from Pinnacle, presumed to be K2O fertilizer recomendation, but was not used for this project
spatial.soil_test_data_pinnacle_raw	Rec Lime	integer	poundPerAcre	Included in data from Pinnacle, presumed to be Lime needs, but was not used for this project
spatial.soil_test_data_pinnacle_raw	Rec Lime 1	float	poundPerAcre	Included in data from Pinnacle, presumed to be Lime needs, but was not used for this project
spatial.soil_test_data_pinnacle_raw	Rec Lime l	integer	poundPerAcre	Included in data from Pinnacle, presumed to be Lime needs, but was not used for this project
spatial.soil_test_data_pinnacle_raw	Rec P2O5 l	float	poundPerAcre	Included in data from Pinnacle, presumed to be P2O5 fertilizer recomendation, but was not used for this project
spatial.soil_test_data_pinnacle_raw	Sample ID	string	NA	A sample ID. Presumed to be unique.
spatial.soil_test_data_pinnacle_raw	Soil BpH	float	dimensionless	Buffer index
spatial.soil_test_data_pinnacle_raw	Soil CA pp	integer	milligramPerKilogram	Soil test calcium
spatial.soil_test_data_pinnacle_raw	Soil CEC m	float	NA	Cation exchange capacity
spatial.soil_test_data_pinnacle_raw	Soil K ppm	integer	milligramPerKilogram	Soil test potassium determined by ammonium acetate extraction
spatial.soil_test_data_pinnacle_raw	Soil MG pp	integer	milligramPerKilogram	Soil Test Magnesium
spatial.soil_test_data_pinnacle_raw	Soil OM	float	percent	Soil organic matter
spatial.soil_test_data_pinnacle_raw	Soil P1 pp	integer	milligramPerKilogram	Soil test phosphorus determined by the Mehlich III method
spatial.soil_test_data_pinnacle_raw	Soil pH 1	float	dimensionless	Soil pH
spatial.soil_test_data_pinnacle_raw	pkey	integer	dimensionless	A unique primary key for this table.