Interactive UPGNA Matrix Map

Zach Torres
Zach Torres

October 16, 2022

Interactive UPGNA Matrix Map

This project was created with data from Global Gates' Unreached People Groups North America Priority Matrix. The data visualized here is publicly available on their website. Click on the demo link below to interact with the map in my app!

My workflow is described below:

  1. Downloaded TIGER shapefile for census MSA/CSA boundaries
  2. Cleaned data in Excel from Priority Matrix (Aligning CBSA/MS/CSA names down to the accent in Montréal) *Ensured the Title of the column/field where MSA/CSA names are stored is identical.
  3. Saved Excel sheet as a .csv file
  4. Used the XY to Point geoprocessing tool to add each people group in a city as a point feature from the .csv file.
  5. Performed a Spatial Join, where parameters will join any feature from the point feature class that a census boundary polygon "contains". Uncheck the box to keep all target features in the spatial join parameters.
  6. Exported data in new joined polygon layer to feature class (Help)
  7. Used geoprocessing tools to create new feature classes in the geodatabase and highlight statistics in the Priority Matrix.
  8. Summary Statistics to create UPGs Per Area using [People Group, Population Size, Priority Score, Primary Language, and Primary Religion] as fields, [Count, Sum, Mean, Unique, and Unique] as the statistic types respectively with "Name" as the case field.
  9. Joined the new Table to the polygon feature class with the following parameters:
  10. Input Table: Layer to which the table will be joined
  11. Input Join Field: Name
  12. Join Table: [select newly created summary statistics table] (all fields must have the "Double" data type)
  13. Join Table Field: Name
  14. Uncheck Keep all Targets
  15. Check Index Joined Fields
  16. Symbolized each new feature class appropriately.
  17. Highlighted all new layers to add to your ArcGIS Online (AGOL) webmap > Right click > Share > As Web Layer
  18. Ensured that every feature layer was exported its own feature class.
  19. Set parameters and Publish
  20. Entered the related AGOL account where the web map was published.
  21. Created a new web map and add the feature layer just published to your AGOL organization.
  22. Ensured the Basemap is set to Charted Territories.
  23. Set transparency for each of the layers to 33% under Properties.
  24. Saved the Web Map with appropriate Title, Tags, and Summary.
  25. Configured an Interactive Legend web app from the web map in ArcGIS Online for a public audience.

Tools used

ArcGIS OnlineArcGIS ProMicrosoft ExcelModelbuilderWeb mapping application

Plug-ins used

ArcGIS Instant Apps


Human Geographysummary statisticsthematic mapUPGNAVectorial Data

You might also like

Join the community!

We're a place where geospatial professionals showcase their works and discover opportunities.