ST_PointOnSurface

Find a point that is guaranteed to be in the interior of a surface or multisurface geometry.

Syntax

ST_PointOnSurface(geo)

geo: The input surface or multisurface geometry.
Type: VARCHAR(ANY)

Returns

A value of type VARCHAR(100) that contains a point in the interior of the input geometry.

Examples

SELECT inza..ST_ASTEXT(inza..ST_POINTONSURFACE(inza..ST_WKTToSQL('POLYGON ((30 110, 50 110, 50 130, 30 130, 30 110))')));
 
ST_ASTEXT
-----------
POINT (40 120)
(1 row)