mpca_feedlots - tt (t)| Field Name | Valid Values | Definition | Definition Source |
|---|
| OBJECTID | - | Internal feature number | ESRI |
| ITEM_ID | - | The unique ID that defines an item. master_ai_id + '-' + subject_item_category_code + subject_item_id | |
| AI_ID | - | Tempo database ID for the feedlot, agency_interest_id | |
| INT_DOC_ID | - | int_doc_id a Tempo database internal document ID - a zero value represents the master file, the master version of this feature that is shared by all MPCA's programs. | |
| SI_CAT | - | subject_item_category_code | |
| SI_ID | - | subject_item_id | |
| NAME | - | The name of the feedlot | |
| PROGRAM_LIST | - | A list of programs with activities at the feedlot | |
| status_fdlt | - | The active status of the feedlot. Note that a feedlot may be active but no longer have animals. | |
| ACTIVITY_REG | - | The activity ID for the most recent registration | |
| NUM_REG | - | The MPCA registration number | |
| CO_NUM_REG | - | The feedlot ID assigned by the county | |
| TITLE_REG | - | Title of the most recent registration document | |
| TYPE_REG | - | Activity type for the most recent registration document | |
| START_D_REG | - | The start date of the registration | |
| END_D_REG | - | The end date of the registration | |
| ACTIVE_REG | - | The active status of the registration. | |
| PERMIT_FLAG | - | Indicates whether there any permit documents for this feedlot. | |
| ACTIVITY_PER | - | The activity ID from the most recent permit document. | |
| NUM_PER | - | The permit number | |
| TITLE_PER | - | Title of the most recent permit | |
| TYPE_PER | - | Activity type for the most recent permit activity. Note that some of these are "No permit required" or "Permit termination". | |
| START_D_PER | - | Start date for the most recent permit. | |
| END_D_PER | - | End date for the most recent permit | |
| CAFO_FLAG | - | A 'Y' or 'N' value to identify whether this facility is considered a Concentrated Animal Feeding Operation (CAFO). | |
| OWNER | - | Name of owner | |
| PHONE_OWNER | - | Owner's Phone Number | |
| ADDR_M_OWNER | - | Owner's Mailing Address | |
| CITY_M_OWNER | - | Owner's City | |
| STATE_M_OWNER | - | Owner's State | |
| ZIP_M_OWNER | - | Owner's ZIP code | |
| CONTACT | - | Name of contact person | |
| PHONE_CONTACT | - | Phone number of contact person | |
| ADDR_M_CONTACT | - | The mailing address of the contact person | |
| CITY_M_CONTACT | - | The city of the contact person | |
| STATE_M_CONTACT | - | The state of the contact person | |
| ZIP_M_CONTACT | - | The ZIP code of the contact person | |
| ADDR_P_FEEDLOT | - | The physical address of the feedlot | |
| CITY_P_FEEDLOT | - | The physical city of the feedlot | |
| STATE_P_FEEDLOT | - | The physical state of the feedlot | |
| ZIP_P_FEEDLOT | - | The physical ZIP code of the feedlot | |
| COUNTY_CODE | - | FIPS county code for the county in which the feedlot is located- derived from feature location | |
| COUNTY_NAME | - | Name of the county in which the feedlot is located - derived from feature location | |
| CONG_DIST | - | Congressional district - derived from feature location | |
| HOUSE_DIST | - | MN house district - derived from feature location | |
| SENATE_DIST | - | MN senate district - derived from feature location | |
| HUC8 | - | USGS 8-digit watershed code - derived from feature location | |
| HUC8_NAME | - | Minnesota DNR's watershed name for USGS 8-digit watershed - derived from feature location | |
| huc10 | - | USGS 10-digit watershed code - derived from feature location | |
| huc10_name | - | Name for USGS 10-digit watershed - derived from feature location | |
| HUC12 | - | USGS 12-digit watershed code - derived from feature location | |
| HUC12_NAME | - | USGS 12-digit watershed name - derived from feature location | |
| DWSMA_CODE | - | MDH's drinking water source management area code - derived from feature location (comma-delimited list if multiple) | |
| DWSMA_NAME | - | MDH's drinking water source management area name - derived from feature location (comma-delimited list if multiple) | |
| LOC_DESC | - | Location description | |
| TRDSQQ | - | Public Land Survey - township, range, range direction, section quarter quarter section code - as reported in the Tempo application | |
| PLS_TOWNSHIP | - | Public Land Survey Township number | |
| RANGE | - | Public Land Survey range - as reported in the Tempo application | |
| RANGE_DIR | - | Public Land Survey range direction - as reported in the Tempo application | |
| SECTION | - | Public Land Survey section number | |
| QUARTERS | - | Public Land Survey Quarter(s) of the Section. a=NE, b=NW, c=SW, d=SE. "ac" means the SW quarter of the NE quarter. - as reported in the Tempo application | |
| LATITUDE | - | Latitude - geographic coordinates (WGS84) - decimal degrees | |
| LONGITUDE | - | Longitude - geographic coordinates (WGS84) - decimal degrees | |
| METHOD_CODE | - | Code for the method used to determine the coordinates for the feedlot. | |
| METHOD_DESC | - | Describes the method used to determine the coordinates for the feedlot. | |
| REF_CODE | - | Code for the coordinate reference point | |
| REF_DESC | - | Coordinate reference point - what do these coordinates represent? | |
| VERIFIED_FLAG | - | 'Y' or 'N' value to indicate whether this location been verified by MPCA staff? | |
| COLLECTION_DATE | - | Date on which the coordinates were collected. | |
| OPEN_LOT_FLAG | - | 'Y' or 'N' value to indicate whether this facility is considered an open lot. An uncovered lot intended for the confined feeding, breeding, raising, or holding of animals and specifically designed as a confinement area in which manure may accumulate, or where the concentration of animals is such that a vegetative cover cannot be maintained within the enclosure. | |
| BUILDING_FLAG | - | 'Y' or 'N' value to indicate whether this facility has buildings that are designed for animal confinement or as animal holding areas? | |
| PASTURE_FLAG | - | 'Y' or 'N' value to indicate whether animals are maintained on Pasture at any time during the year? | |
| LQ_STORE_FLAG | - | 'Y' or 'N' value to indicate whether the facility contains a liquid manure storage area. | |
| LQ_S_CLOSE_DATE | - | Liquid Manure Storage Area closure date | |
| SOL_STORE_FLAG | - | 'Y' or 'N' value to indicate whether the facility contains a manure stockpile (permanent solid manure storage area) | |
| SOL_S_COLS_DATE | - | Permanent Solid Manure Storage Area Closure Date | |
| RIVER_STREAM_FLAG | - | 'Y' or 'N' value to indicate whether there is a river/stream within 300 feet of the facility | |
| SHORELAND_FLAG | - | 'Y' or 'N' value to indicate whether the facility is located in Shoreland | |
| H_WELL_DISTANCE | - | Distance from Animal Holding Area to a Well (in feet) | |
| M_WELL_DISTANCE | - | Distance from Manure Storage Area to a Well (in feet) | |
| LAST_ANIMAL_DATE | - | Date Feedlot last had Animals | |
| WATERBODY_TYPE_CODE | - | Lists all surface water types that are within 1,000 feet of the facility: Calcareous Fen (CFEN), Creek (CREK), Ditch (DITC), Lake (LAKE), Pond (POND), River (RIVR), Stream (STRM), Tile Intake (TILE), Unknown (UNKW), Wetland (WELD) | |
| AU_COUNT | - | Number of total animals units on the premise/feedlot. An animal unit is a measure used to compare differences in the production of manure for an animal feedlot or manure storage area. Different animal unit calculation factors are applied based on the species and size of an animal. | |
| ANIMAL_COUNT | - | Total animal count: sum of all of the animal count fields. If 0 or blank, then this feedlot did not have animals the last time they reported to the MPCA. | |
| PRIMARY_STOCK | - | The primary type of animal at this feedlot | |
| BIRDS_AU | - | Number of animal units; any fowl, domesticated or game bird, of the Galliformes Order | |
| BOVINES_AU | - | Number of animal units; Cattle, Bison, or other animals in the Bovinae SubFamily | |
| DEERELK_AU | - | Number of animal units; Deer, Elk, or other animals in the Cervidae Family | |
| GOATSHEEP_AU | - | Number of animal units; Goats, Sheep or other animals of the Caprinae SubFamily | |
| HORSES_AU | - | Number of animal units; Horse, Donkey, Mule, or other animal of the Equidae Family | |
| LAMAALPAC_AU | - | Number of animal units; Llamas, Alpacas, or other animals in the Camelidae Family | |
| PIGS_AU | - | Number of animal units; Pigs, Hogs, Swine, or other animals in the Suidae Family | |
| OTHER_AU | - | Number of animal units; Foxes, Rabbits, Mink, and other unknown or unspecified species. | |
| CATTLE_DL | - | Dairy cattle less than 1000 pounds - actual number of animals | |
| HEIFER_D | - | Dairy cattle - heifers - actual number of animals | |
| CALF_D | - | Dairy cattle - calves - actual number of animals | |
| CATTLE_DB | - | Dairy cattle greater than 1000 pounds - actual number of animals | |
| STEER_B | - | Beef cattle - slaughter/stock - actual number of animals | |
| HEIFER_B | - | Beef cattle - feeder/heifer - actual number of animals | |
| COW_CALF_B | - | Beef cattle - cow/calf pairs - actual number of animals | |
| CALF_B | - | Beef cattle - calves - actual number of animals | |
| BULL_MATURE | - | Bulls - Actual number of animals | |
| VEAL_CALF | - | Veal calves - actual number of animals | |
| SWINE_BIG | - | Swine greater than 300 pounds - actual number of animals | |
| SWINE_MEDIUM | - | Swine 55-300 pounds - actual number of animals | |
| SWINE_LITTLE | - | Swine less than 55 pounds - actual number of animals | |
| HORSE | - | Horses - actual number of animals | |
| SHEEP | - | Sheep or lambs - actual number of animals | |
| CHX_LM | - | Chickens - liquid manure - actual number of animals | |
| CHX_B_BIG | - | Chickens - broilers greater than 5 pounds - actual number of animals | |
| CHX_B_LITTLE | - | Chickens - broilers less than 5 pounds - actual number of animals | |
| CHX_L_BIG | - | Chickens - layers greater than 5 pounds - actual number of animals | |
| CHX_L_LITTLE | - | Chickens - layers less than 5 pounds - actual number of animals | |
| TURKEY_BIG | - | Turkeys greater than 5 pounds - actual number of animals | |
| TURKEY_LITLE | - | Turkeys less than 5 pounds - actual number of animals | |
| DUCK | - | Ducks - dry manure - actual number of animals | |
| DUCK_LM | - | Ducks - liquid manure - actual number of animals | |
| ALPACAS | - | Alpacas - actual number of animals | |
| BISON | - | Bison/buffalo - actual number of animals | |
| CAMELS | - | Camels - actual number of animals | |
| DEER | - | Deer - actual number of animals | |
| DONKEY_MULE | - | Donkeys/mules - actual number of animals | |
| ELK | - | Elk - actual number of animals | |
| EMUS_OSTRICHES | - | Emus/ostriches - actual number of animals | |
| FOWL | - | Fowl - actual number of animals | |
| FOXES | - | Foxes - actual number of animals | |
| GEESE | - | Geese - actual number of animals | |
| GOATS | - | Goats - actual number of animals | |
| PONIES | - | Horses - mini horses/ponies - actual number of animals | |
| LLAMAS | - | Llamas - actual number of animals | |
| MINK | - | Mink - actual number of animals | |
| RABBITS | - | Rabbits - actual number of animals | |
| REINDEER_CARIBOU | - | Reindeer/caribou - actual number of animals | |
| bison_calf | - | Bison calf - actual number of animals | |
| peacocks | - | Peacocks - actual number of animals | |
| goats_small | - | Small goats - actual number of animals | |
| UNKNOWN | - | All other types of animals - actual number of animals | |
| AU_CAT_DL | - | Dairy cattle less than 1000 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 1) | |
| AU_HEF_D | - | Dairy cattle - heifers - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.7) | |
| AU_CALF_D | - | Dairy cattle - calves - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.2) | |
| AU_CAT_DB | - | Dairy cattle greater than 1000 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 1.4) | |
| AU_STEER_B | - | Beef cattle - slaughter/stock - animal units (number of animals multiplied by the conversion factor for this animal classification: 1) | |
| AU_HEF_B | - | Beef cattle - feeder/heifer - - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.7) | |
| AU_CWCAL_B | - | Beef cattle - cow/calf pairs - animal units (number of animals multiplied by the conversion factor for this animal classification: 1.2) | |
| AU_CALF_B | - | Beef cattle - calves - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.2) | |
| AU_BULL_MATURE | - | Bulls - Animal units: number of animals multiplied by the conversion factor for that animal classification: 1) | |
| AU_VEAL_CALF | - | Veal calves - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.2) | |
| AU_SWINE_B | - | Swine - greater than 300 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.4) | |
| AU_SWINE_M | - | Swine 55-300 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.3) | |
| AU_SWINE_L | - | Swine - less than 55 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.05) | |
| AU_HORSE | - | Horses - animal units (number of animals multiplied by the conversion factor for this animal classification: 1) | |
| AU_SHEEP | - | Sheep or lambs - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.1) | |
| AU_CHX_LM | - | Chickens - liquid manure - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.033) | |
| AU_CHX_BBIG | - | Chickens - broilers greater than 5 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.005) | |
| AU_CHX_BLITTLE | - | Chickens - broilers less than 5 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.003) | |
| AU_CHX_LBIG | - | Chickens - layers greater than 5 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.005) | |
| AU_CHX_LLITTLE | - | Chickens - layers less than 5 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.003) | |
| AU_TURK_BIG | - | Turkeys greater than 5 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.018) | |
| AU_TURK_LITTLE | - | Turkeys less than 5 pounds - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.005) | |
| AU_DUCK | - | Ducks - dry manure - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.01) | |
| AU_DUCK_LM | - | Ducks - liquid manure - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.01) | |
| AU_ALPACAS | - | Alpacas - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.15) | |
| AU_BISON | - | Bison/buffalo - animal units (number of animals multiplied by the conversion factor for this animal classification: 1) | |
| AU_CAMELS | - | Camels - animal units (number of animals multiplied by the conversion factor for this animal classification: 1) | |
| AU_DEER | - | Deer - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.15) | |
| AU_DONKEY_MULE | - | Donkeys/mules - animal units (number of animals multiplied by the conversion factor for this animal classification: 1) | |
| AU_ELK | - | Elk - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.7) | |
| AU_EMUS_OSTRICHES | - | Emus/ostriches - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.15) | |
| AU_FOWL | - | Fowl - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.003) | |
| AU_FOXES | - | Foxes - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.05) | |
| AU_GEESE | - | Geese - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.01) | |
| AU_GOATS | - | Goats - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.15) | |
| AU_PONIES | - | Horses - mini horses/ponies - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.4) | |
| AU_LLAMAS | - | Llamas - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.3) | |
| AU_MINK | - | Mink - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.002) | |
| AU_RABBITS | - | Rabbits - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.005) | |
| AU_REINDEER_CARIBOU | - | Reindeer/caribou - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.3) | |
| au_bison_calf | - | Bison calf - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.2) | |
| au_peacocks | - | Peacocks - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.01) | |
| au_goats_small | - | Small goats - animal units (number of animals multiplied by the conversion factor for this animal classification: 0.075) | |
| AU_UNKNOWN | - | All other types of animals - animal units (number of animals multiplied by the conversion factor for this animal classification: 1) | |
| category_fdlt | - | High-level categorization for this feedlot. Is it permitted, registered, not required to register, or inactive? | |
| type_fdlt | - | Mid-level categorization for this feedlot. Combines the feedlot category and, if registration is required, whether or not their registration is current. | |
| reg_required | - | Does the MPCA require this feedlot to register under Minnesota Rules Chapter 7020? A feedlot is required to register if it has at least 10 animal units in shoreland, or at least 50 animal units outside of shoreland. Some of MPCA's county partners also enter feedlots into our database that are not required to register by state rules, so there may be feedlots in this dataset that were not required to register with the MPCA. | |
| reg_current | - | Is the feedlot's registration up-to-date? Registration windows start every four years, and feedlots must register at least once within each window. The current window is 1/1/2018-12/31/2021 and the previous window was 1/1/2014 to 12/31/2017. Registrations are considered up-to-date if they happened on 1/1/2014 or later because there is still time to register in the current window. | |
| per_class | - | Class of the most recent permit | |
| per_active | - | Is there an effective permit at this feedlot? | |
| npdes_sds | - | Is the permit a NPDES permit or an SDS permit? NPDES is National Pollutant Discharge Elimination System - in other words, a permit issued under the federal Clean Water Act. SDS is State Disposal System - a permit issued under Minnesota statutes. A permit may be issued under both NPDES and SDS. | |
| Shape | - | Feature geometry | ESRI |