<HTML>
<HEAD>
<TITLE>Re: [postgis-users] Postgis and arcgis with data interoperability extension</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
Ok thanks for the OLE DB info.<BR>
I am still new to working with databases so maybe I am wrong, but ESRI told me that I can use ArcSDE only with the Server Version that I until now don t have. But still it should be possible to connect through the Data Interoperability Extension.<BR>
The strange thing is that it works with polygons but not with point geometry<BR>
<BR>
Thanks for your ideas<BR>
<BR>
thomas<BR>
<BR>
<BR>
On 18.11.09 22:51, "George Silva" <<a href="georger.silva@gmail.com">georger.silva@gmail.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>This is very weird. Very weird. I have experience with Esri SDE and if you are working with OGC standarts everything should work fine.<BR>
<BR>
Did you registered all your tables trough ArcSDE? If not, you need to do it.<BR>
<BR>
OLE Connections will only let you handle tabular information, so let that go. It's not the way.<BR>
<BR>
AFAIK ESRI implements OGC standarts. You should NOT have problems with point geometry.<BR>
<BR>
Att<BR>
<BR>
George<BR>
<BR>
On Wed, Nov 18, 2009 at 6:39 PM, Ragi Y. Burhum <<a href="rburhum@gmail.com">rburhum@gmail.com</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>From: Thomas Jakubicka <<a href="crazyh@gmx.net">crazyh@gmx.net</a>><BR>
Subject: [postgis-users] Postgis and arcgis with data interoperability<BR>
extension<BR>
To: <<a href="postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><BR>
Message-ID: <<a href="C729D2DF.2936%crazyh@gmx.net">C729D2DF.2936%crazyh@gmx.net</a> <<a href="mailto:C729D2DF.2936%25crazyh@gmx.net">mailto:C729D2DF.2936%25crazyh@gmx.net</a>> ><BR>
Content-Type: text/plain; charset="US-ASCII"<BR>
<BR>
<BR>
Hello,<BR>
<BR>
I am trying to access my postgis/postgreSQL database through the<BR>
datainteroperability extension and have problems with all my point data. I<BR>
can load and export polygons but no points. The connection to the database<BR>
works fine but when i try to load point data the attribute table is empty<BR>
and only the header row is shown<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
That seems bizarre. FYI, ESRI provides their own implementation of a Geometry type on PostgreSQL. You can also use PostGIS. My "psychic debugging" skills tell me there is a chance you may be mixing the two? <BR>
<BR>
Also, did you load the PostGIS functions as described in the documentation for the database you are working with *before* loading the data?<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
I also tried to access the database through an OLE DB connection witch is<BR>
working so far that I get access to all tables stored in the database but<BR>
still can not show the spatial information. With this connection all<BR>
datasets are shown with the table-symbol and the geometry field stays empty.<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
This is how the ESRI OLE DB provider works - it doesn't load and spatial information. Anything you load from there will be "just a table"<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>We are using the Postgis/PostgreSQL version 8.3 and ArcEditor 9.3.1<BR>
<BR>
Thanks for your help<BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
The best thing I could recommend to you now is to do some logging from the PostgreSQL side of things. See what SQL is being executed during the load and it should show you your problem right away.<BR>
<BR>
Hope this helps,<BR>
<BR>
- Ragi<BR>
<BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
<a href="postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><BR>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE>
</BODY>
</HTML>