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 Air Quality System (AQS) database contains measurements of air pollutant concentrations from throughout the United States and its territories. The measurements include both criteria air pollutants and hazardous air pollutants.

Full Metadata This U.S. EPA Office of Air and Radiation (OAR) - Office of Air Quality Planning and Standards (OAQPS) web service contains the following air quality monitoring network point location layers: CO (carbon monoxide), Lead, Lead-TSP(LC) (lead, total suspended particulates, local conditions), Lead-PM10(LC) (lead, particluate matter up to 10um in size, local conditions), NO2 (nitrogen dioxide), Ozone, PM10 (particulate matter up to 10um in size), PM2.5 (particulate matter up to 2.5um in size), SO2 (sulfur dioxide), PM2.5 Chemical Speciation Network, IMPROVE (Interagency Monitoring of Protected Visual Environments), NATTS (National Air Toxics Trends Stations), NCORE (Multipollutant Monitoring Network). Layers are drawn at all scales. Security classification: Public. Access constraints: None. Use constraints: None. Please check sources, scale, accuracy, currency and other available information. Please confirm that you are using the most recent copy of both data and metadata. Acknowledgement of the EPA would be appreciated.

This GIS dataset contains points which depict air quality monitors within EPA's Air Quality System (AQS) monitoring network. This dataset is 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 GIS dataset includes monitor information and links to download historic air quality data at each monitor.

The AQS Data Mart is a database that contains all of the information from the AQS system. It is a storehouse of air quality information that allows users to make queries of unlimited quantities of data. The Data Mart also includes information from the EPA?s substance and facility registry systems.

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 web feature service contains _location and facility identification information from EPA's Facility Registry Service (FRS) for the subset of facilities that link to the Air Quality System (AQS). The AQS contains ambient air pollution data collected by EPA, State, Local, and Tribal air pollution control agencies from thousands of monitoring stations. 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 subset of FRS integrated facilities that link to monitoring stations once the AQS 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.

AQI data were downloaded for years 2008-2018 from https://aqs.epa.gov/aqsweb/airdata/download_files.html#Annual. Data were filtered to include only Clackamas, Multnomah, and Washington counties. Unhealthy, Very Unhealthy, and Hazardous fields were combined into a single field named Unhealthy for charting in the Regional Barometer application.

description: Air Quality Systems (AQS) 2011-2013 Design Value Data - as of October 1, 2015. A design value is a statistic that describes the air quality status of a given location relative to the level of the National Ambient Air Quality Standards (NAAQS).; abstract: Air Quality Systems (AQS) 2011-2013 Design Value Data - as of October 1, 2015. A design value is a statistic that describes the air quality status of a given location relative to the level of the National Ambient Air Quality Standards (NAAQS).

Ambient PM2.5 (particulate matter less than 2.5 microns) concentrations from the national ambient air quality monitoring networks stored in the Air Quality System (AQS).

KMZ files with the location of all the EPA ambient monitors with the ability to download data from within the description box.

Abstract

Dataset quality ***: High quality dataset that was quality-checked by the EIDC team

These are the standard time aggregations EPA calculates and stores (we do not have monthly data). All have data files grouped by parameter: Criteria Gases, and Particulates Each group has data listed by year, in reverse order, back to 1990.

Each table entry has the file name, linked to the file, the size of the (zipped) file, the number of data rows in the file, and the date the file was last modified. EPA will update these files twice per year; in the spring and fall (late May and November). Keep in mind, data collection agencies have up to 6 months to report their data.

The files are all comma separated text with a header. Each aggregate level has a different format.

Methodology

For site description data, each unique geographic location that contains monitors is called a "site" in AQS. Information about the geographic setting is store in the site record, which are presented here. A unique site is identified by the combination of state code, county code, and site number (within county). It can also be identified by the latitude and longitude.

For monitor description data, each parameter that is measured at a site is considered a "monitor" in AQS. (So a "monitor" does not necessarily correspond to a physical instrument/sampler.) AQS tracks administrative information about monitors including who operates them, the methods being used, the networks they belong to, etc. That information is available in this file. A unique monitor is identified by the combination of state code, county code, site number (within county), parameter code, and parameter occurrence code ("POC", used to differentiate when a parameter is measured more than once at a site).

For daily summary data, each daily summary file contains data for every monitor (sampled parameter) in our database for each day. These files are separated by parameter (or parameter group) to make the sizes more manageable.

