The Enforcement and Compliance History Online (ECHO) data sets have been compiled for access to larger sets of national data to ensure that ECHO meets your data retrieval needs: Resource Conservation and Recovery Act (RCRA) data sets for hazardous waste sites.

The AQS Data Mart is a database containing all of the information from AQS. It has every measured value the EPA has collected via the national ambient air monitoring program. It also includes the associated aggregate values calculated by EPA (8-hour, daily, annual, etc.). The AQS Data Mart is a copy of AQS made once per week and made accessible to the public through web-based applications. The intended users of the Data Mart are air quality data analysts in the regulatory, academic, and health research communities. It is intended for those who need to download large volumes of detailed technical data stored at EPA and does not provide any interactive analytical tools. It serves as the back-end database for several Agency interactive tools that could not fully function without it: AirData, AirCompare, The Remote Sensing Information Gateway, the Map Monitoring Sites KML page, etc.

AQS must maintain constant readiness to accept data and meet high data integrity requirements, thus is limited in the number of users and queries to which it can respond. The Data Mart, as a read only copy, can allow wider access.

The most commonly requested aggregation levels of data (and key metrics in each) are:

Sample Values (2.4 billion values back as far as 1957, national consistency begins in 1980, data for 500 substances routinely collected) The sample value converted to standard units of measure (generally 1-hour averages as reported to EPA, sometimes 24-hour averages) Local Standard Time (LST) and GMT timestamps Measurement method Measurement uncertainty, where known Any exceptional events affecting the data NAAQS Averages NAAQS average values (8-hour averages for ozone and CO, 24-hour averages for PM2.5) Daily Summary Values (each monitor has the following calculated each day) Observation count Observation per cent (of expected observations) Arithmetic mean of observations Max observation and time of max AQI (air quality index) where applicable Number of observations > Standard where applicable Annual Summary Values (each monitor has the following calculated each year) Observation count and per cent Valid days Required observation count Null observation count Exceptional values count Arithmetic Mean and Standard Deviation 1st - 4th maximum (highest) observations Percentiles (99, 98, 95, 90, 75, 50) Number of observations > Standard Site and Monitor Information FIPS State Code (the first 5 items on this list make up the AQS Monitor Identifier) FIPS County Code Site Number (unique within the county) Parameter Code (what is measured) POC (Parameter Occurrence Code) to distinguish from different samplers at the same site Latitude Longitude Measurement method information Owner / operator / data-submitter information Monitoring Network to which the monitor belongs Exemptions from regulatory requirements Operational dates City and CBSA where the monitor is located Quality Assurance Information Various data fields related to the 19 different QA assessments possible

Querying BigQuery tables

You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.epa_historical_air_quality.[TABLENAME]. Fork this kernel to get started.

Acknowledgements

Data provided by the US Environmental Protection Agency Air Quality System Data Mart.

The Environmental Protection Agency's Enforcement and Compliance History Online (ECHO) website provides customizable and downloadable information about environmental inspections, violations, and enforcement actions for EPA-regulated facilities related to the Clean Air Act, Clean Water Act, Resource Conservation and Recovery Act, and Safe Drinking Water Act. These data are updated weekly as part of the ECHO data refresh, and ECHO offers many user-friendly options to explore data, including: • Facility Search: ECHO information is searchable by varied criteria, including location, facility type, and compliance status. Search results are customizable and downloadable. • Comparative Maps and State Dashboards: These tools offer aggregated information about facility compliance status, regulatory agency compliance monitoring, and enforcement activity at the national and state level. • Bulk Data Downloads: One of ECHO’s most popular features is the ability to work offline by downloading large data sets. Users can take advantage of the ECHO Exporter, which provides summary information about each facility in comma-separated values (csv) file format, or download data sets by program as zip files.

This Map Image depicts the Level III and Level IV Ecoregions throughout the United States. The purpose of this map is to show Ecoregions that denote areas of general similarity in ecosystems and in the type, quality, and quantity of environmental resources. The intended audience is for the general public. There are two grouped layers in this map, Level III Ecoregions and Level IV Ecoregions. The first layer represents Level III Omernik Ecoregions. At Level III, the continental United States contains 104 regions whereas the conterminous United States has 84 (US Environmental Protection Agency, 2005). Level IV ecoregions are further subdivisions of Level III ecoregions. The second grouped layer represents Level IV Omernik Ecoregions. Level IV ecoregions are intended for large geographic extents (i.e. states, multiple counties, or river basins). Compilation of the level IV maps have been performed at 1:250,000 scale. For more information about Omernik ecoregions or to download ecoregion maps and GIS data, go to:http://www.epa.gov/wed/pages/ecoregions.htm. For additional information about this mapping service or to obtain the ecoregion data used to create the service, contact US EPA GIS Agency Central Support, esrisupport@epa.gov.

