Weekly Challenge

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

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

Submit Feedback
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.

Challenge #27: Spatial Telco Coverage Smoothing

Highlighted
8 - Asteroid
Spoiler
27 solution.PNG
Highlighted
8 - Asteroid

Another nice execrcise using spatial tools that I don't use very often in my day job. Good learning experience and a showcase of what Alteryx can do.

 

Spoiler
DavidLane_0-1590407774706.png

 

Highlighted
12 - Quasar
12 - Quasar

Good refresh of Spatial tools

Spoiler
jarrod_0-1590680576864.png

 

Highlighted
7 - Meteor

Hi @GeneR @jarrod @DavidLane @CR_Marland @CKP ,

 

I'm a beginner to Alteryx and very new to Spatial. I was trying few Alteryx Spatial challenges and this challenge came up.

 

Here objective is clearly written to "Remove all splatter less than 2 square miles" then why in Filter tool "AreaSqMi" is considered  >= 2.

 

Also if anyone can explain how exactly split polygon helped to remove the spatter. 

Highlighted
12 - Quasar
12 - Quasar

Hi @george317 

 

In order to remove the splatter less than 2sq mi, you have to apply the logic 1 of two ways:

1) select the spatial objects that are less than 2sq mi and exclude

    for this, the filter formula would be AreaSqMi < 2

    however, this would pass all of those values to the "true" side of the filter, so we'd have to just connect to the "false" side to get the "good" spatials.

2) select the spatial objects that are >=2 sq mi, since they are good and ONLY include those

    i went this route because i like to keep my filters "true"

    for this one, i used the AreaSqMi >= 2 and connected to the True side of the filter. 

 

honestly, either way works, but you have to adjust the logic/connection to get the correct spatials.

 

Split polygon (by region) allows the entire complex spatial object to be split up into smaller regions. Using the "detailed" option provides another field in the output called "Split_IsHole" - that is essentially negative space in the polygon and when we remove this spatial object, it allows us to get rid of the holes when concatenate the final spatialObj.

 

the remaining "regions" from the split polygon are just spatial objects, which we can run Area calculations on - this helps us determine the square miles and filter (as detailed above).

 

does that make sense?

Highlighted
7 - Meteor

Yes makes sense completely. Thank you for the time and efforts. God bless you.

Highlighted
8 - Asteroid

Please find attached my proposed solution.

Highlighted
12 - Quasar

Spatial 5

Spoiler
RNO2_0-1591410497603.png

 

Highlighted
8 - Asteroid

Spatial is always fun!

Highlighted
8 - Asteroid

Thanks for challenge. Solution attached