[postgis-users] PostGIS supported by which ArcGIS

[Paragon Corporation]

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:
http://resources.arcgis.com/en/help/main/10.2/index.html#//002p0000006v00000
0
 
 
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,
Regina

  _____  

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 :
http://resources.arcgis.com/en/help/main/10.2/index.html#//002p000000t400000
0
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





















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