Challenge #450: Calculate Maine Coastline Length

Weekly Challenge LMS Banner.png

Hello Community Members!

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

It's time to put your spatial skills to the test again! This challenge, submitted by Claire McCollough (@clmc9601), will challenge you to use the Designer Spatial palette efficiently.

You are provided with two datasets. The first dataset contains polygons representing the counties of Maine, a state in the USA. The second dataset contains a polygon representing the Gulf of Maine, located in the nearby waters of the Atlantic Ocean.

Your tasks are to:

Identify which Maine county has the longest coastline on the Gulf of Maine. (Exclude any islands smaller than 5 kilometers.)
Determine which county has the most small islands. (An island is considered small if it is less than 5 square kilometers.)

Need a refresher? Review the Spatial Analytics lessons in Academy to gear up.

Happy solving!

The Academy Team

Challenge_450_start_file.yxzp

Challenge_450_solution_file.yxzp

Spatial Analysis

Advanced

Intermediate

Accepted answers

All comments

patrick_digan

Spoiler

Challenge_450_start_file.yxmd

mmontgomery

c450

Spoiler

I've seen this problem before, which helped in a quicker solve.

Challenge_450_MM.yxmd

RolandSchubert

Spoiler

Challenge_450_solution_rsc.yxzp

AGoddard

Spoiler

I wasn't sure whether to use Spatial Process or Spatial Match, so I did both and thankfully got the same answer.
Screenshot 2024-11-11 163941.jpg

Challenge_450_solution.yxzp

binu_acs

Spoiler

Challenge_450_solution_BV.yxmd

ed_hayter

Spoiler

Challenge_450_start_file.yxzp

nSpire

Spoiler

Challenge_450_nSpire.yxzp

balajilolla2

Spoiler

Solution Attached
Screenshot 2024-11-11 102514.jpg

Challenge_450_start_file.yxmd

alexnajm

Always love a spatial problem - good one @clmc9601 !

Spoiler

Challenge_450_start_file_Alex Abi-Najm.yxzp

Kenda

Spoiler

Challenge_450_start_file.yxmd

jnibmo

Spoiler

Challenge_450_JI.yxmd

Qiu

@clmc9601
Thank you for this fun challenge.

Really need to carefully read this "most small islands".
I interpreted it wrongly at first.

Spoiler

Challenge_450_start_file-Qiu.yxzp

DaisukeTsuchiya

Spoiler

スクリーンショット 2024-11-12 092607.png

Challenge_450_start_file_DT.yxzp

AkimasaKajitani

My solution.

Spoiler

Challenge_450_start_file_AK.yxzp

Powerhouse_21

Spoiler

PH21_Challenge_450.yxmd

Dhrish

Spoiler

challeng e450 solution.yxzp

alacoume

My solution:

Spoiler

Challenge_450_start_file.yxmd

RWvanLeeuwen

nice challenge and a great refresher!

I had an issue with intersecting the shoreline with the mainland, but I look forward how others tackled this data quality topic

Spoiler

Challenge_450_start_file - RWvL.yxmd

ahsanaali

Spoiler

Challenge_450_Solution_AAA.yxmd

Spainey

Got to try out some new Spatial techniques here, very helpful learning experience.

Spoiler

Challenge_450_mark-spain.yxzp

ggruccio

Fun spatial challenge! I got to the correct answer, but I'll be interested in how others solved it!

Spoiler

Challenge_450_gg_finish.yxzp

olga_strubbe

This was a fun spatial challenge, it gave me a good refresher into spatial Alteryx functions. Thank you, Claire, @clmc9601

I split the Counties data set into detailed regions, but in this case splitting by Regions works as well, as we are not looking into which parts of the counties are considered 'Holes' in identifying islands, as the logic for the islands has already been defined by size of less than 5 sq km.