Find the number of ATMs within a 50 km radius of the agencies

[Denisa_Grecu]

Hello,

I have the following situation:

I need to find the number of ATMs within a 50 km radius of the agencies from the attached example file (just a small sample from my original file).

If we assume that we take all ATMs (single withdrawal, withdrawal and deposit, single deposit), we have about 9500 devices.

So if we combine all the possible cases of distances, we have: 90,250,000 lines.  We will limit the combinations to less than 50km, beyond which there is no business sense.

I put a file to with agencies, addresses and geo-location information to give me some hints and maybe a workflow example. Please note that this is the first time I am working on a geo - coding project and I am not sure where to start from.

Please note that my Alteryx interface and access is limited to some tools, therefore I don´t have all geo coding tools available to work with. The available tools that I have:

Spatial tools: 

Address tools:

Please let me know if my project is achievable within Alteryx.

Looking forward for your answer.

Denisa

[FinnCharlton · Accepted solution]

Hi @Denisa_Grecu , I assume you also have a dataset detailing the locations of the ATMs? If you do, including the latitude and longitudes, then this is definitely achievable in Alteryx. Your workflow would look something like this:

Input Agency Dataset ->
Create Spatial Object for each Agency from Lat/Lon (Create Points Tool)->
Input ATM Dataset ->
Create Spatial Object for each ATM from Lat/Lon (Create Points Tool)->

Create 50km buffer around each Agency (Buffer tool) ->
Find all the ATMs inside each of these buffers (Spatial Match Tool) ->
Count the matches for each Agency (Summarise Tool)

Hope this helps!

[Yoshiro_Fujimori]

Hi @Denisa_Grecu ,

I would recommend you take these Interactive Lessons: Spatial Analytics, especially Creating Spatial Objects, Constructing Trade Areas, Relating Spatial Objects.

And look at the solutions of this Weekly Challenge Inspire Europe '16 Grand Prix (L2)

As a starting point, one way to create spatial objects of 50 km radius from the locations of your data set is as attached.

Formula tool

To create point of the location from [point_geographique] column,

Longitude = ToNumber(GetWord([point_geographique], 1))

Latitude = ToNumber(REGEX_Replace([point_geographique], "([\d\.]+).*", "$1"))

Point = ST_CreatePoint([Longitude],[Latitude])

Trade Area tool

To create spatial object of 50km radius from the above points,

Good luck!

[RobertOdera · Accepted solution]

Hi, @Denisa_Grecu 

Kindly consider this as one approach for a starting point - I hope you find it helpful.

Better if we have sample files for your other next steps.

Also helps is you have a geocoder package or TomTom to use Drive Time as well...

Fyi - you don't need Km to Miles conversion. Just configure the Trade Area tool per below

[Denisa_Grecu]

Hello.

Thank you guys for all insights. All 3 of you gave me hints that helped me. The most complex solution is the one offered by @FinnCharlton and @RobertOdera, although I need to create additional development.  

Thank you,

Denisa Grecu

[RobertOdera]

You're most welcome @Denisa_Grecu!