<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">Notes:<br>
</div>
<div class="moz-cite-prefix">1 ArcSDE server-side SDK as GDAL uses
it doesn't exist any more. ESRI moved all functionality to the
client-side (e.g. ArcGIS) when rewriting ArcGIS Server to 64-bit.
My memory is that was 10.1 but can be 10.2 as Johan write</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">2 You can store OGC-defined geometries
in the native DBMS spatial format using the applicable SDE DBTUNE
geometry storage keyword (for PostGIS: PG_GEOMETRY for Oracle:
SDO_GEOMETRY)<br>
ESRI-specific geometries like text will still be stored in ESRI
geometry format</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">3 If storing geometries in any ESRI
geometry format like ST_GEOMETRY, you need to convert the
geometries to something readable by MapServer. The most efficient
is what I proposed, to use the functions installed by ArcGIS
Server in the sde database schema<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<blockquote type="cite"
cite="mid:8C8682A4-0698-4281-BC91-A0A825B28B80@gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Dear Johan,
<div class=""><br class="">
</div>
<div class="">Good question. </div>
<div class="">So let me explain the problem. My organization is
using ESRI desktop clients (mainly ArcGIS Desktop) to upload the
spatial data to the databases used across the organization and
publish it via network services. As DBMSs, we use Oracle and
Postgres. We upload the data using Esri clients in versions
10.3.1 or 1.6.1.</div>
<div class=""><br class="">
</div>
<div class="">Now I need GDAL to do two things:</div>
<div class="">1. Export the data form these databases to other
formats.</div>
<div class="">2. Use it to connect to MapServer to publish WMS,
WFS services straight from databases.</div>
<div class=""><br class="">
</div>
<div class="">So after looking through the documentation available
online, I thought that using ArcSDE will be the best solution,
but maybe there are better alternatives.</div>
<div class=""><br class="">
</div>
<div class="">Best regards,</div>
<div class="">Marcin</div>
<div><br class="">
<blockquote type="cite" class="">
<div class="">Wiadomość napisana przez Johan Van de Wauw <<a
href="mailto:johan.vandewauw@gmail.com" class=""
moz-do-not-send="true">johan.vandewauw@gmail.com</a>> w
dniu 02.09.2020, o godz. 15:39:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">
<div class="">Marcin,</div>
<div class=""><br class="">
</div>
<div class="">I managed to compile this extension against
ubuntu 14.04 with at that time gdal 1.10 , while helping
a customer migrating away from arcSDE. </div>
<div class=""><br class="">
</div>
<a
href="https://lists.osgeo.org/pipermail/gdal-dev/2016-November/045445.html"
class="" moz-do-not-send="true">https://lists.osgeo.org/pipermail/gdal-dev/2016-November/045445.html</a><br
class="">
<div class=""><br class="">
</div>
<div class="">At that time, it was only possible to
receive this client sdk on cdrom (!). This was
version 10.2, which I believe is the last version of
ArcSDE. I guess it will be much harder to get it now. </div>
<div class=""><br class="">
</div>
<div class="">Are you sure you are still using arcsde?</div>
<div class=""><br class="">
</div>
<div class="">Kind Regards,</div>
<div class="">Johan</div>
</div>
</div>
</blockquote>
</div>
<br class="">
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a></pre>
</blockquote>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Best Regards
Andreas Oxenstierna
T-Kartor Geospatial AB
Olof Mohlins väg 12 Kristianstad
mobile: +46 733 206831
mailto: <a class="moz-txt-link-abbreviated" href="mailto:ao@t-kartor.se">ao@t-kartor.se</a>
<a class="moz-txt-link-freetext" href="http://www.t-kartor.com">http://www.t-kartor.com</a></pre>
</body>
</html>