ArcGIS Business Analyst

COVID-19 Testing Locations: Site Location Automation

Part of our mission here at Esri is to apply geographic thinking and demonstrate technical capabilities to help our users solve the world’s greatest challenges.

As we all navigate the COVID-19 landscape we know testing, testing, and more testing is key to understanding its impact.  As testing becomes increasingly accessible, we pondered how we could use our software to automate the process of identifying large numbers of potential testing locations to reach the masses.

In this blog we’ll use ArcGIS Pro and ModelBuilder, leaning heavily on the Business Analyst and Network Analyst extensions, with the idea that existing businesses could be used to occupy ideal pop-up test centers – like pharmacies.  As you can see from the model – it’s extensive.  But we’ll walk you through it.  You can even download the model and try it yourself.  Several parameters can be customized, such as the area, demographic demand, street network, etc.

Site Selection Model
ModelBuilder workflow to select mass testing sites for COVID-19 patients.

Let’s Get Started

We are focusing on business locations which are assumed to have the highest foot traffic and greatest dwell times during the COVID-19 pandemic.  Executive Orders across the country, including these from New York and California, have instructed that only essential businesses will be in operation. Knowing this, we are considering that individuals will only be traveling between their homes and essential businesses.  Here is a list of inputs:

Location:

We’ll filter the following Business Analyst Infogroup business locations by NAICS codes:

Ranking criteria:

Here are some additional considerations:

The pharmacy weighted value is calculated with the following variables:

Demand:

Pharmacy Candidate Weight Calculation
Candidate pharmacy weighted calculation for location-allocation analysis.

Model Setup

Location-Allocation analysis in Network Analyst contains several “problem types” to help find optimal locations. We will use the Maximize Coverage and Minimize Facilities to find the least number of facilities which can serve the most demand from a specific drive time cutoff value. The demand will be vulnerable population.

 

Location-Allocation
Location-Allocation's Maximize Coverage and Minimize Facilities model type for site selection analysis.

We will then import our facilities and classify the weighted value field for each location to be ranked under the criteria set forth in the data preparation stage. The drive time cutoff will be set to 10 minutes. There are approximately 920 major pharmacies in the dataset. Along with facilities, we will import the demand points. The demand points are represented as Census block group centroids.

LA Facility points
Import facilities and demand points into the location-allocation model.

Results Analysis

As the model outputs the results, 150 optimal sites are selected for testing locations based on the demographic demand points and weighted values for each pharmacy.

Here’s a look at the output in ArcGIS Pro.  This shows the selected businesses (test sites) with “spokes” connecting the potential customers.  The spokes provide a good indication of which location supports the surrounding population.

ArcGIS Pro - Location-Allocation
ArcGIS Pro output showing demand points assigned to the most optimal testing site.

Here is another look at the same analysis output.  We created a simple web-based ArcGIS Dashboard as an additional way to communicate the key findings. To build a dashboard, check out these cool options from Bern.

Results ArcGIS Dashboard
Site selection results displayed in an ArcGIS Dashboard.

Focusing the view a bit, here is one site selected in the Gardena area of LA.

ArcGIS Online Dashboard - single site
A selected testing site with nearby demand displayed in an ArcGIS Dashboard.

Conclusion

The model described above can help decision makers plan for expanded COVID-19 testing scenarios.  It determines the most optimal facilities and which populations to direct them to.  By designating specific block group geographies to specific testing locations, this allows facilities to be prepared for the incoming patients.

The results can also highlight the demand (population) and provide realistic capacity values for the potential number of COVID-19 test availability at each optimal location.

About the authors

Andrew Makowicki is a Solution Engineer for State and Local Governments with Esri. He has a Master of Science degree in Geoinformatics from the University of Salzburg in Austria and has worked in four different countries spanning from Europe, to the Middle East, and Southeast Asia. Using his interdisciplinary skill set, Andrew applies his passion of science and data analytics to enhance the creative use of GIS.

Connect:

Kyle is a Lead Product Engineer with Esri - focusing on geospatial technologies and demographics to develop next generations of ArcGIS Business Analyst apps - used by organizations to discover patterns and predict what's next.

Leave a Reply

Please Login to comment

Next Article

What was old ...

Read this article