<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><div id="bloop_customfont" style="margin: 0px;">If I had a table of points which are irregularly distributed and wanted to evenly distribute them what would be the best strategy and query?</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">These points were created from a GPX file along a road journey so they crudely map to a line string.</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">I was thinking compute the KNN distance for each point and remove those that have a KNN < a threshold (say 100 metres)</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;">Is that the best way to go about it?</div></div><br><div id="bloop_sign_1422186832709755904" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px"><span style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">-- </span><br style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;"><span style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">Dave Barter</span><br style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;"><br style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;"><span style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">Web: </span><a href="http://www.phased.co.uk/" target="_blank" style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">http://www.phased.co.uk</a><br style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;"><a href="mailto:Email%3Adave@phased.co.uk" target="_blank" style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">Email:dave@phased.co.uk</a><br style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;"><span style="font-size: small; text-align: -webkit-auto; line-height: normal; orphans: 2; widows: 2; font-family: arial;">Twitter:@Citizenfishy</span></div></div></body></html>