This file will contain a daily summary record that is:

1) The aggregate of all sub-daily measurements taken at the monitor.

2) The single sample value if the monitor takes a single, daily sample (e.g., there is only one sample with a 24-hour duration). In this case, the mean and max daily sample will have the same value.

The daily summary files contain (at least) one record for each monitor that reported data for the given day. There may be multiple records for the monitor if:

• There are calculated sample durations for the pollutant. For example, PM2.5 is sometimes reported as 1-hour samples and EPA calculates 24-hour averages.

• There are multiple standards for the pollutant (q.v. pollutant standards).

• There were exceptional events associated with some measurements that the monitoring agency has or may request be excluded from comparison to the standard.

%3C!-- --%3E

Ambient Lead (Pb) concentrations from the national ambient air quality monitoring networks stored in the Air Quality System (AQS).

This United States Environmental Protection Agency (US EPA) feature layer represents monitoring site data, updated hourly concentrations and Air Quality Index (AQI) values for the latest hour received from monitoring sites that report to AirNow.Map and forecast data are collected using federal reference or equivalent monitoring techniques or techniques approved by the state, local or tribal monitoring agencies. To maintain "real-time" maps, the data are displayed after the end of each hour. Although preliminary data quality assessments are performed, the data in AirNow are not fully verified and validated through the quality assurance procedures monitoring organizations used to officially submit and certify data on the EPA Air Quality System (AQS).This data sharing, and centralization creates a one-stop source for real-time and forecast air quality data. The benefits include quality control, national reporting consistency, access to automated mapping methods, and data distribution to the public and other data systems. The U.S. Environmental Protection Agency, National Oceanic and Atmospheric Administration, National Park Service, tribal, state, and local agencies developed the AirNow system to provide the public with easy access to national air quality information. State and local agencies report the Air Quality Index (AQI) for cities across the US and parts of Canada and Mexico. AirNow data are used only to report the AQI, not to formulate or support regulation, guidance or any other EPA decision or position.About the AQIThe Air Quality Index (AQI) is an index for reporting daily air quality. It tells you how clean or polluted your air is, and what associated health effects might be a concern for you. The AQI focuses on health effects you may experience within a few hours or days after breathing polluted air. EPA calculates the AQI for five major air pollutants regulated by the Clean Air Act: ground-level ozone, particle pollution (also known as particulate matter), carbon monoxide, sulfur dioxide, and nitrogen dioxide. For each of these pollutants, EPA has established national air quality standards to protect public health. Ground-level ozone and airborne particles (often referred to as "particulate matter") are the two pollutants that pose the greatest threat to human health in this country.A number of factors influence ozone formation, including emissions from cars, trucks, buses, power plants, and industries, along with weather conditions. Weather is especially favorable for ozone formation when it’s hot, dry and sunny, and winds are calm and light. Federal and state regulations, including regulations for power plants, vehicles and fuels, are helping reduce ozone pollution nationwide.Fine particle pollution (or "particulate matter") can be emitted directly from cars, trucks, buses, power plants and industries, along with wildfires and woodstoves. But it also forms from chemical reactions of other pollutants in the air. Particle pollution can be high at different times of year, depending on where you live. In some areas, for example, colder winters can lead to increased particle pollution emissions from woodstove use, and stagnant weather conditions with calm and light winds can trap PM2.5 pollution near emission sources. Federal and state rules are helping reduce fine particle pollution, including clean diesel rules for vehicles and fuels, and rules to reduce pollution from power plants, industries, locomotives, and marine vessels, among others.How Does the AQI Work?Think of the AQI as a yardstick that runs from 0 to 500. The higher the AQI value, the greater the level of air pollution and the greater the health concern. For example, an AQI value of 50 represents good air quality with little potential to affect public health, while an AQI value over 300 represents hazardous air quality.An AQI value of 100 generally corresponds to the national air quality standard for the pollutant, which is the level EPA has set to protect public health. AQI values below 100 are generally thought of as satisfactory. When AQI values are above 100, air quality is considered to be unhealthy-at first for certain sensitive groups of people, then for everyone as AQI values get higher.Understanding the AQIThe purpose of the AQI is to help you understand what local air quality means to your health. To make it easier to understand, the AQI is divided into six categories:Air Quality Index(AQI) ValuesLevels of Health ConcernColorsWhen the AQI is in this range:..air quality conditions are:...as symbolized by this color:0 to 50GoodGreen51 to 100ModerateYellow101 to 150Unhealthy for Sensitive GroupsOrange151 to 200UnhealthyRed201 to 300Very UnhealthyPurple301 to 500HazardousMaroonNote: Values above 500 are considered Beyond the AQI. Follow recommendations for the Hazardous category. Additional information on reducing exposure to extremely high levels of particle pollution is available here.Each category corresponds to a different level of health concern. The six levels of health concern and what they mean are:"Good" AQI is 0 to 50. Air quality is considered satisfactory, and air pollution poses little or no risk."Moderate" AQI is 51 to 100. Air quality is acceptable; however, for some pollutants there may be a moderate health concern for a very small number of people. For example, people who are unusually sensitive to ozone may experience respiratory symptoms."Unhealthy for Sensitive Groups" AQI is 101 to 150. Although general public is not likely to be affected at this AQI range, people with lung disease, older adults and children are at a greater risk from exposure to ozone, whereas persons with heart and lung disease, older adults and children are at greater risk from the presence of particles in the air."Unhealthy" AQI is 151 to 200. Everyone may begin to experience some adverse health effects, and members of the sensitive groups may experience more serious effects."Very Unhealthy" AQI is 201 to 300. This would trigger a health alert signifying that everyone may experience more serious health effects."Hazardous" AQI greater than 300. This would trigger a health warnings of emergency conditions. The entire population is more likely to be affected.AQI colorsEPA has assigned a specific color to each AQI category to make it easier for people to understand quickly whether air pollution is reaching unhealthy levels in their communities. For example, the color orange means that conditions are "unhealthy for sensitive groups," while red means that conditions may be "unhealthy for everyone," and so on.Air Quality Index Levels of Health ConcernNumericalValueMeaningGood0 to 50Air quality is considered satisfactory, and air pollution poses little or no risk.Moderate51 to 100Air quality is acceptable; however, for some pollutants there may be a moderate health concern for a very small number of people who are unusually sensitive to air pollution.Unhealthy for Sensitive Groups101 to 150Members of sensitive groups may experience health effects. The general public is not likely to be affected.Unhealthy151 to 200Everyone may begin to experience health effects; members of sensitive groups may experience more serious health effects.Very Unhealthy201 to 300Health alert: everyone may experience more serious health effects.Hazardous301 to 500Health warnings of emergency conditions. The entire population is more likely to be affected.Note: Values above 500 are considered Beyond the AQI. Follow recommendations for the "Hazardous category." Additional information on reducing exposure to extremely high levels of particle pollution is available here.

