Geospatial · Areas and surfaces

H3 Aggregate

Puts features into hexagon cells of a chosen size and summarizes each cell, for an even grid on density maps.

Also known as: Hex bins, heat map

How it works

Pick the Geometry column and the Resolution (0–15, 8 by default; a higher number means smaller hexagons). Each feature is assigned to the H3 cell that contains its centroid. Then add one or more aggregations, each with a function (Sum, Count, Average, Min, Max, Median, Std dev or Count distinct), a column and an alias; the alias is filled in for you when left blank, and Count over All rows counts the features in the cell. The output has one row per cell that received at least one feature, with h3_cell, the hexagon polygon in geom, and the aggregated values.

Inputs and outputs

Settings

{
  geometryColumn: string
  resolution: number (0-15)
  aggregations: [{ column: string, func: "SUM"|"COUNT"|"AVG"|"MIN"|"MAX"|"MEDIAN"|"STDDEV"|"COUNT_DISTINCT", alias: string }]
}

Example

You want a density map of stores with their total sales. Set Resolution to 7 and add two aggregations: Count of All rows as stores, and Sum of sales as total_sales. Feed the result into a Map node to colour the hexagons by either column.

More in Areas and surfaces

• Trade Areas — Builds catchment areas around each location: distance rings, drive-time bands, areas traced from demand, or rings cut into sectors.
• Gravity Model — Splits each area's demand between the locations in range by their attractiveness and distance (the Huff model). Gives the demand each location captures, such as a new store's sales and what it takes from the others, the top location per area, or a probability for every area and location.
• Calibrate Gravity Model — Fits the Gravity Model's attractiveness and distance-decay settings to what customers actually did, such as loyalty-card visits per area and store, and reports how well the fit reproduces each store.
• Voronoi — Draws one area per point covering everywhere closer to it than to any other point, such as the nearest-store territory for every shop.
• Spatial Interpolate — Estimates a smooth surface from measured sample points, on a hexagon or square grid. For example, a pollution surface from sensors.