Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns a point that is guaranteed to be on a surface in the multi-surface
If the multi-surface is the empty set, returns NULL. Otherwise, returns an ST_Point value guaranteed to spatially intersect
the ST_MultiSurface value.
The spatial reference system identifier of the result is the same as the spatial reference system of the multisurface-expression.
Returns a point that is in the interior of one of the surfaces of a multi-surface.
If the multisurface-expression contains circularstrings, then these are interpolated to line strings.
SQL/MM (ISO/IEC 13249-3: 2006)
The following returns a point that intersects the multi surface.
SELECT TREAT( Shape AS ST_MultiSurface ).ST_PointOnSurface()
FROM SpatialShapes WHERE ShapeID = 27