This map helps to highlight geographic areas and the extent to which they may be candidates for further review, including additional consideration, analysis, or outreach. Link: https://ejscreen.epa.gov/mapper/

Detailed Discharge Monitoring Report (DMR) data supporting effluent charts for one Clean Water Act discharge permit. Includes effluent parameters, amounts discharged and identified Clean Water Act permit limit exceedances. This service downloads tabular DMR and compliance data for one Clean Water Act discharge permit as a comma-separated text file.

The EPA Recovery Mapper is an Internet interactive mapping application that allows users to discover information about every American Recovery and Reinvestment Act (ARRA) award that EPA has funded for six programs. By integrating data reported by the recipients of Recovery Act funding and data created by EPA, this application delivers a level of transparency and public accessibility to users interested in EPA's use of Recovery Act monies. The application is relatively easy to use and builds on the same mapping model as Google, Bing, MapQuest and other commonly used mapping interfaces. EPA Recovery Mapper tracks each award made by each program and gives basic Quick Facts information for each award including award name, location, award date, dollar amounts and more. Data Summaries for each EPA program or for each state are provided displaying dollars for Total Awarded, Total Received (Paid), and Total Jobs This Quarter by Recovery for the latest quarter of data released by Recovery.gov. The data are reported to the government and EPA four times a year by the award recipients. The latest quarterly report will always be displayed in the EPA Recovery Mapper. In addition, the application provides many details about each award. Users will learn more about how to access and interpret these data later in this document. Data shown in the EPA Recovery Mapper are derived from information reported back to FederalReporting.gov from the recipients of Recovery Act funding. EPA reviews the recipient reported data and works with the recipients to correct the data when errors are found. Please note that the dollar amounts displayed at Recovery.gov may differ somewhat from the amounts in this application because EPA Recovery Mapper includes awards that EPA has funded for Superfund sites cleanups that were awarded by the US Army Corps of Engineers. Also, EPA Recovery Mapper also does not display awards for management and oversight and awards made to EPA's Inspector General which account for less than 1.4% of the Recovery Act funding that EPA has received.

EPA's Enforcement and Compliance History Online website to search for facilities in your community to assess their compliance with environmental regulations.

The Enforcement and Compliance History Online (ECHO) data sets have been compiled for access to larger sets of national data to ensure that ECHO meets your data retrieval needs: data from the Air Facility System (AFS) Data Set for Clean Air Act stationary sources previous to October 17, 2014.

