[postgis-users] Reducing the number of points in a GPS track

[Olivier Courtin]

On Oct 24, 2012, at 2:29 PM, Alexandre Saunier wrote:

Hi Alex,

> A bit like the "simplify,count=<...>" filter in GPSBabel:
> http://www.gpsbabel.org/htmldoc-development/filter_simplify.html
> 
> Is there a way to do that kind of simplification with PostGIS?

A way could be to :
 - Compute length of your road with ST_Length
 - Use ST_Line_Interpolate_Point to compute each point on your line
 - Aggregate all points computed in a new simplified line with ST_MakeLine

HTH,

O.