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.

 
 
 

Table of Contents

Index

Glossary

Search

Back