Aggregation
Last updated
Was this helpful?
Last updated
Was this helpful?
Components to aggregate or disaggregate properties in your data in different ways.
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
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]
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]
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
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]
Description
This component unnests the arrays contained an a column.
Inputs
Source table [Table]
Column [Column]
Outputs
Result table [Table]
External links