[postgis-users] navigation tracks (x,zy) h

Gery gamejihou at hotmail.com
Thu Apr 5 08:15:01 PDT 2012

Thanks Steve, let me explain you a bit the problem:
1. the geographical positions of these tracks were recorded with a device
without enough precision, this is, instead of having for example:

67.534221 9.988212
67.534223 9.988210
67.534225 9.988207

I'm getting:
67.534100 9.987500
67.534100 9.987500
67.534100 9.987500

So I need to smooth such thing.

2. I tried st_simplify, but the problem is that this method doesn't produce
curves, I tried many values but at the end I just could get a straight line,
and that doesn't reflect the curves of these tracks.

3. You're right, I'm looking for a method like moving average, I've tried
the post suggested by Bob, in fact I post that message that Bob was
referring to. However, this post shows how to smooth aircraft tracks, David
Bitner used very nicely 4 variables into his code, but my tracks just have
two columns, this is, longitude and latitude. So, I tried this code with no
success so far. I already have installed PL/R and seems to be working with
my PostGis after some examples.

4. After smoothing, I want to convert my tracks into points, this is, one
track divide it into regular points and store it in regard to the name's
track. But first I need to smooth the tracks :)

View this message in context: http://postgis.17.n6.nabble.com/navigation-tracks-x-zy-h-tp4687808p4689698.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

More information about the postgis-users mailing list