Dear MapInfo Pro Community
During the transformation of the road data network to the new asset management system found the road segments are not in the correct order. It means chainage lengths are not following sequentially. There are thousands of segments in such a position.
For instance, as seen in the attached file (yellow highlights length), the road segments arrangement is not next to the end chainage. The line directions are correct related to the road datum points.
To resolve the issue, I have found only a choice to do manually by relocating each road's segment to the correct position. This process is time-consuming and feels not a stylish way to fix the problem.
I am wondering whether there is a method to fix the problem i.e., make the road segments in the chain of measurement.
Any comments or advice would be much appreciated.
The problem is not in the table. Issues are being noted in the layers or road lines.
The segments do not follow the chronological segment i.e., road segments are randomly in the position of the line.
For instance, The Boolite Donald Road starts from Lawler Road (the line direction is correct) but noticed that segment start and finish are not in order say 0m chainage (datum points) is at the middle of the road, noticed the segment starting from 2260m (see details for the attachment).