Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #77: Extending Spatial Lines

Asteroid

That was fun!

Spoiler
image.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution using the Trade Area approach

Highlighted
Alteryx Certified Partner

I could really use some tutoring regarding trigonometry...

Here's the macro I produced:

Spoiler
77 macro.png
Highlighted
Asteroid
 
Highlighted
Asteroid

This was a bit of a head scratcher at first. I though there may be some clever way of using the spatial tools to extend the lines - and then thought that maybe Mr Pythagoras could help - which he didn't (Long and Lat are not the same unit of measurement). Eventually I decided on a solution that simply used a ratio to extend the points 5 miles in the correct direction - which turned out to be a very simple workflow in the end.

 

Spoiler
clipboard_image_0.png
Using coordinates for the vertices of the bounding rectangle for each line I could calculate the adjustment for the start and end points and apply it to create the new start and end points.

clipboard_image_1.png

 

Highlighted
Asteroid

 

Spoiler
77.PNG

Didn't use a macro to complete. Used angle to determine new points which makes the answer just barely off. 

 

Highlighted
Fireball

Similar to approach to what most others seem to have achieved by doing the 'lollipop' approach.

Spoiler
Challenge 77.PNG
Highlighted
Asteroid

Here is my solution!

Highlighted
Alteryx Partner

Challenge 77 is done!

 

Spoiler
challenge 77 JMS solution.PNG

 

Highlighted
Alteryx
Alteryx

Took a flight, some noodling and getting stuck in Newark airport to finally get this one across the finish line.

 

Spoiler
77_challenge.jpg