I am trying to find the road distance between consecutive or say all nearest points.
A sample of my network is shown in the image. My actual network has more than 5000 points. Now I want to calculate the distance between consecutive points like point id 335 and 3797, then 3797 and 2281 and so on, the disconnected points can be ignored.
I tried using closest facility option. I loaded all the points as facilities and incidents to find 3 nearest facilities but it is giving me around 40k + routes which are repeated/overlapping and also the longer routes are not covered, like the nearest facility from point id 2281 will be 2281, 3797 and 678 and it will not cover 1818
I am not sure if i have started in the right direction. If anyone has solved similar kind of problem kindly help me out.
Notes about the network: all the points are properly placed, there are no overlapping lines, no snapping problem, the topological errors have been removed.