ArcGIS Living Atlas

Reveal demographic trends over time with American Community Survey layers in Living Atlas

ArcGIS Living Atlas of the World contains lots of the most popular American Community Survey estimates in the form of hosted feature layers whose values are updated annually. This past December, they were updated with the most recent 2015-2019 values. This is the first time that there have been two five-year periods since the 2010 Decennial Census. That means we can now make comparisons for specific states, counties, and tracts between the most recent 5-year period, 2015-2019, to 2010-2014, to reveal trends over time. It’s not a comparison between 2014 to 2019, but rather a comparison between the 60-month period of 2010-2014 to the 60-month period of 2015-2019.

For many of the ACS Living Atlas layers, there is now a corresponding 2010-2014 boundaries layer, symbolized using the same color ramp and breakpoints for a clear comparison.

Top layer card is the most recent vintage that is updated every year, bottom layer card is the corresponding 2010-2014 vintage.

The possibilities!

From displaying maps side-by-side, to creating informative pop-ups, to performing analysis, the possibilities are endless.

Display changes via configurable apps

The Compare as well as Swipe and Spyglass configurable apps are ideal for creating an interactive comparison that can easily be embedded in your story maps, dashboards, and hub sites. Here are two examples using the ACS Housing Units Occupancy layers that are symbolized to show the homeownership rate. We used the most recent boundaries layer, currently displaying 2015-2019 values, along with the corresponding 2010-2014 boundaries layer.

Interact with the two apps below to see changes in homeownership in Phoenix. The first one uses Compare app and the second uses Swipe.

Example using Compare App:

Example using Swipe App:

 

Show historical context in pop-ups

Using an Arcade capability called featureSetByPortalItem(), it’s possible to bring in attributes from another layer into your pop-ups without having to add that layer to your map. Our colleague Lisa Berry used this approach to create a pop-up that shows total population count for the two time periods in this map.

She even added additional expressions to calculate the percent change, and the conditional text of “increased” or “decreased.” Open the map and choose “Modify Map” at the top right to explore the Arcade expressions within the pop-up configuration. For more details about this technique, check out this blog.

Bring the two layers together for further analysis

Join the layers from the two time periods together to calculate change. This can be done with analysis credits in ArcGIS Online, however it’s much faster to do in ArcGIS Pro. Once you have computed the change, there are lots of next steps you can take. Symbolize your map by the change itself with a diverging color ramp, known as an above and below mapping style in ArcGIS Online, to show growth vs. decline. Create graphs and charts with this new attribute in Pro or in Insights. Select only the counties and tracts that have had a change above a critical value. Combine these layers with other data to add context to your work. We will be putting out more in-depth tutorials on these workflows in the coming year.

What should I keep in mind when making these comparisons?

Smoothing will hide fluctuations

The nature of pooling together 5 years’ worth of data is great for making data available for very fine geography levels for specific groups of people (e.g. children under 6 years old in the care of grandparents). One downside to the five-year estimates is the inherent smoothing effect it has on trends over time. Large fluctuations from year to year will not be apparent when comparing the two 5-year periods of 2010-2014 and 2015-2019. There are only two data points available over a combined 10-year period.

These values are estimates

All ACS data values are estimates based on responses from a sample of the population rather than a complete count. The Census Bureau encourages anyone making comparisons to pay attention to sampling error associated with the estimates. To help with interpreting the reliability of the estimates, the Census Bureau publishes a margin of error (MOE) for each and every ACS estimate. For the commonly-derived calculated fields that we have added, we have followed the guidance from Census for estimating MOEs for those estimates as well. There are several ways to incorporate the MOEs into your maps, should you need to do so.

How do I know if a change is a significant change?

Great question! Fortunately Census provides a Statistical Testing Tool to help you compare two or more estimates to see if the difference between them is statistically significant.

How do I adjust for inflation when comparing monetary values?

So glad you asked! Many topics covered in the ACS include monetary data such as income, earnings, contract rent, home values, etc. These are sometimes called “dollar-denominated data.” The 2010-2014 estimates are expressed in 2014 dollars, whereas the 2015-2019 estimates are expressed in 2019 dollars. To really compare apples to apples, we can adjust for inflation in just a few simple steps, as recommended by Census:

  1. Obtain the All Items Consumer Price Index – Urban – Retroactive Series (CPI-U-RS) Annual Averages from the Bureau of Labor Statistics for the two years: 2014 and 2019. (Actually, we’ve done it for you, in 2014 it was 348.3 and in 2019 it was 376.5).
  2. Divide the more recent value by the older value to create the inflation adjustment factor. (376.5 / 348.3).
  3. Multiply the dollar-denominated value for the earlier year by this inflation adjustment factor.

Now you can create a simple Arcade statement to display the 2010-2014 value of interest expressed in 2019 dollars. For example, let’s see how median contract rent has increased in Fresno County, California. We created the Arcade Expression below:

Expression titled Contract Rent adjusted for inflation. Expression: round($feature["B25058_001E]* (376.5 / 348.3), 0)

Then we configured the pop-up with a simple sentence:

Median contract rent was ${B25028_001E} in the period from 2010-2014, equivalent to ${expression/expr0} in 2019 dollars when adjusted for inflation.

When clicking on Fresno County, we see that a median contract rent of $753 is actually equivalent to $814 when adjusted for inflation.

Median contract rent was $753 in the period from 2010 to 2014, equivalent to $814 in 2019 dollars when adjusted for inflation.

This allows us to consider real change when comparing $814 to the 2015-2019 value of $830. Looks like rents in Fresno have been fairly stable, at least at the county level.

Are there any layers that are not one-to-one comparisons?

Yes. For some layers,   

For some geographic areas,

For more information about comparing 2010-2014 ACS 5-year estimates with 2015-2019 ACS 5-year estimates, including geographic boundary changes and changes in the questionnaire and coding, see this documentation from the U.S. Census Bureau. The recommended approach by Census for making comparisons over time is to use non-overlapping estimates. To find out why comparing overlapping ACS data aren’t encouraged, read here.

What trends will you reveal?

Get started by browsing the Current ACS layers which always contain the most recent estimates, as well as the 2010-2014 ACS layers, all available at your fingertips through ArcGIS Living Atlas.

About the authors

Diana loves working with data! She has over a decade of experience as a practitioner of demography, sociology, economics, policy analysis, and GIS. Diana holds a BA in quantitative economics and an MA in applied demography. She is a senior product engineer on ArcGIS Living Atlas of the World's Policy Maps team. Diana enjoys strong coffee and clean datasets, usually simultaneously.

Steven is a Product Engineer on ArcGIS Living Atlas of the World's Policy Maps team. He is interested in transportation, housing, and demography. Steven enjoys a good chicken wing or 12.

Leave a Reply

Please Login to comment

Next Article

New Nearby and Zone Lookup mobile app templates in AppStudio 5.1(July 2021)

Read this article