Create a template for an LRS route log data product

Available with Location Referencing license.

You can create LRS route log data products using the Generate LRS Data Product tool. This tool requires an LRS data template.

The ArcGIS Roads and Highways extension includes a Data Product Designer wizard to create LRS data templates.

The sample route log shown in the table is created for the SR9WB route depicted in the diagram below. The measures on the route increase in the direction of the arrow. The route log places the records on the route as if a person moving in that direction is noting the classification and measure value information of the chosen layers as they are encountered.

The SR9WB route and associated route characteristics along the route

The route log data product returns the location and information of point events, line events, intersections, referent features, and polygon boundaries for the SR9WB route. The following list shows the characteristics found along the engineering route:

  • Log fields: Sign Type, Functional Class, Speed Limit, and Intersection
  • Location fields: County and City boundaries
  • Referent field: Mile post

The following table is the returned route log for the route after inputting the LRS data template into the Generate LRS Data Product tool.

Route IDDescriptionMeasureReferentOffsetCountyCitySign TypeIntersectionFunctional ClassSpeed Limit

SR9WB

Begin Route: SR9WB

0

Mile 0

0

Union

Titan

Interstate

65

SR9WB

Intersecting SR9WB, SW26WB

0

Mile 0

0

Union

Titan

SR9WB, SW26WB

Interstate

65

SR9WB

Begin Functional Class Interstate

0

Mile 0

0

Union

Titan

Interstate

65

SR9WB

Begin Speed Limit 65 MPH

0

Mile 0

0

Union

Titan

Interstate

65

SR9WB

Speed Limit Sign

1.4

Mile 0

1.4

Union

Titan

Speed Limit

Interstate

65

SR9WB

Stop Sign

2.5

Mile 2

0.5

Union

Titan

Stop

Interstate

65

SR9WB

Intersecting SR9WB, NR38WB

2.5

Mile 2

0.5

Union

Titan

SR9WB, NR38WB

Interstate

65

SR9WB

Leaving City Limit: Titan

3.5

Mile 2

1.5

Union

Titan

Interstate

65

SR9WB

Entering City Limit: Adam

3.5

Mile 2

1.5

Union

Adam

Interstate

65

SR9WB

End Functional Class Interstate

4

Mile 2

2

Union

Adam

Interstate

65

SR9WB

Begin Functional Class Local

4

Mile 2

2

Union

Adam

Local

65

SR9WB

End Speed Limit 65 MPH

6

Mile 6

0

Union

Adam

Local

65

SR9WB

Begin Speed Limit 40 MPH

6

Mile 6

0

Union

Adam

Local

40

SR9WB

Speed Limit Sign

7.6

Mile 6

1.6

Union

Adam

Speed Limit

Local

40

SR9WB

End Speed Limit 40 MPH

10

Mile 10

0

Union

Adam

Local

40

SR9WB

End Functional Class Local

10

Mile 10

0

Union

Adam

Local

40

SR9WB

Intersecting SR9WB, NR71WB

10

Mile 10

0

Union

Adam

SR9WB, NR71WB

Local

40

SR9WB

End Route: SR9WB

10

Mile 10

0

Union

Adam

Local

40

Other types of route log data products that you can configure include the following:

  • Change of pavement conditions along routes in different urban areas
  • Crash, speed limit, and intersections along routes with signs as the referent location
  • The entry and exit measures of interstate routes when they cross counties and cities

The next sections describe how to use the Data Product Designer wizard to create a template for the Generate LRS Data Product tool to produce a route log data product similar to the one shown in the table above.

Choose an LRS data product type

The first step in the Data Product Designer wizard is to specify the data product type.

To specify the Route Log data product type, complete the following steps:

  1. Start ArcGIS Pro and open a project with LRS data in the map.
  2. On the Location Referencing tab, in the LRS Data Products group, click Data Product Designer .

    The Choose an LRS data product type page of the Data Product Designer wizard appears.

  3. Click the Data Product Type drop-down arrow and choose Route Log.
    Route Log data product type on the Choose an LRS data product type page
  4. Click Next.

    The Set template properties page appears.

Set template properties

