[postgis-users] PostGIS supported by which ArcGIS

Paragon Corporation lr at pcorp.us
Thu Jan 15 12:41:43 PST 2015

It sounds like you loaded data with ESRI ST_Geometry format.  I don't think
QGIS has direct support for ESRI ST_Geometry, but I think uDig does.
Those instructions you point to sound like for configuring ESRI's
ST_Geometry data type.  PostGIS datatype is just called geometry and a
completely different ball of wax.
You should probably use these instructions:
The two sets of types while sounding the same and even having some
overlapping functions do not talk to each other and are incompatible with
each other.
I think the benefit of ESRI type is it's easier to use ESRI's versioning
plumbing, but you are limited with what tools you can use with it since I
think most commercial and open source tools understand PostGIS, but fewer
understand the ESRI ST_Geometry type.
This is from a person who only uses ArcGIS passingly when forced to, so take
my historical bent as a bit bent :)
Hope that helps,


From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Adrian Term
Sent: Thursday, January 15, 2015 3:24 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] PostGIS supported by which ArcGIS

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 :
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 ?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150115/05d6bea7/attachment.html>

More information about the postgis-users mailing list