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!

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

Love doing spatial

 

Spoiler
MT_Solution_408.jpg

Aurora_M
7 - Meteor
Spoiler
Spoiler!
Challenge 408 Solved.png
yyGuo
6 - Meteoroid

Done!

Spoiler
Challenge408.png
Zhengyi
8 - Asteroid

Very straightforward one to practice Spatial Match tool.

Woojac
7 - Meteor

My Solution

jaroslav-tomcala
8 - Asteroid

Hi, here is my solution

 

Spoiler
Solution_Challenge_408_start_file.JPG
emmaob98
7 - Meteor
Spoiler
Spoiler.png
Lucy_Hickman
6 - Meteoroid

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
8 - Asteroid

Quick one