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?.
In this workflow, the process is for producing a road log report similar to the one shown above is described.
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 type||Layer name||Explanation|
The routes are selected from this layer. The log reports are produced on the selected routes.
A point layer containing the route with route intersections.
A point event containing the bridge locations.
A point event containing the road sign locations.
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.
- Go to your reporting URL.
- Click the New Report button.
- Click the Road Log Report button.
- Choose the Route Network using the drop-down arrow.
- Choose the Effective date for the report.
- Choose the Output Units using the drop-down arrow.
The measures will be reported using these units.
- Type the Number of decimals.
These are the number of decimals that will show in the measures column in the report.
- 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.
If you want to select all the routes in your data to be used for reporting, do not apply any spatial or attribute filters.
You can use Show SQL to write an SQL statement instead of using the selection method to create an attribute filter.
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 line
Select by polygon
Select by rectangle
Select by circle
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.
- Intersects: The routes that intersect the graphic are selected.
- Completely within: Routes that are completely within the graphic are selected.
- 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.
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.
To use polygon features available in the map to select routes, complete the following steps.
- Choose the polygon layer from the Filter Layer list.
- Click the Select Polygon button .
- Click one or more polygons on the map.
You can also select routes that intersect multiple polygons.
For selecting routes that intersect multiple polygons, complete the following steps.
- Click the Select Multiple Polygons button .
- 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 and click on the map to add a point. The routes that intersect the resulting graphic will be selected.
Select by extent
You can select routes that are within the present extent of the map.
- Click the Select By Extent button .
- Click Next.
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.
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
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
To add an attribute filter, complete the following steps:
- Choose a selection method.
In the example above, Select from current selection is chosen.
- Click Add Clause and choose a field from the network layer to which the filter will be applied.
- Choose the mathematical function and choose the value.
- Click OK.
An attribute selection clause is added.
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.
Click the Show SQL button to view or edit the SQL statement.
- 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.
- Choose the first layer.
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.
- 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.
- Click OK.
- Choose another event.
- 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 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.
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.
If the Merge coincident events box is checked, the records of adjoining events that share the same data are merged together.
- Click OK.
For this report, two additional road log layers were added: Bridges and Signs.
- Click Next.