Challenge #60: Fill in the Spatial Object

The solution to last week's challenge can be found HERE.

This week we are changing it up a bit and pulling a question that was asked to the Community last week! The issue was that the user had a spatial object that had "holes" inside the object. The challenge was to fill in any holes within the object. The answer to this solution can be solved in very few steps, but the challenge comes in knowing or discovering the right configurations within the tools used to solve the problem. If you would like any hints or to find out how the question was solved, check out the original post which also contains the solution:

Spoiler

https://community.alteryx.com/t5/Advanced-Analytics/Remove-holes-from-a-polygon-object/m-p/48652

challenge_60_start_file.yxmd

challenge_60_solution.yxmd

Spatial Analysis

Advanced

Intermediate

Transform

Spatial

Accepted answers

All comments

Max06270

Hi guys,

I got something working with very few tools. To be honest I had no idea how this was going to work out, was just playing around with the spacial tools and.. oh it works! I guess this approach can be ok sometimes lol.

Spoiler

Thanks for the challenge and have a great week,

Maxime

challenge_60_MK.yxmd

alex

I couldn't get it to work using the same exact workflow as shown in the example. I received the following error. Is that because I don't have

spatial package?

So I tried a slightly different way and achieved the correct answer. I also tried using the spatial match to verify. You can see the bold borders indicating the 2 are stacked on top of each other.

Spoiler

challenge_60_AC.yxmd

MarqueeCrew

@JoeM,

I found a "hole" in New Mexico that wasn't a hole, but more of a wedge. I ended up summarizing and combining the 3rd polygon.

Cheers,

Mark

challenge_60_MarqueeCrew.yxmd

Natasha

Thanks for the challenge. I had a good play around with spatial tools.

At first, I got carried away with building more polygons from existing polygons, but after some trial and error, I had a peek at the hint which quickly led me to the same solution as others.

Spoiler

I would prefer not to have hints like this easily available, as it's so hard to resist them. It's supposed to be a challenge anyway

JoeM

@alex, yes it appears that that solution was using a TomTom map that comes with data install. No fear because we have plenty of other base maps

paul_houghton

It took a while for me to think it through, then I thought it ended up being nice a simple. It's just not easy if you don't use the spatial tools very often.

Spoiler

MarqueeCrew

@paul_houghton,

I'll drink to that

NaiLo

Beautifully simple solution, happy it's my first (published) Alteryx challenge!

Spoiler

JoeM

The solution for challenge #60 has been published!

Hartwick96

Here is my go at it.

Cheers!

challenge_60_CK.yxmd

Coxta45

Fun stuff!

Spoiler

challenge_60_solved.yxmd

NicoleJohnson

Same discovery as @MarqueeCrew, summarized the SpatialObjects to deal with the extra "piece" of New Mexico. I love when these "complex" problems have such streamlined solutions!

Spoiler

challenge_60_NicoleJohnson.yxmd

SeanAdams

took a different approach than folk above

Spoiler

did it 2 ways just to check:
- the classic "isHole" flag
- the second is splitting into distinct regions, and then looking for the biggest area, and filtering out the others

challenge_60_SeanSolution.yxmd

estherb47

Took 2 approaches to remove the holes

Spoiler

Spoiler

since the poly split tool creates a "Split is hole" field, you can use that to remove the holes:

Either filter out the holes, or combine them back together with a summ

arize tool

challenge_60_EHB_solution.yxmd

Natasha

Forget to attach the file in my previous post but for some reason I can't edit it now.

challenge_60_answer_NK.yxmd

LordNeilLord

Same approach as pretty much everybody else

Spoiler

challenge_60_LNL.yxmd

jamielaird

Here's my solution, including removing the weird leftover artifact in NM.

Spoiler

challenge_60_JL.yxmd

patrick_digan

Solution attached

Spoiler

challenge_60_start_file.yxmd

nick_ceneviva

Solution attached

challenge_60_Ceneviva.yxmd

samN

I think this was my Fastest spatial yet!!

challenge_60.yxmd

ggruccio

Similar exercise earlier helped with this one.

challenge_60_gg_finish.yxmd

LandonG

Solution attached.

challenge_60_start_file.yxmd

philipmannering

Solution attached.

Spoiler

challenge_60 - Fill in Spatial Object.yxmd

jasperlch

Solution attached.

challenge_60_JL.yxmd

derekbelyea

Spoiler

challenge_27_JDB_AnalytixStudio.yxmd

derekbelyea

Spoiler

challenge_60_JDB_AnalytixStudio.yxmd

JosephSerpis

Challenge Completed

Challenge_60_Joe_Serpis.yxmd

David-Carnes

Well, that was quick.

Spoiler

David-Carnes_060.yxmd

JacobR77

Challenge 60- Fill in the Spatial Object.yxmd

CHarrison

Got this solution by complete luck! Was messing around with random Spatial tools until I came across the Poly-Split

Challenge 60.yxmd

SGolnik

I did it a little differently than the proposed solution but a similar way others did it.

challenge_60_mysolution.yxmd

dsmdavid

Spoiler

solved#60.yxmd

daniel_ferreira

Follow my solution attached...

challenge_60_solved.yxmd

Gauthier_B

Done

Spoiler

challenge_60_start_file.yxmd

msicak

well done! I did a training vid on the poly-split recently and yet overcomplicated my solution, ugh.

Spoiler

challenge_60_msicak.yxmd

CamodCPA

At first, I thought that I had to turn these spatial objects into points than look at the convex hull, but then I realized it is Sunday afternoon and I am overthinking different aspects of this !!!!! So, splitting up the objects into regions and detailed regions, I found that detail regions show the hole. This led to a filter, which, in turn, finally an answer. This took me 20 minutes toooooo long!