Played with #QGis geotagged photos from one of our #Amsterdam canal boat rides. (see prior post about the NetBSD port somehow losing metadata).
The photos have timestamps, which needed a bit of pruning to show HH:MM:SS, including leading zeroes.
I'd like to learn how to "connect the dots" and show which canals we traversed. One day.
Timestamp snippet:
concat(hour("timestamp"), ':', lpad(minute("timestamp"),2,'0') , ':', lpad(second(timestamp),2,'0') )