[postgis-users] RE: zigGIS Usage Experiences

[joshua.uyehara at syngenta.com]

Hey Paolo,

I'm using ArcGIS Desktop 9.1.  As Abe mentioned, however, I'm also using
a later snapshot of ZigGIS.

I had also gone and updated the publicly available ZigGIS to the 9.0
ArcObjects model before receiving the latest version of ZigGIS from Abe,
but I never tested that version with the workaround that I outlined.

I'll email you a copy of the latest snapshot from Abe so that you can
see if you have any better luck with it.

Joshua Uyehara
joshua.uyehara at syngenta.com

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Paolo Corti
Sent: Wednesday, November 29, 2006 7:21 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] RE: zigGIS Usage Experiences


Hello Joshua
I tried what you suggested (I also added the GID field in the view, it
caused an error).
But ZigGis goes in error when is adding layer, specifically at this line
of
code:

doc.AddLayer(layer);

the error i get is AccessViolationExpection

did you also try using ZigGis with ArcMap 9.0 ?

in any case thank you for helping me, i will investigate more deeply and
if i get into some resolution I will drop a note here

best regards
Paolo


joshua.uyehara wrote:
> 
> Hey Paolo,
> 
> Abe isn't working on it anymore, but I have been occasionally plugging

> away at it myself.  The problem with adding the layer in ArcMap is due

> to a minor bug.
> 
> ZigGIS pulls the geometry column data from PostGIS in its native 
> binary format and passes it to ArcMap.  Unfortunately, PostGIS' 
> internal binary format is not identical to the expected wkb format, so

> ArcMap silently ignores it and basically treats the table as a 
> feature-less object class.
> 
> One quick workaround is to create a view of the table that converts 
> the geometry column with asbinary(), and then manually add the 
> necessary entry to the geometry_columns table.
> 
> E.g.,
> 
> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as 
> geom_column, column2, column3, FROM geom_table; INSERT INTO 
> geometry_columns (f_table_schema, f_table_name, f_geometry_column, 
> coord_dimension, srid, type) VALUES
> 	('public', 'geom_table_view', 'geom_column', 2, -1,
'MULTIPOLYGON');
> 
> Change schema, table, column names, srid, etc. to match your table, 
> then specify the view as the table to be opened with ZigGIS.  It's an 
> ugly kludge, but I haven't had the time to fix the problem in ZigGIS 
> itself yet.
> 
> Many of the feature class functionality hasn't been implemented yet, 
> so you can't do much besides display the features.  I'm planning to 
> add features to ZigGIS as I need them for work, but I can't give you 
> any timelines on it, as I'm swamped with other stuff at the moment.
> 
> Hope that helped,
> Joshua Uyehara
> joshua.uyehara at syngenta.com
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> Paolo Corti
> Sent: Monday, November 27, 2006 6:46 AM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] zigGIS Usage Experiences
> 
> 
> Hello Abe
> 
> you made a great job with your ZigGis! The ArcObjects code is amazing!
> 
> maybe you can give me a help
> I compiled your code for using it with ArcGis 9 (i made some little 
> modifications at the code to get this) and .NET 2.0 It compiled fine, 
> but when I start ArcMap and I add a PostGIS layer, it adds the layer 
> on the TOC but nothing is showed/drawed on the map.
> Looks like geometries are not read from the shape column.
> I am wondering if you are still on this project, and maybe you could 
> give me some help, or if I am on my own and must deeply 
> investigate/debug myself the code in order to find what is not going 
> properly
> 
> best regards
> Paolo Corti
> GIS Developer
> http://www.paolocorti.net
> 
> 
> Abe Gillespie wrote:
>> 
>> Sorry for the cross post, but the zigGIS list only has 9 subscribers 
>> with a ton more downloads than that.
>> 
>> I'm curious about any experiences people are having using or even
>> *trying* to use zigGIS.  Is it working?  Anyone need any help?  Any 
>> constructive criticism?  ... I haven't heard a peep yet.
>> 
>> Thanks.
>> -Abe
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 
>> 
> 
> --
> View this message in context:
> http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

--
View this message in context:
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users