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

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

challenge_137_start_file.yxzp

challenge_137_solution.yxzp

Join

Preparation

Advanced

Data Analysis

Data Preparation

Transform

Basic

Accepted answers

All comments

kat

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

Spoiler

love the spatial challenges!

Challenge #137.yxzp

NicoleJohnson

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

NicoleJohnson

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

Cheers,

challenge_137_NicoleJohnson.yxzp

patrick_digan

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).

challenge_137_start_file.yxzp

Ladarthure

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

challenge_137_start_file.yxmd

Wouter

My solution:

Spoiler

challenge_137_solution_WK.yxmd

olivia_paquot

Easy one :-)

challenge_137_start_file.yxmd

CHarrison

Spoiler

Realise now I could've just used a Sample tool at the end... but, hey!
Challenge 137.png

Challenge 137.yxmd

George_Walker

Spoiler

Here's my solution, fun problem

137 solution.yxzp

Hakimipous

A good way to get back to Spatial tools

Fun one!

Spoiler

challenge_137_start_file.yxmd

danilang

Fun early morning challenge

Spoiler

Dan

challenge_137_solution_DL.yxmd

KevinW

my solution:

Spoiler

challenge_137_solution.yxmd

AdiMac

Interesting to conceptualise. thanks!

Spoiler

Challenge 137 fibreSplice.yxmd

thanyasch

Fun problem to increase my basic knowledge of spatial! Thanks for the fun challenge!

Spoiler

challenge_137_start_file.yxmd

danrh

Totally over-complicated this ...

Spoiler

solution.yxmd

BENOIT_RAFFIN

Excellent challenge to review spatial features !!

challenge_137_start_file.yxmd

cgoodman

Here's my solution:

Spoiler

challenge_137_solution.yxmd

DawnR

Done.

challenge_137_DawnR_Completed.yxmd

neilgallen

Anything with spatial is always a good one. Don't get to do that stuff enough.

challenge_137_NGA.yxmd

ponraj

Here is my solution.

Spoiler

challenge_137_solution.yxmd

RsRoel

Interesting one! Always like the spatial challenges

Spoiler

Solution Week 137.yxzp

StevenBetts

Here's my solution

Spoiler

challenge_137_start_file_SMB.yxmd

iain_sterland

SPOILER

Spoiler

challenge_137_IainS.yxmd

catherineduffy

My solution:

Spoiler

challenge_137_catherineduffy.yxmd

hatice

Spoiler

good practice for me, thanks

CharlieS

@JoeM wrote:
Until then, here's another little challenge to tide you over!

giphy

Challenge_0137-CharlieS_Solution.yxmd

Ruud

Hungover in Noly as preparation for TC18, this took longer than it should.

challenge_137_ruud.yxmd

jasperlch

Solution attached.

challenge_137_JL.yxzp

ZenonH

Great challenge, I got to learn more about the settings on spatial tools

Spoiler

challenge_137_sol_ZH.yxmd

ckings

Spoiler

Cheated a bit and referenced the beginning posts! New formula for me!

challenge_137_CAK.yxmd

Verakso

Another week another fun, all though I could feel I have been neglecting Spatial Analysis for while, so thanks to @JoeM and the team behind, to keep us on our toes.

So I solved it

Spoiler

2018-10-23 22_24_24-Alteryx Designer x64 - challenge_137_verakso.yxmd.png

I guess the intersect with the San Diego County shape wasn't really necessary since all the customers and fiber points are within, but I added it for the sake of logic anyway.

Not my prettiest solution, but I did manage to get the right result in the end so...

.. hurry on to next week challenge

//Thomas

challenge_137_verakso.yxmd

petgrap

Spoiler

challenge_137_start_file - PP.yxzp

petgrap

treepruner

Your solution is sooo much easier to follow than the official solution!