<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"
data-hsystem="true"></head><body><style>p{margin: 0;padding:
0;}</style><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><p><br></p><p>
http://blog.light42.com/wordpress/?p=102</p><p><br></p><p>--</p><p>Brian M
Hamlin</p><p>OSGeo California
Chapter</p><p>blog.light42.com</p><p><br></p><p><br></p><p><br></p><p>On Fri, 27
Jun 2014 21:29:58 +0400, Alexander Korotkov <aekorotkov@gmail.com>
wrote:<br></p><blockquote dir="ltr" style="border-left: 2px solid rgb(0, 0, 0);
padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"
_mce_style="border-left: 2px solid #000000; padding-right: 0px; padding-left:
5px; margin-left: 5px; margin-right: 0px;"><div id="html-message"><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" _mce_style="font-family:
arial,sans-serif; font-size: 13px;">------</span><br
style="font-family:arial,sans-serif;font-size:13px" _mce_style="font-family:
arial,sans-serif; font-size: 13px;"><span
style="font-family:arial,sans-serif;font-size:13px" _mce_style="font-family:
arial,sans-serif; font-size: 13px;">With best regards,</span><br
style="font-family:arial,sans-serif;font-size:13px" _mce_style="font-family:
arial,sans-serif; font-size: 13px;"><span
style="font-family:arial,sans-serif;font-size:13px" _mce_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"
_mce_style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px;
border-left-color: #cccccc; border-left-style: solid; padding-left: 1ex;"><div
style="word-wrap:break-word" _mce_style="word-wrap: break-word;"><div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;">
Alex,</div><div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;"><br></div><div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
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"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;"><br></div><div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;"><a href="http://workshops.boundlessgeo.com/postgis-intro/knn.html"
target="_blank">http://workshops.boundlessgeo.com/postgis-intro/knn.html</a><br
_mce_bogus="1"></div>
<div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;"><br></div><div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
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"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;">I can prepare something more plug-n-play (dump file and SQL
examples) when I get back home if needed.</div><div class=""><div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;">
<br></div><div
style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"
_mce_style="font-family: Helvetica,Arial; font-size: 13px; color: #000000;
margin: 0px;">P.</div> <div><div><br></div><span
style="font-family:helvetica,arial;font-size:13px" _mce_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
_mce_bogus="1"></div></div> <br></div><div class=""><p
style="color:rgb(160,160,168)" _mce_style="color: #a0a0a8;">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"
_mce_style="color: #000000; 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"
_mce_style="color: #000000; 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"
_mce_style="color: #000000; 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"
_mce_style="color: #000000; 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><hr><br>
_______________________________________________<br>
postgis-devel mailing list<br>
postgis-devel@lists.osgeo.org<br><a
href="http://webmail.light42.com/hwebmail/services/go.php?url=http%3A%2F%2Flists.osgeo.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fpostgis-devel"
_mce_href="../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
_mce_bogus="1"></blockquote><p><br><br></p><p><br></p><p><br></p></body></html>