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

[Abe Gillespie]

Hey Paolo,

Sorry I haven't gotten with you yet ... just too busy these days.  I'd
prefer opening a project site at code.google.com.  Beyond putting the
latest source there feel free to do whatever you like with the page.

You can ping me at abe.gillespie on GTalk if you need me for anything.

Thanks!
-Abe

On 12/4/06, Paolo Corti <pcorti at gmail.com> wrote:
>
> Abe
> tell me what I have to do:
> should I continue to manage the web space you already have setted?
> should I open a new one?
> should I put everithing at my website?
> let me know
>
> Paolo
>
>
> Abe Gillespie wrote:
> >
> > 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
> >>
> > _______________________________________________
> > 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#a7687175
> 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
>