Skip To Content

Configuring a road log report

A 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

Perform the steps in the following sections to create a road log report similar to the one shown above.

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 create your reports.

ALRS data typeLayer nameExplanation

Network Layer

MilePoint

The layer from which routes are selected. The log reports are created based on the chosen routes.

Intersection Layer

Route_Intersections

The point layer containing the route with route intersections.

Event Layer

Bridges

The point event containing the bridge locations.

Event Layer

Road_Signs

The point event containing the road sign locations.

Event Layer

Speed_Limit

The line event containing the speed limit data.

Selecting the network

The first step to creating a road log report is to choose 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. Click the Route Network drop-down arrow and choose a route network .
    Choosing network properties
    Choosing network properties
  5. Choose the Effective Date for the report.
  6. The data that is valid on the chosen effective date will be used to create the report.
  7. Choose the Output Units using the drop-down arrow.

    The road segments will be reported using these units.

  8. Type the Number of decimals.

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

  9. Type the number of decimals you want to be displayed in the measures column of the report in the Number of decimals text box.
  10. Click Next.

Selecting the routes

The next step is to select the routes for which the road log will be created. 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:

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

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

Spatial selection

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

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

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 Selecting polygon features from the Filter by list.
  2. Click the Select by point 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 by rectangle button Select by rectangle.
  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.

  1. Click the Select the center point button Select the center point
  2. Click the Units drop-down arrow and choose the unit of measure.
  3. Type a distance for the unit of measure in the Distance text box.
  4. Optionally filter proximity selection to routes that intersect, fall completely within, or touch the edge of the proximity border.

    For example, in the screenshot in step 5, those routes that fall completely within 7 miles are selected.

  5. Click the map to add a point.

    The routes that match the resulting graphic are 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 current extent button Select current extent.
  2. Click Next.
  3. Tip:

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

Select by route

You can filter routes by route ID either by selecting a route in the map or by typing the route ID.

  1. Choose Select by route from the Filter by list.
  2. Click the Select Route button to select a route on the map.
  3. Click a route on the map to select it.
    Tip:

    You can also type the route ID into the Route ID text box.

  4. Click Next to filter the features by attributes.

Attribute selection

You can select the routes on the basis of attributes available in the network layer that you have selected to produce the report. There are three selection methods available (only when a spatial filter is applied):

Attribute selection options

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 appears to the right.

    Choose the field from the selected layer to report on
  2. Choose the field from the selected layer for which you want to report.
  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 previously, 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 previous graphic, 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 section appears.

    Report Fields

    You can now format, run, and save the report.