Create a template for an LRS feature count data product

Available with Location Referencing license.

An LRS feature count data product provides information about the number of line events, point events, and intersections per route. You can find the number of pipeline crossings on a route or the number of In-line Inspection (ILI) anomalies along a route that is part of a pipeline. This type of information can be useful for planning and maintenance purposes.

A sample feature count data product is produced for Pipe1 depicted in the diagram below.

Diagram of Pipe1 that includes RouteX and RouteY

Pipe1 includes two routes, RouteX and RouteY. The table below shows the distribution of pipeline crossings, ILI anomalies, and pipeline casing material types per route.

Line NameRoute NamePipeline CrossingsILI AnomaliesSteel CasingConcrete CasingPVC Casing

Pipe1

RouteX

1

3

1

1

0

Pipe1

RouteY

1

2

0

0

1

Feature count table for Pipe1

To produce this data product, you must first create an LRS data template using the Data Product Designer wizard. Then, you can input the LRS data template into the Generate LRS Data Product tool.

The workflow below uses the Data Product Designer wizard to create a template to produce an LRS feature count 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 Feature Count 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 LRS Data Template.

    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 Feature Count.
    Feature Count 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 on the Set template properties page.

  4. Click Next.

    The Add summary fields page appears.

Add summary fields

The next step is to choose summary layers and summary fields. A feature count can be based on unique values in the summary layer on a per-route basis. You can configure multiple summary layers. The summary layers are arranged and divided by levels based on their spatial relationships.

For example, you can configure a county boundary layer as level one, and a city boundary layer as level two.

Note:

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

To add summary fields, complete the following steps:

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

    The layer can be a polygon feature class or a line event that is registered to the network specified when setting the template properties. It must be in the same geodatabase or feature service and have the same projection as the specified network.

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

    Once a summary field is chosen, the Display Value Map section displays a table of the unique values in the summary field.

  4. Optionally, edit the values in the Display Value column in the table.
  5. Optionally, update the display name for the summary level in the Name in Table text box.
  6. Optionally, click the Filter Expression drop-down arrow and define an expression to filter display values in the Display Value Map section.
  7. To add multiple summary levels, repeat the previous steps for each level.
  8. Click Next.

    The Select a route identifier field page appears.

Select a route identifier field

The next step to produce a template for an LRS feature count data product is to add a route identifier field. The route identifier can be a route name or a route ID.

This example uses Route Name as the network's route identifier field.

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 a non-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.

    Choose a route identifier field for the selected network.

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

    The default display name is the Route Identifier value.

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

  3. Optionally, click Preview to preview the route identifier field on a canvas.

    The canvas after adding a route identifier field

    Note:

    If the chosen network is a line network, the Line Name column appears next to the route identifier field in the feature count data product.

  4. Click Next.

    The Add feature count layers page appears.

Add feature count layers

The LRS feature count data product counts line events, point events, and intersections on a per-route basis.

There are two options to configure the feature count fields: Single Value and Unique Values. You can configure the feature count fields one by one using the Single Value option and applying a filter to create categories. Alternatively, you can use the Unique Values option to configure all the unique values needed as feature count fields in the output.

To add feature count layers, complete the following steps:

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

    The layer must be stored in the same geodatabase or feature service and have the same coordinate system as the specified network.

    The first feature count layer configured in the example is the Pipeline Crossing point event layer.

  3. Click the Selection Method drop-down arrow and choose a selection method:
    • Single Value—Add a single feature count field.
    • Unique Values—Add multiple unique values for a feature count layer. Each unique value becomes an individual field. This option is only available when a feature count layer is provided without a name or filter.

    For this example, Single Value is used to configure the Pipeline Crossing layer.

    Add a feature count layer to be included in the feature count data product.

  4. Provide a display name in the Name in Table text box.

    The text provided here populates the blank row in the Feature Count Fields table.

    The canvas after adding a feature count field
    You can preview the template after adding the Pipeline Crossing feature count field.

  5. Optionally, click New expression under Filter Expression and define an expression that filters the feature count layer.
  6. To add another feature count field using the Single Value selection method, repeat the previous steps.

    The second feature count layer configured in the example is the ILI Anomalies point event layer.

    Add a second feature count layer to be included in the feature count data product

    The next four feature count fields in the example are Concrete, Steel, PVC, and High Density Polyethylene. All four casing material types belong to the Casing line event layer. The following steps demonstrate how to add these fields using the Unique Values selection method.

  7. Repeat step 1 above.
  8. Click the Feature Count Layer drop-down arrow and choose a feature count layer.

    For this example, the Casing layer is chosen as the feature count layer.

  9. Click the Selection Method drop-down arrow and choose Unique Values.

    Add a feature count field using the Unique Values selection method.

    A pop-up appears.

  10. Click the Field drop-down arrow in the pop-up, to choose a field and do the following:
    1. Check the check box next to each field to choose the unique values.
    2. Optionally, update the name of each selected field in the Name column.

      The name becomes the name of the feature count field when the unique values are added to the Feature Count Fields table.

    3. Click Add to add the selected unique values as feature count fields.

      Each feature count field automatically has Single Value as the selection method, as well as a filter expression that corresponds to the unique values.

      Selected fields when using the Unique Values selection method

      Note:

      The Unique Values selection method honors the values in coded value domains and subtypes.

  11. Click Preview to verify the fields on the canvas.

    The canvas after adding all the fields

  12. 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