Skip To Content

Adding mileage fields using unique values

You can add multiple mileage fields using the unique values available in an attribute field in an event layer. As shown in the sample report below, multiple mileage fields are added using the field Surface_Type from the Surface Type event. Mileages have been reported for each surface type, such as bituminous, gravel, brick, and so on, available in the Surface Type event layer and are summarized countywise.

Mileage fields using unique values
Mileage fields added by using the Surface Type layer

In this example, the process produces a mileage report similar to the one shown above. The mileages and summaries are calculated using internal event layers that are part of the LRS.

Data required

The following data layers are used to create the report. The layer names used here are for information only. You can use your own layer names to produce your reports:

Data layers used to create the mileage report

LRS data typeLayer nameExplanation

LRS Network Layer

MilePoint

The routes are selected from this layer. The mileage is calculated on the selected routes.

Internal linear event Layer

County

The summary layer used to calculate countywise mileage of the routes.

Internal linear event Layer

Surface_Type

The mileages for each surface type is calculated using this layer.

  1. Configure a mileage report.
  2. Select the routes.
  3. Select the summary fields.

    In this example, the County event is used as the summary event.

  4. Click Next.
  5. Click Add Field(s).
    Click the Add Field(s) button

    The Mileage Fields - Add Fields pane appears to the right.

    Adding the unique values using SurfaceType field
  6. Choose an event in the Mileage Layer drop-down list.

    The internal linear events show up in this list. In this example, SurfaceType was chosen.

  7. Click Unique Values.
  8. In the Field drop-down list, choose a unique value for the event.

    • This drop-down list shows the fields available in the Mileage Layer, that is, the Surface Type event. In this example, SURFACETYPE was chosen.
    • The Add Formula and Add Field tools are applied on all the checked fields.

    1. To add an extra mileage field that is not part of the unique values, for example, Speed Limit, click OK and follow the steps as described in the Add mileage fields section of Configuring a mileage report.
    2. Click the check boxes in the Field Name list to filter the unwanted fields from the report.
  9. Click OK.

    The added fields now act individually and you can edit them one by one using the edit tool.

    The mileage fields with surface types will show up on the Field Name list in the Mileage Fields pane.

    Unique value fields added
  10. Click Next.

    The Report Fields dialog box appears.

    Report Fields

Use the report formatting tools as shown in Formatting a report and run the report as shown in Running a report to produce a report using the mileage fields that are unique values from a selected event's field.


In this topic
  1. Data required