I have a linear reference challenge that I'm trying to solve. I have a road layer with an LRS system and I have several tables designed to map different road characteristics. For example, I have a table for shoulders and it has fields for shoulder type and width. Another table is for medians with a field for width and type. Ultimately the different tables produce multiple line layers for each characteristic and they all overlap. Attached you will see a diagram I created that explains my end goal. What I want to produce is a single line layer that is segmented whenever the road characteristic changes between the different road characteristic line layers. My thought is I need to combine all the tables into one table but the From and To fields have duplicates which still create overlapping lines. Any thoughts?
Thanks for your help.
Steve