[postgis-users] RE: RE: zigGIS Usage Experiences

Fri Dec 1 05:50:30 PST 2006

Hi Joshua,

thank you for emailing me the latest Abe's version.
What I had it was this: http://gforge2.uwc.ac.za/projects/ziggis
and it was for 8.3, with a circular reference problem.
If i knew that there was what you sended me I would have saved 1 day time it
took me to get what I had compiled with AO 9.0.
In any case I compiled the project with Visual Studio 2005 (.net 2.0) and
ArcObjects 9.0 .net assemblies.
It compiles fine, but when I had a layer:
1) if I just add a working PostGis layer it gives error
2) if I add a view (like you suggested) to the Working PostGis layer, it
seems working, the layer is added at the TOC, but nothing is drawn. If I
open the attribute table it shows me all the record, but the geometry field
is empty.

any idea?
thanks in advance

Paolo 

in fact what I had it was downloaded from SourceForge and it was still

joshua.uyehara wrote:
> 
> 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
> _______________________________________________
> 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#a7637883
Sent from the PostGIS - User mailing list archive at Nabble.com.