Aggregate by Attributes

Purpose

The Aggregate by Attributes tool is meant for aggregation of records or features according to the specified parameters.

Description

The tool allows aggregating input features or records using selected aggregation "Group by" field(s).

Aggregate by Attributes allows extracting and grouping unique records only in selected fields, defining aggregation functions for other source fields, creating a new table that contains aggregated data and (if possible) determining output geometry aggregation for it.  

Usage

• Select the "Aggregate by Attributes" tool from the XTools Pro Table Operations menu.

• Select input dataset for aggregating (either a feature layer or a standalone table).

• Specify the name and location of the output table or feature class.

• Select the field(s) by which you want to group features or records.

• Select aggregation parameters for the rest of fields.

• Select geometry aggregation.

• Press Run.

Note:

Aggregation columns will be added to the output dataset in order the input aggregation fields have been selected.

Aggregation field parameters

The following aggregation functions are available:

• First — the first element in the group
  Prefix: fst
  Records in the group are organized by ObjectID field, if it is available in the data source.

• Last — the last element in the group
  Prefix: lst
  Records in the group are organized by ObjectID field, if it is available in the data source.

• Count — number of records in the group whose current field value is not equal to NULL
  Prefix: cnt

• Sum – sum of elements in the group
  Prefix: sum
  The parameter can be applied to the numeric fields only.

• Average – average value of elements in the group
  Prefix: avg
  The parameter can be applied to the numeric fields only.

• Minimum – minimum element value in the group
  Prefix: min

• Maximum – maximum element value in the group
  Prefix: max

• Variance – element variance in the group
  Prefix: var
  Output field type: double. The parameter can be applied to the numeric fields only.

• Standard deviation – standard deviation of elements in the group
  Prefix: dev
  Output field type: double. The parameter can be applied to the numeric fields only.

Geometry aggregation

Following "Geometry aggregation" types can be set for output data:

• Multipart
  - this is the default value, it means that aggregated features will be grouped into multipart features.

• No geometry
  - resulting data will have no geometry.

• Convex Hull
  - a convex hull will be built for resulting data. If this option is selected, the “Buffer size” parameter is available. Buffer size can be positive and negative values. Null is the default value of the Buffer size meaning unchanged hull size. Buffer size values may have decimal part.

• Polyline
  - input point features will be aggregated and grouped into polylines.

• Polygon
  - input point or polyline features will be aggregated and grouped into polygons.