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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
alteryx Community

# 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 #82: Are You in the Path of the Solar Eclipse?

Alteryx Alumni (Retired)

The solution to last week's Challenge can be found here!

You'll want to get this week's Challenge done quickly, especially if you want to find out if your current location is in the path of today's total solar eclipse!

The given input file contains data on the path of the moon's shadow of the solar eclipse that will pass over North America on Aug. 21, 2017 (source: https://eclipse.gsfc.nasa.gov/SEpath/SEpath2001/SE2017Aug21Tpath.html). To experience totality, or the darkness of the moon's shadow, you need to be within the boundaries of the eclipse's path. Use the data below to plot the Northern, Central and Southern limits of the of the eclipse's path. Then, determine if your current location is within the path of totality. If not, what is the minimum distance from your location to being within the boundaries of totality?

*HINT: Convert geographic degrees and minutes into decimal degrees using the formula DEGREES + (MINUTES/60)

**HINT: Longitudes in North America are negative values.

***HINT: It's helpful to limit the path of totality to the boundaries of North America (optional). Download a shapefile of the United States here: https://www.census.gov/geo/maps-data/data/cbf/cbf_nation.html.

Happy Eclipse Day!

15 - Aurora

My solution! And I even had time to run outside and check out the eclipse for myself! (With the proper approved safety eyeglasses of course, since as shown in my solution, I'm about 178 miles away from being able to see the full totality)... This was a fun one, @ChristineB!! Happy Eclipse Day, everyone!

Spoiler
I chose to make show the path of totality as a convex hull once the points were determined to smooth it out a bit (otherwise, it looked like the eclipse was climbing stairs across the US...). Note that originally I did it without the degree+minutes conversion, since it seemed to work when the points were in the format ## ##.#N and ### ##.#W... but converted to decimals format anyway, just to make it cleaner and to match up with the format of my location.

Cheers,

NJ

15 - Aurora

Great problem to get better acquainted with some of the spatial tools.

Here's my solution.

Spoiler
1. Parse out the longitude and latitude for the eclipse northern and southern boundaries.
2. Set the correct order of those coordinates to create the polygon.
3. Create said polygon.
4. Measure the distance.

My workflowI used Montreal and Las Vegas to give more interesting results.

Alteryx Alumni (Retired)

Christine's solution has been posted!

15 - Aurora

Mapped this out for my siblings too :)  None of us were anywhere near the totality, but we all watched through safety glasses! Still such a cool event, and my children and I look forward to the next one.

My approach wasn't a novel one. Prepared the data, first parsing it

Spoiler
17 - Castor

Fun challenge!

Spoiler
I parsed the data and created the points. Then I used poly build and poly split to get all the points on the line. Then I used find nearest to find the closest point to my geocoded address. I added some interface tools so anybody could type their address in to get their distance from the line of totality back.

15 - Aurora

This was a fun one, I spent far too long messing about with Transpose & Crosstab to get the data in a suitable order to build the PolyLine then I remember that you can build these things using the formula tool! MUST NOT FORGET THE FORMULA TOOL!

Spoiler
9 - Comet

I was avoiding this challenge for a while, but once I read up on lat/long and degrees everything fall into place.

Spoiler
17 - Castor

:-) so, it turns out that we were in yellowstone at the time, so we were directly in the path.   But I followed the instructions to the letter, and plotted the path vs. my current location.   No intersection at all (8816 Miles to closest point).

8 - Asteroid

Solution attached.