How to Create an Air Pollution Map Using ArcGIS Pro

Jeff Oppong


Air pollution occurs when harmful substances are released into the atmosphere, that affects the health of humans, other living organisms, and the environmental climate. These harmful substances may come as gases like carbon dioxide, ammonia, methane, chlorofluorocarbons, among many others, from sources like household combustion devices, motor vehicles, industries, forest fires, among many others.

Air pollution can lead to diseases, allergies, and even death of humans. 

What is clean air?

According to air quality activists, dry clean air should make up 78% nitrogen, 21% oxygen, and 1% other gases like argon, carbon dioxide, methane, hydrogen, helium, and more.

Air pollution

Air pollution alters the ideal clean air composition approved by air quality professionals. According to World Health Organization (WHO), 99% of the world population breathes air that exceeds the air quality index approved by WHO and contains high percentage of air pollutants, with low income and middle income nations suffering the most. 

Free weekly newsletter

Fill out your e-mail address to receive our newsletter!

One major subject that affects climate change is air pollution. Many of the actors of air pollution also cause greenhouse gas emissions.

Therefore, well-informed strategies and policies on air pollution provides a two-way mitigation for climate and health by lowering risks of diseases made available by air pollution as well as contributing to the short and long term mitigation of climate change.  

The advent of geospatial tools and technologies has provided a way of addressing air pollution that supports the many anti-air pollution strategies. This GIS tutorial outlines how to use ArcGIS Pro to map air pollution using data from the United States Environmental Protection Agency.

The figure below shows a summary of the methodological flow of the several geospatial tools employed in the study.

A black and white box and line diagram showing the methodology for mapping air pollution using ArcGIS Pro.
Figure 1: a summary of the methodological flow employed in mapping air pollution in ArcGIS Pro.

Accessing and cleaning air pollution Excel data

Screenshot showing the daily download page for the US EPA's air pollution website.
Figure 2: US Environmental Protection Agency (EPA) web interface of Outdoor air quality data.
  1. Access the “Download Daily Data” from the U.S. Environmental Protection Agency’s website. 
  2. From the web interface, set pollutant to “atmospheric particulate matter (PM 2.5)” and year to “2018.”
  3. Set geographic area to your desired US State and select “Get Data.”
  4. Click “Download CSV Spreadsheet.”
  5. Open the .CSV air quality Excel data. For the purposes of this tutorial, information on Daily mean PM 2.5 information, Daily AQI value, site name, site longitude, and site latitude will be of interest. 

To prepare the data for use in the ArcGIS Pro environment, follow the steps outlined below;

  • Select the “Site Name” column, click the “Data” tab and select “sort A to Z” to sort names from A to Z.
  • Click Sort. 
Screenshot showing how to sort in Excel.
Figure 3: Sorting in Excel from A to Z.

After sorting, we will classify the data in Excel based on “Site Name” by selecting our columns of interest.

During the classification process, the average of daily Air Quality Index (AQI) and PM values are estimated to represent their yearly information. 

  1. Select all the data in Excel. From the Data tab, select “subtotal.”
  2. Set “At each change in” option to Site Name and “Use function” to Average. 
  3. From the “Add subtotal to:” tab, select Daily AQI, Daily PM 2.5, Site Longitude, and site latitude. 
  4. Select Ok.
Screenshot showing how to calculate subtotal in Excel.
Figure 4: “Subtotal” in Excel.

The result is processed into a new tab 2. 

  1. Export the following results as shown in figure 5 into a new Excel sheet by copying and pasting their values. 

Considering that the averages of the Daily AQI and PM values are of interest to us, the spaces available for “Units” along the row showing average will be filtered.

Screenshot showing how to filter in Excel.
Figure 6: “Filter” in Excel.

To filter the “Unit” column:

  1. Select the “Unit” column.
  2. From the Data tab, select “Filter.”
  3. From the drop down arrow of the “Units” tab, unselect “select all” and select “blanks.”
  4. Export the results into a new Excel sheet and save in .CSV format for importing into the ArcGIS Pro environment. 

Importing US EPA Excel and boundary data into ArcGIS Pro

To access your desired US State or County data, go to the TIGER/Line® Shapefiles (

Screenshot showing how to create a new project in ArcGIS Pro.
Figure 6: Creating a new project in ArcGIS Pro.
  1. Open and create a new project in ArcGIS Pro.
  2. From the Map tab of the menu bar, select the “Add Data” icon. Navigate to the US State or county data to be imported.
  3. Click OK. 
  4. Repeat steps 2 and 3 to import US EPA Excel sheet data.
  5. Right-click on the imported Excel sheet data from the Table of Contents and select “Display X and Y data.”
  6. From the Display tab, set X field to “Site longitude” and Y field to “Site latitude.”
  7. Click “Ok” to display Excel data. 
Screenshot showing how to add XY in ArcGIS Pro.
Figure 7: Display XY Data in ArcGIS Pro.

Use the Inverse Distance Weighting (IDW) tool in ArcGIS Pro to perform spatial interpolation over the US EPA data.

Screenshot showing IDW in ArcGIS Pro.
Figure 9: IDW in ArcGIS Pro.
  1. Type and search IDW from the search box of the geoprocessing bar.
  2. Set “Input point features” to displayed EPA data.
  3. Set “Z value field” to PM_yearly.
  4. From the environments tab, set Processing Extent and Mask to US State or County boundary.
  5. Click “Run” to perform spatial interpolation for PM_yearly data.
Screenshot of the IDW GUI in ArcGIS Pro.
Figure 10: IDW Processing of PM_Yearly in ArcGIS Pro.

To perform spatial interpolation for AQI_Yearly in ArcGIS Pro;

  1. Set “Input point features” to displayed EPA data.
  2. Set “Z value field” to AQI_Yearly.
  3. From the environments tab, set Processing Extent and Mask to US State or County boundary.
  4. Click “Run” to perform spatial interpolation for AQI_yearly data.
Screenshot showing a map in ArcGIS Pro.
Figure 11: Air Quality Index (AQI) estimation for some parts of Delaware for 2018.

A graph can be created to study the relationship between the PM_Yearly and AQI_Yearly data.

  1. Right-click on the EPA Data displayed.
  2. From the drop down menu, select “Create graph.”
  3. Select “Scatter plot.”
Graph showing a trend line in line.
Figure 12: Trend line showing the relationship between atmospheric particulate matter (PM) and air quality index (AQI data), 2018.

More ArcGIS Pro tutorials

Photo of author
About the author
Jeff Oppong
Jeff Oppong holds a BSc in Geomatic Engineering and currently a graduate student at Hohai University in China, where he's studying MSc. Harbor, Coastal, and Offshore Engineering. Jeff is a prolific researcher and a GIS/Remote sensing expert who aspires to be a change-agent and a renowned Engineer. Jeff Oppong can be contacted via email