Aggregation
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
Description
This component unnests the arrays contained an a column.
Inputs
Source table [Table]Column [Column]
Outputs
Result table [Table]
External links
Last modified 1mo ago