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

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.

LRS data type	Layer name	Explanation
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 Reportbutton .
3. Click the Road Log Report button .

   

   Creating a new road log report

4. Click the Route Network drop-down arrow and choose a route network.

   

   Choosing network properties

5. Choose the Effective Date for the report.
The data that is valid on the chosen effective date will be used to create the report.
6. Choose the Output Units using the drop-down arrow.

   The road segments will be reported using these units.

7. Type the Number of decimals.

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

8. Type the number of decimals you want to be displayed in the measures column of the report in the Number of decimals text box.
9. Klicken Sie auf Weiter.

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.

Hinweis:

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

Tipp:

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

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 Line
	Select By Polygon
	Select By Rectangle
	Select By Circle
	Clear Selection

Hinweis:

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

• Intersects—The routes that intersect the graphic are selected.

  

  Routes that intersect the graphic

• Completely Within—Routes that are completely within the graphic are selected.

  

  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

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

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

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

1. Click the Select by rectangle button .
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 .
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

Select by extent

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

Selection by map extent

1. Click the Select current extent button .
2. Klicken Sie auf Weiter.

Tipp:

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.

   Tipp:

   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 method	Description
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

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

4. Click OK.

   An attribute selection clause is added.

   

   Attribute selection clause is added

   Tipp:

   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

   

   The second attribute selection clause is added

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

   

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.

   

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

   The field selector pane appears to the right.

   

2. Choose the field from the selected layer for which you want to report.
   • You can choose multiple fields from the same layer.
   • To add an attribute filter to the selected field, click the Filter button to add an attribute selection clause.
3. Klicken Sie auf OK.
4. Choose another event.
5. Choose the field or fields for that event.

   

   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.

   

   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.

   

   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.

   

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