[postgis-users] PgArc and postgis 1.0

[joanne cook]

Hi Bruce and List,
 
Many thanks for the response. I haven't got very far with trying to resolve the problem though! I downloaded the cvs version of PgArc so that I could get at the vb code, and tracked down the error message, which seems to be related to the function dumpToPostgis. This is where the sql statement seems to be generated, but when I try and debug it either by stepping through the code or by trying to get it to print the sql statement at various stages throughout the function it doesn't do anything. Basically the error seems to be created either right at the beginning of that function or in an earlier one that I haven't tracked down yet. 
 
When I look at the postgres table after I have been through this process all it says is 0 rows, and my postgresql log also gives me the same "parse error: invalid geometry". 
 
Thanks
 
Jo
 
Message: 5
Date: Wed, 31 May 2006 04:04:38 -0600
From: "Bruce Rindahl" <rindahl at lrcwe.com>
Subject: RE: [postgis-users] PgArc and postgis 1.0
To: "'PostGIS Users Discussion'"
        <postgis-users at postgis.refractions.net>
Message-ID: <000001c68499$a0a812f0$6501a8c0 at Bruce>
Content-Type: text/plain;       charset="us-ascii"

Joanne
pgArc was written by Nicolas Ribot (He follows this list), but he doesn't
have access to a ArcGIS license any more.  I also got it working in ArcGIS
9.1 but I was only interested in loading and viewing so I didn't even look
at the upload functions.  The error message looks like the geometry
constructor isn't quite correct.  If should add a message box statement in
the VBA just before SQL execute to see just what is being sent.  It should
be a standard SQL statement and then anyone can test and see what PostGIS is
complaining about.
Bruce Rindahl

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of joanne
cook
Sent: Wednesday, May 31, 2006 2:53 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] PgArc and postgis 1.0

Hi List,

I'm just getting started with postgres and postgis, and was wondering about
the current status of PgArc for linking to arcmap 9.x. I have got PgArc
working to the stage that I can load tables and view the features in arcmap,
but when I try and edit them and write back to the postgres database I get
an error as follows:

error: CPostgisTable.dumpToPostgis
Error number: -2.147217887
Description: Error while exectuing the query;
ERROR: parse error -invalid geometry

I get this whether I try and save the original table or create a new one.
When I then try and reload the orginal table it appears broken in arcmap,
and doesn't display.

Is there any work happening on a new version of PgArc or does anyone have a
fix for this problem?

Thanks

Jo Cook

-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------

 
-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------


This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com