<!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><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>