<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.17183"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>You should probably use these
instructions:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial><A
href="http://resources.arcgis.com/en/help/main/10.2/index.html#//002p0000006v000000">http://resources.arcgis.com/en/help/main/10.2/index.html#//002p0000006v000000</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>This is from a person who only uses ArcGIS passingly when
forced to, so take my historical bent as a bit bent :)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=635593420-15012015><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Adrian
Term<BR><B>Sent:</B> Thursday, January 15, 2015 3:24 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] PostGIS
supported by which ArcGIS<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>
<DIV>I have the following setup :</DIV>
<DIV>ArcGIS 10.2.2 for Desktop Advanced</DIV>
<DIV>ArcGIS 10.2.2 for Server</DIV>
<DIV>QGIS 2.6.1 Brighton</DIV>
<DIV>PostgreSQL 9.2.9-3</DIV>
<DIV>PostGIS 2.1</DIV>
<DIV><BR></DIV>
<DIV>I managed to make them all hear each other following this instructions
: <A
href="http://resources.arcgis.com/en/help/main/10.2/index.html#//002p000000t4000000">http://resources.arcgis.com/en/help/main/10.2/index.html#//002p000000t4000000</A></DIV>
<DIV>Data is loaded from ArcGIS with the <SPAN
style="FONT-SIZE: 13px">"Import feature class (single)"</SPAN><SPAN
style="FONT-SIZE: 13px"> with the "PG_Geometry" configuration keyword in
Geodatabase Settings.</SPAN></DIV>
<DIV>With ArcGIS I can connect, view, edit and save the data stored in the
"esrified" PostgreSQL/PostGIS database tables.</DIV>
<DIV><BR></DIV>
<DIV>Unfortunately, when<SPAN style="FONT-SIZE: 13px"> I try to do the same
thing in QGIS i get an error message :</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 13px">"Errors: ERROR: 1 feature(s) not
added.</SPAN></DIV>
<P style="FONT-SIZE: 13px; MARGIN: 0px"></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px">Provider errors:</P>
<P style="FONT-SIZE: 13px; MARGIN: 0px">PostGIS error while adding features:
ERROR: column "shape" is of type geometry but expression is of type
st_geometry"</P>
<P style="FONT-SIZE: 13px; MARGIN: 0px">On the other hand, I tried to do the
same thing with UDIG and everything works perfect.</P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><BR></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px">I assume that the issue in QGIS is
something about what Birgit mentioned :</P>
<P style="FONT-SIZE: 13px; MARGIN: 0px">"<SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0)">If
ArcGIS writes geometries into the PostgreSQL database it names the geometry
column as "shape" with the datatype "geometry" </SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><BR></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0)">Any
ideas ?</SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0)">Adrian</SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0)"><BR></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><SPAN
style="FONT-FAMILY: Verdana,Geneva,Helvetica,Arial,sans-serif; COLOR: rgb(0,0,0)"><BR></SPAN></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><BR></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><BR></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><BR></P>
<P style="FONT-SIZE: 13px; MARGIN: 0px"><BR></P>
<DIV><BR></DIV>
<DIV><BR></DIV></DIV></BODY></HTML>