Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Computes the ST_Point that is the mathematical centroid of the multi-surface.
If the multi-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 multisurface-expression.
Computes the ST_Point that is the mathematical centroid of the multi-surface. This point will not necessarily be a point on
This method can not be used with geometries in round-Earth spatial reference system.
SQL/MM (ISO/IEC 13249-3: 2006)
The following example returns the result Point (1.865682 .664892).
Point (1.865682 .664892)
SELECT TREAT( Shape AS ST_MultiSurface ).ST_Centroid()
FROM SpatialShapes WHERE ShapeID = 28