Hi,
1 am using Gammu (http://www.ubuntugeek.com/wammu-mobile-phone-manager.html) to
receive SMS of location from OSMand ( http://osmand.net/ ).
2 Have written an sql to fishout the Long and Lat from the SMS and convert to
easting and northing.
TRIGGER
Now need to write a trigger such that the
These points were created from a GPX file along a road journey so they
crudely map to a line string
Map matching is the term often used to describe the process of assigning
noisy Gpx points to underlying road network.
I was thinking compute the KNN distance for each point and remove
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?
These points were created from a GPX file along a road journey so they crudely
map to a line string.
I was thinking compute the KNN distance for each
Hello,
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.
Then, if you need to keep time information, you could