Show Navigation | Hide Navigation

You are here:
Geoprocessing tool reference > Linear Referencing toolbox > Tools

Dissolve Route Events (Linear Referencing)
Release 9.2 Last modified November 9, 2006	Print all topics in : "Tools"

Related Topics

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

Usage tips

The output table can be a dBASE file or a geodatabase table.
If the input events do not have an ObjectID field, use Make Query Table prior to Dissolve Route Events to add a virtual ObjectID field.
The output table can be displayed in ArcMap using Make Route Event Layer or the Add Route Events dialog box.
An attribute index on the route identifier field speeds up the dynamic segmentation process. If you will be using the Output Route Feature class for dynamic segmentation, it is recommended that you choose to have an attribute index created.
Learn more about aggregating event data.
The following environments affect this tool: configKeyword, scratchWorkspace, and workspace.

Command line syntax
An overview of the Command Line window
DissolveRouteEvents_lr <in_events> <in_event_properties> <dissolve_field; dissolve_field...> <out_table> <out_event_properties> {DISSOLVE | CONCATENATE} {INDEX | NO_INDEX}

Parameter	Explanation	Data Type
<in_events>	The table whose rows 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 which route each event is along. 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. 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 field or fields used to aggregate rows.	Field
<out_table>	The table to 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 which route each event is along. 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 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 that will contain measure values. Required when the event type is POINT or LINE. To-Measure Field — A field that will contain measure values. Required when the event type is LINE.	Route Measure Event Properties
{DISSOLVE \| CONCATENATE}	Specifies whether the input events will be concatenated 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
{INDEX \| NO_INDEX}	Specifies whether an attribute index will be created for the route identifier field that is written to the output event table. INDEX — Create an attribute index. This is the default. NO_INDEX — Do not create an attribute index.	Boolean

Data types for geoprocessing tool parameters

Command line example

Workspace "D:\Data\pitt_county"
DissolveRouteEvents_lr pavecond.dbf "rkey LINE fmp tmp" lanes pave_dissolve1 "rkey LINE fmp tmp"

Workspace "D:\Data\pitt_county\pitt.mdb"
DissolveRouteEvents_lr pavecond "rkey LINE fmp tmp" "lanes; curb" pave_dissolve2 "rkey LINE fmp tmp" CONCATENATE

Workspace "D:\Data\pitt_county\pitt.gdb"
DissolveRouteEvents_lr pavecond "rkey LINE fmp tmp" "lanes; curb" pave_dissolve2 "rkey LINE fmp tmp" CONCATENATE

Workspace "Database Connections\Connection to Jerry.sde"
DissolveRouteEvents_lr gdb.pavecond  "rkey LINE fmp tmp"  "lanes; curb" pave_dissolve3 "rid LINE f_meas t_meas" # NO_INDEX

Scripting syntax
About getting started with writing geoprocessing scripts
DissolveRouteEvents_lr (in_events, in_event_properties, dissolve_field, out_table, out_event_properties, dissolve_type, build_index)

Parameter	Explanation	Data Type
in_events (Required)	The table whose rows will be aggregated.	Table View
in_event_properties (Required)	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 which route each event is along. 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. 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 (Required)	The field or fields used to aggregate rows.	Field
out_table (Required)	The table to be created.	Table
out_event_properties (Required)	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 which route each event is along. 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 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 that will contain measure values. Required when the event type is POINT or LINE. 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 concatenated 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 — Create an attribute index. This is the default. NO_INDEX — Do not create an attribute index.	Boolean

Data types for geoprocessing tool parameters

Script example

# Example 1:
# Dissolve line events based on one field (input table is dBASE).

import arcgisscripting, constants
gp = arcgisscripting.create()
try:
    gp.Workspace = "D:/Data/pitt_county"
    in_tbl = "pavecond.dbf"
    in_props = "rkey LINE fmp tmp"          # re-used as out event properties
    flds = "lanes" 
    out_tbl = "pave_dissolve1.dbf"
    gp.DissolveRouteEvents_lr(in_tbl, in_props, flds, out_tbl, in_props)
except:
    print gp.GetMessages(2)


# Example 2:
#   Concatenate line events based on two fields (input table is file geodatabase).

import arcgisscripting, constants
gp = arcgisscripting.create()
try:
    gp.Workspace = "D:/Data/pitt_county/pitt.gdb"
    in_tbl = "pavecond"
    in_props = "rkey LINE fmp tmp"          # re-used as out event properties
    flds = "lanes; curb" 
    out_tbl = "pave_dissolve2"
    gp.DissolveRouteEvents_lr(in_tbl, in_props, flds, out_tbl, in_props, "CONCATENATE")
except:
    print gp.GetMessages(2)


# Example 3:
#   Concatenate line events based on two fields (input table is personal geodatabase).

import arcgisscripting, constants
gp = arcgisscripting.create()
try:
    gp.Workspace = "D:/Data/pitt_county/pitt.mdb"
    in_tbl = "pavecond"
    in_props = "rkey LINE fmp tmp"          # re-used as out event properties
    flds = "lanes; curb" 
    out_tbl = "pave_dissolve2"
    gp.DissolveRouteEvents_lr(in_tbl, in_props, flds, out_tbl, in_props, "CONCATENATE")
except:
    print gp.GetMessages(2)


# Example 4:
#   Dissolve line events based on two fields (input table is enterprise geodatabase).

import arcgisscripting, constants
gp = arcgisscripting.create()
try:
    wkspc = "Database Connections/Connection to Jerry.sde"
    gp.Workspace = wkspc 
    in_tbl = gp.QualifyTableName("pavecond", wkspc) 
    in_props = "rkey LINE fmp tmp" 
    flds = "lanes; curb" 
    out_tbl = "pave_dissolve3"
    out_props = "rid LINE f_meas t_meas" 
    gp.DissolveRouteEvents_lr(in_tbl, in_props, flds, out_tbl, out_props, "#", "NO_INDEX")
except:
    print gp.GetMessages(2)

Dissolve Route Events (Linear Referencing)

Command line example

Script example