# 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
Highlighted
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
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

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.

Highlighted
Asteroid

Spoiler

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
Highlighted
Asteroid

Here is my solution!

Highlighted
Alteryx Partner

Challenge 77 is done!

Spoiler

Highlighted
Alteryx

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

Spoiler