Related Topics:
Table Name: V_ICIS_FACILITY_CAFO
Description: A summary table containing Concentrated Animal Feeding Operations (CAFOs) information. CAFOs are agricultural operations where animals are kept and raised in confined situations. Manure and wastewater from CAFOs have the potential to contribute pollutants such as nitrogen and phosphorus, organic matter, sediment, pathogens, heavy metals, hormones, antibiotics, and ammonia to the environment. Animal waste can enter water bodies from spills or breaks of waste storage structures, due to accidents or excessive rain, and non-agricultural application of manure to crop land. The NPDES program regulates the discharge of pollutants from CAFOs to waters of the United States.
Columns:
- ACTIVITY_ID
- ANIMAL_TYPE_DESC
- ANIMAL_TYPE_OTHER
- BMP_DESC
- BMP_OTHER
- CAFO_ANIMAL_FACILITY_FLAG
- CAFO_CLASSIFICATION_DESC
- CAFO_REASON_TEXT
- CITY
- CONTAINMENT_CAPACITY
- CONTAINMENT_TYPE_DESC
- CONTAINMENT_TYPE_OTHER
- COUNTY_NAME
- DAYS_OF_STORAGE
- DESIGNATION_DATE
- EMS_DEVELOPED_DATE
- EMS_FLAG
- EMS_LAST_UPDATED_DATE
- FACILITY_NAME
- GEOCODE_LATITUDE
- GEOCODE_LONGITUDE
- ICIS_FACILITY_INTEREST_ID
- LAND_AVAILABLE
- LEGAL_DESC
- LIQUID_MANURE_GENERATED_AMT
- LIQUID_MANURE_TRANSFERRED_AMT
- LIVESTOCK_AUTHORIZED_CAPACITY
- LIVESTOCK_DETERMIN_CAPACITY
- LIVESTOCK_MAX_CAPACITY
- LOCATION_ADDRESS
- NAICS_CODE
- NAICS_DESC
- NMBR_OF_ACRES_DRAINAGE
- NMP_DEVELOPED_DATE
- NMP_FLAG
- NMP_LAST_UPDATED_DATE
- OPEN_CONFINEMENT_COUNT
- PERM_CAFO_ANIMAL_TYPE_ID
- PERM_CAFO_BMP_ID
- PERM_CAFO_CONTAINMENT_ID
- PERM_CAFO_ID
- PERM_CAFO_STORAGE_TYPE_ID
- PGM_SYS_ID
- PRODUCTION_AREA_SIZE
- SIC_CODE
- SIC_DESC
- SOLID_MANURE_GENERATED_AMT
- SOLID_MANURE_TRANSFERRED_AMT
- STATE_CODE
- STATE_DESC
- STORAGE_TYPE_DESC
- STORAGE_TYPE_OTHER
- SUPPLEMENTAL_ADDRESS_TEXT
- TOTAL_CAPACITY_MEASURE
- TOTAL_NMBR
- UNDER_ROOF_CONFINEMENT_COUNT
- ZIP
Other Data Resources available for ICIS.
Envirofacts Data Service API for V_ICIS_FACILITY_CAFO: Envirofacts has developed a RESTful data service API to all of its internal data holdings. This functionality provides a user of Envirofacts with the ability to query any table through the use of a URL. The default output is in XML, which can be utilized in other applications, as well as tools such as Microsoft Excel or Access. Output options of CSV and Excel can be requested in the URL. The entire Envirofacts database metadata is available online, so that all tables and columns within Envirofacts are documented. Having the table structures available in this manner makes most of Envirofacts data easily available through the service. More information is available on the Envirofacts Services page.
Below is a sample of the first 10 rows of data for the V_ICIS_FACILITY_CAFO table. The URL used to produce this output is:
https://data.epa.gov/efservice/V_ICIS_FACILITY_CAFO/ROWS/0:10/EXCEL