revert orientation of rings in SDO-ordinate array
Hi Spatiallers,
Does anyone know of a routine or other code in PL/SQL to revert the orientation of the rings stored in an SDO-ordinate array?
The need arises because we at KMS need to interchange the primary and secondary coordinate axis, when loading a data set into our DataWarehouse. We have easily managed to interchange all x and y coordinates (Northings and Eastings). But we now realize that all polygons became invalid beacause of "wrong orientation of exterior or interior ring"
It is reasonably simple to revert the orientation of a simple polygon cosisting of one ring, but I am a bit hesitant in writing our own routine to handle all possible geometries such as
- polygon with many holes
- multipolygon
- polygon with compound element(s) as boundary
- collection
Thanks in advance,
--
Jens Ole Jensen
Kort & MatrikelStyrelsen (WWW: http://www.kms.dk)
Danmark