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:
There is an option on the tool "Keep zero length line events (optional)" which needs to be unchecked. You may not have seen this because the dialog is so large you have to scroll down to see these extra options.
I cannot see any application where I would want these kept, perhaps it should have been off by default.