To set the template properties once the template type is specified, complete the following steps:

  1. Provide a template name.

    By default, the template is saved in the project folder. Optionally, browse to a different location, provide a name for the template, and click OK.

  2. Click the Network drop-down arrow and choose a network.

    Route characteristics will be provided for this network when the Generate LRS Data Product tool is run with the template.

  3. Optionally, provide a description.
    Template properties are set in the Set template properties page
  4. Optionally, click Preview to preview the information in a canvas.
    The canvas after setting template properties
    Note:
    If the chosen network is a line network, the Line Name column appears in the route log next to the route identifier field.
  5. Click Next.

    The Select a route identifier field page appears.

Select a route identifier field

The next step to produce a template for a route log is to add a route identifier field and provide informative text. The route identifier can be a route name or route ID.

This example uses ROUTE_ID as the network's route identifier field and Route ID as the display name in the Name in Table text box. The display name is also updated in the preview canvas. In the example route log, the start and end points of a route are Begin Route: SR9WB and End Route: SR9WB.

To specify a route identifier field, complete the following steps:

  1. Click the Route Identifier drop-down arrow and choose a field.

    The default option is Route ID if the specified network is not a line network, or Route Name if the specified network is a line network.

    If the specified network has both a route ID and a route name configured, you can choose one of the two options using the drop-down arrow.

  2. Optionally, update the display name in the Name in Table text box.

    The default display name is the Route Identifier value.

  3. Optionally, update the text in the Feature Begin Text and Feature End Text text boxes to indicate the start and end of the routes.

    The default values are Begin and End, respectively.

  4. Optionally, provide text in the Field Value Prefix and Field Value Suffix text boxes to supplement information before and after the route identifier value, respectively.

    In the example, Route: is the prefix for the route identifier value. The example does not include a field value suffix.

    Choose a route identifier field and provide informative texts for a route log template
    The canvas after choosing a route identifier field

    Choosing a route identifier field ensures that the route log data product generated using this template will include route information fields.

    Route information fields in the route log after choosing a route identifier field
  5. Click Next.

    The Add log fields page appears.

Add log fields

In a route log data product, the log fields form the columns that include event and intersection information. You can add log fields from log layers and supplement informative text. Informative text provides details about the log layers.

Note:
A centerline feature class can also be used as a log layer when it is configured with the Address Data Management solution or a utility network.

The example in this section uses four log layers:

  • Signs point event
  • Intersection
  • Speed Limit line event
  • Functional Class line event

An LRS route log data product generated using this template returns a record when any of these layers appear and end on a route.

Note:

Adding log fields is optional. If you don't want to add log fields to the template, click Next to proceed to adding location fields.

To add log fields, complete the following steps:

  1. Click Add to create a blank row in the Log Fields table.
  2. Click the Layer drop-down arrow and choose a log layer.

    The layer can be a point event, a line event, or an intersection that is registered to the network specified when setting the template properties. It must be stored in the same geodatabase or feature service and have the same coordinate system as the specified network. The layer you specify determines which fields are available for the Field menu.

    The first log layer configured in the example is the Signs point event.

  3. Click the Field drop-down arrow and choose a field from the layer specified.

    For this example, Sign Type is configured as one of the log fields.

  4. Optionally, update the display name in the Name in Table text box.

    The default display name is the Field value.

    This text updates the row in the Log Fields table.

  5. Optionally, provide text in the Feature Begin Text and Feature End Text text boxes.

    This text will appear before the start and end of log fields.

    The default values are Begin and End, respectively.

    Note:

    The Feature Begin Text and Feature End Text text boxes are not available when using a point event layer or an intersection layer.

  6. Optionally, provide Field Value Prefix and Field Value Suffix text.

    This text provides additional information about the log value and is inserted before and after the log value, respectively.

    In the example below, Speed Limit is the Field Value Prefix value and MPH is the Field Value Suffix value added for the Functional Class line event.

    Speed Limit entries with informative texts
  7. Optionally, click New expression to define an expression that filters specific log values.

    Only features that meet the filter expression will be returned in route log. For example, FUNCTIONAL_CLASS = 1 will return only interstate functional classes.

  8. Optionally, check the Merge Coincident Events check box for line event log layers.

    Checking this box returns coincident events with the same value in the log field as a single event in the route log.

  9. If you want to add multiple log fields, repeat the previous steps for each field.

    For this example, Sign Type, Intersection, Speed Limit, and Functional Class are configured as log fields.

    Choose log layers and fields to be included in the route log
    The canvas after adding log fields

    By adding log fields, route log data products generated with this template will have columns that include event and intersection information.

    Log fields in the route log after adding log fields
  10. Click Next.

    The Add location fields page appears.

