[postgis-users] PostGIS supported by which ArcGIS
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
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
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
"Errors: ERROR: 1 feature(s) not added.
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
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...
More information about the postgis-users