How to sort or reorder points IDs in this scenario

[JackieMikael]

Hi.

i have tried all spatial sort method, but it doesn't work, its gonna zigzag..

The scenario is like these pictures. In the end, i want to list distances between points in large dataset..

1. old data points

2. merge new green points and old red points

3. reorder or sort them all.

Thanks!

[MicZatorsky_AEC]

Use linear referencing.

• Make sure the line has the direction you want and is in a planar coordinate system
• Using your line, create a route
• Using your points, Locate  Features Along the Route

This will give you a m-value for each point.  From that, you can determine the order and distance between points.