Weekly Challenge

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

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

Submit Feedback
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.

Challenge #214: US Military and High Points

Highlighted
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: https://en.wikipedia.org/wiki/The_PentagonSource: https://en.wikipedia.org/wiki/The_Pentagon

 

This week's challenge comes to us from @Blake and @Aaron_Harter - thank you for your contribution!

 

The MIRTA dataset, released by DoD, contains geographic information for major military installations, ranges, and training areas in the United States and its territories. The other dataset is a listing of the high elevation peaks in each U.S. State, the name of the point, and its elevation.

 

Using the data provided, filter for active MIRTA sites and answer the following questions.

1. Which peak ranks #14 when only considering the highest peak in each state?
2. Which high peak is closest to a MIRTA site?
3. How many high peaks are closest to a MIRTA site in a neighboring state?

Highlighted
Alteryx Partner

Fun challenge! Probably not the most elegant solution, but it works.

 

Spoiler
Capture.PNG

 

View my solution video here:

Spoiler
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1588603272735.png

 

Edit: Thanks @mbogusz , I've fixed my attachment 

Highlighted
14 - Magnetar
14 - Magnetar

My solution!

 

Spoiler
WeeklyChallenge214.JPG

Cheers!

NJ

Highlighted
Alteryx Partner

In a "neighboring state" or "not in the same state"? Not quite the same (30 vs 26)

Spoiler
dsmdavid_0-1588604475832.png

 


I've used this https://www.census.gov/geographies/mapping-files/time-series/geo/carto-boundary-file.html to find neighboring (i.e. touching) states.

Highlighted
9 - Comet

Took me quite a while to figure out why my answer to Q3 was 33. Turns out I used a too simplistic solution for cleansing the State name which resulted in getting rid of the spaces between the words in states like New Mexico.

 

Also did quite a bit of transposing and cross tabbing and then I got the epiphany of the Make columns tool.

 

Also, I think the task should be phrased a little differently, "in a neighboring state" does not necesarily mean in a "different state" - unless I missed something, I think we were unable to check the neighbouring states using only the provided data - unless Alteryx has some built in polygons of the US states?

 

Spoiler
Spoilerzajaccount_0-1588607117120.png

 

Highlighted
Alteryx Certified Partner

Hi @dsmdavid and @zajaccount  - good catch. I should have used the use of the word "nearby" or "different" rather than "neighboring".  The intent of the question was not to have users track down a separate data set and make sure that states were touching, just that the closest peak/site were in different states.

Highlighted
14 - Magnetar
14 - Magnetar

Glad to see @NicoleJohnson has jumped back on the Weekly Challenge Train!

Spoiler
Capture.png

Highlighted
9 - Comet

Nice challenge!  Lots of opportunity to practice Regex and some spatial too. Question 3 was a lot easier than I had originally figured!! - thanks for the clarification Blake.

 

Spoiler
ss 214.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 214 is done! Tried for as few tools as possible, managed to get it down to 16 with the exact output or 13 for the correct answers!

 

Spoiler
image.png