Aggregate Features/Records

 

 

Purpose

 

The Aggregate Features/Records 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 Features/Records 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

 

1. Select the "Aggregate Features/Records" tool from the XTools Pro Table Operations menu.

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

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

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

4. Select aggregation parameters for the rest of fields.

5. Select geometry aggregation.

6. Press Run.

 

 

Aggregation field parameters

 

The following aggregation functions are available:

 

• First — the first element in the group

Prefix: first_

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: last_

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: count_

 

• 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.

 

---