[postgis-users] ST_MaximumEnclosedCircle?

[Derek Watling]

I am looking for different centroids for Polygons. All I have been able to
find is:

ST_Centroid

ST_PointOnSurface

and the centroid of ST_MinimumBoundingCircle

any chance there is something along the lines of ST_MaximumEnclosedCircle
that returns the largest circle that can been drawn inside the polygon?

 

I am labelling polygons on Geoserver and would like the label in the biggest
body area when dealing with pan handle type parcels.

 

So far I am using the following in my view:

CASE

           WHEN st_contains(p.geom, st_centroid(p.geom)) THEN
st_centroid(p.geom)

           ELSE st_pointonsurface(p.geom)

END AS label_point

 

Thank you

Derek Watling

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151103/49de08fc/attachment.html>