Challenge #51: Spatial County Coverage

[GeneR]

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]

Spoiler

[MichelKars]

A little late but here's my solution.

Spoiler

[TaraM]

A solution has been posted

Spoiler

[NicoleJohnson]

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

Spoiler

[SeanAdams]

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]

Same approach here. Love using Spatial Match with Intersect :)

[LordNeilLord]

I do love me some spatial matching!

Spoiler

[LordNeilLord]

I posted in the wrong place :/

[nick_ceneviva]

Solution attached