@KatrinaOppermann Interesting use cases and thanks for the details. ArcGIS Roads and Highways provides advanced linear referencing configurations and various modelling techniques. Some of the relevant options are cited by @RyanKoschatzky
Q: Does Route_Id has to be fixed length?
A: Refer to LRS Data Model > Network feature class Organizations use the fields ‘Route ID’ and ‘Route Name’ in ways that best fit their business requirements. From a design perspective, ‘Route ID’ is like an unique database key, often modelled as a GUID (38 character, alpha-numeric) while ‘Route Name’ is a more human readable, nameplate information.
‘Route ID’ does not have to be fixed length however, the field data type and the data should be consistent throughout the LRS model objects (networks, events, calibration point feature classes). ‘Route ID’ maybe modelled by concatenation of other fields in the network feature class using Modify Route ID Padding.
Q: How to model Lane information?
A: The options are well laid out by Ryan. I would lean towards modelling the highway as the network routes and the lanes as events. This option reduces the maintenance overhead, editing experience is more efficient, and will likely be more performant. You can leverage subtypes to model the Lane table into an LRS event feature class. Refer to LRS Data Model > Events data model
Q: How to model Lane Condition data?
A: Certainly look at consolidating different conditions as suggested by Ryan. Lane Condition will be another LRS event layer and you can use similar modelling techniques as noted above. Alternate could be storing conditions as related table to the Lane.
Q: How to associate Lane Condition to Lanes?
A: There may be multiple options:
- Use dynamic segmentation to combine Lane Condition and Lane data from the two LRS event feature classes. There are multiple tools in ArcGIS Roads & Highways that allow you to dynamically segment the LRS events.
- Use related tables, relationship class
Ayan Palit | Principal Consultant Esri