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

Mon Dec 4 12:51:39 PST 2006

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.