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!

Saqueador
Challenge 408.png
Watermark
12 - Quasar
12 - Quasar

Love doing spatial

 

Saqueador
MT_Solution_408.jpg

Aurora_M
Meteoro
Saqueador
Spoiler!
Challenge 408 Solved.png
yyGuo
Meteoroide

Done!

Saqueador
Challenge408.png
Zhengyi
Asteroide

Very straightforward one to practice Spatial Match tool.

Woojac
Asteroide

My Solution

jaroslav-tomcala
Asteroide

Hi, here is my solution

 

Saqueador
Solution_Challenge_408_start_file.JPG
emmaob98
Meteoro
Saqueador
Spoiler.png
Lucy_Hickman
Meteoroide

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
Asteroide

Quick one