[Qgis-user] Why polygons created with "Avoid intersections" over lap their neighbors in Postgis?

[Cao Minh Tu]

Hi,

I found that polygons created with "Avoid intersections" on a Postgis layer
will sometimes over lap their neighbors. As I don't want overlapping
polygons on my Postgis layer, I implemented a trigger function using
ST_Overlaps to automatically detect and reject them. Because the mismatch
behavior between Qgis and Postgis as stated above, a simple check like that
won't work. To achieve the same result, I would have to re-shape newly
created polygons with ST_Union and ST_Difference in my trigger function,
which is a lot of work to do - since I am a newbie and finding my way
through GIS and database world.

My question is: Is there an easier way to make Qgis "Avoid intersections"
plays well with Postgis "st_overlaps" so I can avoid the other dreaded way?

Thanks!

My same question on gis.stackexchange<http://gis.stackexchange.com/q/64177/5901>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130626/205b77a4/attachment.html>