Merge Event Table

Instructions for use

The fusion of event table can merge the events with the same routing ID and Merged Field value in a certain way, so as to remove redundant information or split the event table according to different Attributes. See the Fuse Event Table for more information.

Function entrance

  • In the Traffic Analysis tab-> Dynamic Segmentation group, click the Dynamic Segmentation button and click the Merge Event Table button in the drop-down menu.
  • Toolbox-> Traffic Analysis-> Dynamic Segmentation tool: Merge Event Table; or drag the tool to the Model Builder Window and double-click the function graph.

Parameter Description

  • Input Event: Set the Parameters of the Input Event and display Fuse Event Table related parameters on the right. Includes the Datasource where the event to be fused is located, the event table, the event type, the routing identifier field, the start scale field, and the end scale field. If the event type is a point event, only one scale field needs to be set.
  • Fusion Settings
    • Fusion Type: Set the fusion type to Overlap or Join. For an introduction to the merge type, see the introduction to How events are merged in the Fuse Event Table .
    • Fusion Tolerance: The tolerance size for the fusion operation. Operates only on events within the fusion tolerance. When the distance between the dot scale values is less than tolerance, two dot events are considered to overlap each other and line events are considered to be connected. Tolerance defaults are related to the Dataset's coordinate system and are described in the tolerance description .
    • Merged Field: specifies the field to be merged in the event table. For events with the same field value, it will be judged according to the ID value of the same route and the value of Merged Field, and whether multiple event tables on the same route are overlapped or connected. The list area below Merged Field, which lists information for all fields of the event table. Check the field to be fused. Merged Field can be a single or multiple fields.
  • Result Data: Set parameters related to Result Data. The Datasource where the Dissolve Result is located and the name of the generated event table.
  • Introduction to the Statistical Method of Statistic Field:
    • Maximum value: get the maximum value of Statistic Field, which is only valid for numerical and time fields.
    • Min: Get the minimum value of Statistic Field, which is only valid for numeric and time fields.
    • Sum: Take the sum of Statistic Fields, which is only valid for numeric fields.
    • Average value: get the average value of Statistic Field, which is only valid for numerical field.
    • First Object: Keep the field value of First Object. Valid for numeric, Boolean, time, and text fields.
    • Last Object: Keep the field value of Last Object. Valid for numeric, Boolean, time, and text fields.
  • When you are ready, click the Execute button to perform this step.

Related topics

Event Table Analysis Overview