[postgis-users] Re: Nearest Neighbour queries in Postgis
Mark Thomas
spatialguru.net at gmail.com
Sat Dec 2 14:49:09 PST 2006
here's code i use to find nearest neighbor for reverse geocoding with
TeleAtlas data.
pt := GeomFromEWKT('SRID=4326;POINT(' || $2 || ' ' || $1 || ')');
select l_f_add, l_t_add, r_f_add, r_t_add, l_pc, r_pc, l_laxon, r_laxon,
l_order01, r_order01, fullname, geom into rec
from usauma________gc where id = (select id from usauma________gc where
geom && Expand(pt,0.003) group by id order by Min(Distance(geom,pt)) limit
1);
of course $2 is longitude, $1 is latitude, pt is geometry and rec is record.
On 12/2/06, postgis-users-request at postgis.refractions.net <
postgis-users-request at postgis.refractions.net> wrote:
>
> Send postgis-users mailing list submissions to
> postgis-users at postgis.refractions.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
> postgis-users-request at postgis.refractions.net
>
> You can reach the person managing the list at
> postgis-users-owner at postgis.refractions.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
>
>
> Today's Topics:
>
> 1. Re: Postgis Java Geometry classes/Hibernate, borken
> query[Solution] (Dave Potts)
> 2. Re: RE: RE: zigGIS Usage Experiences (Paolo Corti)
> 3. Re: RE: RE: zigGIS Usage Experiences (Abe Gillespie)
> 4. Re: RE: RE: zigGIS Usage Experiences (Paolo Corti)
> 5. RE: RE: RE: zigGIS Usage Experiences (Bruce Rindahl)
> 6. RE: RE: RE: zigGIS Usage Experiences (joshua.uyehara at syngenta.com)
> 7. RE: RE: RE: zigGIS Usage Experiences (joshua.uyehara at syngenta.com)
> 8. Re: RE: RE: zigGIS Usage Experiences (Abe Gillespie)
> 9. what is the units of distance parameter in the buffer
> function (Sandeep Kumar Jakkaraju)
> 10. RE: what is the units of distance parameter in the buffer
> function (Pedro Doria Meunier)
> 11. RE: what is the units of distance parameter inthe buffer
> function (Bruce Rindahl)
> 12. Re: what is the units of distance parameter in the buffer
> function (Bill Thoen)
> 13. Nearest Neighbour queries in Postgis (Sandeep Kumar Jakkaraju)
> 14. Re: Nearest Neighbour queries in Postgis (Dylan Beaudette)
> 15. Re: what is the units of distance parameter in the buffer
> function (Michael Fuhr)
> 16. RE: what is the units of distance parameter inthe buffer
> function (Pedro Doria Meunier)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 01 Dec 2006 20:06:13 +0000
> From: Dave Potts <dave.potts at pinan.co.uk>
> Subject: Re: [postgis-users] Postgis Java Geometry classes/Hibernate,
> borken query[Solution]
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <45708B35.10403 at pinan.co.uk>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Dave Potts wrote:
> > Hi Folks
> >
> > I am using hibernate to query a postgis database.
> >
> > The majority of my distance queries work as expected, one does not!
> > For one distance setting I get loads of answers, for a greater
> > distance, I get none, when I would expect to get at least the first set.
> >
> > So I suspect that either Hibernate or Postgis are having problems.
> >
> > I can type the query in by hand and it works as expected , so I don't
> > suspect the database or postgis interface to the database.
> >
> > Is there any debug code in postgres/postgi/Hibernate that will actual
> > allow me work out what data is being sent from postgres to hibernate,
> > what hibernate is caching and what its forwarding to the end user.
> >
> > regards David
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> I found the problem, my hibernate query said something like
>
> blah blah blah manor.geometry is not null and distance(manor.geometry,
> srcCastle.geometry) < :distance
>
> I was setting the value of distance by saying
>
> query.setString("distance","3000");
>
> Distance is a numerical construct
>
> as soon as I said
> query.setInteger("distance",3000);
>
> It now works as expected !
> Its at times like this, I remeber Pascal and its very rigid views about
> argument types.
>
> It has taken some 7 hours to find this problem.
>
> David.
>
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: dave.potts.vcf
> Type: text/x-vcard
> Size: 85 bytes
> Desc: not available
> Url :
> http://lists.refractions.net/pipermail/postgis-users/attachments/20061201/300bf9df/dave.potts-0001.vcf
>
> ------------------------------
>
> Message: 2
> Date: Fri, 1 Dec 2006 12:15:34 -0800 (PST)
> From: Paolo Corti <pcorti at gmail.com>
> Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences
> To: postgis-users at postgis.refractions.net
> Message-ID: <7645455.post at talk.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> 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.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 1 Dec 2006 15:18:15 -0500
> From: "Abe Gillespie" <abe.gillespie at gmail.com>
> Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <a6d397e30612011218j5088643hfb94ed9a1aff9b0a at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> 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
> >
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 1 Dec 2006 12:37:14 -0800 (PST)
> From: Paolo Corti <pcorti at gmail.com>
> Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences
> To: postgis-users at postgis.refractions.net
> Message-ID: <7645784.post at talk.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> I forgot to say that one of the fist thing I want to do is an installer,
> so
> more people can get in touch with ZigGis (I am dead sure many many people
> wanted to use it but didn't because they don't know c# and how to make it
> working).
> Whit more people installing ZigGis we can even get to know more bugs and
> fix
> them (a sort of alfa-beta test)
>
> Paolo
>
>
> Paolo Corti 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#a7645784
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 1 Dec 2006 13:39:22 -0700
> From: "Bruce Rindahl" <rindahl at lrcwe.com>
> Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
> To: "'PostGIS Users Discussion'"
> <postgis-users at postgis.refractions.net>
> Message-ID: <002b01c71588$ca00bcd0$1e00a8c0 at Bruce>
> Content-Type: text/plain; charset="us-ascii"
>
> Bingo
> I would love to test as soon as this is possible.
> 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 1:37 PM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences
>
>
> I forgot to say that one of the fist thing I want to do is an installer,
> so
> more people can get in touch with ZigGis (I am dead sure many many people
> wanted to use it but didn't because they don't know c# and how to make it
> working).
> Whit more people installing ZigGis we can even get to know more bugs and
> fix
> them (a sort of alfa-beta test)
>
> Paolo
>
>
> Paolo Corti 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#a7645784
> 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
>
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 1 Dec 2006 15:47:46 -0500
> From: <joshua.uyehara at syngenta.com>
> Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
> To: <rindahl at lrcwe.com>, <postgis-users at postgis.refractions.net>
> Message-ID:
> <
> FC865F8C89A81F4CB8AC6ED7A033D78D376382 at usarmsxmb02.NAFTA.SYNGENTA.ORG>
>
> Content-Type: text/plain; charset="us-ascii"
>
> I'll post it to my school account until Paolo gets his site up.
>
> http://people.fas.harvard.edu/~uyehara/zigGIS2.zip
>
> Josh
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Bruce Rindahl
> Sent: Friday, December 01, 2006 9:09 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
>
> 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#a756327
> >>> 6 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
>
>
> ------------------------------
>
> Message: 7
> Date: Fri, 1 Dec 2006 15:50:37 -0500
> From: <joshua.uyehara at syngenta.com>
> Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
> To: <rindahl at lrcwe.com>, <postgis-users at postgis.refractions.net>
> Message-ID:
> <
> FC865F8C89A81F4CB8AC6ED7A033D78D376383 at usarmsxmb02.NAFTA.SYNGENTA.ORG>
>
> Content-Type: text/plain; charset="us-ascii"
>
> You don't need Visual Studio 2005 to compile it. A very nice open
> source alternative to VS is sharpdevelop (sharpdevelop.net).
>
> Josh
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Bruce Rindahl
> Sent: Friday, December 01, 2006 9:09 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
>
> 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#a756327
> >>> 6 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
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 1 Dec 2006 15:52:50 -0500
> From: "Abe Gillespie" <abe.gillespie at gmail.com>
> Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <a6d397e30612011252y7b4e4a5cg3a0780c8b3618192 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I developed it in C# Express which is also free.
>
> -Abe
>
> On 12/1/06, joshua.uyehara at syngenta.com <joshua.uyehara at syngenta.com>
> wrote:
> > You don't need Visual Studio 2005 to compile it. A very nice open
> > source alternative to VS is sharpdevelop (sharpdevelop.net).
> >
> > Josh
> >
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> > Bruce Rindahl
> > Sent: Friday, December 01, 2006 9:09 AM
> > To: 'PostGIS Users Discussion'
> > Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
> >
> > 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#a756327
> > >>> 6 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
> >
>
>
> ------------------------------
>
> Message: 9
> Date: Sat, 2 Dec 2006 22:08:02 +0530
> From: "Sandeep Kumar Jakkaraju" <sandeepkumar.jakkaraju at gmail.com>
> Subject: [postgis-users] what is the units of distance parameter in
> the buffer function
> To: postgis-users at postgis.refractions.net
> Message-ID:
> <c653c98f0612020838g4c26e086u223ff1c99d6c9d7b at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> what is the units of distance parameter in the buffer function ...
>
> buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0
> 79.0
> )'),1);
>
> if my geom is in lat/lon ..... how much will be 1 !!
>
> can some one throw more light on the 3 rd optional parameter !!! the
> manual
> is not clear !!
>
> --
> Sandeep Kumar Jakkaraju
> WeBlog:
> http://jakkarajus.blogspot.com
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/3fde8506/attachment-0001.html
>
> ------------------------------
>
> Message: 10
> Date: Sat, 2 Dec 2006 17:12:48 -0000
> From: "Pedro Doria Meunier" <pdoria at netmadeira.com>
> Subject: RE: [postgis-users] what is the units of distance parameter
> in the buffer function
> To: "'PostGIS Users Discussion'"
> <postgis-users at postgis.refractions.net>
> Message-ID: <000901c71635$18083fa0$4818bee0$@com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Kumar,
>
>
>
> If your geom is lat/lon 1=1 degree
>
> As to the 3rd argument it�s a mystery to me too�
>
> >From the manual:
>
> The optional third parameter sets the number
>
> of segment used to approximate a quarter circle (defaults
>
> to 8).
>
>
>
> What�s this good for?!
>
>
>
> Pedro.
>
>
>
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Sandeep
> Kumar Jakkaraju
> Sent: s�bado, 2 de Dezembro de 2006 16:38
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] what is the units of distance parameter in the
> buffer function
>
>
>
>
> what is the units of distance parameter in the buffer function ...
>
> buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0
> 79.0)'),1);
>
> if my geom is in lat/lon ..... how much will be 1 !!
>
> can some one throw more light on the 3 rd optional parameter !!! the
> manual
> is not clear !!
>
> --
> Sandeep Kumar Jakkaraju
> WeBlog:
> http://jakkarajus.blogspot.com <http://jakkarajus.blogspot.com>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/c5e69011/attachment-0001.html
>
> ------------------------------
>
> Message: 11
> Date: Sat, 2 Dec 2006 10:27:20 -0700
> From: "Bruce Rindahl" <rindahl at lrcwe.com>
> Subject: RE: [postgis-users] what is the units of distance parameter
> inthe buffer function
> To: "'PostGIS Users Discussion'"
> <postgis-users at postgis.refractions.net>
> Message-ID: <000c01c71637$1f350810$6501a8c0 at Bruce>
> Content-Type: text/plain; charset="iso-8859-1"
>
> The third parameter defines how close to a circle the buffer will
> be. There
> is no �circle� in PostGIS (or most GIS software) � it is approximated by a
> series of lines. The default value of 8 means a circle will be
> approximated
> by 32 line segments. If you specified this as 1 you would get 4 points or
> a
> square. If the buffer value is very large you might need to increase the
> value to more than 8.
>
> Bruce
>
>
>
> _____
>
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Pedro
> Doria Meunier
> Sent: Saturday, December 02, 2006 10:13 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] what is the units of distance parameter inthe
> buffer function
>
>
>
> Kumar,
>
>
>
> If your geom is lat/lon 1=1 degree
>
> As to the 3rd argument it�s a mystery to me too�
>
> >From the manual:
>
> The optional third parameter sets the number
>
> of segment used to approximate a quarter circle (defaults
>
> to 8).
>
>
>
> What�s this good for?!
>
>
>
> Pedro.
>
>
>
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Sandeep
> Kumar Jakkaraju
> Sent: s�bado, 2 de Dezembro de 2006 16:38
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] what is the units of distance parameter in the
> buffer function
>
>
>
>
> what is the units of distance parameter in the buffer function ...
>
> buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0
> 79.0)'),1);
>
> if my geom is in lat/lon ..... how much will be 1 !!
>
> can some one throw more light on the 3 rd optional parameter !!! the
> manual
> is not clear !!
>
> --
> Sandeep Kumar Jakkaraju
> WeBlog:
> http://jakkarajus.blogspot.com <http://jakkarajus.blogspot.com>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/c8299ee2/attachment-0001.html
>
> ------------------------------
>
> Message: 12
> Date: Sat, 2 Dec 2006 10:27:22 -0700
> From: Bill Thoen <bthoen at gisnet.com>
> Subject: Re: [postgis-users] what is the units of distance parameter
> in the buffer function
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <20061202172722.GB9268 at www.gisnet.com>
> Content-Type: text/plain; charset=us-ascii
>
> On Sat, Dec 02, 2006 at 05:12:48PM -0000, Pedro Doria Meunier wrote:
> > From the manual:
> >
> > The optional third parameter sets the number
> > of segment used to approximate a quarter circle (defaults
> > to 8).
> >
> > What's this good for?!
>
> I think it's a "smoothness" factor for drawing the corners of a buffer,
> i.e. if you use 1 and create a buffer around a point, it's a diamond
> shape.
> If you use 2, it's an octagon. But I'm just guessing...
>
>
> ------------------------------
>
> Message: 13
> Date: Sat, 2 Dec 2006 22:57:32 +0530
> From: "Sandeep Kumar Jakkaraju" <sandeepkumar.jakkaraju at gmail.com>
> Subject: [postgis-users] Nearest Neighbour queries in Postgis
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <c653c98f0612020927n618b7fc3g147eecaef929008b at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Are there any functions for Nearest Neighbour queries in Postgis ???
>
> like the near command of ARCINFO !!
>
> Thanks
>
> --
> Sandeep Kumar Jakkaraju
> WeBlog: http://jakkarajus.blogspot.com
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/f520119e/attachment-0001.html
>
> ------------------------------
>
> Message: 14
> Date: Sat, 2 Dec 2006 10:09:10 -0800
> From: Dylan Beaudette <dylan.beaudette at gmail.com>
> Subject: Re: [postgis-users] Nearest Neighbour queries in Postgis
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <200612021009.10306.dylan.beaudette at gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Saturday 02 December 2006 09:27, Sandeep Kumar Jakkaraju wrote:
> > Are there any functions for Nearest Neighbour queries in Postgis ???
> >
> > like the near command of ARCINFO !!
> >
> > Thanks
>
> how about a self join + distance() + order by distance_to_feature + limit
> 1 ?
>
> cheers,
> --
> Dylan Beaudette
> Soils and Biogeochemistry Graduate Group
> University of California at Davis
> 530.754.7341
>
>
> ------------------------------
>
> Message: 15
> Date: Sat, 2 Dec 2006 10:38:00 -0700
> From: Michael Fuhr <mike at fuhr.org>
> Subject: Re: [postgis-users] what is the units of distance parameter
> in the buffer function
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <20061202173800.GA63467 at winnie.fuhr.org>
> Content-Type: text/plain; charset=us-ascii
>
> On Sat, Dec 02, 2006 at 10:08:02PM +0530, Sandeep Kumar Jakkaraju wrote:
> > what is the units of distance parameter in the buffer function ...
> >
> > buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0
> 79.0
> > )'),1);
> >
> > if my geom is in lat/lon ..... how much will be 1 !!
>
> The distance is in the same units as the geometry; for lat/lon
> that's degrees. A distance of 1 will therefore create a buffer
> of 1 degree around the point.
>
> Note that geometries are (X Y), which is (longitude latitude). The
> above geometry is 79N 28E, which is in the Svalbard Archipelago in
> the Arctic Ocean. If you meant 28N 79E in northern India then use
> POINT(79.0 28.0).
>
> > can some one throw more light on the 3 rd optional parameter !!! the
> manual
> > is not clear !!
>
> "The optional third parameter sets the number of segment used to
> approximate a quarter circle (defaults to 8)."
>
> For a point Buffer() returns a polygon that approximates a circle.
> By default Buffer() uses 8 segments per quarter circle, so the
> "circle" is really a 32-sided polygon. You can increase the number
> of segments to create a polygon that's closer to being a circle.
>
> --
> Michael Fuhr
>
>
> ------------------------------
>
> Message: 16
> Date: Sat, 2 Dec 2006 17:42:14 -0000
> From: "Pedro Doria Meunier" <pdoria at netmadeira.com>
> Subject: RE: [postgis-users] what is the units of distance parameter
> inthe buffer function
> To: <rindahl at lrcwe.com>, "'PostGIS Users Discussion'"
> <postgis-users at postgis.refractions.net>
> Message-ID: <002001c71639$345ee650$9d1cb2f0$@com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Thank you Bruce!
>
> Really helpful!
>
>
>
> Regards,
>
> Pedro.
>
>
>
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Bruce
> Rindahl
> Sent: s�bado, 2 de Dezembro de 2006 17:27
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] what is the units of distance parameter inthe
> buffer function
>
>
>
> The third parameter defines how close to a circle the buffer will
> be. There
> is no �circle� in PostGIS (or most GIS software) � it is approximated by a
> series of lines. The default value of 8 means a circle will be
> approximated
> by 32 line segments. If you specified this as 1 you would get 4 points or
> a
> square. If the buffer value is very large you might need to increase the
> value to more than 8.
>
> Bruce
>
>
>
> _____
>
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Pedro
> Doria Meunier
> Sent: Saturday, December 02, 2006 10:13 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] what is the units of distance parameter inthe
> buffer function
>
>
>
> Kumar,
>
>
>
> If your geom is lat/lon 1=1 degree
>
> As to the 3rd argument it�s a mystery to me too�
>
> >From the manual:
>
> The optional third parameter sets the number
>
> of segment used to approximate a quarter circle (defaults
>
> to 8).
>
>
>
> What�s this good for?!
>
>
>
> Pedro.
>
>
>
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Sandeep
> Kumar Jakkaraju
> Sent: s�bado, 2 de Dezembro de 2006 16:38
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] what is the units of distance parameter in the
> buffer function
>
>
>
>
> what is the units of distance parameter in the buffer function ...
>
> buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0
> 79.0)'),1);
>
> if my geom is in lat/lon ..... how much will be 1 !!
>
> can some one throw more light on the 3 rd optional parameter !!! the
> manual
> is not clear !!
>
> --
> Sandeep Kumar Jakkaraju
> WeBlog:
> http://jakkarajus.blogspot.com <http://jakkarajus.blogspot.com>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/75c0529d/attachment-0001.html
>
> ------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> End of postgis-users Digest, Vol 50, Issue 2
> ********************************************
>
--
Regards,
Mark Thomas
spatialguru.net at gmail.com
205.529.9013
"Commit to the Lord whatever you do,
and your plans will succeed." - Proverbs 16:3
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061202/9b77e54a/attachment.html>
More information about the postgis-users
mailing list