ST_Centroid

Introduction: Return the centroid of a geography as a Geography point.

Format:

ST_Centroid (geog: Geography)

Return type: Geography

Since: v1.9.1

SQL Example:

SELECT ST_Centroid(ST_GeogFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))', 4326))

Output:

POINT (1 1)