Skip To Content

Configuring a road log report

The road log is a report that traverses a route or a set of routes and lists the events and intersections that occur in measure order along with the measure at which they occur. For more information on road log reports, see What is a road log report?.

A road log report published using Roadway Reporter
A road log report published using Roadway Reporter

In this workflow, the process is for producing a road log report similar to the one shown above is described.

Required data

The following data layers are used to create the report. The layer names used here are examples; you can use your own layer names to produce your reports.

ALRS data typeLayer nameExplanation

Network Layer

MilePoint

The routes are selected from this layer. The log reports are produced on the selected routes.

Intersection Layer

Route_Intersections

A point layer containing the route with route intersections.

Event Layer

Bridges

A point event containing the bridge locations.

Event Layer

Road_Signs

A point event containing the road sign locations.

Event Layer

Speed_Limit

A line event containing the speed limit data.

Selecting the network

The first step to producing a road log report is to select the route network.

  1. Go to your reporting URL.
  2. Click the New Report New Report button.
  3. Click the Road Log Report Road Log Report button.
    Creating a new road log report
    Creating a new road log report
  4. Choose the Route Network using the drop-down arrow.
    Choosing network properties
    Choosing network properties
  5. Choose the Effective date for the report.
  6. The data valid on this date will be used for producing the report.
  7. Choose the Output Units using the drop-down arrow.

    The measures will be reported using these units.

  8. Type the Number of decimals.

    These are the number of decimals that will show in the measures column in the report.

  9. Click Next.

Selecting the routes

The next step is to select the routes for which the road log will be produced. There are two options available: spatial selection and attribute selection.

The spatial and attribute filters work in conjunction with each other. This means you can apply an attribute filter in addition to the spatial filter and vice versa. You can also choose to apply either of the spatial or attribute filters.

Note:

If you want to select all the routes in your data to be used for reporting, do not apply any spatial or attribute filters.

Tip:

You can use Show SQL to write an SQL statement instead of using the selection method to create an attribute filter.

Using SQL to create an attribute filter
Using SQL to create an attribute filter

Spatial selection

You have several options for selecting the routes spatially: Drawing bounding graphics, Selecting polygon features, Select by proximity, Select by extent, and Select by Route ID.

Drawing bounding graphics

There are several tools available to draw the bounding graphics to select routes. They are described in the following table:

Tools to draw bounding graphics

Select By Point

Select by point

Select By Line

Select by line

Select By Polygon

Select by polygon

Select By Rectangle

Select by rectangle

Select By Circle

Select by circle

Clear selection

Note:

Before you draw the bounding graphic or use any other spatial filtering tool, you have the option to apply the filter in three ways: Intersects, Completely within, and Touches edge.

Route selection by a drawing a rectangle
Route selection by a drawing a rectangle
  • Intersects: The routes that intersect the graphic are selected.
    Routes that intersect the graphic
    Routes that intersect the graphic
  • Completely within: Routes that are completely within the graphic are selected.
    Routes that are completely within the graphic
    Routes that are completely within the graphic
  • Touches edge: Routes that touch the edge of the graphic are selected. A route within the graphic but not touching its edge will not be selected.
    Routes that are touching the edge of the graphic
    Routes that are touching the edge of the graphic

Selecting polygon features

You can use polygon layers available in the map to select routes. For example, if you have administrative boundaries in the map, such as county or town boundaries, you can select the routes that intersect a particular county or town.

Selecting routes that intersect a town boundary
Selecting routes that intersect a town boundary

To use polygon features available in the map to select routes, complete the following steps.

  1. Choose the polygon layer from the Filter Layer list.
  2. Click the Select Polygon button Select Polygon.
  3. Click one or more polygons on the map.

You can also select routes that intersect multiple polygons.

Selecting routes that intersect multiple town boundaries
Selecting routes that intersect multiple town boundaries

For selecting routes that intersect multiple polygons, complete the following steps.

  1. Click the Select Multiple Polygons button Select Multiple Polygons.
  2. Draw a box on the map that touches those polygons.

Select by proximity

You can select routes that are within a certain distance from a point located on the map. To do so, provide the distance and choose the Units using the drop-down arrow. Click the Select By Proximity tool Select By Proximity and click on the map to add a point. The routes that intersect the resulting graphic will be selected.

Selection by proximity
Selection by proximity

Select by extent

You can select routes that are within the present extent of the map.

Selection by map extent
Selection by map extent

  1. Click the Select By Extent button Select By Extent.
  2. Click Next.
Tip:

After you click Next, the Attribute filter page appears. If you don't want to use the attribute filters, you can skip that step by clicking Next again.

Attribute selection

You can select routes based on available attributes in the Network layer you selected to produce the report. This filter works even if you selected routes using the spatial filters.

There are three selection methods available (only when a spatial filter is applied):

Attribute selection methods

Selection methodDescription

Add to current selection

Applies an OR filter to the spatial selection

Remove from current selection

Applies a NOT filter to the spatial selection

Select from current selection

Applies an AND filter to the spatial selection

Attribute selection options
Attribute selection options

To add an attribute filter, complete the following steps:

  1. Choose a selection method.

    In the example above, Select from current selection is chosen.

  2. Click Add Clause and choose a field from the network layer to which the filter will be applied.
  3. Choose the mathematical function and choose the value.
    Adding an attribute clause
    Adding an attribute clause
  4. Click OK.

    An attribute selection clause is added.

    Attribute selection clause is added
    Attribute selection clause is added
    Tip:

    You can add additional attribute selection clauses by clicking Add Clause and applying AND or OR logic to the first clause and following the same procedure as described above to add a second clause.

    Adding a second attribute selection clause
    Adding a second attribute selection clause
    The second attribute selection clause is added
    The second attribute selection clause is added

    Click the Show SQL button to view or edit the SQL statement.

    The SQL statement for the two clauses
  5. Click Next after applying the attribute filter.

Selecting the layers to report

The next stage in creating a road log report is to select the layers from the list of intersection and event layers. Optionally, you can filter the features of each layer by building an attribute filter expression.

  1. Choose the first layer.
    Choosing the first layer for the road log report

    In this example, an intersection layer is chosen. This is a point feature class.

    The field selector pane opens to the right.

    Choose the field from the selected layer to report on
  2. Choose the field from the selected layer to report on.
  3. Click OK.
  4. Choose another event.
  5. Choose the field or fields for that event.
    Adding a linear event for the road log report

    In this example, the linear event Speed Limit is selected. You can add informative text to the data provided by this event. In the third record in the sample report shown above, the text in the feature column is Starting Speed Limit: 65 mph. The data from the Speed_Limit field in the Speed Limit event is 65, and the rest of the text is added to the record to make it more informative.

    Adding informative text

    As shown in the graphic above, the data extracted from the selected field is 40. You can add, for example, informative text such as Starting in the Begin Text box to add to the record whenever a linear event starts, Ending in the End Text box to add to the record whenever a linear event ends, Speed Limit in the Prefix box to add the event's field name, and mph in the suffix box to provide the units for the speed.

    Informative text added

    If the Merge coincident events box is checked, the records of adjoining events that share the same data are merged together.

  6. Click OK.

    For this report, two additional road log layers were added: Bridges and Signs.

  7. Click Next.

    The Report Fields page appears.

    Report Fields

    You can now Format, Run, and Save the report.