[Mapserver-users] Repost: Oracle Spatial: A tip and a request

[bartvde at xs4all.nl]

Hi,

building OGR with Oracle Spatial does not require different Mapserver
binaries as far as I know. This requires a different build of gdal11.dll.

It is fairly easy to compile gdal/ogr on Windows. There is a perfect
makefile for it.

I have built a binary, but it is smaller than the one delivered with
mapserver, so perhaps I am missing out on some of the other formats. But I
think this one includes Oracle Spatial support.

If you want I can give you a gdal11.dll which includes Oracle Spatial,
although ofcourse untested. You can download it from:

http://www.vz.geodan.nl/users/bart/gdal11.dll

A question to Frank Warmerdam: does compiling in Oracle Spatial support
into OGR mean only setting the ORACLE_HOME environment variable to a
Oracle client on my machine?

BTW: I would be quite interested to see a performance test on the two
options (native Mapserver Oracle Spatial / OGR Oracle Spatial). And I am
willing to provide some spare time for this. So contact me if you need
help.

Best regards,
Bart

> I was asked to forward this from Bjarni Thor Pjetursson, because he's
> having
> problems posting with his Web Outlook...
>
>         erik
> ----------------------
> Hi list,
> first of all, thanks for making binaries with Oracle support. It makes it
> a
> lot easier to be updated with the newest great features of MapServer.
>
> A tip: If you are thinking of using Oracle for storing your spatial data,
> consider using Oracle Locator. Locator gives you 95% of Spatial - only a
> few
> functions and procedures are missing. It ships as part of Oracle 9i
> Standard
> Edition (SE). Compared to Spatial (which requires the enterprise edition),
> the price is much lower. MapServer works fine against both.
>
> A request: Since no real enhancements to maporaclespatial.c seems to have
> occured in over a year, I would like to test the Oracle support through
> OGR.
> Would it be possible to have OGR with Oracle support built into the
> binaries
> as well?
>
> The biggest problem I have with maporaclespatial.c is a bug which only
> allows two columns to be selected from Oracle per layer (the geom column
> and
> one more). I need to access several columns for color, rotation and
> labeling
> etc. And I want to keep the number of queries against the database to a
> minimum.
>
> Any thoughts?
>
> Best regards / and keep up the good work!
>
> Bjarni Thor Pjetursson
> TietoEnator Consulting
> ---------------------
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>