here's code i use to find nearest neighbor for reverse geocoding with TeleAtlas data.<br><br>pt := GeomFromEWKT('SRID=4326;POINT(' || $2 || ' ' || $1 || ')');<br>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
<br> 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);<br><br>of course $2 is longitude, $1 is latitude, pt is geometry and rec is record.
<br><br><div><span class="gmail_quote">On 12/2/06, <b class="gmail_sendername"><a href="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net</a></b> <<a href="mailto:postgis-users-request@postgis.refractions.net">
postgis-users-request@postgis.refractions.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Send postgis-users mailing list submissions to
<br> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>or, via email, send a message with subject or body 'help' to<br> <a href="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net
</a><br><br>You can reach the person managing the list at<br> <a href="mailto:postgis-users-owner@postgis.refractions.net">postgis-users-owner@postgis.refractions.net</a><br><br>When replying, please edit your Subject line so it is more specific
<br>than "Re: Contents of postgis-users digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Postgis Java Geometry classes/Hibernate, borken<br> query[Solution] (Dave Potts)<br> 2. Re: RE: RE: zigGIS Usage Experiences (Paolo Corti)
<br> 3. Re: RE: RE: zigGIS Usage Experiences (Abe Gillespie)<br> 4. Re: RE: RE: zigGIS Usage Experiences (Paolo Corti)<br> 5. RE: RE: RE: zigGIS Usage Experiences (Bruce Rindahl)<br> 6. RE: RE: RE: zigGIS Usage Experiences (
<a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a>)<br> 7. RE: RE: RE: zigGIS Usage Experiences (<a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a>)<br> 8. Re: RE: RE: zigGIS Usage Experiences (Abe Gillespie)
<br> 9. what is the units of distance parameter in the buffer<br> function (Sandeep Kumar Jakkaraju)<br> 10. RE: what is the units of distance parameter in the buffer<br> function (Pedro Doria Meunier)
<br> 11. RE: what is the units of distance parameter inthe buffer<br> function (Bruce Rindahl)<br> 12. Re: what is the units of distance parameter in the buffer<br> function (Bill Thoen)<br> 13. Nearest Neighbour queries in Postgis (Sandeep Kumar Jakkaraju)
<br> 14. Re: Nearest Neighbour queries in Postgis (Dylan Beaudette)<br> 15. Re: what is the units of distance parameter in the buffer<br> function (Michael Fuhr)<br> 16. RE: what is the units of distance parameter inthe buffer
<br> function (Pedro Doria Meunier)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Fri, 01 Dec 2006 20:06:13 +0000<br>From: Dave Potts <<a href="mailto:dave.potts@pinan.co.uk">
dave.potts@pinan.co.uk</a>><br>Subject: Re: [postgis-users] Postgis Java Geometry classes/Hibernate,<br> borken query[Solution]<br>To: PostGIS Users Discussion <<a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a>><br>Message-ID: <<a href="mailto:45708B35.10403@pinan.co.uk">45708B35.10403@pinan.co.uk</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Dave Potts wrote:
<br>> Hi Folks<br>><br>> I am using hibernate to query a postgis database.<br>><br>> The majority of my distance queries work as expected, one does not!<br>> For one distance setting I get loads of answers, for a greater
<br>> distance, I get none, when I would expect to get at least the first set.<br>><br>> So I suspect that either Hibernate or Postgis are having problems.<br>><br>> I can type the query in by hand and it works as expected , so I don't
<br>> suspect the database or postgis interface to the database.<br>><br>> Is there any debug code in postgres/postgi/Hibernate that will actual<br>> allow me work out what data is being sent from postgres to hibernate,
<br>> what hibernate is caching and what its forwarding to the end user.<br>><br>> regards David<br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>I found the problem, my hibernate query said something like
<br><br>blah blah blah manor.geometry is not null and distance(manor.geometry,<br>srcCastle.geometry) < :distance<br><br>I was setting the value of distance by saying<br><br>query.setString("distance","3000");
<br><br>Distance is a numerical construct<br><br>as soon as I said<br>query.setInteger("distance",3000);<br><br>It now works as expected !<br>Its at times like this, I remeber Pascal and its very rigid views about
<br>argument types.<br><br>It has taken some 7 hours to find this problem.<br><br>David.<br><br><br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: dave.potts.vcf<br>Type: text/x-vcard
<br>Size: 85 bytes<br>Desc: not available<br>Url : <a href="http://lists.refractions.net/pipermail/postgis-users/attachments/20061201/300bf9df/dave.potts-0001.vcf">http://lists.refractions.net/pipermail/postgis-users/attachments/20061201/300bf9df/dave.potts-0001.vcf
</a><br><br>------------------------------<br><br>Message: 2<br>Date: Fri, 1 Dec 2006 12:15:34 -0800 (PST)<br>From: Paolo Corti <<a href="mailto:pcorti@gmail.com">pcorti@gmail.com</a>><br>Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences
<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Message-ID: <<a href="mailto:7645455.post@talk.nabble.com">7645455.post@talk.nabble.com</a>><br>Content-Type: text/plain; charset=us-ascii
<br><br><br>Hi Abe<br>I will do it, should I continue in the webspace from where I downloaded?<br>Let me know!<br><br>My plans are:<br>1) Some code refactoring<br>2) correct bugs about rendering<br>3) try to solve the edit problem (maybe I can have a direct contact with
<br>Esri, some years ago I was working for Esri Italy) in the clean way, this<br>meaning without doing anything like in the PgArc fashion with a proxy<br>shapefile but just solving the ArcGis desktop complain that editor is not
<br>allowed (this issue you were also asking at the support esri website:<br><a href="http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977">http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977
</a>)<br>4) if I can't solve the edit issue in a clean way go with the PgArc fashion<br>for editing<br>5) implementing ZigGis to work also with MySql and maybe with SQL Server<br>spatial<br><br>Let me know if I should open a web space at SourceForge or should I continue
<br>to use the web space you were using<br><br>If someone, like Joshua, is willing to help me is very welcome<br><br>best regards<br><br>Paolo Corti<br>GIS Developer<br><a href="http://www.paolocorti.net">http://www.paolocorti.net
</a><br><br><br><br><br>Abe Gillespie wrote:<br>><br>> What I would love to see is someone officially take over the project.<br>> Even if they're not contributing code ... at least managing the<br>> project. I feel like people are finally seeing some good in the code
<br>> and perhaps we can get enough momentum going where this thing finally<br>> moves forward.<br>><br>> Anyone?<br>><br>> -Abe<br>><br>> On 12/1/06, Bruce Rindahl <<a href="mailto:rindahl@lrcwe.com">
rindahl@lrcwe.com</a>> wrote:<br>>> Is there any way this version could be posted somewhere? I would also<br>>> love<br>>> to try it. I do not have access to Visual Studio.<br>>> Thanks<br>>> Bruce Rindahl
<br>>><br>>> -----Original Message-----<br>>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Paolo<br>>> Corti<br>>> Sent: Friday, December 01, 2006 12:04 PM<br>>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>> Subject: [postgis-users] RE: RE: zigGIS Usage Experiences<br>>><br>>><br>>> Thank you Joshua<br>>> now it is working!<br>>><br>>> with some quick debug i discovered it was a stupid problem with my
<br>>> international settings.<br>>><br>>> The funny thing is that now with correcting the regional settings it<br>>> works<br>>> also the previous version i had (the public 8.3 based version - that I
<br>>> modified to work with 9.0 and from which I removed the circular<br>>> reference problem). In this previous version you DON'T NEED to create<br>>> the view, so that problem It was already solved but came back in the
<br>>> version Abe emailed you...<br>>><br>>> So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005<br>>> Solution<br>>> of ZigGis, without need creating the view as you suggested.
<br>>><br>>> I am amazed from the speed of ZigGis with reading data (i wouldn't have<br>>> thought is so fast, after all we are not reading an ArcGis native<br>>> geometry),<br>>> but I see there are still many things to do (before implementing
<br>>> editing):<br>>> for example rendering with symbology is not working, the geometry column<br>>> seems to have a problem (is undefined),<br>>> ....<br>>><br>>> Who knows why it is not possible editing data, this would be a super tip
<br>>> to<br>>> get to know what can be, AFAIK Abe was trying to discover that for more<br>>> than<br>>> one month! I am sure if someone from the Esri Geodatabase team could give<br>>> us<br>
>> a little help about this they could give us the right direction for<br>>> letting<br>>> the layer to be edited. I don't think there is a block, we probably need<br>>> to<br>>> implement in the right way the right interface...
<br>>><br>>> in any case thank you for helping me<br>>><br>>> Best regards<br>>> Paolo<br>>><br>>> Paolo Corti wrote:<br>>> ><br>>> > Hi Joshua,<br>>> >
<br>>> > thank you for emailing me the latest Abe's version.<br>>> > What I had it was this: <a href="http://gforge2.uwc.ac.za/projects/ziggis">http://gforge2.uwc.ac.za/projects/ziggis</a><br>>> > and it was for
8.3, with a circular reference problem.<br>>> > If i knew that there was what you sended me I would have saved 1 day<br>>> time<br>>> > it took me to get what I had compiled with AO 9.0.<br>>> > In any case I compiled the project you emailed me with Visual Studio
<br>>> 2005<br>>> > (.net 2.0) and ArcObjects 9.0 .net assemblies.<br>>> > It compiles fine, but when I add a layer:<br>>> > 1) if I just add a working PostGis layer it gives error<br>>> > 2) if I add a view (like you suggested) to the Working PostGis layer,
<br>>> it<br>>> > seems working, the layer is added at the TOC, but nothing is drawn. If<br>>> I<br>>> > open the attribute table it shows me all the record, but the geometry<br>>> > field is empty.
<br>>> ><br>>> > any idea?<br>>> > thanks in advance<br>>> ><br>>> > Paolo<br>>> ><br>>> > in fact what I had it was downloaded from SourceForge and it was still
<br>>> ><br>>> > joshua.uyehara wrote:<br>>> >><br>>> >> Hey Paolo,<br>>> >><br>>> >> I'm using ArcGIS Desktop 9.1. As Abe mentioned, however, I'm also<br>
>> using<br>>> >> a later snapshot of ZigGIS.<br>>> >><br>>> >> I had also gone and updated the publicly available ZigGIS to the 9.0<br>>> >> ArcObjects model before receiving the latest version of ZigGIS from
<br>>> Abe,<br>>> >> but I never tested that version with the workaround that I outlined.<br>>> >><br>>> >> I'll email you a copy of the latest snapshot from Abe so that you can<br>
>> >> see if you have any better luck with it.<br>>> >><br>>> >> Joshua Uyehara<br>>> >> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>> >>
<br>>> >> -----Original Message-----<br>>> >> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>> >> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>> >> Paolo Corti<br>>> >> Sent: Wednesday, November 29, 2006 7:21 AM<br>>> >> To: <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>> >> Subject: [postgis-users] RE: zigGIS Usage Experiences<br>>> >><br>>> >><br>>> >> Hello Joshua<br>>> >> I tried what you suggested (I also added the GID field in the view, it
<br>>> >> caused an error).<br>>> >> But ZigGis goes in error when is adding layer, specifically at this<br>>> line<br>>> >> of<br>>> >> code:<br>>> >><br>
>> >> doc.AddLayer(layer);<br>>> >><br>>> >> the error i get is AccessViolationExpection<br>>> >><br>>> >> did you also try using ZigGis with ArcMap 9.0 ?<br>>> >>
<br>>> >> in any case thank you for helping me, i will investigate more deeply<br>>> and<br>>> >> if i get into some resolution I will drop a note here<br>>> >><br>>> >> best regards
<br>>> >> Paolo<br>>> >><br>>> >><br>>> >> joshua.uyehara wrote:<br>>> >>><br>>> >>> Hey Paolo,<br>>> >>><br>>> >>> Abe isn't working on it anymore, but I have been occasionally
<br>>> plugging<br>>> >><br>>> >>> away at it myself. The problem with adding the layer in ArcMap is<br>>> due<br>>> >><br>>> >>> to a minor bug.<br>>> >>>
<br>>> >>> ZigGIS pulls the geometry column data from PostGIS in its native<br>>> >>> binary format and passes it to ArcMap. Unfortunately, PostGIS'<br>>> >>> internal binary format is not identical to the expected wkb format,
<br>>> so<br>>> >><br>>> >>> ArcMap silently ignores it and basically treats the table as a<br>>> >>> feature-less object class.<br>>> >>><br>>> >>> One quick workaround is to create a view of the table that converts
<br>>> >>> the geometry column with asbinary(), and then manually add the<br>>> >>> necessary entry to the geometry_columns table.<br>>> >>><br>>> >>> E.g.,<br>>> >>>
<br>>> >>> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as<br>>> >>> geom_column, column2, column3, FROM geom_table; INSERT INTO<br>>> >>> geometry_columns (f_table_schema, f_table_name, f_geometry_column,
<br>>> >>> coord_dimension, srid, type) VALUES<br>>> >>> ('public', 'geom_table_view', 'geom_column', 2, -1,<br>>> >> 'MULTIPOLYGON');<br>>> >>><br>>> >>> Change schema, table, column names, srid, etc. to match your table,
<br>>> >>> then specify the view as the table to be opened with ZigGIS. It's an<br>>> >>> ugly kludge, but I haven't had the time to fix the problem in ZigGIS<br>>> >>> itself yet.
<br>>> >>><br>>> >>> Many of the feature class functionality hasn't been implemented yet,<br>>> >>> so you can't do much besides display the features. I'm planning to<br>>> >>> add features to ZigGIS as I need them for work, but I can't give you
<br>>> >>> any timelines on it, as I'm swamped with other stuff at the moment.<br>>> >>><br>>> >>> Hope that helped,<br>>> >>> Joshua Uyehara<br>>> >>>
<a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>> >>><br>>> >>> -----Original Message-----<br>>> >>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>>> >>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>> >>> Paolo Corti
<br>>> >>> Sent: Monday, November 27, 2006 6:46 AM<br>>> >>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> >>> Subject: Re: [postgis-users] zigGIS Usage Experiences
<br>>> >>><br>>> >>><br>>> >>> Hello Abe<br>>> >>><br>>> >>> you made a great job with your ZigGis! The ArcObjects code is<br>>> amazing!<br>
>> >>><br>>> >>> maybe you can give me a help<br>>> >>> I compiled your code for using it with ArcGis 9 (i made some little<br>>> >>> modifications at the code to get this) and .NET
2.0 It compiled fine,<br>>> >>> but when I start ArcMap and I add a PostGIS layer, it adds the layer<br>>> >>> on the TOC but nothing is showed/drawed on the map.<br>>> >>> Looks like geometries are not read from the shape column.
<br>>> >>> I am wondering if you are still on this project, and maybe you could<br>>> >>> give me some help, or if I am on my own and must deeply<br>>> >>> investigate/debug myself the code in order to find what is not going
<br>>> >>> properly<br>>> >>><br>>> >>> best regards<br>>> >>> Paolo Corti<br>>> >>> GIS Developer<br>>> >>> <a href="http://www.paolocorti.net">
http://www.paolocorti.net</a><br>>> >>><br>>> >>><br>>> >>> Abe Gillespie wrote:<br>>> >>>><br>>> >>>> Sorry for the cross post, but the zigGIS list only has 9 subscribers
<br>>> >>>> with a ton more downloads than that.<br>>> >>>><br>>> >>>> I'm curious about any experiences people are having using or even<br>>> >>>> *trying* to use zigGIS. Is it working? Anyone need any help? Any
<br>>> >>>> constructive criticism? ... I haven't heard a peep yet.<br>>> >>>><br>>> >>>> Thanks.<br>>> >>>> -Abe<br>>> >>>> _______________________________________________
<br>>> >>>> postgis-users mailing list<br>>> >>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> >>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>> >>>><br>>> >>>><br>>> >>><br>>> >>> --<br>>> >>> View this message in context:
<br>>> >>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276</a><br>>> >>> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>> >>><br>>> >>> _______________________________________________<br>>> >>> postgis-users mailing list<br>>> >>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>> >>> _______________________________________________
<br>>> >>> postgis-users mailing list<br>>> >>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>> >>><br>>> >>><br>>> >><br>>> >> --<br>>> >> View this message in context:<br>>> >>
<a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908</a><br>>> >> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>> >><br>>> >> _______________________________________________<br>>> >> postgis-users mailing list<br>>> >> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>> >> _______________________________________________
<br>>> >> postgis-users mailing list<br>>> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>> >><br>>> >><br>>> ><br>>> ><br>>><br>>> --<br>>> View this message in context:<br>>>
<a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254</a><br>>> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">
Nabble.com</a>.<br>>><br>>> _______________________________________________<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>><br>>><br>>><br>>> _______________________________________________
<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br><br>--<br>View this message in context:
<a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645455">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645455</a><br>Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">
Nabble.com</a>.<br><br><br><br>------------------------------<br><br>Message: 3<br>Date: Fri, 1 Dec 2006 15:18:15 -0500<br>From: "Abe Gillespie" <<a href="mailto:abe.gillespie@gmail.com">abe.gillespie@gmail.com
</a>><br>Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences<br>To: "PostGIS Users Discussion" <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>>
<br>Message-ID:<br> <<a href="mailto:a6d397e30612011218j5088643hfb94ed9a1aff9b0a@mail.gmail.com">a6d397e30612011218j5088643hfb94ed9a1aff9b0a@mail.gmail.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
<br><br>Very good! I will get with you offline over the weekend and we can<br>set things up.<br><br>-Abe<br><br>On 12/1/06, Paolo Corti <<a href="mailto:pcorti@gmail.com">pcorti@gmail.com</a>> wrote:<br>><br>> Hi Abe
<br>> I will do it, should I continue in the webspace from where I downloaded?<br>> Let me know!<br>><br>> My plans are:<br>> 1) Some code refactoring<br>> 2) correct bugs about rendering<br>> 3) try to solve the edit problem (maybe I can have a direct contact with
<br>> Esri, some years ago I was working for Esri Italy) in the clean way, this<br>> meaning without doing anything like in the PgArc fashion with a proxy<br>> shapefile but just solving the ArcGis desktop complain that editor is not
<br>> allowed (this issue you were also asking at the support esri website:<br>> <a href="http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977">http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977
</a>)<br>> 4) if I can't solve the edit issue in a clean way go with the PgArc fashion<br>> for editing<br>> 5) implementing ZigGis to work also with MySql and maybe with SQL Server<br>> spatial<br>><br>> Let me know if I should open a web space at SourceForge or should I continue
<br>> to use the web space you were using<br>><br>> If someone, like Joshua, is willing to help me is very welcome<br>><br>> best regards<br>><br>> Paolo Corti<br>> GIS Developer<br>> <a href="http://www.paolocorti.net">
http://www.paolocorti.net</a><br>><br>><br>><br>><br>> Abe Gillespie wrote:<br>> ><br>> > What I would love to see is someone officially take over the project.<br>> > Even if they're not contributing code ... at least managing the
<br>> > project. I feel like people are finally seeing some good in the code<br>> > and perhaps we can get enough momentum going where this thing finally<br>> > moves forward.<br>> ><br>> > Anyone?
<br>> ><br>> > -Abe<br>> ><br>> > On 12/1/06, Bruce Rindahl <<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>> wrote:<br>> >> Is there any way this version could be posted somewhere? I would also
<br>> >> love<br>> >> to try it. I do not have access to Visual Studio.<br>> >> Thanks<br>> >> Bruce Rindahl<br>> >><br>> >> -----Original Message-----<br>> >> From:
<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>> >> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a>] On Behalf Of Paolo<br>> >> Corti<br>> >> Sent: Friday, December 01, 2006 12:04 PM<br>> >> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>> >> Subject: [postgis-users] RE: RE: zigGIS Usage Experiences<br>> >><br>> >><br>> >> Thank you Joshua<br>> >> now it is working!<br>> >><br>> >> with some quick debug i discovered it was a stupid problem with my
<br>> >> international settings.<br>> >><br>> >> The funny thing is that now with correcting the regional settings it<br>> >> works<br>> >> also the previous version i had (the public
8.3 based version - that I<br>> >> modified to work with 9.0 and from which I removed the circular<br>> >> reference problem). In this previous version you DON'T NEED to create<br>> >> the view, so that problem It was already solved but came back in the
<br>> >> version Abe emailed you...<br>> >><br>> >> So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005<br>> >> Solution<br>> >> of ZigGis, without need creating the view as you suggested.
<br>> >><br>> >> I am amazed from the speed of ZigGis with reading data (i wouldn't have<br>> >> thought is so fast, after all we are not reading an ArcGis native<br>> >> geometry),<br>
> >> but I see there are still many things to do (before implementing<br>> >> editing):<br>> >> for example rendering with symbology is not working, the geometry column<br>> >> seems to have a problem (is undefined),
<br>> >> ....<br>> >><br>> >> Who knows why it is not possible editing data, this would be a super tip<br>> >> to<br>> >> get to know what can be, AFAIK Abe was trying to discover that for more
<br>> >> than<br>> >> one month! I am sure if someone from the Esri Geodatabase team could give<br>> >> us<br>> >> a little help about this they could give us the right direction for<br>
> >> letting<br>> >> the layer to be edited. I don't think there is a block, we probably need<br>> >> to<br>> >> implement in the right way the right interface...<br>> >><br>> >> in any case thank you for helping me
<br>> >><br>> >> Best regards<br>> >> Paolo<br>> >><br>> >> Paolo Corti wrote:<br>> >> ><br>> >> > Hi Joshua,<br>> >> ><br>> >> > thank you for emailing me the latest Abe's version.
<br>> >> > What I had it was this: <a href="http://gforge2.uwc.ac.za/projects/ziggis">http://gforge2.uwc.ac.za/projects/ziggis</a><br>> >> > and it was for 8.3, with a circular reference problem.<br>
> >> > If i knew that there was what you sended me I would have saved 1 day<br>> >> time<br>> >> > it took me to get what I had compiled with AO 9.0.<br>> >> > In any case I compiled the project you emailed me with Visual Studio
<br>> >> 2005<br>> >> > (.net 2.0) and ArcObjects 9.0 .net assemblies.<br>> >> > It compiles fine, but when I add a layer:<br>> >> > 1) if I just add a working PostGis layer it gives error
<br>> >> > 2) if I add a view (like you suggested) to the Working PostGis layer,<br>> >> it<br>> >> > seems working, the layer is added at the TOC, but nothing is drawn. If<br>> >> I
<br>> >> > open the attribute table it shows me all the record, but the geometry<br>> >> > field is empty.<br>> >> ><br>> >> > any idea?<br>> >> > thanks in advance
<br>> >> ><br>> >> > Paolo<br>> >> ><br>> >> > in fact what I had it was downloaded from SourceForge and it was still<br>> >> ><br>> >> > joshua.uyehara
wrote:<br>> >> >><br>> >> >> Hey Paolo,<br>> >> >><br>> >> >> I'm using ArcGIS Desktop 9.1. As Abe mentioned, however, I'm also<br>> >> using<br>> >> >> a later snapshot of ZigGIS.
<br>> >> >><br>> >> >> I had also gone and updated the publicly available ZigGIS to the 9.0<br>> >> >> ArcObjects model before receiving the latest version of ZigGIS from<br>> >> Abe,
<br>> >> >> but I never tested that version with the workaround that I outlined.<br>> >> >><br>> >> >> I'll email you a copy of the latest snapshot from Abe so that you can<br>
> >> >> see if you have any better luck with it.<br>> >> >><br>> >> >> Joshua Uyehara<br>> >> >> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com
</a><br>> >> >><br>> >> >> -----Original Message-----<br>> >> >> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a><br>> >> >> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>> >> >> Paolo Corti<br>> >> >> Sent: Wednesday, November 29, 2006 7:21 AM
<br>> >> >> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >> >> Subject: [postgis-users] RE: zigGIS Usage Experiences<br>> >> >>
<br>> >> >><br>> >> >> Hello Joshua<br>> >> >> I tried what you suggested (I also added the GID field in the view, it<br>> >> >> caused an error).<br>> >> >> But ZigGis goes in error when is adding layer, specifically at this
<br>> >> line<br>> >> >> of<br>> >> >> code:<br>> >> >><br>> >> >> doc.AddLayer(layer);<br>> >> >><br>> >> >> the error i get is AccessViolationExpection
<br>> >> >><br>> >> >> did you also try using ZigGis with ArcMap 9.0 ?<br>> >> >><br>> >> >> in any case thank you for helping me, i will investigate more deeply
<br>> >> and<br>> >> >> if i get into some resolution I will drop a note here<br>> >> >><br>> >> >> best regards<br>> >> >> Paolo<br>> >> >>
<br>> >> >><br>> >> >> joshua.uyehara wrote:<br>> >> >>><br>> >> >>> Hey Paolo,<br>> >> >>><br>> >> >>> Abe isn't working on it anymore, but I have been occasionally
<br>> >> plugging<br>> >> >><br>> >> >>> away at it myself. The problem with adding the layer in ArcMap is<br>> >> due<br>> >> >><br>> >> >>> to a minor bug.
<br>> >> >>><br>> >> >>> ZigGIS pulls the geometry column data from PostGIS in its native<br>> >> >>> binary format and passes it to ArcMap. Unfortunately, PostGIS'<br>
> >> >>> internal binary format is not identical to the expected wkb format,<br>> >> so<br>> >> >><br>> >> >>> ArcMap silently ignores it and basically treats the table as a
<br>> >> >>> feature-less object class.<br>> >> >>><br>> >> >>> One quick workaround is to create a view of the table that converts<br>> >> >>> the geometry column with asbinary(), and then manually add the
<br>> >> >>> necessary entry to the geometry_columns table.<br>> >> >>><br>> >> >>> E.g.,<br>> >> >>><br>> >> >>> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as
<br>> >> >>> geom_column, column2, column3, FROM geom_table; INSERT INTO<br>> >> >>> geometry_columns (f_table_schema, f_table_name, f_geometry_column,<br>> >> >>> coord_dimension, srid, type) VALUES
<br>> >> >>> ('public', 'geom_table_view', 'geom_column', 2, -1,<br>> >> >> 'MULTIPOLYGON');<br>> >> >>><br>> >> >>> Change schema, table, column names, srid, etc. to match your table,
<br>> >> >>> then specify the view as the table to be opened with ZigGIS. It's an<br>> >> >>> ugly kludge, but I haven't had the time to fix the problem in ZigGIS<br>> >> >>> itself yet.
<br>> >> >>><br>> >> >>> Many of the feature class functionality hasn't been implemented yet,<br>> >> >>> so you can't do much besides display the features. I'm planning to
<br>> >> >>> add features to ZigGIS as I need them for work, but I can't give you<br>> >> >>> any timelines on it, as I'm swamped with other stuff at the moment.<br>> >> >>>
<br>> >> >>> Hope that helped,<br>> >> >>> Joshua Uyehara<br>> >> >>> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>> >> >>>
<br>> >> >>> -----Original Message-----<br>> >> >>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>> >> >>> [mailto:
<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>> >> >>> Paolo Corti<br>> >> >>> Sent: Monday, November 27, 2006 6:46 AM
<br>> >> >>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >> >>> Subject: Re: [postgis-users] zigGIS Usage Experiences<br>> >> >>>
<br>> >> >>><br>> >> >>> Hello Abe<br>> >> >>><br>> >> >>> you made a great job with your ZigGis! The ArcObjects code is<br>> >> amazing!<br>
> >> >>><br>> >> >>> maybe you can give me a help<br>> >> >>> I compiled your code for using it with ArcGis 9 (i made some little<br>> >> >>> modifications at the code to get this) and .NET
2.0 It compiled fine,<br>> >> >>> but when I start ArcMap and I add a PostGIS layer, it adds the layer<br>> >> >>> on the TOC but nothing is showed/drawed on the map.<br>> >> >>> Looks like geometries are not read from the shape column.
<br>> >> >>> I am wondering if you are still on this project, and maybe you could<br>> >> >>> give me some help, or if I am on my own and must deeply<br>> >> >>> investigate/debug myself the code in order to find what is not going
<br>> >> >>> properly<br>> >> >>><br>> >> >>> best regards<br>> >> >>> Paolo Corti<br>> >> >>> GIS Developer<br>> >> >>>
<a href="http://www.paolocorti.net">http://www.paolocorti.net</a><br>> >> >>><br>> >> >>><br>> >> >>> Abe Gillespie wrote:<br>> >> >>>><br>> >> >>>> Sorry for the cross post, but the zigGIS list only has 9 subscribers
<br>> >> >>>> with a ton more downloads than that.<br>> >> >>>><br>> >> >>>> I'm curious about any experiences people are having using or even<br>> >> >>>> *trying* to use zigGIS. Is it working? Anyone need any help? Any
<br>> >> >>>> constructive criticism? ... I haven't heard a peep yet.<br>> >> >>>><br>> >> >>>> Thanks.<br>> >> >>>> -Abe<br>> >> >>>> _______________________________________________
<br>> >> >>>> postgis-users mailing list<br>> >> >>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >> >>>>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >> >>>><br>> >> >>>><br>> >> >>>
<br>> >> >>> --<br>> >> >>> View this message in context:<br>> >> >>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276
</a><br>> >> >>> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>> >> >>><br>> >> >>> _______________________________________________
<br>> >> >>> postgis-users mailing list<br>> >> >>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >> >>> _______________________________________________<br>> >> >>> postgis-users mailing list<br>> >> >>>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br>> >> >>><br>> >> >>><br>> >> >><br>> >> >> --<br>> >> >> View this message in context:<br>> >> >> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908</a><br>> >> >> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>> >> >>
<br>> >> >> _______________________________________________<br>> >> >> postgis-users mailing list<br>> >> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>> >> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >> >> _______________________________________________
<br>> >> >> postgis-users mailing list<br>> >> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >> >><br>> >> >><br>> >> ><br>> >> ><br>> >><br>> >> --<br>> >> View this message in context:
<br>> >> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254</a><br>> >> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>> >><br>> >> _______________________________________________<br>> >> postgis-users mailing list<br>> >> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >><br>> >>
<br>> >><br>> >> _______________________________________________<br>> >> postgis-users mailing list<br>> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >><br>> > _______________________________________________
<br>> > postgis-users mailing list<br>> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> > <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> ><br>> ><br>><br>> --<br>> View this message in context: <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645455">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645455</a><br>> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>><br>> _______________________________________________
<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br><br><br>------------------------------<br><br>Message: 4<br>Date: Fri, 1 Dec 2006 12:37:14 -0800 (PST)<br>From: Paolo Corti <<a href="mailto:pcorti@gmail.com">
pcorti@gmail.com</a>><br>Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Message-ID: <<a href="mailto:7645784.post@talk.nabble.com">
7645784.post@talk.nabble.com</a>><br>Content-Type: text/plain; charset=us-ascii<br><br><br>I forgot to say that one of the fist thing I want to do is an installer, so<br>more people can get in touch with ZigGis (I am dead sure many many people
<br>wanted to use it but didn't because they don't know c# and how to make it<br>working).<br>Whit more people installing ZigGis we can even get to know more bugs and fix<br>them (a sort of alfa-beta test)<br><br>Paolo<br>
<br><br>Paolo Corti wrote:<br>><br>> Hi Abe<br>> I will do it, should I continue in the webspace from where I downloaded?<br>> Let me know!<br>><br>> My plans are:<br>> 1) Some code refactoring<br>> 2) correct bugs about rendering
<br>> 3) try to solve the edit problem (maybe I can have a direct contact with<br>> Esri, some years ago I was working for Esri Italy) in the clean way, this<br>> meaning without doing anything like in the PgArc fashion with a proxy
<br>> shapefile but just solving the ArcGis desktop complain that editor is not<br>> allowed (this issue you were also asking at the support esri website:<br>> <a href="http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977">
http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977</a>)<br>> 4) if I can't solve the edit issue in a clean way go with the PgArc<br>> fashion for editing<br>> 5) implementing ZigGis to work also with MySql and maybe with SQL Server
<br>> spatial<br>><br>> Let me know if I should open a web space at SourceForge or should I<br>> continue to use the web space you were using<br>><br>> If someone, like Joshua, is willing to help me is very welcome
<br>><br>> best regards<br>><br>> Paolo Corti<br>> GIS Developer<br>> <a href="http://www.paolocorti.net">http://www.paolocorti.net</a><br>><br>><br>><br>><br>> Abe Gillespie wrote:<br>>>
<br>>> What I would love to see is someone officially take over the project.<br>>> Even if they're not contributing code ... at least managing the<br>>> project. I feel like people are finally seeing some good in the code
<br>>> and perhaps we can get enough momentum going where this thing finally<br>>> moves forward.<br>>><br>>> Anyone?<br>>><br>>> -Abe<br>>><br>>> On 12/1/06, Bruce Rindahl <
<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>> wrote:<br>>>> Is there any way this version could be posted somewhere? I would also<br>>>> love<br>>>> to try it. I do not have access to Visual Studio.
<br>>>> Thanks<br>>>> Bruce Rindahl<br>>>><br>>>> -----Original Message-----<br>>>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a><br>>>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>>> Paolo<br>>>> Corti<br>>>> Sent: Friday, December 01, 2006 12:04 PM
<br>>>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> Subject: [postgis-users] RE: RE: zigGIS Usage Experiences<br>>>><br>>>>
<br>>>> Thank you Joshua<br>>>> now it is working!<br>>>><br>>>> with some quick debug i discovered it was a stupid problem with my<br>>>> international settings.<br>>>>
<br>>>> The funny thing is that now with correcting the regional settings it<br>>>> works<br>>>> also the previous version i had (the public 8.3 based version - that I<br>>>> modified to work with
9.0 and from which I removed the circular<br>>>> reference problem). In this previous version you DON'T NEED to create<br>>>> the view, so that problem It was already solved but came back in the<br>>>> version Abe emailed you...
<br>>>><br>>>> So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005<br>>>> Solution<br>>>> of ZigGis, without need creating the view as you suggested.<br>>>><br>
>>> I am amazed from the speed of ZigGis with reading data (i wouldn't have<br>>>> thought is so fast, after all we are not reading an ArcGis native<br>>>> geometry),<br>>>> but I see there are still many things to do (before implementing
<br>>>> editing):<br>>>> for example rendering with symbology is not working, the geometry column<br>>>> seems to have a problem (is undefined),<br>>>> ....<br>>>><br>>>> Who knows why it is not possible editing data, this would be a super tip
<br>>>> to<br>>>> get to know what can be, AFAIK Abe was trying to discover that for more<br>>>> than<br>>>> one month! I am sure if someone from the Esri Geodatabase team could<br>>>> give us
<br>>>> a little help about this they could give us the right direction for<br>>>> letting<br>>>> the layer to be edited. I don't think there is a block, we probably need<br>>>> to<br>>>> implement in the right way the right interface...
<br>>>><br>>>> in any case thank you for helping me<br>>>><br>>>> Best regards<br>>>> Paolo<br>>>><br>>>> Paolo Corti wrote:<br>>>> ><br>>>> > Hi Joshua,
<br>>>> ><br>>>> > thank you for emailing me the latest Abe's version.<br>>>> > What I had it was this: <a href="http://gforge2.uwc.ac.za/projects/ziggis">http://gforge2.uwc.ac.za/projects/ziggis
</a><br>>>> > and it was for 8.3, with a circular reference problem.<br>>>> > If i knew that there was what you sended me I would have saved 1 day<br>>>> time<br>>>> > it took me to get what I had compiled with AO
9.0.<br>>>> > In any case I compiled the project you emailed me with Visual Studio<br>>>> 2005<br>>>> > (.net 2.0) and ArcObjects 9.0 .net assemblies.<br>>>> > It compiles fine, but when I add a layer:
<br>>>> > 1) if I just add a working PostGis layer it gives error<br>>>> > 2) if I add a view (like you suggested) to the Working PostGis layer,<br>>>> it<br>>>> > seems working, the layer is added at the TOC, but nothing is drawn. If
<br>>>> I<br>>>> > open the attribute table it shows me all the record, but the geometry<br>>>> > field is empty.<br>>>> ><br>>>> > any idea?<br>>>> > thanks in advance
<br>>>> ><br>>>> > Paolo<br>>>> ><br>>>> > in fact what I had it was downloaded from SourceForge and it was still<br>>>> ><br>>>> > joshua.uyehara wrote:
<br>>>> >><br>>>> >> Hey Paolo,<br>>>> >><br>>>> >> I'm using ArcGIS Desktop 9.1. As Abe mentioned, however, I'm also<br>>>> using<br>>>> >> a later snapshot of ZigGIS.
<br>>>> >><br>>>> >> I had also gone and updated the publicly available ZigGIS to the 9.0<br>>>> >> ArcObjects model before receiving the latest version of ZigGIS from<br>>>> Abe,
<br>>>> >> but I never tested that version with the workaround that I outlined.<br>>>> >><br>>>> >> I'll email you a copy of the latest snapshot from Abe so that you can<br>>>> >> see if you have any better luck with it.
<br>>>> >><br>>>> >> Joshua Uyehara<br>>>> >> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>>> >><br>>>> >> -----Original Message-----
<br>>>> >> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>>> >> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>>> >> Paolo Corti<br>>>> >> Sent: Wednesday, November 29, 2006 7:21 AM<br>>>> >> To: <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>>> >> Subject: [postgis-users] RE: zigGIS Usage Experiences<br>>>> >><br>>>> >><br>>>> >> Hello Joshua<br>>>> >> I tried what you suggested (I also added the GID field in the view,
<br>>>> it<br>>>> >> caused an error).<br>>>> >> But ZigGis goes in error when is adding layer, specifically at this<br>>>> line<br>>>> >> of<br>>>> >> code:
<br>>>> >><br>>>> >> doc.AddLayer(layer);<br>>>> >><br>>>> >> the error i get is AccessViolationExpection<br>>>> >><br>>>> >> did you also try using ZigGis with ArcMap
9.0 ?<br>>>> >><br>>>> >> in any case thank you for helping me, i will investigate more deeply<br>>>> and<br>>>> >> if i get into some resolution I will drop a note here
<br>>>> >><br>>>> >> best regards<br>>>> >> Paolo<br>>>> >><br>>>> >><br>>>> >> joshua.uyehara wrote:<br>>>> >>><br>
>>> >>> Hey Paolo,<br>>>> >>><br>>>> >>> Abe isn't working on it anymore, but I have been occasionally<br>>>> plugging<br>>>> >><br>>>> >>> away at it myself. The problem with adding the layer in ArcMap is
<br>>>> due<br>>>> >><br>>>> >>> to a minor bug.<br>>>> >>><br>>>> >>> ZigGIS pulls the geometry column data from PostGIS in its native<br>>>> >>> binary format and passes it to ArcMap. Unfortunately, PostGIS'
<br>>>> >>> internal binary format is not identical to the expected wkb format,<br>>>> so<br>>>> >><br>>>> >>> ArcMap silently ignores it and basically treats the table as a
<br>>>> >>> feature-less object class.<br>>>> >>><br>>>> >>> One quick workaround is to create a view of the table that converts<br>>>> >>> the geometry column with asbinary(), and then manually add the
<br>>>> >>> necessary entry to the geometry_columns table.<br>>>> >>><br>>>> >>> E.g.,<br>>>> >>><br>>>> >>> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as
<br>>>> >>> geom_column, column2, column3, FROM geom_table; INSERT INTO<br>>>> >>> geometry_columns (f_table_schema, f_table_name, f_geometry_column,<br>>>> >>> coord_dimension, srid, type) VALUES
<br>>>> >>> ('public', 'geom_table_view', 'geom_column', 2, -1,<br>>>> >> 'MULTIPOLYGON');<br>>>> >>><br>>>> >>> Change schema, table, column names, srid, etc. to match your table,
<br>>>> >>> then specify the view as the table to be opened with ZigGIS. It's<br>>>> an<br>>>> >>> ugly kludge, but I haven't had the time to fix the problem in ZigGIS<br>>>> >>> itself yet.
<br>>>> >>><br>>>> >>> Many of the feature class functionality hasn't been implemented yet,<br>>>> >>> so you can't do much besides display the features. I'm planning to
<br>>>> >>> add features to ZigGIS as I need them for work, but I can't give you<br>>>> >>> any timelines on it, as I'm swamped with other stuff at the moment.<br>>>> >>>
<br>>>> >>> Hope that helped,<br>>>> >>> Joshua Uyehara<br>>>> >>> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>>> >>>
<br>>>> >>> -----Original Message-----<br>>>> >>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>>> >>> [mailto:
<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>>> >>> Paolo Corti<br>>>> >>> Sent: Monday, November 27, 2006 6:46 AM
<br>>>> >>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >>> Subject: Re: [postgis-users] zigGIS Usage Experiences<br>>>> >>>
<br>>>> >>><br>>>> >>> Hello Abe<br>>>> >>><br>>>> >>> you made a great job with your ZigGis! The ArcObjects code is<br>>>> amazing!<br>>>> >>>
<br>>>> >>> maybe you can give me a help<br>>>> >>> I compiled your code for using it with ArcGis 9 (i made some little<br>>>> >>> modifications at the code to get this) and .NET
2.0 It compiled<br>>>> fine,<br>>>> >>> but when I start ArcMap and I add a PostGIS layer, it adds the layer<br>>>> >>> on the TOC but nothing is showed/drawed on the map.<br>>>> >>> Looks like geometries are not read from the shape column.
<br>>>> >>> I am wondering if you are still on this project, and maybe you could<br>>>> >>> give me some help, or if I am on my own and must deeply<br>>>> >>> investigate/debug myself the code in order to find what is not going
<br>>>> >>> properly<br>>>> >>><br>>>> >>> best regards<br>>>> >>> Paolo Corti<br>>>> >>> GIS Developer<br>>>> >>>
<a href="http://www.paolocorti.net">http://www.paolocorti.net</a><br>>>> >>><br>>>> >>><br>>>> >>> Abe Gillespie wrote:<br>>>> >>>><br>>>> >>>> Sorry for the cross post, but the zigGIS list only has 9
<br>>>> subscribers<br>>>> >>>> with a ton more downloads than that.<br>>>> >>>><br>>>> >>>> I'm curious about any experiences people are having using or even
<br>>>> >>>> *trying* to use zigGIS. Is it working? Anyone need any help? Any<br>>>> >>>> constructive criticism? ... I haven't heard a peep yet.<br>>>> >>>>
<br>>>> >>>> Thanks.<br>>>> >>>> -Abe<br>>>> >>>> _______________________________________________<br>>>> >>>> postgis-users mailing list<br>
>>> >>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >>>><br>>>> >>>><br>>>> >>><br>>>> >>> --<br>>>> >>> View this message in context:
<br>>>> >>><br>>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276</a><br>>>> >>> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>>> >>><br>>>> >>> _______________________________________________<br>>>> >>> postgis-users mailing list<br>>>> >>>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br>>>> >>> _______________________________________________<br>>>> >>> postgis-users mailing list<br>>>> >>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >>>
<br>>>> >>><br>>>> >><br>>>> >> --<br>>>> >> View this message in context:<br>>>> >> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908</a><br>>>> >> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>>>> >><br>
>>> >> _______________________________________________<br>>>> >> postgis-users mailing list<br>>>> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >> _______________________________________________
<br>>>> >> postgis-users mailing list<br>>>> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >><br>>>> >><br>>>> ><br>>>> ><br>>>><br>>>> --<br>>>> View this message in context:
<br>>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254</a><br>>>> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>>><br>>>> _______________________________________________<br>>>> postgis-users mailing list<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>><br>>>>
<br>>>><br>>>> _______________________________________________<br>>>> postgis-users mailing list<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>><br>>> _______________________________________________
<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>><br>>><br>><br>><br><br>--<br>View this message in context: <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645784">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645784</a><br>Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br><br><br><br>------------------------------<br>
<br>Message: 5<br>Date: Fri, 1 Dec 2006 13:39:22 -0700<br>From: "Bruce Rindahl" <<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>><br>Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences<br>
To: "'PostGIS Users Discussion'"<br> <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <002b01c71588$ca00bcd0$1e00a8c0@Bruce><br>
Content-Type: text/plain; charset="us-ascii"<br><br>Bingo<br>I would love to test as soon as this is possible.<br>Thanks!<br>Bruce Rindahl<br><br>-----Original Message-----<br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Paolo<br>Corti<br>Sent: Friday, December 01, 2006 1:37 PM
<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences<br><br><br>I forgot to say that one of the fist thing I want to do is an installer, so
<br>more people can get in touch with ZigGis (I am dead sure many many people<br>wanted to use it but didn't because they don't know c# and how to make it<br>working).<br>Whit more people installing ZigGis we can even get to know more bugs and fix
<br>them (a sort of alfa-beta test)<br><br>Paolo<br><br><br>Paolo Corti wrote:<br>><br>> Hi Abe<br>> I will do it, should I continue in the webspace from where I downloaded?<br>> Let me know!<br>><br>> My plans are:
<br>> 1) Some code refactoring<br>> 2) correct bugs about rendering<br>> 3) try to solve the edit problem (maybe I can have a direct contact with<br>> Esri, some years ago I was working for Esri Italy) in the clean way, this
<br>> meaning without doing anything like in the PgArc fashion with a proxy<br>> shapefile but just solving the ArcGis desktop complain that editor is not<br>> allowed (this issue you were also asking at the support esri website:
<br>> <a href="http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977">http://forums.esri.com/Thread.asp?c=93&f=1742&t=158789#610977</a>)<br>> 4) if I can't solve the edit issue in a clean way go with the PgArc
<br>> fashion for editing<br>> 5) implementing ZigGis to work also with MySql and maybe with SQL Server<br>> spatial<br>><br>> Let me know if I should open a web space at SourceForge or should I<br>> continue to use the web space you were using
<br>><br>> If someone, like Joshua, is willing to help me is very welcome<br>><br>> best regards<br>><br>> Paolo Corti<br>> GIS Developer<br>> <a href="http://www.paolocorti.net">http://www.paolocorti.net
</a><br>><br>><br>><br>><br>> Abe Gillespie wrote:<br>>><br>>> What I would love to see is someone officially take over the project.<br>>> Even if they're not contributing code ... at least managing the
<br>>> project. I feel like people are finally seeing some good in the code<br>>> and perhaps we can get enough momentum going where this thing finally<br>>> moves forward.<br>>><br>>> Anyone?
<br>>><br>>> -Abe<br>>><br>>> On 12/1/06, Bruce Rindahl <<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>> wrote:<br>>>> Is there any way this version could be posted somewhere? I would also
<br>>>> love<br>>>> to try it. I do not have access to Visual Studio.<br>>>> Thanks<br>>>> Bruce Rindahl<br>>>><br>>>> -----Original Message-----<br>>>> From:
<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a>] On Behalf Of<br>>>> Paolo<br>>>> Corti<br>>>> Sent: Friday, December 01, 2006 12:04 PM<br>>>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>>> Subject: [postgis-users] RE: RE: zigGIS Usage Experiences<br>>>><br>>>><br>>>> Thank you Joshua<br>>>> now it is working!<br>>>><br>>>> with some quick debug i discovered it was a stupid problem with my
<br>>>> international settings.<br>>>><br>>>> The funny thing is that now with correcting the regional settings it<br>>>> works<br>>>> also the previous version i had (the public
8.3 based version - that I<br>>>> modified to work with 9.0 and from which I removed the circular<br>>>> reference problem). In this previous version you DON'T NEED to create<br>>>> the view, so that problem It was already solved but came back in the
<br>>>> version Abe emailed you...<br>>>><br>>>> So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005<br>>>> Solution<br>>>> of ZigGis, without need creating the view as you suggested.
<br>>>><br>>>> I am amazed from the speed of ZigGis with reading data (i wouldn't have<br>>>> thought is so fast, after all we are not reading an ArcGis native<br>>>> geometry),<br>>>> but I see there are still many things to do (before implementing
<br>>>> editing):<br>>>> for example rendering with symbology is not working, the geometry column<br>>>> seems to have a problem (is undefined),<br>>>> ....<br>>>><br>>>> Who knows why it is not possible editing data, this would be a super tip
<br>>>> to<br>>>> get to know what can be, AFAIK Abe was trying to discover that for more<br>>>> than<br>>>> one month! I am sure if someone from the Esri Geodatabase team could<br>>>> give us
<br>>>> a little help about this they could give us the right direction for<br>>>> letting<br>>>> the layer to be edited. I don't think there is a block, we probably need<br>>>> to<br>>>> implement in the right way the right interface...
<br>>>><br>>>> in any case thank you for helping me<br>>>><br>>>> Best regards<br>>>> Paolo<br>>>><br>>>> Paolo Corti wrote:<br>>>> ><br>>>> > Hi Joshua,
<br>>>> ><br>>>> > thank you for emailing me the latest Abe's version.<br>>>> > What I had it was this: <a href="http://gforge2.uwc.ac.za/projects/ziggis">http://gforge2.uwc.ac.za/projects/ziggis
</a><br>>>> > and it was for 8.3, with a circular reference problem.<br>>>> > If i knew that there was what you sended me I would have saved 1 day<br>>>> time<br>>>> > it took me to get what I had compiled with AO
9.0.<br>>>> > In any case I compiled the project you emailed me with Visual Studio<br>>>> 2005<br>>>> > (.net 2.0) and ArcObjects 9.0 .net assemblies.<br>>>> > It compiles fine, but when I add a layer:
<br>>>> > 1) if I just add a working PostGis layer it gives error<br>>>> > 2) if I add a view (like you suggested) to the Working PostGis layer,<br>>>> it<br>>>> > seems working, the layer is added at the TOC, but nothing is drawn. If
<br>>>> I<br>>>> > open the attribute table it shows me all the record, but the geometry<br>>>> > field is empty.<br>>>> ><br>>>> > any idea?<br>>>> > thanks in advance
<br>>>> ><br>>>> > Paolo<br>>>> ><br>>>> > in fact what I had it was downloaded from SourceForge and it was still<br>>>> ><br>>>> > joshua.uyehara wrote:
<br>>>> >><br>>>> >> Hey Paolo,<br>>>> >><br>>>> >> I'm using ArcGIS Desktop 9.1. As Abe mentioned, however, I'm also<br>>>> using<br>>>> >> a later snapshot of ZigGIS.
<br>>>> >><br>>>> >> I had also gone and updated the publicly available ZigGIS to the 9.0<br>>>> >> ArcObjects model before receiving the latest version of ZigGIS from<br>>>> Abe,
<br>>>> >> but I never tested that version with the workaround that I outlined.<br>>>> >><br>>>> >> I'll email you a copy of the latest snapshot from Abe so that you can<br>>>> >> see if you have any better luck with it.
<br>>>> >><br>>>> >> Joshua Uyehara<br>>>> >> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>>> >><br>>>> >> -----Original Message-----
<br>>>> >> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>>> >> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>>> >> Paolo Corti<br>>>> >> Sent: Wednesday, November 29, 2006 7:21 AM<br>>>> >> To: <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>>> >> Subject: [postgis-users] RE: zigGIS Usage Experiences<br>>>> >><br>>>> >><br>>>> >> Hello Joshua<br>>>> >> I tried what you suggested (I also added the GID field in the view,
<br>>>> it<br>>>> >> caused an error).<br>>>> >> But ZigGis goes in error when is adding layer, specifically at this<br>>>> line<br>>>> >> of<br>>>> >> code:
<br>>>> >><br>>>> >> doc.AddLayer(layer);<br>>>> >><br>>>> >> the error i get is AccessViolationExpection<br>>>> >><br>>>> >> did you also try using ZigGis with ArcMap
9.0 ?<br>>>> >><br>>>> >> in any case thank you for helping me, i will investigate more deeply<br>>>> and<br>>>> >> if i get into some resolution I will drop a note here
<br>>>> >><br>>>> >> best regards<br>>>> >> Paolo<br>>>> >><br>>>> >><br>>>> >> joshua.uyehara wrote:<br>>>> >>><br>
>>> >>> Hey Paolo,<br>>>> >>><br>>>> >>> Abe isn't working on it anymore, but I have been occasionally<br>>>> plugging<br>>>> >><br>>>> >>> away at it myself. The problem with adding the layer in ArcMap is
<br>>>> due<br>>>> >><br>>>> >>> to a minor bug.<br>>>> >>><br>>>> >>> ZigGIS pulls the geometry column data from PostGIS in its native<br>>>> >>> binary format and passes it to ArcMap. Unfortunately, PostGIS'
<br>>>> >>> internal binary format is not identical to the expected wkb format,<br>>>> so<br>>>> >><br>>>> >>> ArcMap silently ignores it and basically treats the table as a
<br>>>> >>> feature-less object class.<br>>>> >>><br>>>> >>> One quick workaround is to create a view of the table that converts<br>>>> >>> the geometry column with asbinary(), and then manually add the
<br>>>> >>> necessary entry to the geometry_columns table.<br>>>> >>><br>>>> >>> E.g.,<br>>>> >>><br>>>> >>> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as
<br>>>> >>> geom_column, column2, column3, FROM geom_table; INSERT INTO<br>>>> >>> geometry_columns (f_table_schema, f_table_name, f_geometry_column,<br>>>> >>> coord_dimension, srid, type) VALUES
<br>>>> >>> ('public', 'geom_table_view', 'geom_column', 2, -1,<br>>>> >> 'MULTIPOLYGON');<br>>>> >>><br>>>> >>> Change schema, table, column names, srid, etc. to match your table,
<br>>>> >>> then specify the view as the table to be opened with ZigGIS. It's<br>>>> an<br>>>> >>> ugly kludge, but I haven't had the time to fix the problem in ZigGIS<br>>>> >>> itself yet.
<br>>>> >>><br>>>> >>> Many of the feature class functionality hasn't been implemented yet,<br>>>> >>> so you can't do much besides display the features. I'm planning to
<br>>>> >>> add features to ZigGIS as I need them for work, but I can't give you<br>>>> >>> any timelines on it, as I'm swamped with other stuff at the moment.<br>>>> >>>
<br>>>> >>> Hope that helped,<br>>>> >>> Joshua Uyehara<br>>>> >>> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>>> >>>
<br>>>> >>> -----Original Message-----<br>>>> >>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>>> >>> [mailto:
<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>>> >>> Paolo Corti<br>>>> >>> Sent: Monday, November 27, 2006 6:46 AM
<br>>>> >>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >>> Subject: Re: [postgis-users] zigGIS Usage Experiences<br>>>> >>>
<br>>>> >>><br>>>> >>> Hello Abe<br>>>> >>><br>>>> >>> you made a great job with your ZigGis! The ArcObjects code is<br>>>> amazing!<br>>>> >>>
<br>>>> >>> maybe you can give me a help<br>>>> >>> I compiled your code for using it with ArcGis 9 (i made some little<br>>>> >>> modifications at the code to get this) and .NET
2.0 It compiled<br>>>> fine,<br>>>> >>> but when I start ArcMap and I add a PostGIS layer, it adds the layer<br>>>> >>> on the TOC but nothing is showed/drawed on the map.<br>>>> >>> Looks like geometries are not read from the shape column.
<br>>>> >>> I am wondering if you are still on this project, and maybe you could<br>>>> >>> give me some help, or if I am on my own and must deeply<br>>>> >>> investigate/debug myself the code in order to find what is not going
<br>>>> >>> properly<br>>>> >>><br>>>> >>> best regards<br>>>> >>> Paolo Corti<br>>>> >>> GIS Developer<br>>>> >>>
<a href="http://www.paolocorti.net">http://www.paolocorti.net</a><br>>>> >>><br>>>> >>><br>>>> >>> Abe Gillespie wrote:<br>>>> >>>><br>>>> >>>> Sorry for the cross post, but the zigGIS list only has 9
<br>>>> subscribers<br>>>> >>>> with a ton more downloads than that.<br>>>> >>>><br>>>> >>>> I'm curious about any experiences people are having using or even
<br>>>> >>>> *trying* to use zigGIS. Is it working? Anyone need any help? Any<br>>>> >>>> constructive criticism? ... I haven't heard a peep yet.<br>>>> >>>>
<br>>>> >>>> Thanks.<br>>>> >>>> -Abe<br>>>> >>>> _______________________________________________<br>>>> >>>> postgis-users mailing list<br>
>>> >>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >>>><br>>>> >>>><br>>>> >>><br>>>> >>> --<br>>>> >>> View this message in context:
<br>>>> >>><br>>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7563276</a><br>>>> >>> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>>> >>><br>>>> >>> _______________________________________________<br>>>> >>> postgis-users mailing list<br>>>> >>>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br>>>> >>> _______________________________________________<br>>>> >>> postgis-users mailing list<br>>>> >>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >>>
<br>>>> >>><br>>>> >><br>>>> >> --<br>>>> >> View this message in context:<br>>>> >> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908</a><br>>>> >> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>>>> >><br>
>>> >> _______________________________________________<br>>>> >> postgis-users mailing list<br>>>> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >> _______________________________________________
<br>>>> >> postgis-users mailing list<br>>>> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>> >><br>>>> >><br>>>> ><br>>>> ><br>>>><br>>>> --<br>>>> View this message in context:
<br>>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254</a><br>>>> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>>><br>>>> _______________________________________________<br>>>> postgis-users mailing list<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>><br>>>>
<br>>>><br>>>> _______________________________________________<br>>>> postgis-users mailing list<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>><br>>> _______________________________________________
<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>><br>>><br>><br>><br><br>--<br>View this message in context:<br><a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645784">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7645784</a><br>Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br><br><br><br><br><br>------------------------------<br><br>Message: 6<br>Date: Fri, 1 Dec 2006 15:47:46 -0500<br>From: <<a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a>><br>Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
<br>To: <<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>>, <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID:<br> <<a href="mailto:FC865F8C89A81F4CB8AC6ED7A033D78D376382@usarmsxmb02.NAFTA.SYNGENTA.ORG">
FC865F8C89A81F4CB8AC6ED7A033D78D376382@usarmsxmb02.NAFTA.SYNGENTA.ORG</a>><br><br>Content-Type: text/plain; charset="us-ascii"<br><br>I'll post it to my school account until Paolo gets his site up.<br><br>
<a href="http://people.fas.harvard.edu/~uyehara/zigGIS2.zip">http://people.fas.harvard.edu/~uyehara/zigGIS2.zip</a><br><br>Josh<br><br><br>-----Original Message-----<br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>Bruce Rindahl<br>Sent: Friday, December 01, 2006 9:09 AM
<br>To: 'PostGIS Users Discussion'<br>Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences<br><br>Is there any way this version could be posted somewhere? I would also<br>love to try it. I do not have access to Visual Studio.
<br>Thanks<br>Bruce Rindahl<br><br>-----Original Message-----<br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>Paolo Corti<br>Sent: Friday, December 01, 2006 12:04 PM<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>Subject: [postgis-users] RE: RE: zigGIS Usage Experiences<br><br><br>Thank you Joshua<br>now it is working!<br><br>with some quick debug i discovered it was a stupid problem with my<br>international settings.<br><br>
The funny thing is that now with correcting the regional settings it<br>works also the previous version i had (the public 8.3 based version -<br>that I modified to work with 9.0 and from which I removed the circular<br>reference problem). In this previous version you DON'T NEED to create
<br>the view, so that problem It was already solved but came back in the<br>version Abe emailed you...<br><br>So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005<br>Solution of ZigGis, without need creating the view as you suggested.
<br><br>I am amazed from the speed of ZigGis with reading data (i wouldn't have<br>thought is so fast, after all we are not reading an ArcGis native<br>geometry), but I see there are still many things to do (before<br>implementing editing):
<br>for example rendering with symbology is not working, the geometry column<br>seems to have a problem (is undefined), ....<br><br>Who knows why it is not possible editing data, this would be a super tip<br>to get to know what can be, AFAIK Abe was trying to discover that for
<br>more than one month! I am sure if someone from the Esri Geodatabase team<br>could give us a little help about this they could give us the right<br>direction for letting the layer to be edited. I don't think there is a
<br>block, we probably need to implement in the right way the right<br>interface...<br><br>in any case thank you for helping me<br><br>Best regards<br>Paolo<br><br>Paolo Corti wrote:<br>><br>> Hi Joshua,<br>><br>
> thank you for emailing me the latest Abe's version.<br>> What I had it was this: <a href="http://gforge2.uwc.ac.za/projects/ziggis">http://gforge2.uwc.ac.za/projects/ziggis</a><br>> and it was for 8.3, with a circular reference problem.
<br>> If i knew that there was what you sended me I would have saved 1 day<br>> time it took me to get what I had compiled with AO 9.0.<br>> In any case I compiled the project you emailed me with Visual Studio<br>
> 2005 (.net 2.0) and ArcObjects 9.0 .net assemblies.<br>> It compiles fine, but when I add a layer:<br>> 1) if I just add a working PostGis layer it gives error<br>> 2) if I add a view (like you suggested) to the Working PostGis layer,
<br>> it seems working, the layer is added at the TOC, but nothing is drawn.<br><br>> If I open the attribute table it shows me all the record, but the<br>> geometry field is empty.<br>><br>> any idea?<br>> thanks in advance
<br>><br>> Paolo<br>><br>> in fact what I had it was downloaded from SourceForge and it was still<br>><br>> joshua.uyehara wrote:<br>>><br>>> Hey Paolo,<br>>><br>>> I'm using ArcGIS Desktop
9.1. As Abe mentioned, however, I'm also<br>>> using a later snapshot of ZigGIS.<br>>><br>>> I had also gone and updated the publicly available ZigGIS to the 9.0<br>>> ArcObjects model before receiving the latest version of ZigGIS from
<br>>> Abe, but I never tested that version with the workaround that I<br>outlined.<br>>><br>>> I'll email you a copy of the latest snapshot from Abe so that you can<br><br>>> see if you have any better luck with it.
<br>>><br>>> Joshua Uyehara<br>>> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>><br>>> -----Original Message-----<br>>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>> Paolo Corti<br>
>> Sent: Wednesday, November 29, 2006 7:21 AM<br>>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> Subject: [postgis-users] RE: zigGIS Usage Experiences
<br>>><br>>><br>>> Hello Joshua<br>>> I tried what you suggested (I also added the GID field in the view,<br>>> it caused an error).<br>>> But ZigGis goes in error when is adding layer, specifically at this
<br>>> line of<br>>> code:<br>>><br>>> doc.AddLayer(layer);<br>>><br>>> the error i get is AccessViolationExpection<br>>><br>>> did you also try using ZigGis with ArcMap 9.0
?<br>>><br>>> in any case thank you for helping me, i will investigate more deeply<br>>> and if i get into some resolution I will drop a note here<br>>><br>>> best regards<br>>> Paolo<br>
>><br>>><br>>> joshua.uyehara wrote:<br>>>><br>>>> Hey Paolo,<br>>>><br>>>> Abe isn't working on it anymore, but I have been occasionally<br>>>> plugging<br>>>
<br>>>> away at it myself. The problem with adding the layer in ArcMap is<br>>>> due<br>>><br>>>> to a minor bug.<br>>>><br>>>> ZigGIS pulls the geometry column data from PostGIS in its native
<br>>>> binary format and passes it to ArcMap. Unfortunately, PostGIS'<br>>>> internal binary format is not identical to the expected wkb format,<br>>>> so<br>>><br>>>> ArcMap silently ignores it and basically treats the table as a
<br>>>> feature-less object class.<br>>>><br>>>> One quick workaround is to create a view of the table that converts<br>>>> the geometry column with asbinary(), and then manually add the
<br>>>> necessary entry to the geometry_columns table.<br>>>><br>>>> E.g.,<br>>>><br>>>> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as<br>>>> geom_column, column2, column3, FROM geom_table; INSERT INTO
<br>>>> geometry_columns (f_table_schema, f_table_name, f_geometry_column,<br>>>> coord_dimension, srid, type) VALUES<br>>>> ('public', 'geom_table_view', 'geom_column', 2, -1,<br>>> 'MULTIPOLYGON');
<br>>>><br>>>> Change schema, table, column names, srid, etc. to match your table,<br>>>> then specify the view as the table to be opened with ZigGIS. It's<br>>>> an ugly kludge, but I haven't had the time to fix the problem in
<br>>>> ZigGIS itself yet.<br>>>><br>>>> Many of the feature class functionality hasn't been implemented yet,<br><br>>>> so you can't do much besides display the features. I'm planning to
<br>>>> add features to ZigGIS as I need them for work, but I can't give you<br><br>>>> any timelines on it, as I'm swamped with other stuff at the moment.<br>>>><br>>>> Hope that helped,
<br>>>> Joshua Uyehara<br>>>> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>>><br>>>> -----Original Message-----<br>>>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>>>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>>> Paolo Corti
<br>>>> Sent: Monday, November 27, 2006 6:46 AM<br>>>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> Subject: Re: [postgis-users] zigGIS Usage Experiences
<br>>>><br>>>><br>>>> Hello Abe<br>>>><br>>>> you made a great job with your ZigGis! The ArcObjects code is<br>amazing!<br>>>><br>>>> maybe you can give me a help
<br>>>> I compiled your code for using it with ArcGis 9 (i made some little<br>>>> modifications at the code to get this) and .NET 2.0 It compiled<br>>>> fine, but when I start ArcMap and I add a PostGIS layer, it adds the
<br><br>>>> layer on the TOC but nothing is showed/drawed on the map.<br>>>> Looks like geometries are not read from the shape column.<br>>>> I am wondering if you are still on this project, and maybe you could
<br><br>>>> give me some help, or if I am on my own and must deeply<br>>>> investigate/debug myself the code in order to find what is not going<br><br>>>> properly<br>>>><br>>>> best regards
<br>>>> Paolo Corti<br>>>> GIS Developer<br>>>> <a href="http://www.paolocorti.net">http://www.paolocorti.net</a><br>>>><br>>>><br>>>> Abe Gillespie wrote:<br>>>>>
<br>>>>> Sorry for the cross post, but the zigGIS list only has 9<br>>>>> subscribers with a ton more downloads than that.<br>>>>><br>>>>> I'm curious about any experiences people are having using or even
<br>>>>> *trying* to use zigGIS. Is it working? Anyone need any help? Any<br><br>>>>> constructive criticism? ... I haven't heard a peep yet.<br>>>>><br>>>>> Thanks.<br>
>>>> -Abe<br>>>>> _______________________________________________<br>>>>> postgis-users mailing list<br>>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>>><br>>>>><br>>>><br>
>>> --<br>>>> View this message in context:<br>>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a756327">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a756327
</a><br>>>> 6 Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>>>><br>>>> _______________________________________________<br>>>> postgis-users mailing list
<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br>>>> _______________________________________________<br>>>> postgis-users mailing list<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>><br>>>><br>>><br>>> --<br>>> View this message in context:
<br>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908</a><br>>> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>><br>>> _______________________________________________<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>> _______________________________________________
<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>><br>>><br>><br>><br><br>--<br>View this message in context:<br><a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254</a><br>Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br><br><br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br>------------------------------<br><br>Message: 7<br>Date: Fri, 1 Dec 2006 15:50:37 -0500<br>From: <<a href="mailto:joshua.uyehara@syngenta.com">
joshua.uyehara@syngenta.com</a>><br>Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences<br>To: <<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>>, <<a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a>><br>Message-ID:<br> <<a href="mailto:FC865F8C89A81F4CB8AC6ED7A033D78D376383@usarmsxmb02.NAFTA.SYNGENTA.ORG">FC865F8C89A81F4CB8AC6ED7A033D78D376383@usarmsxmb02.NAFTA.SYNGENTA.ORG
</a>><br><br>Content-Type: text/plain; charset="us-ascii"<br><br>You don't need Visual Studio 2005 to compile it. A very nice open<br>source alternative to VS is sharpdevelop (<a href="http://sharpdevelop.net">
sharpdevelop.net</a>).<br><br>Josh<br><br>-----Original Message-----<br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>Bruce Rindahl<br>Sent: Friday, December 01, 2006 9:09 AM<br>To: 'PostGIS Users Discussion'<br>Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
<br><br>Is there any way this version could be posted somewhere? I would also<br>love to try it. I do not have access to Visual Studio.<br>Thanks<br>Bruce Rindahl<br><br>-----Original Message-----<br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>Paolo Corti<br>Sent: Friday, December 01, 2006 12:04 PM
<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Subject: [postgis-users] RE: RE: zigGIS Usage Experiences<br><br><br>Thank you Joshua<br>now it is working!<br><br>
with some quick debug i discovered it was a stupid problem with my<br>international settings.<br><br>The funny thing is that now with correcting the regional settings it<br>works also the previous version i had (the public
8.3 based version -<br>that I modified to work with 9.0 and from which I removed the circular<br>reference problem). In this previous version you DON'T NEED to create<br>the view, so that problem It was already solved but came back in the
<br>version Abe emailed you...<br><br>So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005<br>Solution of ZigGis, without need creating the view as you suggested.<br><br>I am amazed from the speed of ZigGis with reading data (i wouldn't have
<br>thought is so fast, after all we are not reading an ArcGis native<br>geometry), but I see there are still many things to do (before<br>implementing editing):<br>for example rendering with symbology is not working, the geometry column
<br>seems to have a problem (is undefined), ....<br><br>Who knows why it is not possible editing data, this would be a super tip<br>to get to know what can be, AFAIK Abe was trying to discover that for<br>more than one month! I am sure if someone from the Esri Geodatabase team
<br>could give us a little help about this they could give us the right<br>direction for letting the layer to be edited. I don't think there is a<br>block, we probably need to implement in the right way the right<br>interface...
<br><br>in any case thank you for helping me<br><br>Best regards<br>Paolo<br><br>Paolo Corti wrote:<br>><br>> Hi Joshua,<br>><br>> thank you for emailing me the latest Abe's version.<br>> What I had it was this:
<a href="http://gforge2.uwc.ac.za/projects/ziggis">http://gforge2.uwc.ac.za/projects/ziggis</a><br>> and it was for 8.3, with a circular reference problem.<br>> If i knew that there was what you sended me I would have saved 1 day
<br>> time it took me to get what I had compiled with AO 9.0.<br>> In any case I compiled the project you emailed me with Visual Studio<br>> 2005 (.net 2.0) and ArcObjects 9.0 .net assemblies.<br>> It compiles fine, but when I add a layer:
<br>> 1) if I just add a working PostGis layer it gives error<br>> 2) if I add a view (like you suggested) to the Working PostGis layer,<br>> it seems working, the layer is added at the TOC, but nothing is drawn.
<br><br>> If I open the attribute table it shows me all the record, but the<br>> geometry field is empty.<br>><br>> any idea?<br>> thanks in advance<br>><br>> Paolo<br>><br>> in fact what I had it was downloaded from SourceForge and it was still
<br>><br>> joshua.uyehara wrote:<br>>><br>>> Hey Paolo,<br>>><br>>> I'm using ArcGIS Desktop 9.1. As Abe mentioned, however, I'm also<br>>> using a later snapshot of ZigGIS.<br>>>
<br>>> I had also gone and updated the publicly available ZigGIS to the 9.0<br>>> ArcObjects model before receiving the latest version of ZigGIS from<br>>> Abe, but I never tested that version with the workaround that I
<br>outlined.<br>>><br>>> I'll email you a copy of the latest snapshot from Abe so that you can<br><br>>> see if you have any better luck with it.<br>>><br>>> Joshua Uyehara<br>>> <a href="mailto:joshua.uyehara@syngenta.com">
joshua.uyehara@syngenta.com</a><br>>><br>>> -----Original Message-----<br>>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>>> [mailto:
<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>> Paolo Corti<br>>> Sent: Wednesday, November 29, 2006 7:21 AM<br>>> To:
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> Subject: [postgis-users] RE: zigGIS Usage Experiences<br>>><br>>><br>>> Hello Joshua<br>>> I tried what you suggested (I also added the GID field in the view,
<br>>> it caused an error).<br>>> But ZigGis goes in error when is adding layer, specifically at this<br>>> line of<br>>> code:<br>>><br>>> doc.AddLayer(layer);<br>>><br>>> the error i get is AccessViolationExpection
<br>>><br>>> did you also try using ZigGis with ArcMap 9.0 ?<br>>><br>>> in any case thank you for helping me, i will investigate more deeply<br>>> and if i get into some resolution I will drop a note here
<br>>><br>>> best regards<br>>> Paolo<br>>><br>>><br>>> joshua.uyehara wrote:<br>>>><br>>>> Hey Paolo,<br>>>><br>>>> Abe isn't working on it anymore, but I have been occasionally
<br>>>> plugging<br>>><br>>>> away at it myself. The problem with adding the layer in ArcMap is<br>>>> due<br>>><br>>>> to a minor bug.<br>>>><br>>>> ZigGIS pulls the geometry column data from PostGIS in its native
<br>>>> binary format and passes it to ArcMap. Unfortunately, PostGIS'<br>>>> internal binary format is not identical to the expected wkb format,<br>>>> so<br>>><br>>>> ArcMap silently ignores it and basically treats the table as a
<br>>>> feature-less object class.<br>>>><br>>>> One quick workaround is to create a view of the table that converts<br>>>> the geometry column with asbinary(), and then manually add the
<br>>>> necessary entry to the geometry_columns table.<br>>>><br>>>> E.g.,<br>>>><br>>>> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as<br>>>> geom_column, column2, column3, FROM geom_table; INSERT INTO
<br>>>> geometry_columns (f_table_schema, f_table_name, f_geometry_column,<br>>>> coord_dimension, srid, type) VALUES<br>>>> ('public', 'geom_table_view', 'geom_column', 2, -1,<br>>> 'MULTIPOLYGON');
<br>>>><br>>>> Change schema, table, column names, srid, etc. to match your table,<br>>>> then specify the view as the table to be opened with ZigGIS. It's<br>>>> an ugly kludge, but I haven't had the time to fix the problem in
<br>>>> ZigGIS itself yet.<br>>>><br>>>> Many of the feature class functionality hasn't been implemented yet,<br><br>>>> so you can't do much besides display the features. I'm planning to
<br>>>> add features to ZigGIS as I need them for work, but I can't give you<br><br>>>> any timelines on it, as I'm swamped with other stuff at the moment.<br>>>><br>>>> Hope that helped,
<br>>>> Joshua Uyehara<br>>>> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>>>><br>>>> -----Original Message-----<br>>>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>>>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>>>> Paolo Corti
<br>>>> Sent: Monday, November 27, 2006 6:46 AM<br>>>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> Subject: Re: [postgis-users] zigGIS Usage Experiences
<br>>>><br>>>><br>>>> Hello Abe<br>>>><br>>>> you made a great job with your ZigGis! The ArcObjects code is<br>amazing!<br>>>><br>>>> maybe you can give me a help
<br>>>> I compiled your code for using it with ArcGis 9 (i made some little<br>>>> modifications at the code to get this) and .NET 2.0 It compiled<br>>>> fine, but when I start ArcMap and I add a PostGIS layer, it adds the
<br><br>>>> layer on the TOC but nothing is showed/drawed on the map.<br>>>> Looks like geometries are not read from the shape column.<br>>>> I am wondering if you are still on this project, and maybe you could
<br><br>>>> give me some help, or if I am on my own and must deeply<br>>>> investigate/debug myself the code in order to find what is not going<br><br>>>> properly<br>>>><br>>>> best regards
<br>>>> Paolo Corti<br>>>> GIS Developer<br>>>> <a href="http://www.paolocorti.net">http://www.paolocorti.net</a><br>>>><br>>>><br>>>> Abe Gillespie wrote:<br>>>>>
<br>>>>> Sorry for the cross post, but the zigGIS list only has 9<br>>>>> subscribers with a ton more downloads than that.<br>>>>><br>>>>> I'm curious about any experiences people are having using or even
<br>>>>> *trying* to use zigGIS. Is it working? Anyone need any help? Any<br><br>>>>> constructive criticism? ... I haven't heard a peep yet.<br>>>>><br>>>>> Thanks.<br>
>>>> -Abe<br>>>>> _______________________________________________<br>>>>> postgis-users mailing list<br>>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>>><br>>>>><br>>>><br>
>>> --<br>>>> View this message in context:<br>>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a756327">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a756327
</a><br>>>> 6 Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>>>><br>>>> _______________________________________________<br>>>> postgis-users mailing list
<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br>>>> _______________________________________________<br>>>> postgis-users mailing list<br>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>>><br>>>><br>>><br>>> --<br>>> View this message in context:
<br>>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908</a><br>>> Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>>><br>>> _______________________________________________<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>> _______________________________________________
<br>>> postgis-users mailing list<br>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>>><br>>><br>><br>><br><br>--<br>View this message in context:<br><a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254</a><br>Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br><br><br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br>------------------------------<br><br>Message: 8<br>Date: Fri, 1 Dec 2006 15:52:50 -0500<br>From: "Abe Gillespie" <<a href="mailto:abe.gillespie@gmail.com">
abe.gillespie@gmail.com</a>><br>Subject: Re: [postgis-users] RE: RE: zigGIS Usage Experiences<br>To: "PostGIS Users Discussion" <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a>><br>Message-ID:<br> <<a href="mailto:a6d397e30612011252y7b4e4a5cg3a0780c8b3618192@mail.gmail.com">a6d397e30612011252y7b4e4a5cg3a0780c8b3618192@mail.gmail.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
<br><br>I developed it in C# Express which is also free.<br><br>-Abe<br><br>On 12/1/06, <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a> <<a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com
</a>> wrote:<br>> You don't need Visual Studio 2005 to compile it. A very nice open<br>> source alternative to VS is sharpdevelop (<a href="http://sharpdevelop.net">sharpdevelop.net</a>).<br>><br>> Josh<br>
><br>> -----Original Message-----<br>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>> Bruce Rindahl<br>> Sent: Friday, December 01, 2006 9:09 AM<br>> To: 'PostGIS Users Discussion'<br>> Subject: RE: [postgis-users] RE: RE: zigGIS Usage Experiences
<br>><br>> Is there any way this version could be posted somewhere? I would also<br>> love to try it. I do not have access to Visual Studio.<br>> Thanks<br>> Bruce Rindahl<br>><br>> -----Original Message-----
<br>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a>] On Behalf Of<br>> Paolo Corti<br>> Sent: Friday, December 01, 2006 12:04 PM<br>> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> Subject: [postgis-users] RE: RE: zigGIS Usage Experiences
<br>><br>><br>> Thank you Joshua<br>> now it is working!<br>><br>> with some quick debug i discovered it was a stupid problem with my<br>> international settings.<br>><br>> The funny thing is that now with correcting the regional settings it
<br>> works also the previous version i had (the public 8.3 based version -<br>> that I modified to work with 9.0 and from which I removed the circular<br>> reference problem). In this previous version you DON'T NEED to create
<br>> the view, so that problem It was already solved but came back in the<br>> version Abe emailed you...<br>><br>> So now I have a working (for ArcGis 9.0 and 9.1) Visual Studio 2005<br>> Solution of ZigGis, without need creating the view as you suggested.
<br>><br>> I am amazed from the speed of ZigGis with reading data (i wouldn't have<br>> thought is so fast, after all we are not reading an ArcGis native<br>> geometry), but I see there are still many things to do (before
<br>> implementing editing):<br>> for example rendering with symbology is not working, the geometry column<br>> seems to have a problem (is undefined), ....<br>><br>> Who knows why it is not possible editing data, this would be a super tip
<br>> to get to know what can be, AFAIK Abe was trying to discover that for<br>> more than one month! I am sure if someone from the Esri Geodatabase team<br>> could give us a little help about this they could give us the right
<br>> direction for letting the layer to be edited. I don't think there is a<br>> block, we probably need to implement in the right way the right<br>> interface...<br>><br>> in any case thank you for helping me
<br>><br>> Best regards<br>> Paolo<br>><br>> Paolo Corti wrote:<br>> ><br>> > Hi Joshua,<br>> ><br>> > thank you for emailing me the latest Abe's version.<br>> > What I had it was this:
<a href="http://gforge2.uwc.ac.za/projects/ziggis">http://gforge2.uwc.ac.za/projects/ziggis</a><br>> > and it was for 8.3, with a circular reference problem.<br>> > If i knew that there was what you sended me I would have saved 1 day
<br>> > time it took me to get what I had compiled with AO 9.0.<br>> > In any case I compiled the project you emailed me with Visual Studio<br>> > 2005 (.net 2.0) and ArcObjects 9.0 .net assemblies.<br>> > It compiles fine, but when I add a layer:
<br>> > 1) if I just add a working PostGis layer it gives error<br>> > 2) if I add a view (like you suggested) to the Working PostGis layer,<br>> > it seems working, the layer is added at the TOC, but nothing is drawn.
<br>><br>> > If I open the attribute table it shows me all the record, but the<br>> > geometry field is empty.<br>> ><br>> > any idea?<br>> > thanks in advance<br>> ><br>> > Paolo
<br>> ><br>> > in fact what I had it was downloaded from SourceForge and it was still<br>> ><br>> > joshua.uyehara wrote:<br>> >><br>> >> Hey Paolo,<br>> >><br>> >> I'm using ArcGIS Desktop
9.1. As Abe mentioned, however, I'm also<br>> >> using a later snapshot of ZigGIS.<br>> >><br>> >> I had also gone and updated the publicly available ZigGIS to the 9.0<br>> >> ArcObjects model before receiving the latest version of ZigGIS from
<br>> >> Abe, but I never tested that version with the workaround that I<br>> outlined.<br>> >><br>> >> I'll email you a copy of the latest snapshot from Abe so that you can<br>><br>> >> see if you have any better luck with it.
<br>> >><br>> >> Joshua Uyehara<br>> >> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>> >><br>> >> -----Original Message-----<br>> >> From:
<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>> >> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a>] On Behalf Of<br>> >> Paolo Corti<br>> >> Sent: Wednesday, November 29, 2006 7:21 AM<br>> >> To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>> >> Subject: [postgis-users] RE: zigGIS Usage Experiences<br>> >><br>> >><br>> >> Hello Joshua<br>> >> I tried what you suggested (I also added the GID field in the view,
<br>> >> it caused an error).<br>> >> But ZigGis goes in error when is adding layer, specifically at this<br>> >> line of<br>> >> code:<br>> >><br>> >> doc.AddLayer(layer);
<br>> >><br>> >> the error i get is AccessViolationExpection<br>> >><br>> >> did you also try using ZigGis with ArcMap 9.0 ?<br>> >><br>> >> in any case thank you for helping me, i will investigate more deeply
<br>> >> and if i get into some resolution I will drop a note here<br>> >><br>> >> best regards<br>> >> Paolo<br>> >><br>> >><br>> >> joshua.uyehara wrote:<br>
> >>><br>> >>> Hey Paolo,<br>> >>><br>> >>> Abe isn't working on it anymore, but I have been occasionally<br>> >>> plugging<br>> >><br>> >>> away at it myself. The problem with adding the layer in ArcMap is
<br>> >>> due<br>> >><br>> >>> to a minor bug.<br>> >>><br>> >>> ZigGIS pulls the geometry column data from PostGIS in its native<br>> >>> binary format and passes it to ArcMap. Unfortunately, PostGIS'
<br>> >>> internal binary format is not identical to the expected wkb format,<br>> >>> so<br>> >><br>> >>> ArcMap silently ignores it and basically treats the table as a<br>> >>> feature-less object class.
<br>> >>><br>> >>> One quick workaround is to create a view of the table that converts<br>> >>> the geometry column with asbinary(), and then manually add the<br>> >>> necessary entry to the geometry_columns table.
<br>> >>><br>> >>> E.g.,<br>> >>><br>> >>> CREATE VIEW geom_table_view AS SELECT asbinary(geom_column) as<br>> >>> geom_column, column2, column3, FROM geom_table; INSERT INTO
<br>> >>> geometry_columns (f_table_schema, f_table_name, f_geometry_column,<br>> >>> coord_dimension, srid, type) VALUES<br>> >>> ('public', 'geom_table_view', 'geom_column', 2, -1,
<br>> >> 'MULTIPOLYGON');<br>> >>><br>> >>> Change schema, table, column names, srid, etc. to match your table,<br>> >>> then specify the view as the table to be opened with ZigGIS. It's
<br>> >>> an ugly kludge, but I haven't had the time to fix the problem in<br>> >>> ZigGIS itself yet.<br>> >>><br>> >>> Many of the feature class functionality hasn't been implemented yet,
<br>><br>> >>> so you can't do much besides display the features. I'm planning to<br>> >>> add features to ZigGIS as I need them for work, but I can't give you<br>><br>> >>> any timelines on it, as I'm swamped with other stuff at the moment.
<br>> >>><br>> >>> Hope that helped,<br>> >>> Joshua Uyehara<br>> >>> <a href="mailto:joshua.uyehara@syngenta.com">joshua.uyehara@syngenta.com</a><br>> >>><br>> >>> -----Original Message-----
<br>> >>> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>> >>> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>> >>> Paolo Corti<br>> >>> Sent: Monday, November 27, 2006 6:46 AM<br>> >>> To: <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> >>> Subject: Re: [postgis-users] zigGIS Usage Experiences<br>> >>><br>> >>><br>> >>> Hello Abe<br>> >>><br>> >>> you made a great job with your ZigGis! The ArcObjects code is
<br>> amazing!<br>> >>><br>> >>> maybe you can give me a help<br>> >>> I compiled your code for using it with ArcGis 9 (i made some little<br>> >>> modifications at the code to get this) and .NET
2.0 It compiled<br>> >>> fine, but when I start ArcMap and I add a PostGIS layer, it adds the<br>><br>> >>> layer on the TOC but nothing is showed/drawed on the map.<br>> >>> Looks like geometries are not read from the shape column.
<br>> >>> I am wondering if you are still on this project, and maybe you could<br>><br>> >>> give me some help, or if I am on my own and must deeply<br>> >>> investigate/debug myself the code in order to find what is not going
<br>><br>> >>> properly<br>> >>><br>> >>> best regards<br>> >>> Paolo Corti<br>> >>> GIS Developer<br>> >>> <a href="http://www.paolocorti.net">http://www.paolocorti.net
</a><br>> >>><br>> >>><br>> >>> Abe Gillespie wrote:<br>> >>>><br>> >>>> Sorry for the cross post, but the zigGIS list only has 9<br>> >>>> subscribers with a ton more downloads than that.
<br>> >>>><br>> >>>> I'm curious about any experiences people are having using or even<br>> >>>> *trying* to use zigGIS. Is it working? Anyone need any help? Any<br>><br>
> >>>> constructive criticism? ... I haven't heard a peep yet.<br>> >>>><br>> >>>> Thanks.<br>> >>>> -Abe<br>> >>>> _______________________________________________
<br>> >>>> postgis-users mailing list<br>> >>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >>>><br>> >>>><br>> >>><br>> >>> --<br>> >>> View this message in context:<br>> >>>
<a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a756327">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a756327</a><br>> >>> 6 Sent from the PostGIS - User mailing list archive at
<a href="http://Nabble.com">Nabble.com</a>.<br>> >>><br>> >>> _______________________________________________<br>> >>> postgis-users mailing list<br>> >>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >>> _______________________________________________
<br>> >>> postgis-users mailing list<br>> >>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >>><br>> >>><br>> >><br>> >> --<br>> >> View this message in context:<br>> >> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908">
http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7601908</a><br>> >> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>> >><br>> >> _______________________________________________
<br>> >> postgis-users mailing list<br>> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >> _______________________________________________<br>> >> postgis-users mailing list<br>> >> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> >> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> >><br>> >>
<br>> ><br>> ><br>><br>> --<br>> View this message in context:<br>> <a href="http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254">http://www.nabble.com/zigGIS-Usage-Experiences-tf696976.html#a7644254
</a><br>> Sent from the PostGIS - User mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br>><br>> _______________________________________________
<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br><br><br>------------------------------<br><br>Message: 9<br>
Date: Sat, 2 Dec 2006 22:08:02 +0530<br>From: "Sandeep Kumar Jakkaraju" <<a href="mailto:sandeepkumar.jakkaraju@gmail.com">sandeepkumar.jakkaraju@gmail.com</a>><br>Subject: [postgis-users] what is the units of distance parameter in
<br> the buffer function<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Message-ID:<br> <<a href="mailto:c653c98f0612020838g4c26e086u223ff1c99d6c9d7b@mail.gmail.com">
c653c98f0612020838g4c26e086u223ff1c99d6c9d7b@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>what is the units of distance parameter in the buffer function ...<br><br>buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(
28.0 79.0<br>)'),1);<br><br>if my geom is in lat/lon ..... how much will be 1 !!<br><br>can some one throw more light on the 3 rd optional parameter !!! the manual<br>is not clear !!<br><br>--<br>Sandeep Kumar Jakkaraju<br>
WeBlog:<br><a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com</a><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/3fde8506/attachment-0001.html">
http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/3fde8506/attachment-0001.html</a><br><br>------------------------------<br><br>Message: 10<br>Date: Sat, 2 Dec 2006 17:12:48 -0000<br>From: "Pedro Doria Meunier" <
<a href="mailto:pdoria@netmadeira.com">pdoria@netmadeira.com</a>><br>Subject: RE: [postgis-users] what is the units of distance parameter<br> in the buffer function<br>To: "'PostGIS Users Discussion'"
<br> <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <000901c71635$18083fa0$4818bee0$@com><br>Content-Type: text/plain; charset="iso-8859-1"
<br><br>Kumar,<br><br><br><br>If your geom is lat/lon 1=1 degree<br><br>As to the 3rd argument it�s a mystery to me too�<br><br>>From the manual:<br><br>The optional third parameter sets the number<br><br>of segment used to approximate a quarter circle (defaults
<br><br>to 8).<br><br><br><br>What�s this good for?!<br><br><br><br>Pedro.<br><br><br><br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Sandeep<br>Kumar Jakkaraju<br>Sent: s�bado, 2 de Dezembro de 2006 16:38<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br>Subject: [postgis-users] what is the units of distance parameter in the<br>buffer function<br><br><br><br><br>what is the units of distance parameter in the buffer function ...<br><br>buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(
28.0<br>79.0)'),1);<br><br>if my geom is in lat/lon ..... how much will be 1 !!<br><br>can some one throw more light on the 3 rd optional parameter !!! the manual<br>is not clear !!<br><br>--<br>Sandeep Kumar Jakkaraju<br>
WeBlog:<br><a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com</a> <<a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com</a>><br><br>-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>URL: <a href="http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/c5e69011/attachment-0001.html">http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/c5e69011/attachment-0001.html
</a><br><br>------------------------------<br><br>Message: 11<br>Date: Sat, 2 Dec 2006 10:27:20 -0700<br>From: "Bruce Rindahl" <<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>><br>Subject: RE: [postgis-users] what is the units of distance parameter
<br> inthe buffer function<br>To: "'PostGIS Users Discussion'"<br> <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <000c01c71637$1f350810$6501a8c0@Bruce
><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>The third parameter defines how close to a circle the buffer will be. There<br>is no �circle� in PostGIS (or most GIS software) � it is approximated by a
<br>series of lines. The default value of 8 means a circle will be approximated<br>by 32 line segments. If you specified this as 1 you would get 4 points or a<br>square. If the buffer value is very large you might need to increase the
<br>value to more than 8.<br><br>Bruce<br><br><br><br> _____<br><br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Pedro<br>Doria Meunier<br>Sent: Saturday, December 02, 2006 10:13 AM<br>To: 'PostGIS Users Discussion'<br>Subject: RE: [postgis-users] what is the units of distance parameter inthe
<br>buffer function<br><br><br><br>Kumar,<br><br><br><br>If your geom is lat/lon 1=1 degree<br><br>As to the 3rd argument it�s a mystery to me too�<br><br>>From the manual:<br><br>The optional third parameter sets the number
<br><br>of segment used to approximate a quarter circle (defaults<br><br>to 8).<br><br><br><br>What�s this good for?!<br><br><br><br>Pedro.<br><br><br><br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Sandeep<br>Kumar Jakkaraju<br>Sent: s�bado, 2 de Dezembro de 2006 16:38
<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Subject: [postgis-users] what is the units of distance parameter in the<br>buffer function<br><br><br><br><br>what is the units of distance parameter in the buffer function ...
<br><br>buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0<br>79.0)'),1);<br><br>if my geom is in lat/lon ..... how much will be 1 !!<br><br>can some one throw more light on the 3 rd optional parameter !!! the manual
<br>is not clear !!<br><br>--<br>Sandeep Kumar Jakkaraju<br>WeBlog:<br><a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com</a> <<a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com
</a>><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/c8299ee2/attachment-0001.html">http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/c8299ee2/attachment-0001.html
</a><br><br>------------------------------<br><br>Message: 12<br>Date: Sat, 2 Dec 2006 10:27:22 -0700<br>From: Bill Thoen <<a href="mailto:bthoen@gisnet.com">bthoen@gisnet.com</a>><br>Subject: Re: [postgis-users] what is the units of distance parameter
<br> in the buffer function<br>To: PostGIS Users Discussion <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <<a href="mailto:20061202172722.GB9268@www.gisnet.com">
20061202172722.GB9268@www.gisnet.com</a>><br>Content-Type: text/plain; charset=us-ascii<br><br>On Sat, Dec 02, 2006 at 05:12:48PM -0000, Pedro Doria Meunier wrote:<br>> From the manual:<br>><br>> The optional third parameter sets the number
<br>> of segment used to approximate a quarter circle (defaults<br>> to 8).<br>><br>> What's this good for?!<br><br>I think it's a "smoothness" factor for drawing the corners of a buffer,<br>
i.e. if you use 1 and create a buffer around a point, it's a diamond shape.<br>If you use 2, it's an octagon. But I'm just guessing...<br><br><br>------------------------------<br><br>Message: 13<br>Date: Sat, 2 Dec 2006 22:57:32 +0530
<br>From: "Sandeep Kumar Jakkaraju" <<a href="mailto:sandeepkumar.jakkaraju@gmail.com">sandeepkumar.jakkaraju@gmail.com</a>><br>Subject: [postgis-users] Nearest Neighbour queries in Postgis<br>To: "PostGIS Users Discussion" <
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID:<br> <<a href="mailto:c653c98f0612020927n618b7fc3g147eecaef929008b@mail.gmail.com">c653c98f0612020927n618b7fc3g147eecaef929008b@mail.gmail.com
</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Are there any functions for Nearest Neighbour queries in Postgis ???<br><br>like the near command of ARCINFO !!<br><br>Thanks<br><br>--<br>Sandeep Kumar Jakkaraju
<br>WeBlog: <a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com</a><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/f520119e/attachment-0001.html">
http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/f520119e/attachment-0001.html</a><br><br>------------------------------<br><br>Message: 14<br>Date: Sat, 2 Dec 2006 10:09:10 -0800<br>From: Dylan Beaudette <
<a href="mailto:dylan.beaudette@gmail.com">dylan.beaudette@gmail.com</a>><br>Subject: Re: [postgis-users] Nearest Neighbour queries in Postgis<br>To: PostGIS Users Discussion <<a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a>><br>Message-ID: <<a href="mailto:200612021009.10306.dylan.beaudette@gmail.com">200612021009.10306.dylan.beaudette@gmail.com</a>><br>Content-Type: text/plain; charset="utf-8"
<br><br>On Saturday 02 December 2006 09:27, Sandeep Kumar Jakkaraju wrote:<br>> Are there any functions for Nearest Neighbour queries in Postgis ???<br>><br>> like the near command of ARCINFO !!<br>><br>> Thanks
<br><br>how about a self join + distance() + order by distance_to_feature + limit 1 ?<br><br>cheers,<br>--<br>Dylan Beaudette<br>Soils and Biogeochemistry Graduate Group<br>University of California at Davis<br>530.754.7341
<br><br><br>------------------------------<br><br>Message: 15<br>Date: Sat, 2 Dec 2006 10:38:00 -0700<br>From: Michael Fuhr <<a href="mailto:mike@fuhr.org">mike@fuhr.org</a>><br>Subject: Re: [postgis-users] what is the units of distance parameter
<br> in the buffer function<br>To: PostGIS Users Discussion <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <<a href="mailto:20061202173800.GA63467@winnie.fuhr.org">
20061202173800.GA63467@winnie.fuhr.org</a>><br>Content-Type: text/plain; charset=us-ascii<br><br>On Sat, Dec 02, 2006 at 10:08:02PM +0530, Sandeep Kumar Jakkaraju wrote:<br>> what is the units of distance parameter in the buffer function ...
<br>><br>> buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0 79.0<br>> )'),1);<br>><br>> if my geom is in lat/lon ..... how much will be 1 !!<br><br>The distance is in the same units as the geometry; for lat/lon
<br>that's degrees. A distance of 1 will therefore create a buffer<br>of 1 degree around the point.<br><br>Note that geometries are (X Y), which is (longitude latitude). The<br>above geometry is 79N 28E, which is in the Svalbard Archipelago in
<br>the Arctic Ocean. If you meant 28N 79E in northern India then use<br>POINT(79.0 28.0).<br><br>> can some one throw more light on the 3 rd optional parameter !!! the manual<br>> is not clear !!<br><br>"The optional third parameter sets the number of segment used to
<br>approximate a quarter circle (defaults to 8)."<br><br>For a point Buffer() returns a polygon that approximates a circle.<br>By default Buffer() uses 8 segments per quarter circle, so the<br>"circle" is really a 32-sided polygon. You can increase the number
<br>of segments to create a polygon that's closer to being a circle.<br><br>--<br>Michael Fuhr<br><br><br>------------------------------<br><br>Message: 16<br>Date: Sat, 2 Dec 2006 17:42:14 -0000<br>From: "Pedro Doria Meunier" <
<a href="mailto:pdoria@netmadeira.com">pdoria@netmadeira.com</a>><br>Subject: RE: [postgis-users] what is the units of distance parameter<br> inthe buffer function<br>To: <<a href="mailto:rindahl@lrcwe.com">
rindahl@lrcwe.com</a>>, "'PostGIS Users Discussion'"<br> <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <002001c71639$345ee650$9d1cb2f0$@com
><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Thank you Bruce!<br><br>Really helpful!<br><br><br><br>Regards,<br><br>Pedro.<br><br><br><br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">
postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Bruce<br>Rindahl<br>Sent: s�bado, 2 de Dezembro de 2006 17:27
<br>To: 'PostGIS Users Discussion'<br>Subject: RE: [postgis-users] what is the units of distance parameter inthe<br>buffer function<br><br><br><br>The third parameter defines how close to a circle the buffer will be. There
<br>is no �circle� in PostGIS (or most GIS software) � it is approximated by a<br>series of lines. The default value of 8 means a circle will be approximated<br>by 32 line segments. If you specified this as 1 you would get 4 points or a
<br>square. If the buffer value is very large you might need to increase the<br>value to more than 8.<br><br>Bruce<br><br><br><br> _____<br><br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Pedro<br>Doria Meunier<br>Sent: Saturday, December 02, 2006 10:13 AM<br>To: 'PostGIS Users Discussion'
<br>Subject: RE: [postgis-users] what is the units of distance parameter inthe<br>buffer function<br><br><br><br>Kumar,<br><br><br><br>If your geom is lat/lon 1=1 degree<br><br>As to the 3rd argument it�s a mystery to me too�
<br><br>>From the manual:<br><br>The optional third parameter sets the number<br><br>of segment used to approximate a quarter circle (defaults<br><br>to 8).<br><br><br><br>What�s this good for?!<br><br><br><br>Pedro.<br>
<br><br><br>From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net
</a>] On Behalf Of Sandeep<br>Kumar Jakkaraju<br>Sent: s�bado, 2 de Dezembro de 2006 16:38<br>To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Subject: [postgis-users] what is the units of distance parameter in the
<br>buffer function<br><br><br><br><br>what is the units of distance parameter in the buffer function ...<br><br>buffer(geom,distance,[integer]) ---> buffer(GEOMFROMTEXT('POINT(28.0<br>79.0)'),1);<br><br>if my geom is in lat/lon ..... how much will be 1 !!
<br><br>can some one throw more light on the 3 rd optional parameter !!! the manual<br>is not clear !!<br><br>--<br>Sandeep Kumar Jakkaraju<br>WeBlog:<br><a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com
</a> <<a href="http://jakkarajus.blogspot.com">http://jakkarajus.blogspot.com</a>><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/75c0529d/attachment-0001.html">
http://lists.refractions.net/pipermail/postgis-users/attachments/20061202/75c0529d/attachment-0001.html</a><br><br>------------------------------<br><br>_______________________________________________<br>postgis-users mailing list
<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br><br><br>End of postgis-users Digest, Vol 50, Issue 2<br>********************************************<br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br><br>Mark Thomas<br><a href="mailto:spatialguru.net@gmail.com">
spatialguru.net@gmail.com</a><br>205.529.9013<br><br>"Commit to the Lord whatever you do,<br> and your plans will succeed." - Proverbs 16:3