Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #184: Closest Pubs to Tobacco Dock

Highlighted
8 - Asteroid

I couldn't help but chuckle reading through the thread at how everyone else did the river split using fancy spatial tools. I just used the data provided, added some context from the real world, and got the task finished quick so I can get out from behind the keyboard and into a pub!

 

 

Spoiler
Nice one, pretty straight forward. Parsed the lat/long points and then buffered the 1km radius. Did a spatial match for the in/out pubs then used the Borough name in the Map Report tool to categorize the results into north and south of the River Thames. 


Capture.PNGMap.PNG

 

 

Highlighted
13 - Pulsar

Does anyone have a list of pubs for New Orleans?  I'd like to plan for next June...

Highlighted
5 - Atom

Seems that the solution was with distance < 1mile, this was my first challenge, very interesting and useful for my job

Highlighted
8 - Asteroid

I don't normally post my answers to these but I thought this one might be of some use to someone. I decided to have a go a building a custom polygon that intersected the Thames and took only the bit north of the river. Hopefully there is an easier way of doing this than my method! Looking forward to rolling that out as a question to my tutor in the spatial analytics class at inspire.

Highlighted
7 - Meteor
Spoiler
PIcture.PNG

Highlighted
8 - Asteroid

A slightly easier way of creating the custom polygon

Highlighted
Alteryx
Alteryx

Solution attached, thrown of by changing the co-ordinates of the West value

Highlighted
Alteryx Certified Partner

My solution

 

Spoiler
challenge_184.PNG
Highlighted
12 - Quasar

My solution:

 

Spoiler
Capture.JPG
Highlighted
5 - Atom

Here's my solution:

 

Spoiler
Capture.PNG
Spoiler
I initially was working on filtering out the points south of the river with spatial tools but realized I could accomplish that by filtering out the borough of Southwark instead.