Aggregation
Components to aggregate or disaggregate properties in your data in different ways.
Count
Description
This component creates a new table with a single row and a 'count' column containing the row count of the input table
Inputs
Source table [Table]
Outputs
Result table [Table]
External links
Group by
Description
This component creates a new table with aggregated values.
It is required to convert spatial types to an allowed type by using 'ST_ASBINARY' before grouping by them.
Inputs
Source table [Table]Columns and methods for aggregation [String]Columns to group by [String]
Outputs
Result table [Table]
Point Stats in Polygons
Description
This component adds new columns with statistics computed from the points of a second table that fall within each polygon.
Inputs
Points table [Table]Polygons table [Table]Geo column in points table [Column]Geo column in polygons table [Column]Column to compute stats for in points table [Column]Column with identifier in polygons table [Column]
Outputs
Result table [Table]
ST Dump
Description
This component explodes multi-part geographies into multiple single-part ones.
The output table has the same structure as the input one, but the geo column only contains single part geographies. Rows with multi-part geographies are replaced by several rows with single-part geographies and identical values for the rest of columns.
Inputs
Source table [Table]Geo column [Column]
Outputs
Result table [Table]
External links
Summarize
This component creates a new table with aggregated values for the input whole table.
Inputs
Source table [Table]Aggregation: Use the UI of this component to select a list of aggregated properties that will be added to the result table.
Outputs
Result table [Table]
Unnest
Description
This component unnests the arrays contained an a column.
Inputs
Source table [Table]Column [Column]
Outputs
Result table [Table]
External links
Last updated