[postgis-users] RE: zigGIS Usage Experiences

[Carl Anderson]

Joshua,

would you mind send such an email to me as well.  I had been very 
interested in ZigGIS but I could never get it to work with ArcGIS 9.1


C.
carl.anderson at vadose.org

joshua.uyehara at syngenta.com 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
>