Add location fields

After adding log layers, you can add location layers and location fields. The location fields form the columns that contain information about the polygon boundaries crossed by the routes. You can also provide informative text for the location layers.

The example in this section uses County and City as the location layers. A route log data product generated using this template will return a record when a route enters or leaves a county or city.

Note:

Adding location fields is optional. If you don't want to add location fields to the template, click Next to proceed to selecting a referent field.

To add location fields, complete the following steps:

  1. Click Add to create a blank row in the Location Fields table.
  2. Click the Layer drop-down arrow and choose a location layer.

    The layer must be a polygon feature class stored in the same geodatabase or feature service and have the same coordinate system as the specified network when setting the template properties.

    The first location layer configured in the example is CountyBoundary.

  3. Click the Field drop-down arrow and choose a field from the location layer specified.

    For this example, County is configured as the location field.

  4. Optionally, update the display name in the Name in Table text box.

    The default display name is the location field.

    This text updates the row in the Location Fields table.

  5. Optionally, provide text for the Feature Begin Text and Feature End Text text boxes.

    This text will appear before the start and end of the location fields.

    The default values are Begin and End, respectively.

    For this example, the Feature Begin Text and Feature End Text text boxes are updated to Entering County Limit: and Leaving County Limit:, respectively.

  6. Optionally, click the Filter Expression drop-down arrow and provide an expression to filter by a specific location field.

    Only features that meet the filter expression will be returned in the route log.

    The example does not have a filter expression configured for location fields. One example of a filter expression, REGION = "SOUTHWEST", will return only route interactions with counties in the southwest region.

  7. If you want to add multiple location fields, repeat the previous steps for each field.

    The example has two location fields, County and City.

    Add location fields to be included in the route log
    The canvas after adding location fields

    By adding location fields, the route log data products generated with this template will have columns that contain records of when a route enters or leaves a location.

    The location fields in the route log after adding location fields
  8. Click Next.

    The Select a referent field page appears.

Select a referent field

After adding location layers, you can add a referent field from a referent layer. The referent field forms the columns that include referent and offset information. You can also provide informative text for the referent layer.

Note:
  • Configuring a referent field is optional. If you do not want to configure a referent field, click Finish to save the template.
  • You can configure only one referent layer for a route log template.

To configure a referent field, complete the following steps:

  1. Click the Referent Located At drop-down arrow and choose a referent method:
    • Nearest Upstream—The nearest referent feature upstream of the route log entry will be used to calculate the referent offset. If no upstream referent feature exists, the referent values will be empty.
    • Nearest—The nearest referent feature, upstream or downstream to the route log entry, will be used to calculate the referent offset.

    The following graphic and table illustrate the difference between the two referent methods. The stop sign event is 1 mile upstream from the nearest mile post, so the offset is -1. Additionally, the stop sign is 6 miles from the nearest upstream mile post, so the offset is 6.

    A stop sign with two mile posts on Route1

    Referent methodReferentOffset (US Survey Miles)

    Nearest

    Mile 7

    -1

    Nearest Upstream

    Mile 0

    6

  2. Click the Layer drop-down arrow and choose a referent layer.

    The layer must be a point event stored in the same geodatabase or feature service and have the same coordinate system as the specified network when setting the template properties.

    For this example, MilePost is configured as the referent layer.

  3. Click the Field drop-down arrow and choose a referent field.

    For this example, Post_Name is the referent field.

  4. Optionally, update the display name in the Name in Table text box.

    The default display name is Referent.

  5. Optionally, provide text in the Field Value Prefix and Field Value Suffix text boxes.

    The text provides information about the referent value and is inserted before and after the value, respectively.

  6. Optionally, click the Offset Unit drop-down arrow and choose a different unit.

    The default offset unit is Feet (International).

    For this example, the Offset Unit value is set to Miles (US Survey).

    Choose a referent layer and field for a route log template
    The canvas after adding a referent field

    By adding a referent field, the route log data products generated with this template will have columns that include referent and offset information.

    Referent and offset information in the route log after choosing a referent field
  7. Click Finish to save the template.

The template is complete and can be used in the Generate LRS Data Product tool to generate an LRS data product.

Note:

To review or edit an existing template, on the Set template properties page, click Browse for the template location next to the Template text box. You can choose a template from the project folder or from other locations.

Related topics