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) |