ST_Centroid method

surface-expression.ST_Centroid()

ST_Point If the surface is the empty set, returns NULL. Otherwise, returns the mathematical centroid of the surface.
The spatial reference system identifier of the result is the same as the spatial reference system of the surface-expression.

Returns the ST_Point value that is the mathematical centroid of the surface value. Note that this point will not necessarily be a point on the surface.

Note

This method can not be used with geometries in round-Earth spatial reference system.

SQL/MM (ISO/IEC 13249-3: 2006) 8.1.4

The following example returns the result Point (5 4.666667).

SELECT TREAT( Shape as ST_Surface ).ST_Centroid()
FROM SpatialShapes WHERE ShapeID = 22

ST_Centroid method

Syntax

Returns

Remarks

Note

See also

Standards and compatibility

Example