So as I understand, the database has to save GPS coordinates provided every 60 seconds.
If two (or more) the same coordinates come in a row, then the coordinates should be saved only once - because the driver can be not moving for a longer time due to ie. a traffic jam and we don't want to record several same coordinates.
However, the same coordinates may be saved in a route if they doesn't appear next to each other. The route may involve driving twice through the same street or intersection, and that may generate the same GPS coordinates.
For this purpose I think the best solution is just to use a stored procedure.
Create your table with the following SQL:
Then create a stored procedure using this SQL. You can execute it right after the table creation SQL above.
Now to save the GPS coordinates use the following SQL:
The first parameter ("testRoute" in this example) is the table where you want to save the coordinates, then comes latitude and longitude.
Here is a
test that proves that this method does not save the same coordinates in a row (that is, that come next to each other), but still can save the same coordinates if they appear later: