Opened 15 years ago

Closed 13 years ago

#2530 closed defect (wontfix)

Add support for reading Oracle Oriented Points

Reported by: dmorissette Owned by: fsimon@…
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  ) ...." 
...

Change History (1)

comment:1 by dmorissette, 13 years ago

Cc: aboudreault added
Resolution: wontfix
Status: newclosed

Closing WONTFIX. Let's reopen if we get any new requests for this.

Note: See TracTickets for help on using tickets.