Ambient ozone concentrations for 2008 from the national ambient air quality monitoring networks stored in the Air Quality System (AQS).

Each daily summary file contains data for every monitor (sampled parameter) in our database for each day. This dataset shows Ozone at all monitoring locations throughout the year 2017.

Ambient concentrations of most requested pollutants from the national ambient air quality monitoring networks stored in the Air Quality System (AQS).

The Air Quality System (AQS) contains ambient air pollution data collected by EPA, state, local, and tribal air pollution control agencies from thousands of monitoring stations.

The Environmental Protection Agency (EPA) provides air pollution data about ozone and particulate matter (PM2.5) to CDC for the Tracking Network. The EPA maintains a database called the Air Quality System (AQS) which contains data from approximately 4,000 monitoring stations around the country, mainly in urban areas. Data from the AQS is considered the "gold standard" for determining outdoor air pollution. However, AQS data are limited because the monitoring stations are usually in urban areas or cities and because they only take air samples for some air pollutants every three days or during times of the year when air pollution is very high. CDC and EPA have worked together to develop a statistical model (Downscaler) to make modeled predictions available for environmental public health tracking purposes in areas of the country that do not have monitors and to fill in the time gaps when monitors may not be recording data. This data does not include "Percent of population in counties exceeding NAAQS (vs. population in counties that either meet the standard or do not monitor PM2.5)". Please visit the Tracking homepage for this information.View additional information for indicator definitions and documentation by selecting Content Area "Air Quality" and the respective indicator at the following website: http://ephtracking.cdc.gov/showIndicatorsData.action

The Katrina Air Quality System (AQS) contains records specific to the Katrina/Rita Emergency Response and provides this data to the Environmapper application.