This EPA GeoPlatform Online web map provides foundational map layers for the EPA AirData Air Quality Monitors web mapping application (https://epa.maps.arcgis.com/apps/webappviewer/index.html?id=5f239fd3e72f424f98ef3d5def547eb5).This web map contains points which depict air quality monitors within EPA's Air Quality System (AQS) monitoring network. The layers are updated weekly to reflect the most recent changes in the monitoring network. The monitors are generally operated by State, local, and tribal air pollution control agencies using procedures specified by the U.S. EPA. These agencies collect the data, quality assure it, and then submit it to the EPA Air Quality System (AQS). The layers include monitor information and links to download historic air quality data at each monitor.Layers in this web map show active and inactive monitors from these monitoring networks:CO - ActiveCO - InactiveLead - ActiveLead - InactiveLead - TSP(LC) - ActiveLead - TSP(LC) - InactiveLead - PM10(LC) - ActiveLead - PM10(LC) - InactiveNO2 - ActiveNO2 - InactiveOzone - ActiveOzone - InactivePM10 - ActivePM10 - InactivePM2.5 - NAAQS/AQI - ActivePM2.5 - NAAQS/AQI - InactivePM2.5 - Additional AQI - ActivePM2.5 - Additional AQI - InactiveSO2 - ActiveSO2 - InactivePM2.5 Chemical Speciation Network - ActivePM2.5 Chemical Speciation Network - InactiveIMPROVE (Interagency Monitoring of Protected Visual Environments) - ActiveIMPROVE (Interagency Monitoring of Protected Visual Environments) - InactiveNATTS (National Air Toxics Trends Stations) - ActiveNATTS (National Air Toxics Trends Stations) - InactiveNCORE (Multipollutant Monitoring Network) - ActiveNCORE (Multipollutant Monitoring Network) - InactiveNear Road - ActiveNear Road - InactivePAMS - ActivePAMS - InactiveAdditional layers are included to provide context:Nonattainment Areas:Lead, 2008Ozone, 2008Ozone, 1997PM10, 1987PM2.5, 2012PM2.5, 2006PM2.5, 1997SO2, 2010American Indian Reservations and Off-Reservation Trust LandsClass 1 areas under the Clean Air Act

This EnviroAtlas web service supports research and online mapping activities related to EnviroAtlas (https://www.epa.gov/enviroatlas). This web service includes layers depicting EnviroAtlas metrics at the block group level within each EnviroAtlas community. This dataset was produced by the US EPA to support research and online mapping activities related to EnviroAtlas. EnviroAtlas (https://www.epa.gov/enviroatlas) allows the user to interact with a web-based, easy-to-use, mapping application to view and analyze multiple ecosystem services for the contiguous United States. The dataset is available as downloadable data (https://edg.epa.gov/data/Public/ORD/EnviroAtlas) or as an EnviroAtlas map service. Additional descriptive information about each attribute in this dataset can be found in its associated EnviroAtlas Fact Sheet (https://www.epa.gov/enviroatlas/enviroatlas-fact-sheets).

This map service contains the Project Points layer, indicating the general location and type of projects conducted under the San Francisco Bay Water Quality Improvement Fund (SFBWQIF). SFBWQIF is a competitive grant program that is helping implement TMDLs to improve water quality, protect wetlands, and advance green development planning throughout the Bay Area. This service is incorporated in the San Francisco Bay Water Quality Improvement Fund Story Map, an interactive series of maps and QlikSense graphics highlighting the competitive grant program which supports projects to protect and restore San Francisco Bay. The application can be found on the EPA GeoPlatform at: "https://epa.maps.arcgis.com/apps/MapSeries/index.html?appid=db223d22741140b9b10baf7e91815271 "https://epa.maps.arcgis.com/apps/MapSeries/index.html?appid=db223d22741140b9b10baf7e91815271 The story map is also embedded in the following EPA web page:"https://www2.epa.gov/sfbay-delta/sf-bay-water-quality-improvement-fund-interactive-project-map"> https://www2.epa.gov/sfbay-delta/sf-bay-water-quality-improvement-fund-interactive-project-map

This EnviroAtlas dataset describes the block group population and the percentage of the block group population that has potential views of water bodies. A potential view of water is defined as having a body of water that is greater than 300m2 within 50m of a residential _location. The window views are considered "potential" because the procedure does not account for presence or directionality of windows in one's home. The residential locations are defined using the EnviroAtlas Dasymetric (2011/October 2015) map. This dataset was produced by the US EPA to support research and online mapping activities related to EnviroAtlas. This dataset was produced the US EPA to support research and online mapping activities related to EnviroAtlas. This dataset was produced the US EPA to support research and online mapping activities related to EnviroAtlas. EnviroAtlas (https://www.epa.gov/enviroatlas) allows the user to interact with a web-based, easy-to-use, mapping application to view and analyze multiple ecosystem services for the contiguous United States. The dataset is available as downloadable data (https://edg.epa.gov/data/Public/ORD/EnviroAtlas) or as an EnviroAtlas map service. Additional descriptive information about each attribute in this dataset can be found in its associated EnviroAtlas Fact Sheet (https://www.epa.gov/enviroatlas/enviroatlas-fact-sheets).

The Enforcement and Compliance History Online (ECHO) data sets have been compiled for access to larger sets of national data to ensure that ECHO meets your data retrieval needs: Integrated Compliance Information System (ICIS) data set for federal civil enforcement cases.

The US EPA Disaster Debris Recovery Tool is an interactive dataset that promotes the proper recovery, recycling, and disposal of disaster debris management for planners and emergency responders at the federal, state, tribal and local levels. The dataset include point vector data for over 20,000 composting facilities, demolition contractors, transfer stations, three types of landfills, and recycling facilities for construction and demolition materials, electronics, household hazardous waste, metals, tires, and vehicles in all 50 states as well as Puerto Rico and the U.S. Virgin Islands. These data are also available through https://epa.maps.arcgis.com/apps/webappviewer/index.html?id=2fec4eed18c140c8aa4bb0a74f207b65 web mapping service.

This EnviroAtlas dataset estimates green space along walkable roads. Green space within 25 meters of the road centerline is included and the percentage is based on the total area between street intersections. green space is defined as Trees & Forest, Grass & Herbaceous, Woody Wetlands, and Emergent Wetlands. In this metric, water is also included in green space. Green space provides valuable benefits to neighborhood residents and walkers by providing shade, improved aesthetics, and outdoor gathering spaces. This dataset was produced by the US EPA to support research and online mapping activities related to EnviroAtlas. This dataset was produced the US EPA to support research and online mapping activities related to EnviroAtlas. This dataset was produced the US EPA to support research and online mapping activities related to EnviroAtlas. EnviroAtlas (https://www.epa.gov/enviroatlas) allows the user to interact with a web-based, easy-to-use, mapping application to view and analyze multiple ecosystem services for the contiguous United States. The dataset is available as downloadable data (https://edg.epa.gov/data/Public/ORD/EnviroAtlas) or as an EnviroAtlas map service. Additional descriptive information about each attribute in this dataset can be found in its associated EnviroAtlas Fact Sheet (https://www.epa.gov/enviroatlas/enviroatlas-fact-sheets).

This EnviroAtlas dataset shows the approximate walking distance from a park entrance at any given location within the EnviroAtlas community boundary. The zones are estimated in 1/4 km intervals up to 1km then in 1km intervals up to 5km. Park entrances were included in this analysis if they were within 5km of the community boundary. This dataset was produced by the US EPA to support research and online mapping activities related to EnviroAtlas. EnviroAtlas (http://enviroatlas.epa.gov/EnviroAtlas) allows the user to interact with a web-based, easy-to-use, mapping application to view and analyze multiple ecosystem services for the contiguous United States. The dataset is available as downloadable data (https://edg.epa.gov/data/Public/ORD/EnviroAtlas) or as an EnviroAtlas map service. Additional descriptive information about each attribute in this dataset can be found in its associated EnviroAtlas Fact Sheet (http://enviroatlas.epa.gov/EnviroAtlas/DataFactSheets).

This downloadable data package consists of location and facility identification information from EPA's Facility Registry Service (FRS) for all sites that are available in the FRS individual feature layers. The layers comprise the FRS major program databases, including: Assessment Cleanup and Redevelopment Exchange System (ACRES) : brownfields sites ; Air Facility System (AFS) : stationary sources of air pollution ; ICIS-AIR (AIR) : stationary sources of air pollution; Bureau of Indian Affairs (BIA) : schools data on Indian land; Base Realignment and Closure (BRAC) facilities; Clean Air Markets Division Business System (CAMDBS) : market-based air pollution control programs; Comprehensive Environmental Response, Superfund Enterprise Management System (SEMS): hazardous waste sites; Integrated Compliance Information System (ICIS) : integrated enforcement and compliance information; National Compliance Database (NCDB) : Federal Insecticide, Fungicide, and Rodenticide Act (FIFRA) and the Toxic Substances Control Act (TSCA); National Pollutant Discharge Elimination System (NPDES) module of ICIS : NPDES surface water permits; Radiation Information Database (RADINFO) : radiation and radioactivity facilities; RACT/BACT/LAER Clearinghouse (RBLC) : best available air pollution technology requirements; Resource Conservation and Recovery Act Information System (RCRAInfo) : tracks generators, transporters, treaters, storers, and disposers of hazardous waste; Toxic Release Inventory (TRI) : certain industries that use, manufacture, treat, or transport more than 650 toxic chemicals; Emission Inventory System (EIS) : inventory of large stationary sources and voluntarily-reported smaller sources of air point pollution emitters; countermeasure (SPCC) and facility response plan (FRP) subject facilities; Electronic Greenhouse Gas Reporting Tool (E-GGRT) : large greenhouse gas emitters; Emissions and; Generation Resource Integrated Database (EGRID) : power plants. The Facility Registry Service (FRS) identifies and geospatially locates facilities, sites or places subject to environmental regulations or of environmental interest. Using vigorous verification and data management procedures, FRS integrates facility data from EPA's national program systems, other federal agencies, and State and tribal master facility records and provides EPA with a centrally managed, single source of comprehensive and authoritative information on facilities. This data set contains the FRS facilities that link to the programs listed above once the program data has been integrated into the FRS database. Additional information on FRS is available at the EPA website https://www.epa.gov/enviro/facility-registry-service-frs. Included in this package are a file geodatabase, Esri ArcMap map document and an XML file of this metadata record. Full FGDC metadata records for each layer are contained in the database.

This EnviroAtlas web service supports research and online mapping activities related to EnviroAtlas (https://www.epa.gov/enviroatlas). This web service includes layers depicting EnviroAtlas national metrics mapped at the 12-digit HUC within the conterminous United States. This dataset was produced by the US EPA to support research and online mapping activities related to EnviroAtlas. EnviroAtlas (https://www.epa.gov/enviroatlas) allows the user to interact with a web-based, easy-to-use, mapping application to view and analyze multiple ecosystem services for the contiguous United States. The dataset is available as downloadable data (https://edg.epa.gov/data/Public/ORD/EnviroAtlas) or as an EnviroAtlas map service. Additional descriptive information about each attribute in this dataset can be found in its associated EnviroAtlas Fact Sheet (https://www.epa.gov/enviroatlas/enviroatlas-fact-sheets).

Integrated Compliance Information System (ICIS) National Pollutant Discharge Elimination System (NPDES) Discharge Monitoring Report (DMR) data sets for Clean Water Act permitted dischargers.