Returns a point that is guaranteed to be on a surface in the multi-surface
Syntax
multisurface-expression.ST_PointOnSurface()
Returns
ST_Point If the multi-surface is the empty set, returns NULL. Otherwise, returns an ST_Point value guaranteed to spatially intersect the ST_MultiSurface value.
Examples
Example 1 –
The following returns a point that intersects the multi surface.
SELECT TREAT( Shape AS ST_MultiSurface ).ST_PointOnSurface()
FROM SpatialShapes WHERE ShapeID = 27