Geographic dissolve

The Geographic dissolve step allows you to aggregate or merge geographical entities into larger units. It's particularly useful for simplifying complex geographical data or creating higher-level geographical representations, such as grouping countries into continents.

Step parameters

• Group rows by...: The column(s) by which data to dissolve should be grouped

• And aggregate...: Optional. The column(s) you wish to aggregate in addition to the column containing geo data. See aggregate step for details on the format.

Example

Input

Geo - dissolve input

Configuration

{
    "groups": ["name"],
    "include_nulls": false,
    "aggregations": [
        {
            "aggfunction": "distinct",
            "columns": ["coffee shop"],
        }
    ]
}

Output

Geo - dissolve input