[postgis-users] RE: RE: zigGIS Usage Experiences
Paolo Corti
pcorti at gmail.com
Fri Dec 1 12:15:34 PST 2006
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.
More information about the postgis-users
mailing list