Weekly Challenges

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.

SUBMIT YOUR IDEA

Challenge #421: Which US city could observe solar eclipses in both 2023 and 2024?

RWvanLeeuwen
11 - Bolide

here we go:

Spoiler
421.png

not sure about that missing bracket though... I did not fix the data quality with Alteryx, because I'd rather discuss a fix in the source

messi007
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
Capture_20240409.PNG
olga_strubbe
10 - Fireball

This was a fun challenge, thank you @gawa!

And a great practice for spatial tools. 

2024-04-09_09-46-28.png

TobiasFitschen
8 - Asteroid
Spoiler
Challenge_421.png

MitchyMitch
8 - Asteroid

Good challenge! Feel like I'm getting more efficient as I go! 😊

Spoiler
Challenge 421.png
Powerhouse_21
9 - Comet
Spoiler
421.png

421-map.png

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Cool challenge :)

 

Spoiler
421.PNG

 

 

TurboToad
10 - Fireball

Took a minute to figure out the spatial tools & map, fun challenge! ☀️😎

Spoiler
421.PNG

AkimasaKajitani
17 - Castor
17 - Castor

My solution! Fun challenge!! @gawa -san!

 

I found that the start input has a problem that doesn't contain the whole original input files.

 

Spoiler

Start file input
スクリーンショット 2024-04-10 233853.png

Original File
スクリーンショット 2024-04-10 235058.png


This file contained an unnecessary comma at the end of the file, which caused a conversion error.


When I use the original files, I can get 48 cities at task 1(sample output is 41 cities).

 

Workflow

 

Spoiler
スクリーンショット 2024-04-10 234220.png

スクリーンショット 2024-04-10 234539.png



 

 

ARussell34
8 - Asteroid

I probably could have started with a union to just pull in both files...hindsight is 20/20.

 

AR_421.png