Challenge #184: Closest Pubs to Tobacco Dock

A solution to last week's challenge can be found here!

Are you going to Inspire London? So are we, and we couldn't be more excited! Between two full days of Platform Training, a variety of breakout sessions, keynotes, and (our fave!) THE GRAND PRIX, we are ready to get.amplified!

Surely, all this activity will make us pretty thirsty. In preparation for Inspire, complete this week's challenge to map out the nearest pubs to Tobacco Dock where we can grab a pint with fellow Alteryx aficionados.

challenge_184_start_file.yxzp

Reporting

Spatial Analysis

Preparation

Advanced

Intermediate

Transform

Spatial

Accepted answers

All comments

JORGE4900

Break up lat lon into two fields; create points, create trade area, and spatial match. Looks like 4 Pubs within 1 km.

Spoiler

challenge_184_Jorge_Solution.yxmd

JordyMicheal

Same as others it seems. Fun little one

Spoiler

challenge_184_start_file.yxzp

LukeG

Spoiler

Used Spatial Match and Find Nearest to get same solution

Challenge_184_LG.yxmd

patrick_digan

Spoiler

1) I didn't realize that I had to use a negative on the x value to get the right spot.
2) I think this is a great use of custom map icons
Annotation 2019-10-07 130733.jpg

challenge_184_start_file.yxzp

viveknshah

Spoiler

Hopefully I met the ROYAL STANDARD! , else probably just REACH out my HENLEY ARMS upto BRICK LANE BREWS

challenge_184_shvive.yxmd

TonyA

Fun challenge. Too bad I can't get to Inspire and check the dock out in person...

Spoiler

I got caught by the "W" on the longitude and forgot to change the sign. The solution set me straight...

Added a solution to finding all the pubs on the same side of the Thames. It's not pretty and has some limitations but it's the best I could come up with. Looking forward to seeing others' solutions.

EDIT: Added a second version of the solution that doesn't have the limitations of the first one

challenge_184_TonyA.yxmd

challenge_184_TonyA_v2.yxmd

viveknshah

Learnt I made a blooper thanks to patrick_digan , My first spatial attempt and the learning continues!

Spoiler

challenge_184_shvive.yxmd

danilang

As it should be...32 pubs within one KM. I'm kinda' wary about the Slug and Lettuce, though.

Spoiler

Split lat/lon and change the lon to - since it's W. Find nearest within 1KM and spend some quality time in the Map tool to get icons.

Dan

challenge_184_solution_dl.yxmd

Kenda

Spoiler

I don't work with Lat/Long very often, let alone with London addresses, but I quickly learned that W meant to multiply that number by -1 based on the given output.

I wonder how many of these pubs @BenMoss has been to...

184kb.yxzp

T_Willins

Regular and advanced.

Spoiler

challenge_184_solution.yxmd

JORGE4900

Nice solution @patrick_digan You were able to figure out the longitude needed to be negative; I also like the way you came up with the icons for the pubs

Adam_Dooley

That Report Map tool is neat! Something I need to mess around more with.

Spoiler

challenge_184_AD.yxmd

JORGE4900

Nice job creating that polygon @T_Willins and cutting it out from the trade area.

RolandSchubert

Excellent preparation for Inspire.

Spoiler

Create Points and Find Nearest did the job, Report Map to show trhe results

challenge_184_solution_rsc.yxmd

kmcdaniel

Spoiler

challenge_184_kmcdaniel_solution.yxmd

JosephSerpis

Challenge Completed. I went for the advanced challenge and isolated the pubs from the South of the river using a technique called Voronoi polygons which @timrains showed me how to do within Alteryx.

Spoiler

challenge_184_Joe_Serpis.yxzp

hbraunius

My solution attached.

challenge_184_solution_hb.yxzp

RoDO

My solution

Spoiler

challenge_184_RODO_Solution.yxzp

CharlieS

Answering the real questions here.

Challenge_0184-CharlieS_Solution.yxmd

meeravijayan2011

Spoiler

SPOILER

challenge_184_solution_file.yxmd

Bdonahue

Spoiler

