Re: [gdal-dev] Ingesting ESRI geometry into PostGIS

2015-11-23 Thread Stefan Keller
See also https://trac.osgeo.org/postgis/wiki/UsersWikiPostgisarcgis :S 2015-11-23 20:01 GMT+01:00 David Vick : > 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

Re: [gdal-dev] Ingesting ESRI geometry into PostGIS

2015-11-23 Thread David Vick
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 th

Re: [gdal-dev] Ingesting ESRI geometry into PostGIS

2015-11-23 Thread Paul Ramsey
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 tha

[gdal-dev] Ingesting ESRI geometry into PostGIS

2015-11-23 Thread David Vick
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 ogr2ogr completes and I can verify that the