Add support for reading Oracle Oriented Points
|Reported by:||dmorissette||Owned by:|
|Component:||Input - Native Oracle Spatial Support||Version:||unspecified|
The following page defines an oriented point extension in Oracle which uses SDO_ORDINATES to store the point coordinates instead of SDO_POINT (in this case SDO_POINT is NULL). We'd need to support this in MapServer's Oracle Spatial driver:
It is not clear whether we can support/return the orientation (angle), but at a minimum we should return the point location the same way as we would for a SDO_POINT.
And until that's implemented... when this was discussed on mapserver-dev, the following work around was proposed for users who need to deal with this and have no direct influence on the way points are represented in the oracle database.
... DATA "GEOMETRY FROM (SELECT MDSYS.SDO_GEOM.SDO_CENTROID(shape) geometry,... FROM MYTABLE ) ...." ...