Drivetime Drive Distance Calculatiom

Hi All,

I have a 20M dataset. The dataset have customer Latitude, Longitude info and corresponding store Latitude Longitude info. I want to calculate Drive time and drive distance from Customer to Store.

But I saw that the run time is really huge.

So I checked with 100 sample records.

What I found is:

For small distances between two points (Say less than 10 miles), Alteryx Spatial is not taking much time to calculate Drivetime and Drive distance.

But for large distances, it is taking so much time.

My intuition is that for bigger distance it usually take much time. Is it true?

Can anyone please suggest me what is the convenient way to complete this?

Help

Spatial Analysis

Accepted answers

CharlieS

It's true that longer distances take longer to compute, and there isn't much getting around that for drive times. Make sure the dataset is installed on a local drive (same computer that's running Alteryx) and not on a network drive for best performance.

All comments

CharlieS

rmitra14

Thanks Charlie.

Brian6

I have the same issue ... very large datasets making driving distance impossible to use. I submitted a suggestion this morning asking for "estimated driving distance" Which would be helpful for compliance calculations.

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Estimated-Driving-Distances-needed-for-CMS-Reporting-and/idi-p/394608

CharlieS

That many records will make it more difficult, but certainly not impossible to use. There's no limitation by the product, only in how computer resources are used to process this request. I suggest breaking up the record calculation using a batch macro to better manage computer resources, or across multiple computers simultaneously.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703