ST_Centroid() method

Computes the ST_Point that is the mathematical centroid of the multi-surface.

Syntax

multisurface-expression.ST_Centroid()

Returns

ST_Point If the multi-surface is the empty set, returns NULL. Otherwise, returns the mathematical centroid of the surface.

Examples

Example 1 – The following example returns the result Point (1.865682 .664892).
```
SELECT TREAT( Shape AS ST_MultiSurface ).ST_Centroid()
FROM SpatialShapes WHERE ShapeID = 28
```

Standards

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

Parent topic: ST_MultiSurface type

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com