5. Geospatial Functions : PointOnSurface
 
Share this page                  
PointOnSurface
POINTONSURFACE(g Geometry)
Alias: ST_POINTONSURFACE
Returns one of the points in g.
Result type: point
Example:
SELECT ASTEXT(POINTONSURFACE(POLYFROMTEXT('POLYGON((10 10, 10 0, 0 10, 10 10))')));
--------------------------------
col1
--------------------------------
POINT (7.5 5)
--------------------------------