Opened 16 years ago
Closed 14 years ago
#2530 closed defect (wontfix)
Add support for reading Oracle Oriented Points
| Reported by: | dmorissette | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | 5.2.1 release |
| Component: | Input - Native Oracle Spatial Support | Version: | unspecified |
| Severity: | normal | Keywords: | |
| Cc: | aboudreault |
Description
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:
http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm#CBBIGEFH
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 ) ...." ...
Closing WONTFIX. Let's reopen if we get any new requests for this.