GEOG 865
Cloud and Server GIS

Joining demographic data with service areas (Data Enrichment)


In this part of the walkthrough we’ll try to learn a bit more about the customer base that lives within each 8-minute service area polygon we derived. We’ll accomplish this using what Esri calls “Data Enrichment”, in other words, joining and summarizing attributes from extensive demographic databases.

  1. In the map viewer, open your Delivery analysis map from the previous section of the lesson.
  2. Click Analysis and choose Data Enrichment > Enrich Layer.
  3. Click Select Variables and make sure that United States is selected from the dropdown.
    Here’s where you will be tempted to go crazy and add all kinds of interesting demographic and consumer information to your shopping cart of variables. Go ahead and add the following:
     - 2017 Total Population (under Population)
     - 2017 Total Households (under Households)
     - Restaurant Spending (Monthly)  (under Spending)
     - 2017 Have a Smartphone (under Behaviors)
     - One other variable you think would be useful for our analysis
  4. Ensure that you have only 5 selected variables (in other words, make sure you didn’t accidentally click a whole category and get tons of variables added to your cart).
  5. Click Apply. This will close the variable selection dialog box.
  6. In the left menu of your viewer, scroll down and examine the other options for enrichment, but don’t change any of them. Then click Run Analysis and wait a few minutes for the enrichment to occur.
    When the enrichment finishes, you’ll see a service area polygon layer just like the one you already have. The difference is in the attributes.
  7. Open the attribute table for the Enriched travel time layer.
  8. Scroll over until you see some of the new attributes, such as 2017 Total Population. The image below shows some of the attributes you should see (Households should also be in your table but are not pictured here).

    Enriched variables in ArcGIS Online attribute table

    Notice that some of the fields are more useful than others in their current state. We have a smartphone figure that isn’t normalized by anything. We could at least divide that by population to get some kind of an index of smartphone ownership, although it wouldn’t be perfect.
  9. In your attribute table, click the Add Field menu item as shown below.

    Adding a field using ArcGIS Online
  10. Add a field called PctSmartphone of type Double.
  11. After the PctSmartphone field is added to your table, click the field heading and click Calculate.
  12. Calculate the field as MP27002a_B/TOTPOP_CY as shown below. If the table goes blank after you calculate it, click onto another table and then come back to this one.

    Calculating a field in ArcGIS Online
  13. Examine your new index of smartphone ownership to see which service areas have the highest ownership.
  14. Calculate another field called TotalRestaurantSpending that represents the monthly restaurant spending multiplied by the number of households (NOT population). This gives some idea of the amount spent on restaurants in each service area each month.
  15. Look over all the attributes and think about questions like the following: Did the service area with the largest area also have the largest population? Is there any relationship between smartphone ownership and restaurant spending?
  16. Save your map.