[Gdal-dev] SDE to PostgreSQL/PostGIS

Howard Butler hobu.inc at gmail.com
Thu Jan 17 10:17:29 EST 2008


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



More information about the gdal-dev mailing list