[gdal-dev] Compiling GDAL with ArcSDE support

[Andreas Oxenstierna]

Notes:
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

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)
    ESRI-specific geometries like text will still be stored in ESRI 
geometry format

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


> Dear Johan,
>
> Good question.
> 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.
>
> Now I need GDAL to do two things:
> 1. Export the data form these databases to other formats.
> 2.  Use it to connect to MapServer to publish WMS, WFS services 
> straight from databases.
>
> So after looking through the documentation available online, I thought 
> that using ArcSDE will be the best solution, but maybe there are 
> better alternatives.
>
> Best regards,
> Marcin
>
>> Wiadomość napisana przez Johan Van de Wauw <johan.vandewauw at gmail.com 
>> <mailto:johan.vandewauw at gmail.com>> w dniu 02.09.2020, o godz. 15:39:
>>
>> Marcin,
>>
>> 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.
>>
>> https://lists.osgeo.org/pipermail/gdal-dev/2016-November/045445.html
>>
>> 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.
>>
>> Are you sure you are still using arcsde?
>>
>> Kind Regards,
>> Johan
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev


-- 
Best Regards

Andreas Oxenstierna
T-Kartor Geospatial AB
Olof Mohlins väg 12 Kristianstad
mobile: +46 733 206831
mailto: ao at t-kartor.se
http://www.t-kartor.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200903/0cf15d0d/attachment.html>