We have points table including vehicle routes.In huge traffic conditions,devices collecting data on route may output redundant points where at any coordinate same points may repeat.We can easily search and remove those points,but we have another issue like this.
Since points have threshold like 5 meters (for example) among them,when in traffic output may occur so many close(adjacent) points that we cannot seem to analyze.Also we cant adjust device,we have to move on with what we have.
We need to implement an algorithm or script to remove these redundant points.Or at least we can join them into one as we calculate some fields using functions like avg,sum.
How can we achieve this ?
We have coordinates in mapinfo table but as points we can move them into anything,your answers does not have to be in one platform.
Open source solutions would be ideal.