Storing referent and offset information for event location
Roads and Highways can persist referent locations and measures with events, in addition to the route ID and measures. This is particularly useful for honoring event locations that are input as referent and offset, as opposed to relocating events after a cartographic realignment based on the new location of the event’s route ID and measure. As shown in the figure below, there are two line events on route 1 that are located between intersection 1 and intersection 2. The black event's from and to measures are stored in the form of route ID and measure, whereas for the green event, the same attributes are stored in the form of referent and offset values in addition to the route ID and measures.
Roads and Highways provides an option for changing the measure length of a route as a product of cartographic realignment of the route to reflect the change in geometric length. Therefore, when a cartographic realignment takes place to fix the shape of route 1, the measures on the black event remain intact even though the measure length of the route has increased and the resulting event does not touch intersection 2 anymore. The event has lost its location relative to intersection 2.
The green event changes its measure per its relation to the referent and offset values. Here the location of the intersections remains intact, hence the resulting event is still located between intersection 1 and intersection 2.
 |
In addition to route ID and measures, the events can have columns to store information about any referent location provided as data entry in the Roadway Characteristics Editor to derive the location of the event. The reference locations that can be stored include the following:
- Offset distance from any point feature in the geodatabase
- Offset distance from a Roads and Highways intersection point feature
- Offset distance from a Roads and Highways point event feature
- Offset distance from an x,y coordinate
- Offset distance from a station
To leverage this feature, additional columns must be configured with your events to include columns for the referent method, the referent location, and the referent offset. For linear events, there are two sets of these columns, one for the from measure and one for the to measure, as shown in the table below. For point events, only one set of the new columns is required. Also see Events data model.
You need to manually add these columns to the table before registering an event that stores referent offset values.
EventID | RouteID | FromDate | ToDate | FromMeasure | FromRefMethod | FromRefLocation | FromRefOffset | ToMeasure | ToRefMethod | ToRefLocation | ToRefOffset | Speed |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
100 | 9001 | 5/1/2000 | <NULL> | 0.26 | LRSI_Intersections | {3FA576BD-F8D9-4F6D-8FB6-DCFC44B56E5F} | 10 | 0.43 | LRSI_Intersections | {3FA576BD-F8D9-4F6D-8FB6-DCFC44B56E5F} | -26.2 | 40 |
200 | 9002 | 5/1/2000 | <NULL> | 0 | LRSI_Intersections | {D77B4973-BE9A-48C1-8227-50086A3A6928} | 0 | 2.359 | X/Y | 468465.683, 361690.902 | 100 | 40 |
300 | 9003 | 5/1/2000 | <NULL> | 0.41 | LRSE_Stations | 5 | -134.682 | 0.68 | LRSE_Stations | 5 | 1+38.998 | 40 |
400 | 9004 | 5/1/2000 | <NULL> | 0 | Posts | 11 | -20 | 1 | Length | 6336 | 65 |
The next sections describe the properties of the newly added columns.
Referent Method
This column stores the methodology provided for referencing the event location. When using Roads and Highways to provide a measure for an event by providing an intersection offset; x,y coordinate offset; feature and offset; event and offset; or starting station and offset, the provided referent location and offset will be stored with the event, along with the calculated route and measures. In addition, events in the same layer can have different referent methods; for example, a crash event in the layer can be located by x,y coordinate offset and another crash in the same event layer can be located by intersection and offset.
The Referent Method information is stored in a coded value domain named dReferentMethod in the geodatabase. This domain is created automatically when creating the ALRS with the following default values:
- Code 0 for x,y location offset
- Code 1 for length distance from a point location
- Code 2 for stationing offset
 |
The rest of the coded values are added automatically when you add a network, register a line or point event, create an LRS intersection class, or add a stationing event.
Note:- If you want to offset an event from a point feature class that is not part of the ALRS (but present within the geodatabase), you need to manually add that feature class's code and description (name) into the dReferentMethod domain.
- You can access the domains by right-clicking the geodatabase, selecting Properties > Domains, and clicking the dReferentMethod domain.
A coded value is used to store the referent method versus saving the name of the feature class used for the referent feature. In this manner, if the name of the feature class is changed, the event data will not need to be updated.
Referent Location
This column stores the referent location information for locating the feature. The following table describes the type of information stored in this field.
If the Referent Method is | Then the Referent Location field stores |
|---|---|
Route ID and Measure | Measure |
Intersection and Offset | Intersection ID |
Event ID and Offset | Event ID |
Feature Class and Offset | Object ID |
X,Y Coordinates | Comma-separated coordinates |
A Station Measure (relative to a Station Event layer) | Referent station Event ID |
Starting Station and Offset | Referent station Event ID |
Referent Offset
This column stores the offset measure from the referent location. The following table describes the type of information stored in this field.
If the Referent Method is | Then the Referent Offset field stores |
|---|---|
Route ID and Measure | Measure |
Intersection and Offset; Event and Offset; X,Y Coordinates; or Feature Class and Offset | Offset as a negative or positive value (compass directions provided by the user are translated to + or – offsets at storage) |
A station measure (relative to a Station Event layer) or Starting Station and Offset | User-supplied station measure in the station format (for example, 100+22.65) |
The units of measure for storage are configured at the time of registering the event layer.