See also https://trac.osgeo.org/postgis/wiki/UsersWikiPostgisarcgis
:S 2015-11-23 20:01 GMT+01:00 David Vick <[email protected]>: > 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> > [email protected] > mobile: 1-636-698-3174 > > > On Mon, Nov 23, 2015 at 12:41 PM, Paul Ramsey <[email protected]> > 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 ([email protected]) >> 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> >> [email protected] >> mobile: 1-636-698-3174 >> >> _______________________________________________ >> gdal-dev mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/gdal-dev >> >> -- >> Paul Ramsey >> Sent with Airmail >> > > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
