Calculating Shortest Paths for Individual Rows in Large Network Dataset

Question

I need help with network analysis on the Esri Community forum. I have a table with 100,000 rows describing routes from point A to point B. Each route is described by starting and ending coordinates. I also have a prepared network dataset, and I need to calculate the shortest path along the line for each row. I tried using "cos matrices," but it combines all the rows.

Melinda Morang · Answer

What network dataset are you using?  Is it one you created yourself?  Usually when I see routes like this, it's a symptom of a network dataset connectivity problem or a problem with the way the cost attributes are configured.  The Route solver will always return the "shortest" path, but if the cost attributes are returning incorrect values, the shortest path calculation will also be incorrect.  Or, if there is no connection between roads at intersections, the shortest path may be to travel very far until it finds a usable connection.

JiříKomínek · Answer

thanks I tried the tool, but instead of the shortest path between points I got the longest possible distance 🙂 I don't know why, but this is not quite the right calculation. I tried it with only 4 points for a sample, OD COS Matrix gives a realistic result.

JiříKomínek · Answer

Thank you very much! I will try it tonight. I read quickly documentation and it looks like what i need.