Challenge #133: US Grand Prix Prelims - NASA Location Analysis

As we gear up for the Grand Prix Europe Finals (finalists to be announced this week!), I wanted to give everyone a taste for what it takes to qualify for the Grand Prix.

This workflow was 1 of 9 that contestants could solve. They had 60 minutes to complete as many as possible, each netting points towards a final score. This question was worth 5 points (average question value was 4.67).

Good luck!

challenge_133_start_file.yxmd

Join

Spatial Analysis

Preparation

Advanced

Intermediate

Data Preparation

Transform

Spatial

Accepted answers

All comments

CharlieS

Spoiler

Challenge_0133-CharlieS_Solution.yxmd

patrick_digan

Here's my solution:

Spoiler

I joined on the non-spatial outputs from the spatial info tool

challenge_133_start_file.yxmd

ggruccio

Very fun spatial challenge! Looks like I was thinking along the same lines as @CharlieS.

Spoiler

challenge_133_gg_finish.yxmd

ckings

Spoiler

I would have taken too much time to solve this in the prelims unfortunately. Still a fun one though!

challenge_133_CAK.yxmd

JimmyG

@ckings keep working on the weekly challenges on the speed will come!

maraquindoza

Attached is my solution

challenge_133_start_file_Mara.yxmd

KOBoyle

Solution attached.

Spoiler

challenge_133_solution_KO.yxmd

Ladarthure

My solution, nice challenge!

challenge_133_start_file.yxmd

danilang

Fun Challenge

Spoiler

Same general track as the previous ones, except that I took advantage of the spatial function Create Convex Hull within the Summarize tool. This way there is no need to join back to the original list and then use a Poly-Build. Using this method you do create more polygons up front, so it may take a hit performance-wise.

Dan

challenge_133_solution_DL.yxmd

clant

Here is my solution,

Spoiler

challenge_133_finish_file.yxmd

DavidP

Here's mine

challenge_133_DavidP.yxmd

neilgallen

attached!

Spoiler

challenge_133_NGA.yxmd

DougRangel

challenge_133_Solved.yxmd

Aidan_K

This is my first Spatial challenge, I think I've got it

Thanks,

AidanKing

challenge_133_AidanKing.yxmd

George_Walker

Spoiler

Looks like others have done it more cleanly with a join, but here is my solution

challenge_133_solution_file.yxmd

JimmyG

@Aidan_K wow, first spatial challenge - well done!

kat

Spoiler

Challenge #133.yxmd

NicoleJohnson

My solution! SO excited to see who is up on stage for the Europe Grand Prix in a few weeks!!

Spoiler

I remember getting tripped up on this one, and I think it had something to do with how I tried to combine the spatial objects at the end to create the desired polygon... Went with the Transpose-to-Summarize method this time, and it seemed to work just fine to line up the original facility object with the matching facility objects in a way that allowed me to combine them smoothly.

Finished this one in 4 1/2 minutes - though it probably helps that I'd seen it and struggled with it once before

Cheers!

challenge_133_NicoleJohnson.yxmd

sfadel

Challenge_0133-SalimF_Solution.yxmd

mestevez1

Got my inspiration from @ggruccio, @ckings and @TylerNa. Always a great learning opportunity.

Spoiler

AGoyal

Solved.

Spoiler

challenge_133_start_file.yxmd

StevenBetts

Here's my solution

Spoiler

challenge_133_start_file_SMB.yxmd

jasperlch

Nice challenges on Spatial Tools!

challenge_133_JL.yxmd

unknown

CE challenge_133_start_file (1).yxmd

AndyBate

Complete - really enjoyed this one

challenge_133.yxmd

estherb47

My solution. Looks like it's a hybrid of some previous answers. Fun spatial challenge.

Is there an advantage to the Poly-Build tool over the Summarize tool for building a convex hull? I always drift towards the Summarize, just because I learned that one first.

Spoiler

challenge_133_EHB_completedyxmd.yxmd

KyleLarsen

challenge_133_start_file_solved.yxmd

jvansistine

This one wasn't too bad, although I had just recently used a bunch of these tools for another project so I knew just what to do!

challenge_133_solved_jvs.yxmd

JimmyG

@jvansistine you use the Poly-build tool often? I'm interested to hear the use case!

JimmyG

I don't know if there is a big advantage of one over the other, @estherb47. The spatial calculations are apparently faster in a Formula tool versus the Spatial tools (like distance), so I would imagine that might apply to Summarize versus Poly-build.