I took the Alteryx Conference Location input, split it to rows and removed Leading/Trailing Whitespaces. I then appended back the original location for kicks. I did a right() function to pull the direction of the coordinate. I then normalized the latitude or longitude by multiplying it by 1 or -1 for N,W and S,E. I pivoted back on the original location and then created a point and then used the trade area to create a 1km circle (Everyone uses miles in England... Kilometers are all a lie!). I created a point for each bar and, as they already were correctly formatted, used the spatial match to see where target records matched the trade area "universe". I then grabbed the Ward maps and joined those to the returns to figure out that Greenwich is across the river (and where the English decided the Prime Meridian would run) from the conference. I excluded all records in that ward and was left with 4 results. I compared the distances and sorted (in Feet from the venue) the list of pubs. Henley arms is your best bet at just under 3/10ths of a mile.
Screen Shot 2019-10-07 at 4.05.58 PM.png

Screen Shot 2019-10-07 at 4.05.58 PM.png

challenge_184 BD.yxmd

lmorrell

Fun challenge! The formatting in reporting tools always teaches me something new. Went for the original and advanced solutions - relying on the Distance tool to get the job done. Keen to see how others have approached the grouping across the river.

Spoiler

Original Solution

Advanced Solution

challenge_184_LM.yxzp

estherb47

I love spatial challenges!!!

Spoiler

Basic approach:

And advanced. Couldn't figure out how to get a shapefile of the area needed, so just traced using a map input. Then broke the pubs into north and south of the river. Find Nearest works to find the cardinal direction, and then a filter to separate north and south.

The workflow:

Most importantly, pub crawl at Inspire Europe?

Cheers!

Esther

challenge_184_EHB_completed.yxzp

Sebenius

Clean one and a small catcha on it as well if one is to quick.

Spoiler

Weekly 184 Map.

Map.

DataBlender

My solution, spent most of the time trying to match the formatting of the map!

challenge_184_solution.yxzp

LukeM

Map rendered with North and South of the river in pink and blue

For those coming to Inspire there are a few good pubs in that area. Notably The Town of Ramsgate and the Angel. Angel is up there with the best in London.

Lost a fair bit of time on that advanced one, trying to create two separate shapes form the polygon and river line. Eventually realised there was a much neater way...

Spoiler

Great fun. See you all at Inspire!

@JosephSerpis interested to know how you created that polygon?

challenge_184_LM solution.yxmd

DanielMS

Spoiler

Dan_Salway_challenge_184.yxmd

afv2688

Nice one!

Spoiler

challenge_184_end_file.yxmd

hanykowska

Nice one, looking forward to Inspire next week!

I did for only pubs on one side of the river which was a nice challenge

Spoiler

I got the Thames shapefile from here: https://www.ordnancesurvey.co.uk/

challenge_184_solution_hanykowska.yxzp

pasccout

Here is my solution

challenge_184_my_solution.yxmd

neilgallen

fun.

challenge_184_NGA_Solution.yxmd

jamielaird

My solution only requires a single tool:

Spoiler

If it's your first time in London, or you haven't visited before, I can't recommend it highly enough. Genuinely one of the most atmospheric places for a drink and a personal favourite.

Edit: Actual solution attached. I was lazy and didn't account for the river.

As @patrick_digan points out you have to negative the longitude or you end up half way down the runway at City airport.

challenge_184_solution_JL.yxmd

ch12345

I was caught out to start with due to the W direction. I'm not particularly experienced with the mapping tools, so I'm not sure if there was a more efficient way to remove outlying sectors.

Spoiler

challenge_184_start_file.yxmd

Joe_Beaven

Done!

Spoiler

Challenge 184.yxmd

simbert

Very useful challenge!

Spoiler

challenge_184_done.yxmd

JosephSerpis

Hi @LukeM the secret is to tick on "Eliminate Overlap" in the Trade Area tool and by feeding in some co-ordinates south of the river it creates trade areas with no overlaps.

JORGE4900

Hello Joe @JosephSerpis ; that is a good technique, and it helps to visualize how all those individual points keep from over-lapping each other.

The key is to generate trade areas that do not overlap each other.

Spoiler

When filtering the other trade areas, the remaining trade area retains the 4 borders of the overlapping points' trade areas.

Spoiler

timrains

Nice technique @JosephSerpis

patrick_digan

@LukeM For what it's worth, I've used the buffer tool in the past to turn the line into a really thin polygon. Then you can use the spatial process to remove the line from the trade area and then poly split to split the 2 separate parts into their own rows. Your solution is simpler, but this method will return the 2 separate pieces of the polygon which is sometimes useful.