Events data model

Events are managed within Esri Roads and Highways in feature classes called event feature classes. When registering an event, you can register an event as either residing within the same geodatabase as the LRS or being in a database outside the geodatabase with the LRS. For events residing within the geodatabase with the LRS, Esri Roads and Highways manages the shape of the feature based on the route, measure, and to and from dates. This provides increased performance for mapping and spatial query of the event data. For external events outside the geodatabase with the LRS, a read-only connection to the source event data is required. Depending on the type of event being registered, different fields are required in the source event data. The required fields for each event type are below.

Note:

Event feature classes can be modeled in advance or created when registering the event in the LRS. If modeled in advance, ensure the spatial reference, x,y-, z-, and m-tolerance and resolution of the event feature class matches that of the network it associates with. This ensures the events and measures stay in alignment with the routes they are associated with in the network. For more information about tolerance and resolution in Esri Roads and Highways, see LRS data model.

Route and Measure events

If your event will be based on Route and Measure, fields to determine the route and measure the event is located on are required. In addition to those fields, the following fields are required in the source event data.

Field	Data Type	Length	IsNullable	Description
EventID	String	Between 32 and 255	No	Unique ID for each event record
RouteID	String	Length of the Network RouteID field or greater	No	Unique ID for each route in the network
FromDate	Date	8	Yes	The date the event became active on the route
ToDate	Date	8	Yes	The date the event was retired on the route
Measure (point events)	Any Numeric		No	The measure on the route where the event will be located
FromMeasure (line events)	Any Numeric		No	The measure on the route where the beginning of the event will be located
ToMeasure (line events)	Any Numeric		No	The measure on the route where the end of the event will be located
LocationError	String	100	Yes	The location error for the event.

Storing Referent Location with events

When registering Route and Measure events, the option to store the event location based on its offset from another location is possible. These offsets can be based on x- and y-coordinates, a station, length from the beginning of an event, other LRS events, intersections, or another point feature class. To enable storing referent locations with a Route and Measure event, the following fields should be in the source event data.

Field	Data Type	Length	IsNullable	Description
ReferentMethod (point events)	Short Integer	5	Yes	Method of referencing the offset feature. Can be x,y coordinates, Stationing, Length, LRS Network, Event, Intersection, or other point feature class.
ReferentLocation (point events)	String	Between 50 and 255	Yes	Location of the offsetting feature. Can be an x,y coordinate, Feature/EventID, or IntersectionID.
ReferentOffset (point events)	String	Between 50 and 255	Yes	The offset measure. Saved in the unit of measure configured when configuring offset fields.
FromReferentMethod (linear events)	Short Integer	5	Yes	Method of referencing the offset feature. Can be X-Y coordinates, Stationing, Length, LRS Network, Event, Intersection, or other point feature class.
FromReferentLocation (linear events)	String	Between 50 and 255	Yes	Location of the offsetting feature. Can be an x,y coordinate, Feature/EventID, or IntersectionID.
FromReferentOffset (linear events)	String	Between 50 and 255	Yes	The offset measure. Saved in the unit of measure configured when configuring offset fields.
ToReferentMethod (linear events)	Short Integer	5	Yes	Method of referencing the offset feature. Can be x,y coordinates, Stationing, Length, LRS Network, Event, Intersection, or other point feature class.
ToReferentLocation (linear events)	String	Between 50 and 255	Yes	Location of the offsetting feature. Can be an x,y coordinate, Feature/EventID, or IntersectionID.
ToReferentOffset (linear events)	String	Between 50 and 255	Yes	The offset measure. Saved in the unit of measure configured when configuring offset fields.

Stationing events

When registering a stationing event, all of the fields from a Route and Measure point event are required in the source event data. In addition, the following fields should be present in the source event data.

Field	Data Type	Length	IsNullable	Description
Station	String	Any	Yes	Stationing value for the station.
BackStation	String	Any	Yes	Back stationing value for the station. This value would be populated if an equation point is present at the station location.
StationDirection	String	Any	Yes	Field used to designate if stationing values increase in the opposite direction of the increase in measure on routes.