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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #137: Find the Closest 'Dry' Point!

JoeM
Alteryx Community Team
Alteryx Community Team

Thanks to @NicoleJohnson for a wonderful Weekly Challenge and Weekly Challenge Session last week! Now that the team is back stateside, we will begin to resume business as usual starting next Monday! Until then, here's another little challenge to tide you over!

 

In this challenge a telecom company is trying to determine the closest splice point to each of their customers in San Diego County. The caveat is that the closest point MAY NOT be across any body of water, river, pond, etc. Provided in the solution is 1) a shape file of water in San Diego, 2) a shape file of San Diego County 3) Customer points and 4) Fiber Splice Points

 

splicepoints.png

kat
12 - Quasar

Could it be that I'm first to submit the answer? 😄

Spoiler
love the spatial challenges!love the spatial challenges!
NicoleJohnson
14 - Magnetar
14 - Magnetar

@kat - that was crazy fast! You should consider competing in the Grand Prix or something... 😉

NicoleJohnson
14 - Magnetar
14 - Magnetar

My solution! Though just to make sure those cables don't cross the water, I should probably head to San Diego to check it out. You know, just to be safe. 🙂

Spoiler
WeeklyChallenge137.JPG

Cheers,

NJ

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
I decided to mix it up and use the formula/filter tool instead of spatial tools. I don't know what I was doing wrong, but the ST_Intersects was not returning the correct answers like the ST_Intersection object was (try customer1 and fibersplice5). 

Capture.PNG
Ladarthure
13 - Pulsar
13 - Pulsar

Hi, my solution, never used spatial with way, fun one! 

Wouter
8 - Asteroid

My solution:

Spoiler
challenge 137.jpg
olivia_paquot
8 - Asteroid

Easy one 🙂

 

CHarrison
8 - Asteroid
Spoiler
Realise now I could've just used a Sample tool at the end... but, hey! 
Challenge 137.png
George_Walker
8 - Asteroid
Spoiler
Capture.PNG

Here's my solution, fun problem