I have a table comprising multipoints (tracks) and points (stops between tracks). there can be several consecutive multipoints.
now, i want to merge any points lying very closely to each other (spatially and temporally) and delete all multipoints lying between them.
if there would be only one multpoint and one point in turn, i could delete the correct multipoints with comparing the respective lead point with the respective lag point (window function), but in case of group_id's 434 - 437 there are three multipoints in a row. so, how to compare the next point with the previous point in each case, even if there are more than one multipoint between those points?