[Gdal-dev] SDE to PostgreSQL/PostGIS

[Martin Chapman]

Pål,

One thing to try is that SDE only likes UNC names, not IP addresses from my experience.

Martin Chapman
Chief Software Architect
Fortified Datacom Inc.
http://www.fortifieddatacom.com
mchapman at fortifieddatacom.com
303-324-1065


-----Original Message-----
From: gdal-dev-bounces at lists.osgeo.org [mailto:gdal-dev-bounces at lists.osgeo.org] On Behalf Of Pål Kristensen
Sent: Thursday, January 17, 2008 1:29 AM
To: gdal-dev at lists.osgeo.org
Subject: Re: [Gdal-dev] SDE to PostgreSQL/PostGIS


Hi!

Thanks for the help! Unfortunately there seems to be something wrong. I got
the attached error message when executing the following command:

SET PG_USE_COPY=YES
ogr2ogr -nlt LINESTRING -nln n50_bilveg -lco GEOMETRY_NAME=the_geom -a_srs
EPSG:32633 -f PostgreSQL PG:"dbname=kartdata user=xxx host=xx.xx.xx.xx"
SDE:xx.xx.xx.xx,5157,,n50,n50,n50.bilveg

http://www.nabble.com/file/p14914348/ogr2ogr_error.png 

Do you know what is causing this?

Ogrinfo --formats however shows both SDE and PostgreSQL support.


Regards
Pål Kristensen



Howard Butler-3 wrote:
> 
> I have placed a PostGIS plugin on the download page.  Please confirm  
> that it works for you...
> 
> http://download.osgeo.org/gdal/win32/1.5/
> 
> Howard
> 
> On Jan 16, 2008, at 2:12 AM, Pål Kristensen wrote:
> 
>>
>> Hi!
>>
>> I'm trying to convert some data (approx 10GB) from SDE to PostgreSQL/ 
>> PostGIS
>> using ogr2ogr. Due to the large amount of data it's not practical to  
>> use
>> shapefiles as intermediate storage. The problem is that I can't find  
>> any
>> GDAL/OGR windows binaries with both SDE support and PostgreSQL  
>> support.
>>
>> The windows binaries which you can download form
>> http://download.osgeo.org/gdal/win32/1.5/ does support SDE 9.x, by  
>> using the
>> plugins available at the same link. However these win binaries does,  
>> for
>> some reason, not support PostgreSQL.
>>
>> I then tried to use the latest FWtools (2.0.4) that has PostgreSQL  
>> support,
>> but I cant find any SDE plugins that works with newer FWtools than  
>> version
>> 1.3.9.
>>
>> So basically FWtools works with PostgreSQL and the win32 binaries  
>> from the
>> GDAL web site works with SDE.
>>
>> Is there any win32 compilation of the latest gdal 1.5.0 that has both
>> PostgreSQL and SDE 9.x support??
>>
>> Regards,
>> Pål Kristensen
>> -- 
>> View this message in context:
>> http://www.nabble.com/SDE-to-PostgreSQL-PostGIS-tp14873585p14873585.html
>> Sent from the GDAL - Dev mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> gdal-dev mailing list
>> gdal-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> 
> 

-- 
View this message in context: http://www.nabble.com/SDE-to-PostgreSQL-PostGIS-tp14873585p14914348.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.

_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev