I am creating a bicycle route data using a road dataset. My road dataset ID field does not follow (in order) with my bicycle route. I'm wanting to create an ID field that traces my route and orders the ID by that route from start to finish. How can I best do this? I would prefer not to type in manually as there is more than 100 segments and re-typing in the ID numbers manually would take some time. Thanks for your help.
If you are just duplicating the road IDs into another field use the field calculator to do the value transfer. Similarly if you are assigning one number to many segments use the field calculator with a selected set of segments.
Network Analyst would be your best bet for creating the routes. It works like MapQuest and you could set begin, mid and end points of your bike routes derived from your existing road network to build new routes. I believe it will properly ID the route segment order of the lines it builds as part of its output (although that is a guess, since I really have not used it myself).
However, if you mean that you want to assign unique IDs to every segment to define an ordered route trace not built by Network Analyst, that is a manual process. Bicycle routes do not follow any required rule pattern that can be automated that I know of. For your specific set of bike routes you may have followed a pattern that would account for the vast majority of routes. If you could express those rules systematically you could program an ID assignment process to do it. But unless you are a skilled programmer, the effort to write that code will take longer than to manually assign IDs to 100 or so segments. I would only bother to write a program when I had at least 5000 segments, since tackling the complexity of route tracing in a custom program is a huge undertaking.