[gdal-dev] Ingesting ESRI geometry into PostGIS

[Stefan Keller]

See also https://trac.osgeo.org/postgis/wiki/UsersWikiPostgisarcgis

:S

2015-11-23 20:01 GMT+01:00 David Vick <dvick at boundlessgeo.com>:

> Paul,
>
> Thanks for the response.  We are running ArcSDE on top of the PostgreSQL
> server hence the first part of the question.  As part of our process we are
> using ArcObjects to extract the schema of the FileGDB and write the schema
> to PostgreSQL and then are attempting to use gdal/ogr2ogr to move the data
> as this is much faster than ESRI's processes, but this has failed and now
> we know why.  Your second point is quite clear and something that my client
> will have to look at in the future.
>
> David Vick
>
> Professional Services Engineer | Boundless <http://www.boundlessgeo.com>
> dvick at boundlessgeo.com
> mobile: 1-636-698-3174
>
>
> On Mon, Nov 23, 2015 at 12:41 PM, Paul Ramsey <pramsey at cleverelephant.ca>
> wrote:
>
>> This is a non-sequitur "PostgreSQL/PostGIS that has the default
>> geometry_storage parameter set to st_geometry”. The ST_Geometry type is an
>> ESRI thing, and you need to have ESRI dll’s installed in your
>> PostgreSQL/ESRI server in order to create such a column. That’s Problem #1.
>>
>> Problem #2 is that GDAL doesn’t support writing to a PostgreSQL/ESRI
>> database, so you’ll have to write a suitable driver for that.
>>
>> ATB,
>>
>> P.
>>
>> On November 23, 2015 at 10:34:28 AM, David Vick (dvick at boundlessgeo.com)
>> wrote:
>>
>> All,
>>
>> I'm trying to use ogr2ogr to ingest FileGDB's into PostgreSQL/PostGIS
>> that has the default geometry_storage parameter set to st_geometry.  When
>> running ogr2ogr with DEBUG on I see a message PG: Field shape is of unknown
>> format type st_multipolygon <type=st_multipolygon> ogr2ogr completes and I
>> can verify that the data is copied into postgis, but the geometries are NOT
>> copied over.  Does anyone have an idea on how to resolve this?
>>
>> Thanks,
>>
>> David Vick
>>
>> Professional Services Engineer | Boundless <http://www.boundlessgeo.com>
>> dvick at boundlessgeo.com
>> mobile: 1-636-698-3174
>>
>> _______________________________________________
>> gdal-dev mailing list
>> gdal-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>>
>> --
>> Paul Ramsey
>> Sent with Airmail
>>
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20151123/cbda2fbd/attachment.html>