How to sort or reorder points IDs in this scenario

Question

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 · Answer

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.