« Return to Thread: zigGIS Usage Experiences
RE: zigGIS Usage Experiences
by Paolo Corti
::
Rate this Message:
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
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@syngenta.com
-----Original Message-----
From: postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of
Paolo Corti
Sent: Monday, November 27, 2006 6:46 AM
To: postgis-users@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@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
« Return to Thread: zigGIS Usage Experiences
| Free embeddable forum powered by Nabble | Forum Help |
