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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #388: Meteorite Impact Sites

Alteryx

A solution to last week’s challenge can be found here.

This challenge comes to us from @AkimasaKajitani . Thank you for your contribution, Aki!

Meteorite showers are a captivating natural phenomenon, though it can be challenging to see them depending on your location. Fortunately, residents and visitors in the Las Vegas area enjoy an advantageous position, being in proximity to expansive desert skies that offer excellent conditions for meteorite watching.

For this challenge, your mission is to plan a budget-friendly meteorite impact site tour near Las Vegas, ensuring enthusiasts visit locations where they have the best opportunity to witness this celestial spectacle.

Here are the tasks you must complete. Calculate all distances in kilometers.

1. Find a meteorite impact site that is closest to a hotel that costs less than \$200 per night. Designate this location as the "First Stop."
2. Identify the nearest meteorite impact site in relation to the First Stop. Label this site as the "Second Stop" and determine the distance between the first and second stops.
3. Locate the nearest meteorite impact site in relation to the Second Stop. Name this site “Third Stop” and determine the distance between the second and third stops.
4. Calculate the total distance traveled from the hotel to the third stop.

Data Summary:

You have two datasets. The text dataset contains the latitude and longitude of some hotels in Las Vegas with their cost per night. The second dataset, meteorite-landings.csv, contains the latitude and longitude of over 45,000 meteorites that have struck our planet.

9 - Comet

My first Solution:

Spoiler

My Solution using an iterative Macro which calculates the next 100 locations to visit:

Spoiler

---------------------------

9 - Comet

Spoiler

16 - Nebula
Spoiler

Great challenge, @AkimasaKajitani

12 - Quasar

Nice quick spatial challenge

Spoiler

I did want to use miles over KM though!
16 - Nebula

My solution! I also add a map solution!!

Spoiler

@Kenda Thanks!!

Map

Spoiler

When I see the Map of Las Vegas, I remember my awesome experience at Inspire 2023 and it makes me feel nostalgic.

6 - Meteoroid
Spoiler
11 - Bolide
Spoiler

15 - Aurora

Love the Spatial tools!

Spoiler
7 - Meteor
Spoiler