[Gdal-dev] SDE to PostgreSQL/PostGIS

[Pål Kristensen]

Thanks!!

Works like a charm.

Regards
Pål


Howard Butler-3 wrote:
> 
> Oops.  Can you try the new version that is available from the download  
> site?
> 
> Howard
> 
> On Jan 17, 2008, at 3:34 AM, Martin Chapman wrote:
> 
>> Correct.
>>
>> 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 2:06 AM
>> To: gdal-dev at lists.osgeo.org
>> Subject: RE: [Gdal-dev] SDE to PostgreSQL/PostGIS
>>
>>
>> Hi!
>>
>> Thanks! I assumed that it was something like that. The SDE plugin  
>> seems to
>> work correctly, but the problem is the PostgreSQL plugin that Howard  
>> Butler
>> compiled for me yesterday.
>>
>> So, the solution would be to recompile the PostgreSQL plugin without  
>> debug
>> support?
>>
>> Regards,
>> Pål Kristensen
>>
>>
>>
>> mchapman wrote:
>>>
>>> Whoops, from the image looks like your application or the plugin is
>>> compiled with the debug version and it doesn't like the different  
>>> heap
>>> space.
>>>
>>> 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
>>>
>>> _______________________________________________
>>> 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-tp14873585p14914870.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
> 
> _______________________________________________
> 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-tp14873585p14921866.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.