<div dir="ltr">Hello,<div><br></div><div>You could build the linestring from points (makeLine(geom order by time)) then , with linear referencing (st_lineInterpolatePoint, st_linelocatePoint), you can divide your linestring by the distance you want, creating new points.</div><div>Then, if you need to keep time information, you could interpolate time from initial segment where a new point lies in.</div><div><br></div><div>Nicolas</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 25 January 2015 at 12:54, Dave Barter <span dir="ltr"><<a href="mailto:dave@phased.co.uk" target="_blank">dave@phased.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><div 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 style="margin:0px"><br></div><div 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 style="margin:0px"><br></div><div 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 style="margin:0px"><br></div><div style="margin:0px">Is that the best way to go about it?</div></div><span class="HOEnZb"><font color="#888888"><br><div><div style="font-family:helvetica,arial;font-size:13px"><span style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial">-- </span><br style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial"><span style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial">Dave Barter</span><br style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial"><br style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial"><span style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial">Web: </span><a href="http://www.phased.co.uk/" style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial" target="_blank">http://www.phased.co.uk</a><br style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial"><a href="mailto:Email%3Adave@phased.co.uk" style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial" target="_blank">Email:dave@phased.co.uk</a><br style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial"><span style="font-size:small;text-align:-webkit-auto;line-height:normal;font-family:arial">Twitter:@Citizenfishy</span></div></div></font></span></div><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>