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

Fri Dec 1 12:18:15 PST 2006

Very good!  I will get with you offline over the weekend and we can
set things up.

-Abe

On 12/1/06, Paolo Corti <pcorti at gmail.com> wrote:
>
> Hi Abe
> I will do it, should I continue in the webspace from where I downloaded?
> Let me know!
>
> My plans are:
> 1) Some code refactoring
> 2) correct bugs about rendering
> 3) try to solve the edit problem (maybe I can have a direct contact with
> Esri, some years ago I was working for Esri Italy) in the clean way, this
> meaning without doing anything like in the PgArc fashion with a proxy
> shapefile but just solving the ArcGis desktop complain that editor is not
> allowed (this issue you were also asking at the support esri website:
> http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977)
> 4) if I can't solve the edit issue in a clean way go with the PgArc fashion
> for editing
> 5) implementing ZigGis to work also with MySql and maybe with SQL Server
> spatial
>
> Let me know if I should open a web space at SourceForge or should I continue
> to use the web space you were using
>
> If someone, like Joshua, is willing to help me is very welcome
>
> best regards
>
> Paolo Corti
> GIS Developer
> http://www.paolocorti.net
>
>
>
>
> Abe Gillespie wrote:
> >
> > 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
> >>
> > _______________________________________________
> > 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#a7645455
> 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
>