I am attempting to use the Overlay Route Events tool to intersect two tables based on a LRS system. I want to add the attributes from the one table to the other. Both of these tables have the same geometry, as they are founded on the same base LRS, though the log point breaks (and thus the line geometry segments) are at difference locations.
Each table has valid route identifier fields, and valid beginning and ending logpoint, or in other words, each table contains no overlapping segments within itself.
The Overlay Route Events tool, using intersect, produces duplicate records. For instance, if table A had a route R1 with two records for miles 0-2, 2-4, and table B had route R1 with two records for miles 0.5, 0.5-4, the resulting table shows breaks at the expected places, HOWEVER, there are duplicates at each break, as well as an additional record at the break point. So, this example results in:
0-0.5 (2 records)
0.5-0.5 (1 record)
0.5-2 (2 records)
2-2 (1 record)
2-4 (2 records)
This should not be the case. It should result in:
0-0.5
0.5-2
2-4
One record each.
I have run the operation several times, and have received these results each time.
Any thoughts as to why this tool is producing these results? In the meantime, back to GeoMedia products.