Merge Event Table

Feature Description

Merging event tables combines events with the same route ID and merged field values to eliminate redundant information or split event tables based on different attributes. For more details, see Fuse Event Table.

Feature Entry

  • On the Transport Analysis Tab -> Dynamic Segmentation group, click the Dynamic Segmentation button, then select Merge Event Table from the dropdown menu.
  • Toolbox -> Transport Analysis -> Dynamic Segmentation tool: Merge Event Table; or drag this tool to the model builder window and double-click its icon.

Parameter Description

  • Input Event: Configures input event parameters. The right panel displays fuse event table parameters, including the datasource, event table, event type, route ID field, start measure field, and end measure field. For point events, only one measure field is required.
  • Fusion Settings
    • Fusion Type: Set to overlap or connect. For details, see Fuse Event Table - Event Fusion Methods.
    • Fusion Tolerance: The tolerance range for merging. Only events within this tolerance will be processed. Two point events are considered overlapping if their measure values differ by less than this tolerance. For line events, this defines connectivity. Default tolerance depends on the dataset's coordinate system (see Tolerance Guide).
    • Merged Field: Specifies fields in the event table to be merged. Events with the same route ID and merged field values will be fused based on overlap or connection criteria. Check desired fields in the list below. Single or multiple fields can be selected.
  • Result Data: Configures result parameters, including the datasource and name for the dissolved event table.
  • Statistic Field Methods:
    • Max: Maximum value of the statistic field (numeric/time fields only).
    • Min: Minimum value of the statistic field (numeric/time fields only).
    • Sum: Sum of the statistic field (numeric fields only).
    • Average: Average value of the statistic field (numeric fields only).
    • First Object: Retains the first object's field value (valid for numeric, boolean, time, and text fields).
    • Last Object: Retains the last object's field value (valid for numeric, boolean, time, and text fields).
  • Click the Execute button to run the operation when ready.

Related Topics