Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA@estherb47 0.3 meters! That's got to be some sort of witch craft
@LordNeilLord, witchcraft or a lot of time testing a lot of different ideas, and iterations of those. Alteryx got a workout with this challenge!! I even went down to smaller grids, but they found points that were further away from Ned :)
Hoorah for Challenge 100! And to finding @Ned (0.3m away in 21.5 seconds)!! Looks like a great spot. Maybe we should host Inspire 2019 out there in the wild Colorado yonder... :)
Super fun challenge #100 @ChristineB!! It's been lovely reaching these last 100 milestones with you, @JoeM, and the rest of the Community. The view is quite lovely up here!
Cheers,
NJ
I finally got my head around this challenge which was quite challenging. Final results are 3.6m from Ned in 22.2 seconds
So - took a week and a half to go through this - tried some pretty silly ideas on the way.
Solution details in the spoiler section - around 2m30sec (if you exclude the weeks it took me to get a solution that ran in a sensible time)
The solution that I got to just uses progressively larger buffers (around the roads) in an interative macro to find the value of a buffer that eliminates all but the final spot where Ned is hiding.This is the main flow - it first puts the roads into a buffered polygon, and then looks for ever larger buffers
put buffer around the roads. Broken into batches of 50 to speed this along
Then look iteratively for the largest buffer that still returns one hiding place
The solution posed by @LordNeilLord ; @JosephSerpis ; @Natasha @ggruccio @estherb47 @DataPrepChad; @jamielaird @NicoleJohnson; @patrick_digan using a grid then a spatial match and/or filter for nearest is much more effective.
This must have been the hardest challenge I've ever done. Took quite a while to figure out and the final product just seems so inelegant. Nonetheless, just under 20 seconds to run and 33m away.