Batch Calculate Drivetime Between Specific Origins and Destinations

Question

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!

IJurgensen · Answer

I'll give this a try, thank you!

DavidPike · Answer

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