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 - [EMAIL PROTECTED] 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
