<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Robert,<br>
Just to complete the Bart answer, this feature I finished in the
4.4 version of Mapserver.<br>
Now with native support you can query data from Oracle Spatial
using Mapserver without problems. You can use query functions in
Mapscript, query mode in CGI, WMS/WFS requests....<br>
Regards.<br>
<br>
------------------------------------------------------------------------
<br>
Fernando Simon
<br>
Mapserver and Oracle Spatial developer
<br>
G10 - Laboratorio de Computacao Aplicada - Brazil
<br>
<a class="moz-txt-link-freetext" href="http://www.univali.br/g10">http://www.univali.br/g10</a>
- UNIVALI/CTTMAR
<br>
------------------------------------------------------------------------<br>
<br>
<br>
Robert oude Lohuis wrote:
<blockquote cite="midLISTSERV%25200510240550512243.434B@LISTS.UMN.EDU"
type="cite">
<pre wrap="">True, but there is a difference:
The native support does not have the capability to get administrative data
from the database, but delivers only the geometry data. OGR does have
support for queries which deliver data of other database-columns other than
the geometry column.
But, as Bart already mentioned, this comes with a price. The performance
decreased in our case with a factor 2.
greetz,
Robert.
On Mon, 24 Oct 2005 12:05:25 +0200, Bart van den Eijnden
<a class="moz-txt-link-rfc2396E" href="mailto:BEN@SYNCERA-ITSOLUTIONS.NL"><BEN@SYNCERA-ITSOLUTIONS.NL></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I think the Mapserver native would be the preferred way. It should have the
</pre>
</blockquote>
<pre wrap=""><!---->best performance, and it has the same features as the OGR one. Note that the
OGR OCI driver was mostly developed for writing data and not so much for
reading (so it might not be completely optimized for that).
</pre>
<blockquote type="cite">
<pre wrap="">Best regards,
Bart
Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG DELFT
tel.nr.: 015-7512436
email: <a class="moz-txt-link-abbreviated" href="mailto:BEN@Syncera-ITSolutions.nl">BEN@Syncera-ITSolutions.nl</a>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Jukka Sirviö <a class="moz-txt-link-rfc2396E" href="mailto:Jukka.Sirvio@ARBONAUT.COM"><Jukka.Sirvio@ARBONAUT.COM></a> 24-10-2005 10:24 >>>
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">Hello!
Does anyone have a suggestion which is the preferred way for getting the
spatial data from Oracle? Is it Mapserver Native support or is it through
OGR / gdal? What are the drawbacks / benefits for both of these? I already
know that if I use ogr approach I have to compile gdal and then compile
mapserver for this version of gdal.
I quess that Mapserver native approach is more widely used?
Yours:
Jukka
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
</body>
</html>