Display non spatial table

[Nolte, Tim]

Johannes,

I'm not sure which version of Oracle you are using, we're on 10g,
however, I was recently in the same position as you. What I found out
was that all editions of 10g include some minimal Oracle Spatial
capabilities, and it's called "Locator". What this gave me is the
ability to create the spatial data right in the database form the X/Y
coordinates. All I had to do what make sure that MapServer was compiled
with Oracle Spatial support and enter the connection and spatial query
directly in my mapfile. The other way to do this is via OGR however
there are performance hits going this route as to compared with using
actual spatial data from the database. If you need any help setting up
your MapServer to use Oracle spatial let me know as I've done it on both
Solaris and HostGIS.

-----Original Message-----
Hello List,

I'd like to display a non spatial table from an ORACLE Database
(accessible
trough SDE) using Mapserver. The table includes two fields X and Y that
contain coordinates, representing point features. In ArcGIS it is
possible
to create an event layer from X/Y data. Is there anything comparable
using
mapserver? 

When asking in the IRC channel, alienbrain told me that it's no problem
to
display X/Y data using mapscript, but what I need is a WMS to be used in
mapbender. Can this be done? If yes, what is the correct mapfile syntax?


----
Timothy J Nolte - tnolte at ilpcs.com
Associate Network Planning Engineer

iPCS Wireless, Inc.
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office: 616-656-5163
PCS:    616-706-2438
Fax:    616-554-6484
Web: www.ipcswirelessinc.com