[postgis-users] Intersects() error

[Gilbert, Antoine]

Hi

 

When I use a simple bbox intersects query like this, all is ok :

 

SELECT AsBinary (geom)  as geom, GeometryType( geom) as
_pgGeometryTypeAlias FROM(select * from "can_nad27_region") as foo WHERE
(GeomFromText('POLYGON((-62.048854187348795 46.80208227121052,
-64.80640318784656 51.480318104127846, -69.24339730246844
52.96374353310841, -73.24748751348027 52.96374353310841,
-77.68448162810215 51.480318104127846, -80.44203062859991
46.80208227121052, -77.43144917490224 42.30768527650847,
-73.23675825984627 40.673442256588125, -69.25412655610243
40.673442256588125, -65.0594356410465 42.307685276508444,
-62.048854187348795 46.80208227121052))',SRID(geom)) && geom)

 

But when I had an Intersects() condition on the exactly sames polygons I
have an error :

 

 

SELECT AsBinary (geom)  as geom, GeometryType( geom) as
_pgGeometryTypeAlias FROM(select * from "can_nad27_region") as foo WHERE
(GeomFromText('POLYGON((-62.048854187348795 46.80208227121052,
-64.80640318784656 51.480318104127846, -69.24339730246844
52.96374353310841, -73.24748751348027 52.96374353310841,
-77.68448162810215 51.480318104127846, -80.44203062859991
46.80208227121052, -77.43144917490224 42.30768527650847,
-73.23675825984627 40.673442256588125, -69.25412655610243
40.673442256588125, -65.0594356410465 42.307685276508444,
-62.048854187348795 46.80208227121052))',SRID(geom)) && geom) AND
Intersects(GeomFromText('POLYGON((-62.048854187348795 46.80208227121052,
-64.80640318784656 51.480318104127846, -69.24339730246844
52.96374353310841, -73.24748751348027 52.96374353310841,
-77.68448162810215 51.480318104127846, -80.44203062859991
46.80208227121052, -77.43144917490224 42.30768527650847,
-73.23675825984627 40.673442256588125, -69.25412655610243
40.673442256588125, -65.0594356410465 42.307685276508444,
-62.048854187348795 46.80208227121052))',SRID(geom)), geom)

 

NOTICE:  TopologyException: side location conflict (-110,75.8445)

 

ERROR:  GEOS intersects() threw an error!

 

Any idea?

 

Antoine

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060123/fb50f421/attachment.html>