[mapserver-users] Spatial data from Oracle - how?

[Rodrigo Cabral]

There are two options... By your email I guess the 1st one you don't want to
try, but anyway:

1) Install SDO (Oracle Spatial) which has a whole spatial data support
implemented, including MDSYS.SDO_GEOMETRY type for storing the data in your
shapefiles. Compile mapserver with Oracle Spatial support and migrate your
shapefiles to Oracle using a shp2sdo program from OTN (don't have the URL
with me right now). Create the mapfile with an oraclespatial layer, and it's
done.

2) Split your data in two parts: static base layers are stored in standard
shapefiles; while dynamic layers (which your database handles) are stored in
Oracle in your private format (perhaps you have only lat/lons points and
want to see them). You will have to work with PHP (using OCI) and MapScript
to draw/query your points. Depending on your application, there's a lot of
coding ahead. If data is complex or big, expect delays for delivering
content to the web.

Rod.

----- Original Message -----
From: "Bjarni Pjetursson" <Bjarni.Pjetursson at tietoenator.com>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Thursday, April 04, 2002 10:58 AM
Subject: [mapserver-users] Spatial data from Oracle - how?


Hi,
I've succesfully run the Gmap and Itasca demo and managed to replace the old
shp-files with my own, but now I want to retrieve data from a database.

On the main page of MapServer it is said: "If the data has a spatial
component and you can get to it via your favorite scripting enviroment then
you can map it."

But I can't find any documentation on data from a database. How can I pass
the data on to MapServer?

I want to use Perl or PHP on Apache HP Unix. I have my spatial data in an
Oracle 8.1.6 database (not Oracle Spatial).

What  to do?
Any suggestions will be highly appreciated.

Regards
Bjarni Thor Pjetursson