<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17573"></HEAD>
<BODY>
<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>