ST_Centroid() method

Returns the ST_Point value that is the mathematical centroid of the surface value.

Syntax

surface-expression.ST_Centroid()

Returns

ST_Point If the 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 (5 4.666667).
```
SELECT TREAT( Shape as ST_Surface ).ST_Centroid()
FROM SpatialShapes WHERE ShapeID = 22
```

Standards

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

Parent topic: ST_Surface type

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