Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution.
Not sure what the solution was using, it looked like nothing what I got when I used 1Km distance. I only found 4 pubs, all north of the river. I went ahead and upped it to 1.5Km and got a few more, including some on both sides of the river so I could do that part of the challenge. I'm studying for advanced cert so decided to go the extra mile and also tried this with trade areas and without, and put them in a report
Long at Lat values showed Woolwich for me - so I put the Long/Lat in customly to the text input (so I still needed to break it up with a text-to-columns.
Also added a custom polygon to only show pubs north of the river!
Used Regex to get Lat & Lon of Dock. Create Points tool for both Dock and Pubs. Trade Area tool at 1km on Docks point. Spatial Match with Dock Trade Area as Universe and Pubs as Target to find Where Target within Universe. Result: 4 pubs in target area.