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> dv...@boundlessgeo.com mobile: 1-636-698-3174 On Mon, Nov 23, 2015 at 12:41 PM, Paul Ramsey <pram...@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 (dv...@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> > dv...@boundlessgeo.com > mobile: 1-636-698-3174 > > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > -- > Paul Ramsey > Sent with Airmail >
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
