Accessing tracks.db to generate statistics
first of all, I wish you all the best in the forthcoming year 2021.
At the end of the year 2020 I wished to summarize my activities recorded as tracks in Locus. Since there is no functionality available for time series reporting right in the application, I came up with an idea of generating some statistics by myself. I was able to connect the tracks.db, but I am not able to decipher information stored in the table "waypoints" (track length, total elevation and total duration). Although there are separate columns with intuitive names available in the table, apparently they are not used for storing such information (NULL values). I suppose that statistical information is somehow encoded in the column named "statistics".
I would like to ask, whether there is some documentation of the table available. Eventually, if there is some guidance on how to obtain basic track information for my reporting purposes.