Aggregate by Attributes

#updated

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.



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 “Level of detail” and “Buffer size” parameters are available. Level of details allows creating convex hulls with more detailed shapes, it may vary between 0% and 100%. Default 0% means convex hull, all greater values (1 to 100%) will output detailed hulls. 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.