Select to view content in your preferred language

Batch Calculate Drivetime Between Specific Origins and Destinations

392
2
02-12-2024 06:57 AM
Labels (2)
IJurgensen
Emerging Contributor

Good Morning,

I have a CSV with lat/long origins and destinations and need to calculate the drivetime between each specific origin and specific destination. Think of these as distribution centers that are assigned to specific stores. I'm not looking for a tool to tell me which stores to assign to which centers, this assignment was already done but I need to calculate the drivetime between each store and their respective centers. I have the Network Analyst and Business Analyst tool sets and can use either ArcGIS Pro or Online - whichever is easier. 

Thank you!

0 Kudos
2 Replies
DavidPike
MVP Frequent Contributor

I'd just use Route Analysis and wrangle your input table so that each Centre and Store share the same Route ID.  Add the table in all as stops, and when you run the analysis - it will spit out a single route for each shared routeID.

Centre 1 | Route1 | Shape

Store A | Route 1 | Shape

Centre 2 | Route 2 | Shape

Store A | Route 2 | Shape

Centre 3 | Route 3 | Shape

Store B | Route 3 | Shape

 

0 Kudos
IJurgensen
Emerging Contributor

I'll give this a try, thank you!

 

0 Kudos