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

Fri Dec 1 11:11:25 PST 2006

What I would love to see is someone officially take over the project.
Even if they're not contributing code ... at least managing the
project.  I feel like people are finally seeing some good in the code
and perhaps we can get enough momentum going where this thing finally
moves forward.

Anyone?

-Abe

On 12/1/06, Bruce Rindahl <rindahl at lrcwe.com> wrote:
> Is there any way this version could be posted somewhere?  I would also love
> to try it.  I do not have access to Visual Studio.
> Thanks
> Bruce Rindahl
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paolo
> Corti
> Sent: Friday, December 01, 2006 12:04 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] RE: RE: zigGIS Usage Experiences
>
>
> Thank you Joshua
> now it is working!
>
> with some quick debug i discovered it was a stupid problem with my
> international settings.
>
> The funny thing is that now with correcting the regional settings it works
> also the previous version i had (the public 8.3 based version - that I
> modified to work with 9.0 and from which I removed the circular
> reference problem). In this previous version you DON'T NEED to create
> the view, so that problem It was already solved but came back in the
> version Abe emailed you...
>
> So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005 Solution
> of ZigGis, without need creating the view as you suggested.
>
> I am amazed from the speed of ZigGis with reading data (i wouldn't have
> thought is so fast, after all we are not reading an ArcGis native geometry),
> but I see there are still many things to do (before implementing editing):
> for example rendering with symbology is not working, the geometry column
> seems to have a problem (is undefined),
> ....
>
> Who knows why it is not possible editing data, this would be a super tip to
> get to know what can be, AFAIK Abe was trying to discover that for more than
> one month! I am sure if someone from the Esri Geodatabase team could give us
> a little help about this they could give us the right direction for letting
> the layer to be edited. I don't think there is a block, we probably need to
> implement in the right way the right interface...
>
> in any case thank you for helping me
>
> Best regards
> Paolo
>
> Paolo Corti wrote:
> >
> > 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 you emailed me with Visual Studio 2005
> > (.net 2.0) and ArcObjects 9.0 .net assemblies.
> > It compiles fine, but when I add 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#a7644254
> 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
>