Hey guys hoping the network analyst experts can provide me a suggestion for the following task.
We have a *.csv file containing about 200k entries each entry lists the origin (XY Point) and the destination (XY Point) and an ID. The only thing we need to get out of the analysis is the Distance in km for each line in the csv file, nothing else (no Route Directions, Shapes etc).
CSV
ID, start_x, start_y, end_x, end_y
values ===============values
I was able to implement a script to solve what we need by using a ODCM with arcpy. But the problem is that (if I got it right) the ODCM calculates the routes for every entry which is okay for 1k or something like this but at 200k it takes "years". I am not quite satisfied with this solution because eventually I already know from which origin to which destination the route should be taken and I can't make it work using the Routing approach instead of ODCM.
Any suggestions how to solve this? An arcpy or ArcGIS Pro Workflow would be great!
Thanks in advance!
