Challenge #388: Meteorite Impact Sites

[AYXAcademy]

Hi Maveryx,

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.

Source: https://www.kaggle.com/datasets/nasa/meteorite-landings

[benjimoser]

My first Solution:

Spoiler

  

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

Spoiler

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

[mmontgomery]

Not too bad

Spoiler

[Kenda]

Spoiler

Great challenge, @AkimasaKajitani 

[ed_hayter]

Nice quick spatial challenge

Spoiler

I did want to use miles over KM though!

[AkimasaKajitani]

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.

 

[nhardin]

Spoiler

[ahsanaali]

Spoiler

 

[alexnajm]

Love the Spatial tools!

Spoiler

[AshaDaniels]

Spoiler