Re: [postgis-users] Auto Complete

2008-04-01 Thread Nicolas Ribot
> Hello everyone, > > Im quite a novice in the Open GIS world, and i would like to know if > theres any client out there that connects to PostGIS and has a > Autocomplete polygon tool (like in arcGis). > Hi,could you describe a little more what autocomplete polygon function looks like ? thanks

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Nicolas Ribot
> Good people; > > I have this odd problem that I hope others may clarify for me. > > I have a big ArcInfo polygon coverage produced by a sequence of spatial > unions. One of the component polygon coverages was brutalized somewhere > along the way and it has some polygons with triangular and bo

RE: [postgis-users] Auto Complete

2008-04-01 Thread Sune Edmund Pedersen
Hi, for an explanation look at http://gis.washington.edu/esrm250/lessons/create_f_layers/exercise/index.htm l and search for auto-complete On PostGIS we normally implement the functionality in an auto-clip function in either the service layer of the web-application or in the database. It is a rule

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Chris Hermansen
Hi Nicolas, all; Nicolas, I understand your comment. But after looking at the data some more in OpenJump, that appears to not be my problem. If I load the PostGIS theme into OpenJump and run the QA on it, I see that it is the polygon that contains the bow-tie shaped figure that is the problem.

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Martin Davis
Chris, Can you post the WKT for the problematic feature? (Ascii art is nifty, but not really a substitute for a 1600x1200 pixel display... 8^) Chris Hermansen wrote: Hi Nicolas, all; Nicolas, I understand your comment. But after looking at the data some more in OpenJump, that appears to n

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Chris Hermansen
Martin, all; Here is the wkt for the enclosing polygon: 53327 | SRID=1;POLYGON((1224673.7804 499721.97084,1224664.2479 499721.56584,1224639.311 499709.63254,1224658.0919 499675.28084,1224664.2479 499721.56584,1224673.1624 499747.57644,1224676.7094 499739.52814,1224676.916 499740.76654,1224692.

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Martin Davis
Chris, This is a classic self-intersecting polygon, which self-touches at a single point. These are invalid according to the OGC model. They are valid in some other spatial models (notably ArcSDE), where they are referred to as "inverted polygons", and are used to represent polygons with a

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Chris Hermansen
Martin, Thanks for the info. I ended up editing out the offending polygons with OpenJump; there were only about 20. They were created by someone's sloppy geoprocessing and we were the lucky beneficiaries. I guess what is interesting is the self-intersecting and loop self-intersecting polygons w

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Martin Davis
Chris Hermansen wrote: I guess what is interesting is the self-intersecting and loop self-intersecting polygons were built by ogr2ogr when converting from ArcInfo coverages to PostGIS. Now that *is* interesting. Seems like maybe a bug in the ogr2ogr code? Is it worth asking FW about this?

Re: [postgis-users] Auto Complete

2008-04-01 Thread Maciej Sieczka
George Silva pisze: Imagine that you have a polygon already drawn in your screen. You need to make another polygon that doesnt overlap the older one, but has one of the edges coincident. QGIS 0.9.2 will have such an "auto-cutter" implemented. It's alreday vaialble in their rc2. To enable it:

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Chris Hermansen
Well, it's worth it to me :-) but then I would say that wouldn't I? I can provide the input ArcInfo coverage for testing. It's big but not enormous; 50,000 polygons or so. Martin Davis wrote: > > Chris Hermansen wrote: >> I guess what is interesting is the self-intersecting and loop >> self-inte

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Frank Warmerdam
Martin Davis wrote: Chris Hermansen wrote: I guess what is interesting is the self-intersecting and loop self-intersecting polygons were built by ogr2ogr when converting from ArcInfo coverages to PostGIS. Now that *is* interesting. Seems like maybe a bug in the ogr2ogr code? Is it worth

Re: [postgis-users] bow-tie polygons and the like

2008-04-01 Thread Martin Davis
Great, go for it! (I wasn't actually suggesting that *I* do the contacting. 8^) I'm sure Frank is easy to find) Chris Hermansen wrote: Well, it's worth it to me :-) but then I would say that wouldn't I? I can provide the input ArcInfo coverage for testing. It's big but not enormous; 50,00

[postgis-users] Problems installing PostGIS on Red Hat EL 5

2008-04-01 Thread Paragon Corporation
I seem to be having problems loading the Postgis library on a RHEL 5 box PostgreSQL 8.3.1. I'm getting this error ERROR: could not load library "/usr/lib/pgsql/liblwgeom.so": /usr/lib/pgsql/liblwgeom.so: undefined symbol: GEOSTopologyPreserveSimplify CONTEXT: SQL statement "SELECT postgis_lib_v

Re: [postgis-users] Problems installing PostGIS on Red Hat EL 5

2008-04-01 Thread Jeshua Lacock
On Apr 1, 2008, at 11:39 PM, Paragon Corporation wrote: /usr/lib/pgsql/liblwgeom.so: undefined symbol: GEOSTopologyPreserveSimplify CONTEXT: SQL statement "SELECT postgis_lib_version()" PL/pgSQL function "postgis_full_version" line 11 at SQL statement When I run select postgis_full_version(

RE: [postgis-users] Problems installing PostGIS on Red Hat EL 5

2008-04-01 Thread Paragon Corporation
Jeshua, Thanks for the tip, but unfortunately that didn't work. I verified that the geos-config was in /usr/local/bin/geos-config (and had a new date on it) - (by the way I had 8.2.5 on this server before I blew it out so not sure if that may be causing problems) I reran the configure and make c

Re: [postgis-users] Problems installing PostGIS on Red Hat EL 5

2008-04-01 Thread Jeshua Lacock
On Apr 1, 2008, at 11:39 PM, Paragon Corporation wrote: ERROR: could not load library "/usr/lib/pgsql/liblwgeom.so": /usr/lib/pgsql/liblwgeom.so: undefined symbol: GEOSTopologyPreserveSimplify CONTEXT: SQL statement "SELECT postgis_lib_version()" PL/pgSQL function "postgis_full_version" lin