<div dir="ltr">See also <a href="https://trac.osgeo.org/postgis/wiki/UsersWikiPostgisarcgis">https://trac.osgeo.org/postgis/wiki/UsersWikiPostgisarcgis</a> <div><br></div><div>:S</div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-11-23 20:01 GMT+01:00 David Vick <span dir="ltr"><<a href="mailto:dvick@boundlessgeo.com" target="_blank">dvick@boundlessgeo.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Paul,<div><br></div><div>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.</div></div><div class="gmail_extra"><span class=""><br clear="all"><div><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">David Vick</div><div dir="ltr"><br>Professional Services Engineer | <a href="http://www.boundlessgeo.com" target="_blank">Boundless</a><br><a href="mailto:dvick@boundlessgeo.com" target="_blank">dvick@boundlessgeo.com</a><br>mobile: 1-636-698-3174</div><div dir="ltr"><br><img src="https://docs.google.com/a/boundlessgeo.com/uc?id=0B47HJesavZUJaks1NUN1cEsxNFU&export=download"><span></span><span></span></div></div></div></div></div></div></div></div></div>
<br></span><div><div class="h5"><div class="gmail_quote">On Mon, Nov 23, 2015 at 12:41 PM, Paul Ramsey <span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">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. </div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">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.</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">ATB,</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">P.</div><div><div> <br><p style="color:#000">On November 23, 2015 at 10:34:28 AM, David Vick (<a href="mailto:dvick@boundlessgeo.com" target="_blank">dvick@boundlessgeo.com</a>) wrote:</p> </div></div><blockquote type="cite"><span><div><div></div><div><div><div>
<div dir="ltr">
<div>All,</div>
<div><br></div>
<div>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?</div>
<div><br></div>
<div>Thanks,</div>
<br clear="all">
<div>
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">David Vick</div>
<div dir="ltr"><br>
Professional Services Engineer | <a href="http://www.boundlessgeo.com" target="_blank">Boundless</a><br>
<a href="mailto:dvick@boundlessgeo.com" target="_blank">dvick@boundlessgeo.com</a><br>
mobile: <a href="tel:1-636-698-3174" value="+16366983174" target="_blank">1-636-698-3174</a></div>
<div dir="ltr"><br>
<img src="https://docs.google.com/a/boundlessgeo.com/uc?id=0B47HJesavZUJaks1NUN1cEsxNFU&export=download">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
_______________________________________________<br>gdal-dev mailing list<br><a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a></div></div></span></blockquote><span><font color="#888888"> <div><div style="font-family:helvetica,arial;font-size:13px">-- <br>Paul Ramsey<br>Sent with Airmail</div></div></font></span></div></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div><br></div>