ST_PointOnSurface() method

Returns an ST_Point value that is guaranteed to spatially intersect the ST_Surface value.

Syntax

surface-expression.ST_PointOnSurface()

Returns

ST_Point If the surface is the empty set, returns NULL. Otherwise, returns an ST_Point value guaranteed to spatially intersect the ST_Surface value.

Examples

Example 1 – The following returns a point that intersects the polygon.
```
SELECT NEW ST_Polygon( 'Polygon(( 1 0, 0 10, 1 1, 2 10, 1 0 ))' )
.ST_PointOnSurface()
```

Standards

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