In this blog, I am walking you through the step-by-step process of solving an Alteryx spatial challenge of Week 51. Here is the link to the challenge Challenge #51: Spatial County Coverage – Alteryx Community
Solving Part 1
Step 1:
Let’s see what the data is about.
We have the Lat and Lon values, so we can create the Points using the values. Drag in the ‘Create Points‘ tool from the Spatial Tab or search for the tool in the search bar, set up the following configuration, and run to create the Points.
Step 2:
The challenge is to find the overlap between the individual tools. So as the next step, we are finding the circular area around the point with a radius of 15 miles. For this use the tool ‘Trade Area‘ and follow the configuration. Run to see the Polygon created.
Step 3:
Now bring the ‘Spatial Match‘ tool and follow the configuration. Also drag in the browse tool to see the map.
Step 4:
Now, the idea is to find the all counties with the 15 miles radius of the store. So the next logical step is to find the area. To find it use the tool ‘Spatial Info‘ and configure as follows, then run to see the area of the radii.
Step 5:
Now we need to find the counties that overlaps the area. To achieve this, drag in ‘Spatial Process‘ and configure as follow.
Step 6:
Drag in the ‘Spatial Info‘ tool to find the area of the intersection and find the percentage using the formula (overlap area*100)/county’ area.
Here is the final workflow.
That solves Part-1 of the challenge. You can refer to my profile for the Part -2.
