UM Geospatial Digital Special Collections
gdsc

2022 US EPA Daily Summary PM 2.5 FRM/FEM Mass (88101)

Collections: Climate Change | Health Outcomes | Vulnerability
Citation: US Environmental Protection Agency (2022). 2022 US EPA Daily Summary PM 2.5 FRM/FEM Mass (88101) [gis dataset]. US Environmental Protection Agency. https://aqs.epa.gov/aqsweb/airdata/download_files.html. last updated: 2024-10-28 (update frequency: As Needed). Abstract: 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. Key words: EPA, particulate matter, PM 2.5, USA, daily, monitors
Name Description Type Units
state_code The FIPS code of the state in which the monitor resides. int4
county_code The FIPS code of the county in which the monitor resides. int4
site_num A unique number within the county identifying the site. int4
parameter_code The AQS code corresponding to the parameter measured by the monitor. varchar
poc "This is the ""Parameter Occurrence Code"" used to distinguish different instruments that measure the same parameter at the same site." varchar
latitude The monitoring site's angular distance north of the equator measured in decimal degrees. float8 decimal degrees
longitude The monitoring site's angular distance east of the prime meridian measured in decimal degrees. float8 decimal degrees
datum The Datum associated with the Latitude and Longitude measures. varchar
parameter_name The name or description assigned in AQS to the parameter measured by the monitor. Parameters may be pollutants or non-pollutants. varchar PM2.5 - Local Conditions
sample_duration The length of time that air passes through the monitoring device before it is analyzed (measured). So, it can represent an averaging time of many samples (for example, a 1-hour value may be the average of four one-minute samples collected during each quarter of the hour)., it represents an averaging period in the atmosphere (for example varchar
pollutant_standard A description of the ambient air quality standard rules used to aggregate statistics. (See description at beginning of document.) varchar
date_local The calendar date for the summary. All daily summaries are for the local standard day (midnight to midnight) at the monitor. date
units_of_measure The unit of measure for the parameter. QAD always returns data in the standard units for the parameter. Submitters are allowed to report data in any unit and EPA converts to a standard unit so that we may use the data in calculations. varchar micrograms/cubic meter (LC)
event_type Indicates whether data measured during exceptional events are included in the summary. A wildfire is an example of an exceptional event, it is something that affects air quality, but the local agency has no control over. No Events means no events occurred. Events Included means events occurred and the data from them is included in the summary. Events Excluded means that events occurred but data form them is excluded from the summary. Concurred Events Excluded means that events occurred but only EPA concurred exclusions are removed from the summary. If an event occurred for the parameter in question varchar
observation_count The number of observations (samples) taken during the day. int4
observation_percent The percent representing the number of observations taken with respect to the number scheduled to be taken during the day. This is only calculated for monitors where measurements are required (e.g., only certain parameters). float8
arithmetic_mean The average (arithmetic mean) value for the day. float8 micrograms/cubic meter (LC)
1st_max_value The highest value for the day. float8 micrograms/cubic meter (LC)
1st_max_hour The hour (on a 24-hour clock) when the highest value for the day (the previous field) was taken. int4 hour
aqi The Air Quality Index for the day for the pollutant, if applicable. int4 AQI index
method_code An internal system code indicating the method (processes, equipment) varchar
method_name A short description of the processes,equipment varchar
local_site_name The name of the site (if any) given by the State, local varchar
address The approximate street address of the monitoring site. varchar
state_name The name of the state where the monitoring site is located. varchar
county_name The name of the county where the monitoring site is located. varchar
city_name The name of the city where the monitoring site is located. This represents the legal incorporated boundaries of cities and not urban areas. varchar
cbsa_name The name of the core bases statistical area (metropolitan area) where the monitoring site is located. varchar
date_of_last_change The date the last time any numeric values in this record were updated in the AQS data system. date
Open Geospatial Consortium Standards: dynamic vector tiles | | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_nearest_neighbor(table=us_2022_daily_epa_pm25,lat=25.718,lng=-80.279,id=site_num)
Sponsors: