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

List:       postgis-users
Subject:    Re: [postgis-users] Nearest neighbor in 3D
From:       Bartosz Bekier <bartosz.bekier () gmail ! com>
Date:       2012-05-26 14:00:54
Message-ID: CA+VQafa-whnOx6ncBXuJUWgq4oS28tnao3Nn78Orv+AriizymQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


2012/5/26 Paul Ramsey <pramsey@opengeo.org>

> Using ST_3DDistance will work and give you the right answer, but it
> will not be index assisted. The KNN operator <-> is only implemented
> against the 2D index currently.
>

Ok, I see, thanks for confirming that. I'll try to use ST_3Ddwithin() to
limit the number of results, it seems to use the index.

Regards,
-- 
Bartosz

[Attachment #5 (text/html)]

<div class="gmail_quote">2012/5/26 Paul Ramsey <span dir="ltr">&lt;<a \
href="mailto:pramsey@opengeo.org" \
target="_blank">pramsey@opengeo.org</a>&gt;</span><br><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div class="im HOEnZb">Using ST_3DDistance will work and give you the right answer, \
but it<br> will not be index assisted. The KNN operator &lt;-&gt; is only \
implemented<br> against the 2D index \
currently.<br></div></blockquote><div><br></div><div>Ok, I see, thanks for confirming \
that. I&#39;ll try to use ST_3Ddwithin() to limit the number of results, it seems to \
use the index.</div><div><br>

</div><div>Regards,</div><div>-- </div><div>Bartosz</div><div><br></div></div>



_______________________________________________
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]