<div dir="ltr"><div><div><div>Hey,<br></div>I used Nicolas's strategy and it works.<br></div><div>You could slightly improving it by some preprocessing on the linestring itself<br></div><div>(smoothing or simplifying, depending on your data)<br></div>Cheers,<br></div>Rémi-C<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-01-25 22:32 GMT+01:00 Nicolas Ribot <span dir="ltr"><<a href="mailto:nicolas.ribot@gmail.com" target="_blank">nicolas.ribot@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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"><div><div class="h5">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></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><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><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></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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>
<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>