postgisaddons
postgisaddons copied to clipboard
BUG on little areas
I think I found a little bug. Run my code and see the little triangle that should not consider as Overlap ...
DROP TABLE IF EXISTS temp.areas; CREATE TABLE temp.areas AS SELECT 1 id, ST_GeomFromText('POLYGON((0 1,3 2,3 0,0 1),(1.5 1.337,1.56 1.18,1.6 1.22,1.65 1.2,2 1.32,2 0.666,1.5 0.666,1.5 1.337))') geom UNION ALL SELECT 2 id, ST_GeomFromText('POLYGON((1 1, 3.8 2, 4 0, 1 1))') geom UNION ALL SELECT 3 id, ST_GeomFromText('POLYGON((2 1, 4.6 2, 5 0, 2 1))') geom UNION ALL SELECT 4 id, ST_GeomFromText('POLYGON((3 1, 5.4 2, 6 0, 3 1))') geom UNION ALL SELECT 5 id, ST_GeomFromText('POLYGON((3 1, 5.4 2, 6 0, 3 1))') geom ;