I am working with a climate model that operates by means of a rotated grid of points. The rotation angle is about 15 degrees counterclockwise. The points are provided with (N, E) coordinates, but their IDs are nonconsecutive, and have irregular intervals.
In the image below, the bottom left point has OBJECTID=35, the one to its right has OBJECTID=40, the third to its right has OBJECTID=50, but then the leftmost point in the row above has OBJECTID=51.
My problem: I want to assign each point a new ID (integer) that starts from
0 (bottom left point) and increases towards the right hand side of the row, and row by row until it reaches the upper right point (highest ID).
The rotation causes problems because none of the coordinates are steady, but is there any way I could do this?
The grid has 400 points in the blue arrow direction, and 300 in the green arrow direction.
ArcGIS version: 10.3.1