Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #184: Closest Pubs to Tobacco Dock

Highlighted

I need to get better with spatial tools. This was a tough one for me.

Spoiler
sonyakasenkramer_0-1577820422168.png
Highlighted
Asteroid

I use formula instead of spacial match tool, very nice practice of report map tool, thanks!

Highlighted
Alteryx Partner

Solution attached.

Highlighted
Alteryx Partner

Another fun challenge in the books. Spatial challenges are always fun.

 

Spoiler
Make sure you pay attention to the longitude of the Tobacco Dock! 

Capture.PNG
Highlighted
Asteroid

Have to update when better at reporting but there's some extra steps in mine (labelling, table) specifically for the map.  Numbered/sorted pub locations by distance (crow's) from Tobacco Dock to facilitate cross reference of map to table.

Spoiler
 For the extra credit I would
1) spatially - intersect the pubs with an externally acquired (or internally drawn) shape with neighborhoods/wards/boroughs.
2) use the ward or borough attribute in the pubs table as I believe the Thames River bounds these divisions - can be checked comparison to external shape from #1 above.
Challenge184workflow.png


  

Highlighted
Meteor

Quick one - bars North of the Thames within 1KM.

 

Spoiler
Plight 184 Solution.PNGPlight 188 Solution.PNG
Highlighted
Asteroid
 
Highlighted
Pulsar

Here is my solution 

 

Spoiler
Capture.PNG
Highlighted

That one was so much fun! For the second part, I used a Map Input tool to draw a polygon where the river is (and created a yxdb based on the Tobacco Dock location point to use as a reference for the Map Input tool).

Spoiler
Angela_M_Burks_0-1579898933358.png
Highlighted
Meteor

My solution

 

Spoiler
jallen297_0-1580235181961.png