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

Fri Dec 1 12:52:50 PST 2006

I developed it in C# Express which is also free.

-Abe

On 12/1/06, joshua.uyehara at syngenta.com <joshua.uyehara at syngenta.com> wrote:
> You don't need Visual Studio 2005 to compile it.  A very nice open
> source alternative to VS is sharpdevelop (sharpdevelop.net).
>
> Josh
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Bruce Rindahl
> Sent: Friday, December 01, 2006 9:09 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
>
> 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#a756327
> >>> 6 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>