This object is in archive!
Is it possible to visualize the age of tracks?
Answered
Hi!
Can I change the color of tracks in some automatic way so that I can see their age on the map? For example fade to a different color or make them less opaque the older they are?
If not, I assume it is possible via sqlite/tracks.db at own risk? Or will it definitely corrupt the file because it's signed/protected in some way?
Thanks,Anton
The same question
Good day Anton,
I've never read request on such functionality and also I personally never needed it. What is the usage of such coloring? Isn't better to use quite a flexible filter for imported tracks and just display tracks for a certain time range? Or just sort tracks in own folder by "create date"?
What you need is currently not possible and if you are not little more skilled with Java or any dev. language, it is not possible over SQLite database as well. The style for the track is stored in "blob" that contains quite complicated serialized Java class so it needs to be read first before it can be modified.
Menion
Good day Anton,
I've never read request on such functionality and also I personally never needed it. What is the usage of such coloring? Isn't better to use quite a flexible filter for imported tracks and just display tracks for a certain time range? Or just sort tracks in own folder by "create date"?
What you need is currently not possible and if you are not little more skilled with Java or any dev. language, it is not possible over SQLite database as well. The style for the track is stored in "blob" that contains quite complicated serialized Java class so it needs to be read first before it can be modified.
Menion
Hi!
I have many tracks in the area where I live and want to see where I haven't been and plan routes according to that. But I also want to see where I've not been in a long time. So filtering tracks means I can't distinguish between "I've never been on that road or that general area" and "I've been there, but that was a long time ago, I can plan routes close to it or with parts of it and still cover new areas/roads."
My hope was that it's possible to get what I want with just some plain SQL. I'll consider diving into the blob data, but that's less a skill topic and more a spent time versus benefit topic I'll have to consider.
Thanks for the hints,
Anton
Hi!
I have many tracks in the area where I live and want to see where I haven't been and plan routes according to that. But I also want to see where I've not been in a long time. So filtering tracks means I can't distinguish between "I've never been on that road or that general area" and "I've been there, but that was a long time ago, I can plan routes close to it or with parts of it and still cover new areas/roads."
My hope was that it's possible to get what I want with just some plain SQL. I'll consider diving into the blob data, but that's less a skill topic and more a spent time versus benefit topic I'll have to consider.
Thanks for the hints,
Anton
Hello Anton,
understand, thanks for the explanation. This is a really specific use case. You may try to play with database objects directly, I may point you on more information about it, but expect that without some development skills, it will be a really hard task.
Many objects stored in the database are really complex so I have a long time ago decided to store them in a special binary object in a single column instead of creating a big table. Not just styles for tracks, but many other objects as well.
Menion
Hello Anton,
understand, thanks for the explanation. This is a really specific use case. You may try to play with database objects directly, I may point you on more information about it, but expect that without some development skills, it will be a really hard task.
Many objects stored in the database are really complex so I have a long time ago decided to store them in a special binary object in a single column instead of creating a big table. Not just styles for tracks, but many other objects as well.
Menion
Wasn't that complicated in the end with the right pointers from you.
Before:
After:
Via bash script + sqlite3 command line tool. Just changed opaqueness manually and compared how the value changed in the blob.
You know what took the longest? Forgot to change use_category_style to 0 and wondered why nothing changed.
Wasn't that complicated in the end with the right pointers from you.
Before:
After:
Via bash script + sqlite3 command line tool. Just changed opaqueness manually and compared how the value changed in the blob.
You know what took the longest? Forgot to change use_category_style to 0 and wondered why nothing changed.
Heh, this is so smart, nice! :)
You have completely skipped complicated loading of binary objects and it's storing back to the database. Nice workaround!
Menion
Heh, this is so smart, nice! :)
You have completely skipped complicated loading of binary objects and it's storing back to the database. Nice workaround!
Menion
Replies have been locked on this page!