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

[Cao Minh Tu]

Sorry,

I will resend there.


2013/6/26 Tim Sutton <tim at linfiniti.com>

> Hi
>
> Please use the QGIS user mailing list for this type of question. Sign up
> here:
>
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> Regards
>
> Tim
>
>
> On Wed, Jun 26, 2013 at 8:49 AM, Cao Minh Tu <caominhtuvn at gmail.com>wrote:
>
>> 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>
>>
>> _______________________________________________
>> Qgis-community-team mailing list
>> Qgis-community-team at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-community-team
>>
>>
>
>
> --
> Tim Sutton - QGIS Project Steering Committee Member (Release  Manager)
> ==============================================
> Visit http://linfiniti.com to find out about:
>  * QGIS programming services
>  * GeoDjango web development
>  * FOSS Consulting Services
> Skype: timlinux Irc: timlinux on #qgis at freenode.net
> ==============================================
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-community-team/attachments/20130626/ca45cccd/attachment.html>