Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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 #408: Sainsbury’s Market Research

alexnajm
17 - Castor
17 - Castor

Love Spatial as always!

スポイラ
Challenge 408.png
Watermark
12 - Quasar
12 - Quasar

Love doing spatial

 

スポイラ
MT_Solution_408.jpg

Aurora_M
メテオール
スポイラ
Spoiler!
Challenge 408 Solved.png
yyGuo
メテオロイド

Done!

スポイラ
Challenge408.png
Zhengyi
アステロイド

Very straightforward one to practice Spatial Match tool.

Woojac
メテオール

My Solution

jaroslav-tomcala
アステロイド

Hi, here is my solution

 

スポイラ
Solution_Challenge_408_start_file.JPG
emmaob98
メテオール
スポイラ
Spoiler.png
Lucy_Hickman
メテオロイド

I haven't worked a lot with Spatial data, but I wanted to give this a try on my own.

 

I was able to provide the correct output, but I didn't use the spatial match tool. I appended all the boroughs to all the locations, then used the spatial formula to find all the records where the the borough contained the store location then used the summarize tool to group by borough and count all the locations contained in the boroughs. 

 

Here is my workflow:

2024-02-06_13-33-57.png

Ray_Pospisil
アステロイド

Quick one