I'll try and explain what I have and what I'm trying to accomplish. It seems like it should be simple but I'm struggling. I have a Measured layer that has segments for each mile along a route. In the table I have the Route_Id which looks like this. C000001E_12 for example. The C stands for Corridor. The 000001 is the route name. the E is the roadbed identifier and the 12 would be the mile post. So for C000001E there are several mile posts or C000001E_0, C000001E_1, C000001E_2 and so on until the end of the route. Each one of these segments has a length field which denotes the length of that mile. some are long and some are short miles. I'm wanting to create a route segment based on the mile posts. I was thinking I could create a line layer that has the specific C000001E with individual mile post records and their lengths. Has anyone done anything similar or can you help point me in the right direction?
TIA
Terry