[Openstreetmap] duplicate track points

[SteveC]

* @ 18/01/06 08:33:06 AM simon at zymurgy.org wrote:
> I had a thought yesterday, when I think that I forgot to clear down the 
> track logs in my GPS before recording a new track.
> 
> Is there anything in the GPX upload process to eliminate duplicate 
> trackpoints? exact same lat, long, timestamp and uploader is an obvious 
> duplicate.
> 
> If they aren't being de-duplicated on insert, maybe a clear-up of such 
> records database might make rendering the gpx wms layer a little bit 
> quicker.

Nothing is currently stopping duplicate points AFAIR. I think Petter(?)
brought it up that the API was returning dupe points a while ago.
Probably not much of a hit to do DISTINCTROW in the SQL. In fact it
might already be there...

Oh it is! That was clever. So no problem.

have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/