[postgis-users] PostGIS supported by which ArcGIS

[David Fawcett]

Adrian,

I think that Regina is correct and that the layer that you loaded is using
the ESRI st_geometry.  I am using PostGIS with ESRI products (10.2) and I
am able to create a feature class in the 'esrified' postgres table with
ESRI tools and then manipulate it using PostGIS and QGIS (2.4, I don't have
2.6 on this machine.)

To load data, I generally use the ESRI Tool Conversion>To
Geodatabase>Feature Class to Feature Class, setting PG_Geometry in the
Geodatabase settings control.

So far, this setup is working quite well and giving us pretty much 'the
best of both worlds'.  The geometry column does get named 'shape' by ESRI,
but that isn't an issue on the PostGIS side.

David.

On Thu, Jan 15, 2015 at 2:23 PM, Adrian Term <adrian.term at gmail.com> wrote:

> I have the following setup :
> ArcGIS 10.2.2 for Desktop Advanced
> ArcGIS 10.2.2 for Server
> QGIS 2.6.1 Brighton
> PostgreSQL 9.2.9-3
> PostGIS 2.1
>
> I managed to make them all hear each other following this instructions :
> http://resources.arcgis.com/en/help/main/10.2/index.html#//002p000000t4000000
> Data is loaded  from ArcGIS with the "Import feature class (single)"
> with the "PG_Geometry" configuration keyword in Geodatabase Settings.
> With ArcGIS I can connect, view, edit and save the data stored in the
> "esrified" PostgreSQL/PostGIS  database tables.
>
> Unfortunately, when I try to do the same thing in QGIS i get an error
> message :
> "Errors: ERROR: 1 feature(s) not added.
>
> Provider errors:
>
> PostGIS error while adding features: ERROR: column "shape" is of type
> geometry but expression is of type st_geometry"
>
> On the other hand, I tried to do the same thing with UDIG and everything
> works perfect.
>
>
> I assume that the issue in QGIS is something about what Birgit mentioned :
>
> "If ArcGIS writes geometries into the PostgreSQL database it names the
> geometry column as "shape" with the datatype "geometry"
>
>
> Any ideas ?
>
> Adrian
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150115/f77a09d1/attachment.html>