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.
-
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. -
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.
Aggregation field parameters
The following aggregation functions are available:
Geometry aggregation
Following "Geometry aggregation" types can be set for output data: