Planning Info
Nutrient Management Data Dictionary
View Applications Data Description
Annual Cropping Data
Below table lists the fields and a brief description of the columns that show up in the Cropping Data dump report.
Total AcresDoubleacreTotal field acresCropping AcresDoubleacreAcres that can be cropped
Variable Name/Label | Data Type | Units | Description / Purpose |
Crop Year | Integer | year | Crop Year selected for the report, starts with prior year’s harvest and goes through crop year’s harvest. |
Farm Name | Text | Name of the farm | |
Is Farm Cafo | Text (Boolean) | Flagged “Yes” when farm is a CAFO (Concentrated Animal Feeding Operation) | |
SubFarm Name | Text | Subfarm name the field is part of, if specified | |
Field Name | Text | Name of the field | |
DNR Winter Approved | Text (Boolean) | Flagged “Yes” when the field has been approved for winter spreading by the DNR | |
Field Acres | Double | acre | Field acres as seen on the Fields tab |
Total Acres | Double | acre | Total field acres |
Cropping Acres | Double | acre | Acres in the field that can be cropped |
Winter Spreadable Acres (Non-CAFO) | Double | acre | Acres available for winter spreading in accordance with the 2015 590 |
Manure Spreadable Acres 25ft (CAFO) | Double | acre | The number of acres that manure can be spread on around the entire field. This is the area past the 25ft manure SWQMA restriction area |
Manure Prohibited Acres 25 ft (CAFO) | Double | acre | The number of acres that are prohibited from manure being spread on because they are within 25ft of a SWQMA |
SWQMA Spreadable Incorp/Inject Only Acres 25ft (CAFO) | Double | acre | The number of acres that can be spread on 25ft from a SWQMA in each field |
Manure Spreadable 100ft (CAFO) | Double | acre | The number of acres that manure can be spread on around the entire field. This is the area past the 100ft manure SWQMA restriction area |
Manure Prohibited Acres 100ft (CAFO) | Double | acre | The number of acres that are prohibited from manure being spread on because they are within 100ft of a SWQMA |
Winter Manure Spreadable Acres 100ft (CAFO) | Double | acre | The number of acres that manure can be spread on during the winter in each field |
County | Text | County where the field is located | |
Soil Series (predominant) | Text | Predominant soil series name | |
Soil Symbol (predominant) | Text | Predominant soil map unit symbol, used for nutrient recommendations | |
Soil Series (critical) | Text | Dominant Critical soil series name. This is the series name for most erosion prone soil map unit that covers at least 10% of the field. | |
SoilSymbol (critical) | Text | Dominant Critical soil map unit symbol. This is the most erosion prone soil map unit that covers at least 10% of the field. It is used for calculating soil loss and the P Index. | |
Slope | Double | percent | Slope steepness (%) of the dominant critical soil map unit from the point of origin of overland flow to the point where the slope decreases sufficiently for deposition to occur or to the point where runoff enters a defined channel (wet or dry) for the dominant critical soil map unit |
Slope Length | Double | feet | Distance (in ft) from the point of origin of overland flow to the point where the slope decreases sufficiently for deposition to occur or to the point where runoff enters a defined channel (wet or dry) for the dominant critical soil map unit |
Slope Length To Water | Double | feet | Length range (in ft) indicating the distance of the flow path or channel for runoff from the lower edge of the field to surface water. |
Slope To Water | Double | percent | Range of slope values indicating the % Slope of the flow path or channel for runoff from the lower edge of the field to surface water. |
SoilTexture | Text | Physical texture of soil such as silt loam, loam, clay etc. | |
Concentrated Flow Channel | Text (Boolean) | Flagged as “Yes” if there is a concentrated flow channel present on the field | |
Is Locked | Text (Boolean) | Flagged as “Yes” if the field is marked as “locked” on the Fields page | |
Field Notes | Text | This column is for information about a field that will be helpful to remember during the planning process. | |
NRestriction | Text | Soil characteristics that create a high potential for nitrate leaching to ground water. P – Indicates high permeability, R – Indicates any type of bedrock less than 20 inches from the surface, W – indicates an apparent water table less than 12 inches from the surface, + – Indicates the map unit may have multiple restrictions. | |
Cafo Manure Restriction | Text (Boolean) | Flagged when the field is in a CAFO and has a manure restriction | |
Cafo W Soil | Text (Boolean) | Flagged when the field is in a CAFO and has a W Soil present in the field | |
Cafo 303 (d) | Text (Boolean) | Flagged when the field is in a CAFO and has a 303 (d) restriction | |
Cafo SWQMA | Text (Boolean) | Flagged when the field is in a CAFO and is within 1000 ft from a lake or pond or within 300 ft of a river, stream, or conduit to a navigable water | |
SWQMA | Text (Boolean) | Flagged when the field is within 1000 ft from a lake or pond and 300 ft of a perennial stream or river | |
Drinking Water Well or Conduit to Groundwater (50 ft 590, 100 ft CAFO) | Text (Boolean) | Field level flag to identify whether the field has a drinking water well within 50 ft of its edge. For CAFOs, this flag extends to drinking water wells within 100 ft of the field edge. | |
Local Prohibition | Text (Boolean) | Flagged when the field has local prohibitions for winter applications set | |
Winter Slope | Text (Boolean) | Flagged when the field has slope restrictions for winter applications set | |
Feb/Mar Prohibition on Liquid Manure | Text (Boolean) | Flagged when the field has a prohibition on liquid manure in Feb/Mar | |
Public Well 100ft | Text (Boolean) | Flagged when a public well is within 100ft downslope of a field | |
Municipal Well 1000ft | Text (Boolean) | Flagged when a municipal well is within 1000ft downslope of a field | |
Irrigation Well (8 ft 590, 100 ft CAFO) | Text (Boolean) | Flagged when an irrigation well is within 8ft downslope of a field (590 farm) or 100ft downslope of a field (CAFO farm) | |
Tile Lines in Field | Text (Boolean) | Flagged when tile lines are present within the field | |
Sinkhole | Text (Boolean) | Flagged when a sink hole is within 200 ft downslope of a field | |
TileInlet | Text (Boolean) | Flagged when a tile Inlet is within 200 ft downslope of a field | |
Any Well within 300 ft | Text (Boolean) | Flagged when a well is within 300 ft downslope of a field | |
Frac Bed Rock | Text (Boolean) | Flagged when a fractured bedrock is within 200 ft downslope of a field | |
Other Conduit | Text (Boolean) | Flagged when there’s some other conduit to groundwater within 200 ft downslope of a field | |
Restriction Expln | Text | Application restriction explanations | |
Start Year | Integer | year | Rotation Start Year. This is the crop year that Snap-Plus will use as the start of the crop rotation sequence for calculating rotational soil loss, P Index, and P2O5 and K2O balances. |
Rot Length | Integer | year | Number of years in the crop rotation |
PBal Start Year | Integer | year | CAFO P Rotation start year. In CAFOs, a field with soil test P between 100 ppm and 200 ppm must use a crop rotation that starts no earlier than the prior year and is no longer than 4 years to meet both the P Index and P2O5 balance standards. If the SnapPlus rotation is set to a longer rotation or a rotation that starts earlier, the CAFO P Rotation needs to be reset before the compliance check is made. PBal Start Year has the reset CAFO P Rotation Start Year value, otherwise the value remains 0. |
PBal Rot Length | Integer | year | Length of the CAFO P Rotation |
Tillage Code | Text | String of tillage abbrv delimited by – for each crop year in a rotation | |
Rotation Code | Text | String of Crop abbrv delimited by – for each crop year in a rotation | |
Rot Avg Soil Loss | Double | ton/ac/yr | Rotation’s average Soil loss in tons/ac/yr as calculated by RUSLE2. |
Soil T | Double | ton/ac/yr | Tolerable Soil loss in tons/ac/yr |
SCI | Double | The Soil Conditioning Index (SCI) predicts the consequences of cropping system and tillage practices on soil organic matter in a field. A positive SCI indicates a cropping system that, if continued, is likely to result in increasing levels of soil organic matter. | |
Avg PI | Double | Rotation’s average P Index. The rotational P Index is an indicator of the amount of phosphorus leaving the field and being transported to surface water in runoff annually on average for the crop years in the rotation. | |
Annual Total PI | Double | Sum of Particulate PI and Soluble PI | |
Particulate PI | Double | P in eroded soil | |
Soluble PI | Double | Dissolved P from soil. This value includes all soluble PI components except for the frozen ground acute loss index | |
Acute Winter Loss PI | Double | Dissolved P from frozen soil manure | |
Bal P2O5 | Double | lb/ac | P2O5 Balance calculated as the sum of applications minus crop removal for the entire crop rotation |
Bal Target P2O5 | Double | lb/ac | P2O5 Balance target value for the rotation based on soil test P according to 590 or CAFO guidelines |
Bal K2O | Double | lb/ac | K2O Balance for the rotation |
Is Tiled | Text (Boolean) | Indicates if the field has a tile drainage system installed | |
Contour | Text (Boolean) | Indicates if the field is “No” contouring or is worked “On contour” or “Strip cropped” | |
Filter Strip | Text (Boolean) | Indicates if the field has “No/Edge/In-field” filter strips | |
PriorCrop | Text | Crop name for the crop year before the report’s year | |
Current Crop | Text | Crop name for the report’s crop year | |
Prior Tillage | Text | Tillage for the previous crop year | |
Prior Tillage Abbr | Text | Tillage abbreviation for the previous crop year | |
Tillage | Text | Tillage for the report’s crop year | |
Tillage Abbr | Text | Tillage abbreviation for the report’s crop year | |
Yield Goal | Text | Planned yield per acre | |
Soil Test Date | Text (Date) | Date Soil Test was performed. Soil test is the analysis of a soil sample to determine soil characteristics such as nutrient content, pH level. | |
Is Irrigated | Text (Boolean) | Indicates is the field is irrigated for the crop year | |
Soil Test AvgP | Double | ppm | Average soil test P in ppm for the field obtained by averaging P on soil test samples done on one soil test date |
Soil Test AvgK | Double | ppm | Average field soil test K in ppm for the field by averaging K on soil test samples done on one soil test date |
Soil Test AvgPH | Double | pH | Average field pH obtained by averaging pH on soil test samples done on soil test date |
Soil Test OM | Double | percent | Avg field organic matter in % calculated by averaging OM on soil test samples done on soil test date |
Lime Rec Target PH | Double | pH | Target pH for rotation, based on crop in rotations with highest target pH |
Lime Rec 65NI | Double | ton/ac | Recommended lime application rate in tons per acre using lime with a Neutralizing Index of 60-69 |
Lime Rec 85NI | Double | ton/ac | Recommended lime application rate in tons per acre using lime with a Neutralizing Index of 80-89 |
Crop Demand PK | Integer | A2809 P and K crop demand level (1-4) | |
Soil Interp P | Integer | A2809 soil test interpretation level for P: 0 is Very low, 1 is Low, 2 is Optimum, 3 is High, and 5 is Excessively high | |
Soil Interp K | Integer | A2809 soil test interpretation level for K: 0 is Very low, 1 is Low, 2 is Optimum, 3 is High, 4 is Very high, and 5 is Excessively high | |
Crop Removal P2O5 | Double | lb/ac | P2O5 Removal by crops for the rotation |
Crop Removal K2O | Double | lb/ac | K2O Removal by crops for the rotation |
Rec N | Double | lb/ac | UW-Extension recommendation to apply N in lb per acre |
Rec P2O5 | Double | lb/ac | UW-Extension Phosphorus (P) application recommendation in lb per acre P2O5 |
Rec K2O | Double | lb/ac | UW-Extension Potassium (K) recommendation in lb per acre K2O |
Adj Rec Note | Text | Notes on user adjustments to UW N, P2O5, and K2O recommendations | |
Adj Rec N | Double | lb/ac | Adjusted UW-Extension recommendation for N for the report’s crop year |
Adj Rec P2O5 | Double | lb/ac | Adjusted recommendation for P2O5 for the report’s crop year after taking into account prior year’s “banked” applications |
Adj Rec K2O | Double | lb/ac | Adjusted recommendation for K2O for the report’s crop year after taking into account prior year’s “banked” applications |
Total Credits N | Double | lb/ac | Total applications and credits for N for the crop year the report is run |
Total Credits P2O5 | Double | lb/ac | Total applications and credits for P2O5 for the crop year the report is run |
Total Credits K2O | Double | lb/ac | Total applications and credits for K2O for the crop year the report is run |
Over Under Adj UW Recs N | Double | lb/ac | Over or Under adjusted UW Recommendations for N (Total credits and applications N – Adjusted UW Rec for N) |
Over Under Adj UW Recs P2O5 | Double | lb/ac | Over or Under adjusted UW Recommendations for P2O5 (Total credits and applications P2O5 – Adjusted UW Rec for P2O5) |
Over Under Adj UW Recs K2O | Double | lb/ac | Over or Under adjusted UW Recommendations for K2O (Total credits and applications K2O – Adjusted UW Rec for K2O) |
Legume Credit N | Double | lb/ac | 1st and 2nd year legume credit if applicable |
CurrentYearManureCreditN | Double | lb/ac | N credit from manure applications for the crop year |
CurrentYearManureCreditP2O5 | Double | lb/ac | P2O5 credit from manure applications for the crop year |
CurrentYear ManureCreditK2O | Double | lb/ac | K2O credit from manure applications for the crop year |
CurrentYear FertilizerCreditN | Double | lb/ac | N from fertilizer applications for the crop year |
CurrentYear FertilizerCreditP2O5 | Double | lb/ac | P2O5 from fertilizer applications for the crop year |
CurrentYear FertilizerCreditK2O | Double | lb/ac | K2O from fertilizer applications for the crop year |
Previousmanure CreditN | Double | lb/ac | N credit from manure applications made in prior crop years (2nd and 3rd year manure credits) |
AnnualNotes | Text | Notes entered for the field for the report’s crop year | |
TotalRate SolidManure | Double | Total soild manure (lbs/acre or tons/acre) applied for the report’s crop year | |
Total Rate Liquid Manure | Double | Total liquid manure (gals/acre) applied for the report’s crop year | |
Manure Application Current Year 3 | Text | Flagged “Yes” if manure was applied three years prior to the report’s crop year | |
Manure Application Current Year 2 | Text | Flagged “Yes” if manure was applied two years prior to the report’s crop year | |
Manure Application Current Year 1 | Text | Flagged “Yes” if manure was applied one prior to the report’s crop year | |
Model Update Date | DateTime | Autogenerated DateTime stamp when last model run is completed. |
Applications Data
Below table lists the fields and a brief description of the columns that show up in the Applications Data dump report.
Variable Name/Label | Data Type | Units | Description / Purpose |
Crop Year | Integer | year | Crop Year for this data row |
Farm Name | Text | Name of the farm | |
Field Name | Text | Name of the field | |
Acres | Double | acres | Field size |
Slope | Double | percent | % value indicating the steepness of field slope |
N Res | Text | Soil characteristics that create a high potential for nitrate leaching to ground water. P – Indicates high permeability, R – Indicates any type of bedrock less than 20 inches from the surface, W – indicates an apparent water table less than 12 inches from the surface, + – Indicates the map unit may have multiple restrictions. If the field is in a CAFO, R may indicate that bedrock is within 24 inches of the surface and W indicates an apparent water table within 24 inches of the surface. | |
CAFO Manure Restriction | Text (Boolean) | Flagged if the field has a CAFO manure restriction | |
CAFO W Checked | Text (Boolean) | Flagged if the field is part of a CAFO plan and has a W-soil restriction | |
303 (d), ORW or ERW | Text (Boolean) | Flagged if the field is part of a CAFO plan and has a 303 (d), ORW, or ERW restriction | |
Prior Crop | Text | Crop grown during the year prior to the crop year for this data row | |
Planned Crop | Text | Crop grown in this data row’s crop year | |
Fertilizer Source | Text | Fertilizer type applied in the field during this data row’s crop year. There may be more than one fertilizer used in each year – each fertilizer, manure or lime application will have its own row. | |
Manure Source | Text | Manure/Wastewater source applied in the field for this data row’s crop year. There may be more than one manure used in each year – each fertilizer, manure or lime application will have its own row. | |
Lime Source | Text | Lime source applied in the field for this data row’s crop year. Each lime, manure and fertilizer application in a crop year on this field will have it’s own row. | |
Applied Acres | Double | Acres | Acres on which the application in this data row was applied. |
Application rate | Double | Rate of application for the fertilizer, manure, or lime material in this data row. | |
Total Applied | Double | Amount of fertilizer, manure, or lime material applied in this data row. | |
Rate Units | Text | For solid manure sources, the application units are ton/acre. For solid fertilizer sources, application units are lb/acre. For liquid fertilizer and manure sources, units are gallons/acre. For lime materials, the units are ton/acre. | |
Season | Text | Season the nutrient source is applied (Fall, Winter, Spring, or Summer). Grazing applications have two seasons, Grazing and Winter. | |
Spread Method | Text | Surface – Unincorporated, used for broadcast manure and fertilizer. Manure remains on surface for three or more days following application
Incorp – Incorporated by tillage, used for manure and fertilizer. Manure is mixed into the soil by some sort of tillage within three days following application Injected – Used for manure. No manure is left on the surface following application Subsurface – Used for fertilizer. Fertilizer is placed below the soil surface at planting or in bands Grazing – Manure is applied to the field by direct excretion from the animal |
|
Is Manure | Text | Flagged “Yes” if the applied nutrient source is a manure. Flagged “No” for fertilizer and lime applications | |
Season Notes | Text | Notes entered for the field for this data row’s crop year | |
N | Double | lbs/unit solid or lbs/1000 gallons | N Surface value for first year available nutrients |
P2O5 | Double | lbs/unit solid or lbs/1000 gallons | P2O5 value for first year available nutrients |
K2O | Double | lbs/unit solid or lbs/1000 gallons | K2O value for first year available nutrients |
DM Percent | Percent | Dry portion of animal feed |