st_centroid_agg.md 553 B

ST_CENTROID_AGG [esql-st_centroid_agg]

Syntax

:::{image} ../../../../../images/st_centroid_agg.svg :alt: Embedded :class: text-center :::

Parameters

true Description

Calculate the spatial centroid over a field with spatial point geometry type.

Supported types

field result
cartesian_point cartesian_point
geo_point geo_point

Example

FROM airports
| STATS centroid=ST_CENTROID_AGG(location)
centroid:geo_point
POINT(-0.030548143003023033 24.37553649504829)