Dissolve Route Events (Linear Referencing)

Summary

Removes redundant information from event tables or separates event tables having more than one descriptive attribute into individual tables.

Usage

• The input table can be any type of table that ArcGIS supports. The output table can be a .dbf file or a geodatabase table.

• If the Input Event Table parameter value does not have an ObjectID field, use the Make Query Table tool prior to using this tool to add a virtual ObjectID field.

• An attribute index on the route identifier field speeds up the dynamic segmentation process. If you will be using the Output Event Table parameter value for dynamic segmentation, it is recommended that you choose to have an attribute index created.

Parameters

Dialog

Label	Explanation	Data Type
Input Event Table	The table with the rows that will be aggregated.	Table View
Event Table Properties	Parameter consisting of the route location fields and the type of events in the input event table. Route Identifier Field—The field containing values that indicate the route on which each event is located. This field can be numeric or character. Event Type—The type of events in the input event table (POINT or LINE). POINT—Point events occur at a precise location along a route. Only a from-measure field must be specified. LINE—Line events define a portion of a route. Both from- and to-measure fields must be specified. From-Measure Field—A field containing measure values. This field must be numeric and is required when the event type is POINT or LINE. Note when the Event Type is POINT, the label for this parameter becomes Measure Field. To-Measure Field—A field containing measure values. This field must be numeric and is required when the event type is LINE.	Route Measure Event Properties
Dissolve Fields	The fields that will be used to aggregate rows.	Field
Output Event Table	The table that will be created.	Table
Output Event Table Properties	Parameter consisting of the route location fields and the type of events that will be written to the output event table. Route Identifier Field—The field that will contain values that indicate the route on which each event is located. Event Type—The type of events the output event table will contain (POINT or LINE). POINT—Point events occur at a precise location along a route. Only a single measure field must be specified. LINE—Line events define a portion of a route. Both from- and to-measure fields must be specified. From-Measure Field—A field that will contain measure values. Required when the event type is POINT or LINE. Note when the Event Type is POINT, the label for this parameter becomes Measure Field. To-Measure Field—A field that will contain measure values. Required when the event type is LINE.	Route Measure Event Properties
Combine adjacent events only (Optional)	Specifies whether the input events will be aggregated or dissolved. Unchecked—Events will be aggregated wherever there is measure overlap. This is the default. Checked—Events will be aggregated where the to-measure of one event matches the from-measure of the next event. This option is applicable only for line events.	Boolean
Build index (Optional)	Specifies whether an attribute index will be created for the route identifier field that is written to the output event table. Checked—An attribute index will be created. This is the default. Unchecked—An attribute index will not be created.	Boolean

Python

arcpy.lr.DissolveRouteEvents(in_events, in_event_properties, dissolve_field, out_table, out_event_properties, {dissolve_type}, {build_index})

Name	Explanation	Data Type
in_events	The table with the rows that will be aggregated.	Table View
in_event_properties	Parameter consisting of the route location fields and the type of events in the input event table. Route Identifier Field—The field containing values that indicate the route on which each event is located. This field can be numeric or character. Event Type—The type of events in the input event table (POINT or LINE). POINT—Point events occur at a precise location along a route. Only a from-measure field must be specified. LINE—Line events define a portion of a route. Both from- and to-measure fields must be specified. From-Measure Field—A field containing measure values. This field must be numeric and is required when the event type is POINT or LINE. Note when the Event Type is POINT, the label for this parameter becomes Measure Field. To-Measure Field—A field containing measure values. This field must be numeric and is required when the event type is LINE.	Route Measure Event Properties
dissolve_field [dissolve_field,...]	The fields that will be used to aggregate rows.	Field
out_table	The table that will be created.	Table
out_event_properties	Parameter consisting of the route location fields and the type of events that will be written to the output event table. Route Identifier Field—The field that will contain values that indicate the route on which each event is located. Event Type—The type of events the output event table will contain (POINT or LINE). POINT—Point events occur at a precise location along a route. Only a single measure field must be specified. LINE—Line events define a portion of a route. Both from- and to-measure fields must be specified. From-Measure Field—A field that will contain measure values. Required when the event type is POINT or LINE. Note when the Event Type is POINT, the label for this parameter becomes Measure Field. To-Measure Field—A field that will contain measure values. Required when the event type is LINE.	Route Measure Event Properties
dissolve_type (Optional)	Specifies whether the input events will be aggregated or dissolved. DISSOLVE—Events will be aggregated wherever there is measure overlap. This is the default. CONCATENATE—Events will be aggregated where the to-measure of one event matches the from-measure of the next event. This option is applicable only for line events.	Boolean
build_index (Optional)	Specifies whether an attribute index will be created for the route identifier field that is written to the output event table. INDEX—An attribute index will be created. This is the default. NO_INDEX—An attribute index will not be created.	Boolean

