- classified GPS-data them according to "Starting city - Destination city".
- a geodataset for German highways, that contains a
"Route-ID"for each section.
Now I want to count how many times I drove over which
"Route-ID" at which relation in QGIS.
For this, I joined the
"Route-ID" per location and kept only one GPS-point per trip per
"Route-ID". So I want to count the GPS-points per Relation per
"Route-ID". Any suggestions?
The Dataset looks like:
As example: I drove 5 times from Cologne to Frankfurt and used 4 times the combination "A4" and "A45" but one time the "A3". On the way back i used the combination "A4" and "A45" 2 times and the "A3" 3 times. The result should look like this: