<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=FR-CA style='font-size:
10.0pt;font-family:Arial'>Hi</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=FR-CA style='font-size:
10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>When I use a simple bbox intersects query like this, all is ok :</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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)</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>But when I had an Intersects() condition on the exactly
sames polygons I have an error :</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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)</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>NOTICE: TopologyException: side location conflict
(-110,75.8445)</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ERROR: GEOS intersects() threw an error!</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any idea?</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Antoine</span></font></p>
</div>
</body>
</html>