Code sample

DissolveRouteEvents example 1 (Python window)

The following Python window script demonstrates how to use the DissolveEventRoutes function.

import arcpy
arcpy.env.workspace = "C:/Data"
arcpy.lr.DissolveRouteEvents("pavecond.dbf", "rkey LINE fmp tmp", "lanes", 
                             "pave_dissolve1.dbf", "rkey LINE fmp tmp")

DissolveRouteEvents example 2 (stand-alone script)

The following Python script demonstrates how to use the DissolveRouteEvents function in a stand-alone Python script.

# Name: DissolveRouteEvents_Example2.py
# Description: Dissolve line events based on one field (input table is dBASE).

# Import system modules 
import arcpy

# Set workspace
arcpy.env.workspace = "D:/Data/pitt_county"

# Set local variables
in_tbl = "pavecond.dbf"
in_props = "rkey LINE fmp tmp"  # re-used as out event properties
flds = "lanes" 
out_tbl = "pave_dissolve1.dbf"

# Run DissolveRouteEvents
arcpy.lr.DissolveRouteEvents(in_tbl, in_props, flds, out_tbl, in_props)

DissolveRouteEvents example 3 (stand-alone script)

The following Python script demonstrates how to use the DissolveRouteEvents function in a stand-alone Python script.

# Name: DissolveRouteEvents_Example3.py
# Description: Concatenate line events based on two fields (input table is file geodatabase).

# Import system modules
import arcpy

# Set workspace
arcpy.env.workspace = "C:/Data/pitt.gdb"

# Set local variables
in_tbl = "pavecond"
in_props = "rkey LINE fmp tmp"  # re-used as out event properties
flds = "lanes;curb" 
out_tbl = "pave_dissolve2"

# Run DissolveRouteEvents
arcpy.lr.DissolveRouteEvents(in_tbl, in_props, flds, out_tbl, in_props, 
                             "CONCATENATE")

DissolveRouteEvents example 4 (stand-alone script)

The following Python script demonstrates how to use the DissolveRouteEvents function in a stand-alone Python script using enterprise geodatabase data.

# Name: DissolveRouteEvents_Example4.py
# Description: Dissolve line events based on two fields (input table is enterprise geodatabase).

# Import system modules
import arcpy

# Set workspace
arcpy.env.workspace = "C:/MyProject/myConn.sde"

# Set local variables
in_tbl = arcpy.ValidateTableName("pavecond", wkspc) 
in_props = "rkey LINE fmp tmp" 
flds = "lanes;curb" 
out_tbl = "pave_dissolve3"
out_props = "rid LINE f_meas t_meas" 

# Run DissolveRouteEvents
arcpy.lr.DissolveRouteEvents(in_tbl, in_props, flds, out_tbl, out_props, "#", 
                             "NO_INDEX")

Environments

Current Workspace, Output CONFIG Keyword, Scratch Workspace

Licensing information

• Basic: Yes
• Standard: Yes
• Advanced: Yes