linref_DissolveConcatenateEvents

Dissolve/Concatenate Event Tables

Both Dissolve and Concatenate functions combine records in an event table if the events are on the same route and have the same value in a specified field. The functions are available for line event layers only. The wizard allows the resulting data to be added to the map as a line event layer or a standalone table.

Dissolve will combine the events if their measures overlap
Concatenate will combine the events if the TO measure of one event is equal to the FROM measure of the next event

dissolve

concatenate

Input

An line event layer
A dissolve/concatenate field - the values of the records in this field will be used for dissolving/concatenating of the events

Output:

A new event table (DBF or within File GDB) with the aggregated events
The new table will contain all the original fields of the table of the input event layer

Running Programmatically

(Go to TOP)

Parameters

Expression	Explanation
Function Name	DissolveRouteEvents
Function Name	ConcatenateRouteEvents
<Event Table>	A String - the full path to the event table (DBF or table in File GDB).
<Output Table>	A String - the full path to the output table (DBF or table in File GDB).
<Key Field>	A String - the name of the route ID field in the event table .
<Dissolve Field>	A String - the name of the field in the input table to be used for Dissolve/Concatenate
<From Measure Field>	A String - the name of the From Measure field in the event table .
<To Measure Field>	A String - the name of the To Measure field in the event table.

Running the function

ETGWPath used in the table below is the full path to ETGWRun.exe (E.G. "C:\Program Files\ETSpatial Techniques\ETGeo Wizards\ETGWRun.exe")

Dissolve Events

Language	Syntax
Python	subprocess.call([ETGWPath, "DissolveRouteEvents", "Event Table", "Output Table", "Key Field", "Dissolve Field", "From Measure Field", "To Measure Field")
.NET using ETGWRun.exe	StartInfo.FileName = ETGWPath StartInfo.Arguments = "DissolveRouteEvents" "Event Table" "Output Table" "Key Field" "Dissolve Field" "From Measure Field" "To Measure Field"
.NET using ETGWOutX.dll	DissolveRouteEvents(Event Table, Output Table, Key Field, Dissolve Field, From Measure Field, To Measure Field)
ArcPy	arcpy.DissolveRouteEvents(Event Table, Output Table, "Key Field", "Dissolve Field", "From Measure Field", "To Measure Field")

Concatenate Events

Language	Syntax
Python	subprocess.call([ETGWPath, "ConcatenateRouteEvents", "Event Table", "Output Table", "Key Field", "Dissolve Field", "From Measure Field", "To Measure Field"])
.NET using ETGWRun.exe	StartInfo.FileName = ETGWPath StartInfo.Arguments = "ConcatenateRouteEvents" "Event Table" "Output Table" "Key Field" "Dissolve Field" "From Measure Field" "To Measure Field"
.NET using ETGWOutX.dll	ConcatenateRouteEvents(Event Table, Output Table, Key Field, Dissolve Field, From Measure Field, To Measure Field)
ArcPy	arcpy.ConcatenateRouteEvents(Event Table, Output Table, "Key Field", "Dissolve Field", "From Measure Field", "To Measure Field")

Notes:

<> - required parameter
{} - optional parameter
See examples for Python , .NET or ArcPy
The argument separator for StartInfo.Arguments is space. If a string might contain a space, you need to double quote it.

(Go to TOP)