Configuring a segment report

Segment reports dynamically segment events on a route together into a single record set. The segment report returns separate records at any measure along the event where any of the attributes change. Segment reports can have multiple use cases depending on the needs of an organization and can provide the basis of analysis to evaluate legislation, policy, and budget options. For more information on segment reports, see Segment reports.

In this example, the process is for producing a segment report similar to the one shown above.

Data required

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

ALRS data type	Layer name	Explanation
Network layer	MilePoint	The routes are selected from this layer. The layers are segmented on the selected routes.
Event layer	AADT	The annual average daily traffic layer used to segment the routes.
Event layer	IRI	The international roughness index layer used to segment the routes.
Event layer	Surface type	The surface type layer used to segment the routes.
Event layer	Urban_Type	The rural and urban type layer used to segment the routes.

Selecting the network

The first step towards producing a segment report is to select the route network.

1. Go to your reporting URL.
2. Click the New Report button.

   

3. Click the Segment Report button.

   

   Create a new segment report

4. Choose the Route Network using the drop-down arrow.

   

5. Choose the Effective date for 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. Click Next to select the routes.

Selecting the routes

The next step in the segment report creation process is to select the routes with which the segment measures will be calculated. There are two options available: spatial 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

Spatial selection

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

Spatial selection by drawing bounding graphics

Drawing bounding graphics

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

	Select by point
	Select by line
	Select by polygon
	Select by rectangle
	Select by circle
	Clear selection

Route selection by a drawing a rectangle

• Intersects—Routes that intersect the graphic get selected.

  

  Routes that intersect the graphic

• Completely within—Routes completely within the graphic get selected.

  

  Routes that are completely within the graphic

• Touches edge—Routes that touch the edge of the graphic get selected. A route even though 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 features 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 the polygon layer from the Filter Layer list.
2. Click the Select Polygon 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 Multiple Polygons 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. To do so, provide the distance and select the Units using the drop-down arrow. Click the Select By Proximity tool and click the map to add a point. The routes that intersect the resulting graphic will be 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 By Extent button .
2. Click Next to filter the features by attributes.

   If you don't want to select the routes using attributes, then you can skip this step by clicking Next.

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:

1. Choose a selection method.

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

   

   Attribute selection method chosen

2. Click Add Clause and select a field from the network layer on which the filter will be applied.

   

   Selecting a field from the network layer

3. Choose the mathematical function and click the value.
4. Click OK.

   

   Selecting the field value

   

   An attribute selection clause is added

   Tip:

   You can add more attribute selection clauses by clicking Add Clause and choosing whether to apply an AND or OR logic to the first clause.

   

   Adding a second attribute selection clause

   Follow the same procedure as described above to add a second clause.

   

   The second attribute selection clause is added

5. Click Next after applying the attribute filter.

Selecting the layers to segment

The next stage in creating a segment report is to select the layers to segment. Optionally, you can filter the features of each layer by building an attribute filter expression.

1. Select one or more layers to segment.

   

   Selecting the layers to segment

2. If you want to add an attribute filter to the selected layer, select the Filter button to add an attribute selection clause.

   

   Adding an attribute filter

   Alternatively, you can filter the attributes of selected layers by unchecking them from the Segment Layers menu.

   

   Filtering attributes for selected layers

   In this example, IRIYEAR and IRISTATUS attributes have been removed from the IRI layer. These attributes will not be included in the produced report.

3. Click Next.

   The Report Fields page appears. You can now Format, Run, and Save the report.