[postgis-users] RE: zigGIS Usage Experiences

Abe Gillespie abe.gillespie at gmail.com
Wed Nov 29 06:24:50 PST 2006


Right, and one of my goals was to use the built-in ArcGIS editor since
it has all the functionality needed AND is already familiar to the
ESRI crowd.

As far as the OLE DB provider ... I'm almost positive you can write a
provider in C#.  The main interop layer that ArcGIS uses is COM and C#
speaks it fluently.  It's just a matter of using the various .Net COM
class attributes.  However, there was some reason I discounted the OLE
DB provider.

Besides ... why not just piggy back on all the work that has already been done?

-Abe

On 11/29/06, Paolo Corti <pcorti at gmail.com> wrote:
>
> Yes looks like a limit of custom layers, according to Esri docs
>
> If you want to implement edit for custom layer looks like you have to
> implement custom edit tool, there is a sample with xy file custom layer on
> ArcObjects on line for implementing custom layer editing tool. Having said
> that, from the other2 approaches: Plug in data source is read-only, so the
> only viable solution would remain OGIS OLE DB Providers, but looks like it
> is developable only with ATL c++
>
> I recall the approaches here:
> 1) Custom Layers
> 2) Plug in data sources
> 3) OGIS compliant OLE DB providers
>
> best regards
> Paolo Corti
> http://www.paolocorti.net
>
>
> Abe Gillespie wrote:
> >
> > I agree.  And I even initially went down the route of a custom layer.
> > I think it fell short right about when I started exploring editing
> > capabilities ... IIRC it's not possible with a custom layer.  I also
> > explored the OLEDB data source and that had its restrictions somewhere
> > too.
> >
> > -Abe
> >
> > On 11/28/06, joshua.uyehara at syngenta.com <joshua.uyehara at syngenta.com>
> > wrote:
> >> Of all of the approaches so far, ZigGIS is the conceptually the
> >> 'cleanest', as it is going the route of a full feature class adapter
> >> implementation (the custom layer approach), but it also requires the
> >> greatest amount of work, as you have to eventually implement the
> >> functionality exposed by about a dozen interfaces.
> >>
> >> pgArc is great for single users, but you run into problems when you need
> >> concurrent access, or relationships with other tables in your database.
> >> The same problems would plague the toolbox approach (which I assume
> >> would basically be a front-end to shp2pgsql and pgsql2shp).
> >>
> >> That's not to say that the pgArc or toolbox approaches aren't worth
> >> pursuing.  They can probably meet some specific needs much faster than
> >> ZigGIS will be able to.
> >>
> >> Joshua Uyehara
> >> joshua.uyehara at syngenta.com
> >> Office: +1 808 337 1408 ext 34
> >> Cell: +1 808 346 5185
> >>
> >> -----Original Message-----
> >> From: postgis-users-bounces at postgis.refractions.net
> >> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> >> Bruce Rindahl
> >> Sent: Tuesday, November 28, 2006 9:34 AM
> >> To: 'PostGIS Users Discussion'
> >> Cc: 'Shaun Kolomeitz'; 'Tyler Mitchell'
> >> Subject: RE: [postgis-users] RE: zigGIS Usage Experiences
> >>
> >> General discussion :)
> >>
> >> I am using pgArc for my PostGIS/ArcMap connection.  It does both
> >> read/write with some bugs.  I hope to post the changes to 9.x soon on
> >> the pgArc site.
> >>
> >> There is also another effort at:
> >> http://datashare.gis.unbc.ca/transhape/
> >> that uses a different approach.
> >>
> >> I looked at zigGIS and passed only because I don't program in C#.
> >>
> >> Finally, Would there be any interest in a ArcToolbox version of
> >> PostGIS/ArcMap ??  I have done a lot of work on toolboxes and think I
> >> could get a proof of concept going pretty soon.  Advantages would be
> >> Python as a scripting language, the GUI is drag and drop and the tools
> >> could be modular (One for read, one for append, one for update, etc).
> >> No compiling would be necessary and the scripts could be used in Model
> >> Builder.  Comments??
> >>
> >> 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: Tuesday, November 28, 2006 12:02 PM
> >> To: postgis-users at postgis.refractions.net
> >> Subject: Re: [postgis-users] RE: zigGIS Usage Experiences
> >>
> >>
> >> Yes Abe
> >> I have seen your 3ed at support.esri.com no one seemed to help you I am
> >> sorry
> >>
> >> Have you checked out these 3 alternatives at ArcObjects help (under
> >> extending arcobjects)?
> >> 1) Custom Layers
> >> 2) Plug in data sources
> >> 3) OGIS compliant OLE DB providers
> >>
> >> Plug in is not applicable (it is read only), but the other 2 are viable
> >> Custom Layers also from .NET I was investigating if also OGIS OLE DB
> >> could be developed in .NET (in the Help is written only VC++ realistic
> >> for implementation, but maybe this comment is obsolete now)
> >>
> >> in any case,
> >> congratulations for your great job, even if ZigGis do not write ;-)
> >>
> >> Paolo
> >>
> >>
> >>
> >> Abe Gillespie wrote:
> >> >
> >> > Sorry, zigGIS does not write.  That, of course, is the "Holy Grail" of
> >>
> >> > these efforts.
> >> >
> >> > -Abe
> >> >
> >> > On 11/28/06, Paolo Corti <pcorti at gmail.com> wrote:
> >> >>
> >> >> Hello Joshua
> >> >> and thanks for the workaround, I will test it as ASAP It is very
> >> >> possibly that we could join to make some modification at ZigGis, as
> >> >> far as I would like in my spare time to write a connector for PostGis
> >>
> >> >> for ArcMap.
> >> >> First I was looking at PgArc (I also migrated that at ArcObjects 9),
> >> >> but I think the best approach is like ZigGis does, without a proxy
> >> >> shapefile, but directly reading the data.
> >> >> I have one more question, before going on.
> >> >> In this mailing list it was claimed, I think just from Abe, that
> >> >> ZigGis can read and also WRITE PostGis data. Is this correct? Because
> >>
> >> >> from what you are writing seems that ZigGis can just read and not
> >> >> write, and maybe I could be not interested in continuing using
> >> >> ZigGis.
> >> >> In fact I have decided to write in my spare time a full Read/Write
> >> >> PostGis connector for ArcMap. But before doing that I would like to
> >> >> deeply investigate if ZigGis already does the job.
> >> >>
> >> >> Best regards
> >> >> Paolo Corti
> >> >> http://www.paolocorti.net
> >> >>
> >> >>
> >> >> 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#a75632
> >> >> > 76 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#a7585042
> >> >> 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#a7585331
> >> 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
> >>
> > _______________________________________________
> > 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#a7595753
> 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
>



More information about the postgis-users mailing list