In Oracle Spatial (SDO), is there a way to get the centroid point of a polygon that is contained by the surface of the polygon?

Question

I need to find the centroid of a polygon in Oracle Spatial that exists inside of the polygon itself. I cannot use the sdo_geom.sdo_centroid method because this returns a point outside of the shape if the shape resembles a horseshoe.

I found sdo_geom.sdo_pointonsurface method, but it returns a point that is just on the edge of the polygon. While this mathematically works, it is not safe in our environment because all polygons share a boundary with other polygons and sometimes there is a slight overlap in the data. This overlap cannot include the calculated point.

Is there another approach to finding this point without writing custom code? I'm not opposed to writing custom code for this, but I would like to use something pre-built if it already exists.

Thanks!

Answer 1

Simon Greener has a package for a "para-centroid": codesys.geom.sdo_centroid.

You can download it, but I don't know if there is any sort of licensing that is attached to the source.

Here are links:

http://bit.ly/T9eyy

http://www.spatialdbadvisor.com/source_code

Answer 2

hey dude it's cool all that stuff about SDO Spatial in ORACLE