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 #204: Updating Brazil

Highlighted
Alteryx
Alteryx

A solution to last week’s challenge can be found here.image source: https://en.wikipedia.org/wiki/States_of_Brazilimage source: https://en.wikipedia.org/wiki/States_of_Brazil

 

Did you know that Brazil is the largest country in South America? “Super legal!” you say to yourself em Português. Brazil is also an incredibly diverse country with many unique geographic regions. That’s why it’s a good idea to bring a map.

 

Unfortunately, the map I found is from 1920 and doesn’t show all 27 states (26 and the Federal District). Your task is to use the supplied data to update the map from the 22 existing states to include all 27.

 

Additionally, the capital moved from Rio de Janeiro to Brasilia in 1960, so the updated state of Rio de Janeiro should regain the land occupied by the Federal District in the 1920 map.

 

Boa Sorte!

Highlighted
8 - Asteroid
Spoiler
challenge_204.PNG

Not sure if purposeful but nice timing to reference Brazil with Carnaval going on right now!

 

Cheers from Rio de Janeiro!

Highlighted
Alteryx Certified Partner

Excelente desafio esta semana!

Spoiler
204.PNG
Highlighted
13 - Pulsar

My solution.  Probably a more efficient solution, but time is short this morning.

 

Spoiler
Workflow 204.png

 

Highlighted
Alteryx Certified Partner

This is making me hungry for some pao de queijo! 

 

Spoiler
204.png

 

Spoiler
Edit : 13:15 CST Added video walk through 

 

Highlighted
8 - Asteroid

Here's my solution.

Step1: Process Federal District to merge with Rio

Step2: Remove parts of Old States that now belongs to New ones.

Step3: Combine all processed areas to generate final map.

 

Spoiler
Solution ScreenshotSolution Screenshot
Alteryx Certified Partner

Here's my solution:

 

Spoiler
Challenge 204.png
Highlighted
17 - Castor
17 - Castor

Spatial operations and functions for the win!!

 

Spoiler
w.png

Dan

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I don't use spatial tools in my daily business, so it's usually a challenging task - but always interesting.

 

Spoiler
24-02-_2020_19-57-41.png
Highlighted
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1582572689459.png