<!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 10.00.9200.16750"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=504523204-01022014><FONT color=#0000ff
size=2 face=Arial>ah found the other one:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=504523204-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=504523204-01022014><FONT color=#0000ff
size=2 face=Arial><A
href="http://trac.osgeo.org/postgis/ticket/2556">http://trac.osgeo.org/postgis/ticket/2556</A></FONT></SPAN></DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Paragon
Corporation<BR><B>Sent:</B> Friday, January 31, 2014 11:27 PM<BR><B>To:</B>
'PostGIS Users Discussion'<BR><B>Cc:</B> 'PostGIS Development
Discussion'<BR><B>Subject:</B> Re: [postgis-users] Odd Behavior with
ST_Intersects (PostGIS 2.1,Ubuntu 12.04)<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>Jerry,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>Thanks very much for the report. I had noticed what I
think might be the same issue, but couldn't find such a short and succinct
example as yours to reproduce.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>I have added to my original ticket: <A
href="http://trac.osgeo.org/postgis/ticket/2422">http://trac.osgeo.org/postgis/ticket/2422</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>I think there is another ticket in our bug tracker that might
be the same issue too but can't recall the number.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>Thanks very very much for this great
example.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>Paul -- if you are watching you have work to do
:)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net">http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=795072304-01022014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Jerry
Sievert<BR><B>Sent:</B> Friday, January 31, 2014 6:25 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] Odd Behavior
with ST_Intersects (PostGIS 2.1,Ubuntu 12.04)<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>Hello,
<DIV><BR></DIV>
<DIV>I am using Ubuntu 12.04 with the official PostgreSQL apt repo (via <A
href="https://wiki.postgresql.org/wiki/Apt">https://wiki.postgresql.org/wiki/Apt</A>).
I am running into an easily reproducible issue, and was hoping for some
help to solve this.</DIV>
<DIV><BR></DIV>
<DIV>When using ST_Intersects() not all rows that intersect are returned.
This was not the case in previous versions that we have upgraded
from.</DIV>
<DIV><BR></DIV>
<DIV>These are the steps to reproduce on a fresh install of Ubuntu 12.04 with
all packages updated and PostGIS/PostgreSQL 9.3 installed:</DIV>
<DIV><BR></DIV>
<DIV>
<DIV><FONT face="courier new, monospace">test=# CREATE TABLE test (id serial,
condition_geo geography);</FONT></DIV>
<DIV><FONT face="courier new, monospace">CREATE TABLE</FONT></DIV>
<DIV><FONT face="courier new, monospace">test=# INSERT INTO test (condition_geo)
VALUES (ST_Buffer(ST_GeogFromWKB(ST_MakePoint(20.0,30.0)),10.0));</FONT></DIV>
<DIV><FONT face="courier new, monospace">INSERT 0 1</FONT></DIV>
<DIV><FONT face="courier new, monospace">test=# SELECT id FROM test WHERE
ST_Intersects("condition_geo", ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'),
20.0)) IS TRUE;</FONT></DIV>
<DIV><FONT face="courier new, monospace"> id</FONT></DIV>
<DIV><FONT face="courier new, monospace">----</FONT></DIV>
<DIV><FONT face="courier new, monospace"> 1</FONT></DIV>
<DIV><FONT face="courier new, monospace">(1 row)</FONT></DIV>
<DIV><FONT face="courier new, monospace"><BR></FONT></DIV>
<DIV><FONT face="courier new, monospace">test=# INSERT INTO test (condition_geo)
VALUES (ST_Buffer(ST_GeogFromWKB(ST_MakePoint(20.0,30.0)),10.0));</FONT></DIV>
<DIV><FONT face="courier new, monospace">INSERT 0 1</FONT></DIV>
<DIV><FONT face="courier new, monospace">test=# SELECT id FROM test WHERE
ST_Intersects("condition_geo", ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'),
20.0)) IS TRUE;</FONT></DIV>
<DIV><FONT face="courier new, monospace"> id</FONT></DIV>
<DIV><FONT face="courier new, monospace">----</FONT></DIV>
<DIV><FONT face="courier new, monospace"> 1</FONT></DIV>
<DIV><FONT face="courier new, monospace">(1 row)</FONT></DIV>
<DIV><FONT face="courier new, monospace"><BR></FONT></DIV>
<DIV><FONT face="courier new, monospace">test=# SELECT id FROM test WHERE
ST_Intersects("condition_geo", ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'),
20.0)) IS TRUE AND id = 2;</FONT></DIV>
<DIV><FONT face="courier new, monospace"> id</FONT></DIV>
<DIV><FONT face="courier new, monospace">----</FONT></DIV>
<DIV><FONT face="courier new, monospace"> 2</FONT></DIV>
<DIV><FONT face="courier new, monospace">(1 row)</FONT></DIV></DIV>
<DIV><BR></DIV>
<DIV>Note that the SELECT should return both rows 1 and 2 in the first
SELECT.</DIV>
<DIV><BR></DIV>
<DIV>Any thoughts?</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV></DIV></BODY></HTML>