<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19046">
</head>
<body>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">Thanks for the response, especially as it was truncated by an accidental premature send.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">I have solved my immediate problem by casting to geometry.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">It is, however, worrrying that such fundamental errors exist in in the geography functions,as for example,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">SELECT ST_Intersects('POINT(-160 -43)'::geography, 'POLYGON((-170 -80, -170 0, 170 0, 170 -80, -170 -80))'::geography)
<br>
</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">also returns FALSE, which is not a query on the outer fringe.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">Incidently, the same query using && also gives an incorrect result.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">SELECT 'POINT(-160 -43)'::geography && 'POLYGON((-170 -80, -170 0, 170 0, 170 -80, -170 -80))'::geography</div>
</span></font>
<div><font color="#0000ff" size="2" face="Arial"></font> </div>
<div><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">BTW I'm using PostGIS1.5.</span></font></div>
<div><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011"></span></font> </div>
<div><font color="#0000ff" size="2" face="Arial"><span class="020230409-19042011">I - Dave</span></font></div>
<div><font color="#0000ff" size="2" face="Arial"></font> </div>
<!-- Converted from text/plain format -->
<p align="left"><font size="2">David M. Kidd</font></p>
<p align="left"><font size="2">Research Associate<br>
Center for Population Biology<br>
Silwood Park Campus<br>
Imperial College London<br>
0207 594 2470</font></p>
<div> </div>
<br>
<div dir="ltr" lang="en-us" class="OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>From:</b> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net]
<b>On Behalf Of </b>Paragon Corporation<br>
<b>Sent:</b> 18 April 2011 17:17<br>
<b>To:</b> 'PostGIS Users Discussion'<br>
<b>Subject:</b> Re: [postgis-users] ST_Intersects on geography<br>
</font><br>
</div>
<div></div>
<div dir="ltr" align="left"><span class="294351416-18042011"><font color="#0000ff" size="2" face="Arial">Hmm I didn't realize we use BOOM! in our errors, but I guess we do since I get the same message in 2.0 and 1.5. :)</font></span></div>
<div dir="ltr" align="left"><span class="294351416-18042011"><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span class="294351416-18042011"><font color="#0000ff" size="2" face="Arial">I know there are issues with the outer fringes when you get into the -180 ... area which we have bug tickets in place for and patches not yet applied.
That could be one of them</font></span></div>
<div dir="ltr" align="left"><font face="Arial"><font size="2"><font color="#0000ff"><span class="294351416-18042011">try moving in a bit like 179.5 89 etc.</span></font></font></font></div>
<div dir="ltr" align="left"><span class="294351416-18042011"><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<span class="294351416-18042011"></span><font face="Arial"><font color="#0000ff"><font size="2">Unfortunately the guy who deals with these things is incognito at the moment<span class="294351416-18042011"></span></font></font></font><br>
<div dir="ltr" lang="en-us" class="OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>From:</b> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net]
<b>On Behalf Of </b>Kidd, David M<br>
<b>Sent:</b> Monday, April 18, 2011 10:25 AM<br>
<b>To:</b> postgis-users@postgis.refractions.net<br>
<b>Subject:</b> [postgis-users] ST_Intersects on geography<br>
</font><br>
</div>
<div></div>
<div><font size="2" face="Arial"><span class="964441214-18042011">Hi,</span></font></div>
<div><font size="2" face="Arial"><span class="964441214-18042011"></span></font> </div>
<div><font size="2" face="Arial"><span class="964441214-18042011">Applogies if the is a stupid newbie question.</span></font></div>
<div><font size="2" face="Arial"><span class="964441214-18042011"></span></font> </div>
<div><font size="2" face="Arial"><span class="964441214-18042011">I have am writing some some simple point in polygon searches on geographic data using ST_Intersects, but have been getting some unexpected results;</span></font></div>
<div><font size="2" face="Arial"><span class="964441214-18042011"></span></font> </div>
<div><font size="2" face="Arial"><span class="964441214-18042011">Searching for a point in the southern hemisphere:</span></font></div>
<div><font size="2" face="Arial"><span class="964441214-18042011"></span></font> </div>
<div><font face="Arial"><font size="2">SELECT ST_Intersects('POINT(-160 -43)'::geography, 'POLYGON((-180 -90, -180 0, 180 0, 180 -90, -180 -90))'::geography)<span class="964441214-18042011">
</span></font></font></div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011"></span></font></font> </div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011">R</span><span class="964441214-18042011">eturns f</span></font></font></div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011"></span></font></font> </div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011">Searching for a point in the northern hemisphere:</span></font></font></div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011"></span></font></font> </div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011">SELECT ST_Intersects('POINT(160 43)'::geography, 'POLYGON((0 0, 0 90, 180 90, 180 0, 0 0))'::geography)</span></font></font></div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011"></span></font></font> </div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011">ERROR: BOOM! Could not generate outside point!<br>
CONTEXT: SQL function "st_intersects" statement 1</span></font></font></div>
<div> </div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011">********** Error **********</span></font></font></div>
<div> </div>
<div><font face="Arial"><font size="2"><span class="964441214-18042011">ERROR: BOOM! Could not generate outside point!<br>
SQL state: XX000<br>
Context: SQL function "st_intersects" statement 1</span></font></font></div>
<div><font size="2" face="Arial"><span class="964441214-18042011">This works though
</span></font></div>
<div><font size="2" face="Arial"><span class="964441214-18042011"></span></font> </div>
<div><font size="2" face="Arial"><span class="964441214-18042011"></span></font> </div>
<div><font size="2" face="Arial"><span class="964441214-18042011"></span></font> </div>
<div><font size="2" face="Arial"></font> </div>
<div> </div>
<!-- Converted from text/plain format -->
<p align="left"><font size="2">David M. Kidd</font></p>
<p align="left"><font size="2">Research Associate<br>
Center for Population Biology<br>
Silwood Park Campus<br>
Imperial College London<br>
0207 594 2470</font></p>
<div> </div>
</body>
</html>