Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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 #184: Closest Pubs to Tobacco Dock

tiffany_chen
8 - Asteroid

First time to use spatial tools and learn based on others' solutions. Nice learn!

Spoiler
2019-11-17_174652.png2019-11-17_174728.png2019-11-17_175911.png
chris_ramsay_dup_425
8 - Asteroid

Here's my solution.

Yet to isolate the pubs on one side of the river.

Thanks,

Chris

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 184 is done, including the bonus!

 

Spoiler
image.png


image.png
SeanAdams
17 - Castor
17 - Castor

This was a good challenge - spent ages going down a rabbit hole to try to find shape files for the Thames river etc.    Then found an easier way (given we're only looking at 1km away) 🙂  Similar to your idea @TonyA 

@Hollingsworth- is there a better way to do this?

 

MapOutput.png

Spoiler

The approach was:
- Create the 1km radius
- then pump this into a yxdb
- use the mapInput tool to create two simple polygons of north and south of the river
- Map each pub to one of these using a formula (contains)

Solution.png



 

 

mbogusz
9 - Comet
Spoiler
Solution without the Report tool; Minimum viable product.Solution without the Report tool; Minimum viable product.
echuong1
Alteryx Alumni (Retired)

Getting the tobacco dock's correct location tricked me at first! 

SueDonim
8 - Asteroid

Fun exercise.  I could not figure out how to add labels to the points though.  Poked around on map tool but couldn't see it

 

Spoiler
Process:
- Text to columns to split lat and long ("," delimiter)
- Extract number from lat and long (left function).  Changed to "-" since west longitude
- Create points
- Set trade area at 1km
- Create points for lat and long of pubs
- Find Nearest set at 1km

MapOutput.PNGMySolution.PNG
PeterA
Alteryx Alumni (Retired)

 

A quick fun one... but wished I had drive time stats vs the blanket 1km radius.

 

Spoiler
weekly_challenge_184.jpg

CharlB
5 - Atom

I did this challenge a few weeks ago. Also, it was my first weekly challenge so go easy on me!

Really enjoyed it though.

johnsand
6 - Meteoroid

5th challenge for me - enjoying these 🐵