Re: [postgis-users] hard upgrade of database fails because of tsvector syntax error

2014-02-10 Thread Scott Pezanowski
Richard and Sandro, Thank you for your replies and suggestions. Richard, I think your suggestion is a good one and may have worked. Unfortunately, because of various reasons, the original DB does not exist anymore. I may possibly have to let this one go; At least for now. All of the PostGIS

[postgis-users] To correct Exterior Rings

2014-02-10 Thread Richard LEHAUT
Hi I succeeded to correct interior rings, but I've problem wih interior rings. Looks this screen (black circle). http://imagik.fr/view-rl/74788 Do you idea to resolve my problem? Thanks Richard L ___ postgis-users mailing list

[postgis-users] To correct Exterior Rings

2014-02-10 Thread Richard LEHAUT
Hi I succeeded to correct interior rings, but I've problem wih interior rings. Looks this screen (black circle). http://imagik.fr/view-rl/74788 Do you idea to resolve my problem? Thanks Richard L ___ postgis-users mailing list

Re: [postgis-users] To correct Exterior Rings

2014-02-10 Thread Rémi Cura
simplify simplify preserve topology polygonise then filter on area, opening operator (negativ buffer of X then positiv buffer of X) ... Cheers, Rémi-C 2014-02-10 13:43 GMT+01:00 Richard LEHAUT richard.leh...@crpf.fr: Hi I succeeded to correct interior rings, but I've problem wih interior

Re: [postgis-users] Tricks to find polygon/line intersection faster

2014-02-10 Thread Evan Martin
I've discovered a slight problem with the handy tiled intersection trick suggested earlier: some of my lines run exactly along a meridian or along a parallel and so do the tiles, so those intersections get counted twice! For example, LINESTRING(-18 14.5,-18 15.5) results in the following

Re: [postgis-users] Tricks to find polygon/line intersection faster

2014-02-10 Thread Rémi Cura
Hey, geometry equality can be defined in many ways. For your duplication problem, it is a simple postgres problem : you want that for any couple (line, poly), you have at most one result (given polygon are convex, which they are if they are squares). so at the end of you computing you just add