Challenge #100: Find Ned!
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@estherb47 0.3 meters! That's got to be some sort of witch craft
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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 :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I finally got my head around this challenge which was quite challenging. Final results are 3.6m from Ned in 22.2 seconds
After chatting to @PhilipMannering I realised that I missed a very crucial information while skimming through the task, and that is Ned set up his tent in the farthest location from any road in the state of Colorado. Well now all the grid solutions started to make sense to me. I spent some time to figure out what is the correct relationship between the target and universe, and went on to decrease the size of the grid. At the end I think my solution is quite similar to @estherb47.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.