We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #51: Spatial County Coverage

GeneR
Alteryx Alumni (Retired)

The link to last week’s challenge is HERE.

 

Wow, exercise #51 already.  Can’t believe it has been nearly a year!    

 

For this week I would like to investigate some of the geospatial tools available in Alteryx   The spatial tools will allow you to calculate distances, create trade areas, find intersection of spatial objects, calculate sizes, etc..  Even if you don’t have the spatial data from Alteryx (the spatial data provides supporting data packages for geocoding, address standardization and calculations using the road network), most of the tools will still perform as long as you have the spatial references or objects already available in your input data.

 

Use Case: For regulatory purposes we have been asked to identify the all the counties within a 15-mile radius of each of our stores as well as identifying the percent of the county’s area that is overlapped (Coverage).

 

Objective:

Part 1) Calculate the percent overlap by individual store

Part 2) Calculate the percent of overlap by county for the entire store network

 

Joe_Mako
12 - Quasar
Spoiler
Week 52.png
MichelKars
6 - Meteoroid

A little late but here's my solution.

 

Spoiler
Knipsel.PNG
TaraM
Alteryx
Alteryx

A solution has been posted

Spoiler
2016-12-05 08_58_50-Alteryx Designer x64 BETA - Spatial_CountyCoverage_Solution.yxmd.png
Tara McCoy
NicoleJohnson
14 - Magnetar
14 - Magnetar

Solution. Appears to be very similar to @MichaelKars...

 

Spoiler
WeeklyChallenge51.JPG
SeanAdams
17 - Castor
17 - Castor

Similar to those posted above, 'cept...

 

Spoiler
... I didn't use the spatial match component - just used intersections, and eliminated 0 area intersections using  a filter
estherb47
15 - Aurora
15 - Aurora

Same approach here. Love using Spatial Match with Intersect 🙂

LordNeilLord
15 - Aurora

 

I do love me some spatial matching!

Spoiler
Weekly Challenge 51.png

 

LordNeilLord
15 - Aurora

 

I posted in the wrong place 😕

 

nick_ceneviva
11 - Bolide

Solution attached