Ask or search…
K
Links
Comment on page

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

Unnest

Description
This component unnests the arrays contained an a column.
Inputs
  • Source table [Table]
  • Column [Column]
Outputs
  • Result table [Table]
External links
Last modified 7mo ago