[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] st_intersects() returns false with point and
From:       Craig de Stigter <craig.destigter () koordinates ! com>
Date:       2011-02-24 9:09:50
Message-ID: AANLkTim=4kPBGLAQD34yJRaaoEikhNsBiTDrqENOf=kP () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Thanks for the confirmation. Created
#845<http://trac.osgeo.org/postgis/ticket/845>

On Thu, Feb 24, 2011 at 9:41 PM, Sandro Santilli <strk@keybit.net> wrote:

> On Thu, Feb 24, 2011 at 09:35:44AM +0100, Sandro Santilli wrote:
> > On Thu, Feb 24, 2011 at 12:58:24PM +1300, Craig de Stigter wrote:
> > > Hi list
> > >
> > > This query returns false, but the box and point intersect:
> > >
> > > select st_intersects('POINT(169.69960846592
> -46.5061209281002)'::geometry,
> > > > 'POLYGON((169.699607857174 -46.5061218662,169.699607857174
> > > > -46.5061195965597,169.699608806526 -46.5061195965597,169.699608806526
> > > > -46.5061218662,169.699607857174 -46.5061218662))'::geometry);
> > > >  st_intersects
> >
> > Does sound like a bug:
> >
> >  st_relate | st_intersects | st_disjoint
> > -----------+---------------+-------------
> >  0FFFFF212 | f             | f
> >
> > ST_Relate is correct, ST_Disjoint is correct, ST_Intersects is _wrong_
> >
> >    I B E
> >    -----
> >  I 0 F F
> >  B F F F
> >  E 2 1 2
> >
> > Could you please file a bug for this ?
> >  http://trac.osgeo.org/postgis
>
> For the record: the GEOS side is fine, so must be some shortcut in postgis.
>
> --strk;
>
>  ()   Free GIS & Flash consultant/developer
>  /\   http://strk.keybit.net/services.html
>



-- 
Koordinates Ltd
PO Box 1604, Shortland St, Auckland, New Zealand
Phone +64-9-966 0433 Fax +64-9-969 0045
Web http://www.koordinates.com

[Attachment #5 (text/html)]

Thanks for the confirmation. Created <a \
href="http://trac.osgeo.org/postgis/ticket/845" target="_blank">#845</a><br><br><div \
class="gmail_quote">On Thu, Feb 24, 2011 at 9:41 PM, Sandro Santilli <span \
dir="ltr">&lt;<a href="mailto:strk@keybit.net" \
target="_blank">strk@keybit.net</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div>On Thu, Feb 24, 2011 at 09:35:44AM +0100, Sandro \
Santilli wrote:<br> &gt; On Thu, Feb 24, 2011 at 12:58:24PM +1300, Craig de Stigter \
wrote:<br> &gt; &gt; Hi list<br>
&gt; &gt;<br>
&gt; &gt; This query returns false, but the box and point intersect:<br>
&gt; &gt;<br>
&gt; &gt; select st_intersects(&#39;POINT(169.69960846592 \
-46.5061209281002)&#39;::geometry,<br> &gt; &gt; &gt; &#39;POLYGON((169.699607857174 \
-46.5061218662,169.699607857174<br> &gt; &gt; &gt; -46.5061195965597,169.699608806526 \
-46.5061195965597,169.699608806526<br> &gt; &gt; &gt; -46.5061218662,169.699607857174 \
-46.5061218662))&#39;::geometry);<br> &gt; &gt; &gt;  st_intersects<br>
&gt;<br>
&gt; Does sound like a bug:<br>
&gt;<br>
&gt;  st_relate | st_intersects | st_disjoint<br>
&gt; -----------+---------------+-------------<br>
&gt;  0FFFFF212 | f             | f<br>
&gt;<br>
&gt; ST_Relate is correct, ST_Disjoint is correct, ST_Intersects is _wrong_<br>
&gt;<br>
&gt;    I B E<br>
&gt;    -----<br>
&gt;  I 0 F F<br>
&gt;  B F F F<br>
&gt;  E 2 1 2<br>
&gt;<br>
&gt; Could you please file a bug for this ?<br>
&gt;  <a href="http://trac.osgeo.org/postgis" \
target="_blank">http://trac.osgeo.org/postgis</a><br> <br>
</div>For the record: the GEOS side is fine, so must be some shortcut in postgis.<br>
<div><div></div><div><br>
--strk;<br>
<br>
  ()   Free GIS &amp; Flash consultant/developer<br>
  /\   <a href="http://strk.keybit.net/services.html" \
target="_blank">http://strk.keybit.net/services.html</a><br> \
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Koordinates Ltd<br>PO \
Box 1604, Shortland St, Auckland, New Zealand<br>Phone <a \
href="tel:%2B64-9-966%200433" target="_blank">+64-9-966 0433</a> Fax <a \
href="tel:%2B64-9-969%200045" target="_blank">+64-9-969 0045</a><br> Web <a \
href="http://www.koordinates.com" target="_blank">http://www.koordinates.com</a><br>



_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic