[mapserver-dev] Point layers with Oracle driver

[David Fuhry]

Daniel,

Point ordinates wouldn't ever be in SDO_ELEM_INFO; it only stores 
metadata for how to interpret SDO_ORDINATES.

I'm not sure what MapServer does, but Oracle MapViewer will render a
point if the ordinates are stored in either the SDO_POINT or the
SDO_ORDINATES substructure of SDO_GEOMETRY.

Notably, 10g+ has a feature known as "oriented points", in which
SDO_POINT is null, and the (x,y[,z]) point ordinates are stored in
SDO_ORDINATES, and are followed by values (still in SDO_ORDINATES) which
describe an angle, for obvious use in labeling.

The correct behavior would be for MapServer to render the point at the
location stored in SDO_ORDINATES iff the SDO_POINT is null.

Thanks,

Dave


Daniel Morissette wrote:
> Fernando,
> 
> I've had someone report to me that when MapServer reads point layers 
> from Oracle, it works fine if the coordinates are stored in the 
> SDO_POINT, but it doesn't work if they are stored in SDO_ELEM_INFO or 
> SDO_ORDINATES which are apparently two other valid ways of storing point 
> data.
> 
> Are you aware of this issue? Is there a way around it or do you have any 
> advice to provide to users who run into this problem?
> 
> Thanks
> 
> Daniel