<div dir="ltr"><div class="gmail_extra">That's good. Now I'm looking for dataset to do some tests of "exact knn".<br><br>------<br>With best regards,<br>Alexander Korotkov.<br><br><div class="gmail_quote">
On Fri, Jun 27, 2014 at 9:48 PM, <span dir="ltr"><<a href="mailto:maplabs@light42.com" target="_blank">maplabs@light42.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div><p>Alexander -</p><p><br></p><p> there are some images here that
might be useful.. </p><p>I dont know exactly what the question is, but, this
post is an attempt at showing several distance searchs and the
results.</p><div class=""><p><br></p><p>
<a href="http://blog.light42.com/wordpress/?p=102" target="_blank">http://blog.light42.com/wordpress/?p=102</a></p><p><br></p><p>--</p><p>Brian M
Hamlin</p><p>OSGeo California
Chapter</p><p><a href="http://blog.light42.com" target="_blank">blog.light42.com</a></p><p><br></p><p><br></p><p><br></p></div><div><div class="h5"><p>On Fri, 27
Jun 2014 21:29:58 +0400, Alexander Korotkov <<a href="mailto:aekorotkov@gmail.com" target="_blank">aekorotkov@gmail.com</a>>
wrote:<br></p></div></div><blockquote dir="ltr" style="border-left-width:2px;border-left-style:solid;border-left-color:rgb(0,0,0);padding-right:0px;padding-left:5px;margin-left:5px;margin-right:0px"><div><div class="h5">
<div><div dir="ltr"><div class="gmail_extra">Hi!</div><div class="gmail_extra"><br></div><div class="gmail_extra">Turning back to this
topic. Could you prepare dump and SQL examples, please? </div><div class="gmail_extra"><br clear="all"><div><span style="font-family:arial,sans-serif;font-size:13px">------</span><br style="font-family:arial,sans-serif;font-size:13px">
<span style="font-family:arial,sans-serif;font-size:13px">With best regards,</span><br style="font-family:arial,sans-serif;font-size:13px"><span style="font-family:arial,sans-serif;font-size:13px">Alexander Korotkov.</span><br>
</div><br><div class="gmail_quote">On Fri, Jan 17, 2014 at 6:04 PM, Paul Ramsey <span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div style="word-wrap:break-word"><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">
Alex,</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">This piece of the workshop gives some visuals about how unpleasant
reasoning abound nearest neighbour using boxes is. (It’s almost embarrassing
trying to explain it to people)</div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><a href="http://workshops.boundlessgeo.com/postgis-intro/knn.html" target="_blank">http://workshops.boundlessgeo.com/postgis-intro/knn.html</a><br>
</div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">You can pull the NYC roads data from the associated data package
and replicate the results. </div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">I can prepare something more plug-n-play (dump file and SQL
examples) when I get back home if needed.</div><div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">
<br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">P.</div> <div><div><br></div><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br>Paul Ramsey<br><a href="http://cleverelephant.ca" target="_blank">http://cleverelephant.ca</a><div>
<a href="http://postgis.net" target="_blank">http://postgis.net</a><br></div></div> <br></div><div><p style="color:rgb(160,160,168)">On January 17, 2014
at 9:01:33 AM, Alexander Korotkov (<a href="mailto://aekorotkov@gmail.com" target="_blank">aekorotkov@gmail.com</a>) wrote:</p>
<blockquote type="cite"><span><div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<br>You may take a look at my patch to PostgreSQL enabling exact
knn-gist:</div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<a href="http://www.postgresql.org/message-id/CAPpHfdu_qBLNRnv-r=_tofZYYa6-r=Z5_MGF4_phAOkWcYxfRg@mail.gmail.com" target="_blank">http://www.postgresql.org/message-id/CAPpHfdu_qBLNRnv-r=_tofZYYa6-r=Z5_MGF4_phAOkWcYxfRg@mail.gmail.com</a><br>
</div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
Ideally, it could be in 9.4. But I expect serious critics about accessing heap
from gist is fundamentally bad design.</div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
Test cases are very welcome. It would be very nice to have them
before<span> </span><a href="http://airmail.calendar/2014-01-19%2012:00:00%20EST" target="_blank">January 19.</a><span> </span>I know it very soon, but in this
case I can include them to PGCon proposal.</div>
<br></div></span></blockquote></div></div></blockquote></div><br></div></div>
</div>
<br></div></div><hr><div class=""><br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br><a href="http://webmail.light42.com/hwebmail/services/go.php?url=http%3A%2F%2Flists.osgeo.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fpostgis-devel" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel</a><br>
</div></blockquote><p><br><br></p><p><br></p><p><br></p></div></blockquote></div><br></div></div>