I have a spreadsheet with many origins and three destinations. I need to calculate the driving time between each origin and its corresponding destination. The origins and destinations are in the same spreadsheet. I geocoded the origins and destinations separately. Any advice is appreciated. Thanks!
Are you wanting road distance or straight-line?
If you want road distance, then you need the Network Analyst extension.
An overview of the Network Analyst toolbox—ArcGIS Pro | ArcGIS Desktop
an od matrix would work if you don't need to see the route
If you want straight line, then you can make point feature class or just a table using the origins and destinations, then calculate a geodesic distance if your points are in a decimal degree coordinate system.
Other options are described in
Thanks Dan! I have Network Analyst and have run OD Cost Matrix. How do I get Analyst to calculate the travel time from an origin to a specific designated destination? Instead of Analyst choosing a destination based on parameters, the destinations are already designated. I do not need the route shapes, just the straight lines and the travel time. My data is shaped per the table below.
Record # | Origin | Destination |
---|---|---|
1 | Address 1 | A |
2 | Address 2 | B |
3 | Address 3 | C |
4 | Address 4 | A |
5 | Address 5 | A |
6 | Address 6 | B |
7 | Address 7 | B |
Lawrence Roakes
Hi Lawrence
Did you get any success?
I have exactly the same problem as you. How could I set the OD matrix properties in order to know the distance between many origins and their corresponding destinations?
Thanks in advance
Hello Lawrence et al,
Indeed, I'm asking the same question and I'm wondering if there's been any movement or workaround solutions on this thread? Perhaps someone from ESRI can weight in? Essentially what's needed is the integration of the Generate Origin-Destination Links GP tool within the OD Cost Matrix function that resides in Network Analyst to facilitate drive times instead of as-the-crow fly distances. Curious if anyone has scripted some like this? Thanks!