[Mapserver-users] Attribute queries using Oracle Spatial connection

[Frank Warmerdam]

Jussi Rasinmäki wrote:
> Hi,
> I would need to use Oracle tables as the source for both spatial and
> attribute information in Mapserver, hence a couple of questions:
> (1) Any ideas whether the msOracleSpatialLayerGetItems function in
> Mapserver's Oracle Spatial support is being developed currently and it's
> schedule?
> (2) Address to the most recent maporaclepatial.c and it's version number?
> (3) Can I make attribute queries to an Oracle table in Mapserver by using
> OGR compiled with Oracle Spatial support?

Jussi,

I can't address 1 and 2, but the answer to (3) is that you can get attributes
from a spatial Oracle table using OGR compiled with Oracle Spatial support.
Currently the OGR driver doesn't offer simple access to non-geometric tables
from Oracle (they aren't in the enumerated list of layers from the database)
but you can construct SELECT queries against non-spatial tables through OGR.

You would likely have to build OGR with oracle support yourself, as none
of the pre-built binaries currently include this.

Best regards,

-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent