<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Having not looked at your particular use case in detail, my guess is it's related to the world not being flat, see e.g.:
<div><br>
</div>
<div><a href="http://blog.opengeo.org/2012/04/30/the-earth-is-not-flat-volume-2/" target="_blank">http://blog.opengeo.org/2012/04/30/the-earth-is-not-flat-volume-2/</a></div>
<div><br>
</div>
<div>Best,</div>
<div>Steve<br>
<div><br>
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div class="WordSection1">
<p class="MsoNormal"><img src="http://sig.cmparks.net/cmp-ms-90x122.png" alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" height="122" hspace="12" width="90">
<span style="font-size:14.0pt; font-family:"Arial","sans-serif"; color:#006C56">Stephen V. Mather<br>
</span><span style="font-size:11.0pt; font-family:"Arial","sans-serif"; color:#006C56">GIS Manager<br>
</span><span style="font-size:9.0pt; font-family:"Arial","sans-serif"; color:#006C56">(216) 635-3243 (Work)
</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"><a href="http://www.clemetparks.com" target="_blank"><span style=""><br>
clevelandmetroparks.com</span></a></span></p>
<p class="MsoNormal"></p>
<br>
</div>
<div class="WordSection1"><br>
</div>
<div class="WordSection1"><br>
</div>
</div>
<div></div>
</div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF795421" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> postgis-users-bounces@lists.osgeo.org [postgis-users-bounces@lists.osgeo.org] on behalf of Jensen, Layne K CIV SPAWARSYSCEN-PACIFIC, 56210 [layne.jensen@navy.mil]<br>
<b>Sent:</b> Tuesday, February 19, 2013 10:25 AM<br>
<b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Subject:</b> [postgis-users] Perplexed: ST_Intersects with Geography, odd results<br>
</font><br>
</div>
<div></div>
<div>
<div><font color="#000000" size="2" face="Arial"> </font></div>
<font color="#000000" size="2" face="Arial">
<p style="border-bottom:0px; text-align:left; border-left:0px; padding-bottom:0px; widows:2; text-transform:none; text-indent:0px; margin:0px 0px 1em; padding-left:0px; padding-right:0px; font:14px/18px 'Helvetica Neue',Helvetica,Arial,sans-serif; word-wrap:break-word; white-space:normal; orphans:2; letter-spacing:normal; color:rgb(51,51,51); clear:both; vertical-align:baseline; border-top:0px; border-right:0px; word-spacing:0px; padding-top:0px">
We are using PostgreSQL version 9.2.2 with PostGIS 2.0,and need to do simple queries to find points that are within or intersect with a polygon.</p>
<p style="border-bottom:0px; text-align:left; border-left:0px; padding-bottom:0px; widows:2; text-transform:none; text-indent:0px; margin:0px 0px 1em; padding-left:0px; padding-right:0px; font:14px/18px 'Helvetica Neue',Helvetica,Arial,sans-serif; word-wrap:break-word; white-space:normal; orphans:2; letter-spacing:normal; color:rgb(51,51,51); clear:both; vertical-align:baseline; border-top:0px; border-right:0px; word-spacing:0px; padding-top:0px">
The following test case returns only partial results for an unknown reason. If the minimum longitude value of the polygon is changed from 0 to 1 to 2 to 5 to 20 (leaving the latitudes limits as they are), different numbers of the points are returned, even though
all of the points fall into the polygon for all these values.</p>
<pre style="border-bottom:0px; text-align:left; border-left:0px; padding-bottom:5px; widows:2; text-transform:none; background-color:rgb(238,238,238); text-indent:0px; margin:0px 0px 10px; padding-left:5px; width:auto; padding-right:5px; font:12px/18px Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif; orphans:2; letter-spacing:normal; color:rgb(51,51,51); max-height:600px; vertical-align:baseline; overflow:auto; border-top:0px; border-right:0px; word-spacing:0px; padding-top:5px"><code style="border-bottom:0px; border-left:0px; padding-bottom:0px; background-color:rgb(238,238,238); margin:0px; padding-left:0px; padding-right:0px; font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif; color:rgb(34,34,34); font-size:12px; vertical-align:baseline; border-top:0px; border-right:0px; padding-top:0px">CREATE TABLE testing.tsttab
(
lat real,
lon real,
tstpoint geography(Point,4326)
);
INSERT INTO testing.tsttab (lat, lon, tstpoint) values (36.1, 22.1, ST_GeographyFromText('POINT(22.1 36.1)'));
INSERT INTO testing.tsttab (lat, lon, tstpoint) values (36.2, 22.2, ST_GeographyFromText('POINT(22.2 36.2)'));
INSERT INTO testing.tsttab (lat, lon, tstpoint) values (36.3, 22.3, ST_GeographyFromText('POINT(22.3 36.3)'));
INSERT INTO testing.tsttab (lat, lon, tstpoint) values (36.4, 22.4, ST_GeographyFromText('POINT(22.4 36.4)'));
INSERT INTO testing.tsttab (lat, lon, tstpoint) values (36.5, 22.5, ST_GeographyFromText('POINT(22.5 36.5)'));
INSERT INTO testing.tsttab (lat, lon, tstpoint) values (36.6, 23.1, ST_GeographyFromText('POINT(23.1 36.6)'));
INSERT INTO testing.tsttab (lat, lon, tstpoint) values (36.7, 23.2, ST_GeographyFromText('POINT(23.2 36.7)'));
select * from testing.tsttab
where st_intersects(
st_geogfromtext('POLYGON((2 35, 2 37, 40 37, 40 35, 2 35))'),tstpoint);</code></pre>
<div><span style="text-align:left; widows:2; text-transform:none; text-indent:0px; display:inline!important; font:14px/18px 'Helvetica Neue',Helvetica,Arial,sans-serif; white-space:normal; orphans:2; float:none; letter-spacing:normal; color:rgb(51,51,51); word-spacing:0px">If we
convert to GEOMETRY rather than GEOGRAPHY, it performs correctly. Can anyone shed light on what we are doing wrong?</span></div>
<div><span style="text-align:left; widows:2; text-transform:none; text-indent:0px; display:inline!important; font:14px/18px 'Helvetica Neue',Helvetica,Arial,sans-serif; white-space:normal; orphans:2; float:none; letter-spacing:normal; color:rgb(51,51,51); word-spacing:0px"></span> </div>
</font>
<div><font color="#000000" size="2" face="Arial"><span style="text-align:left; widows:2; text-transform:none; text-indent:0px; display:inline!important; font:14px/18px 'Helvetica Neue',Helvetica,Arial,sans-serif; white-space:normal; orphans:2; float:none; letter-spacing:normal; color:rgb(51,51,51); word-spacing:0px">Thank
you!</span></font></div>
</div>
</div>
</div>
</div>
</body>
</html>