Online maps as a backend for SQLite maps
Hello Menion,
back from vacation and have done a number of actions. My PC is hot from MOBAC still ;-) All SQLITE now.
And I have some comparison data now:
Maverick SQLITEDB
example 1 195000 kb 197000 kB
example 2 39800 kb 41600 kB
So the DB does not impose big overhead and in turn it`s one one file only rather than scores of them.
But here are additional observations: nicely enough Maverick can directly see and use the SQLITEDBs in the Locus map directory. Once I chose such a DB as base, and I then hit the limit of resolution (say 13), but I zoom beyond, it will simply load the additional pages on the fly (as single file tiles, though).
On the other hand, there is such a strict separation between Online and "Own" DBs in Locus. Why is that ? And why would you not allow Locus to just add additional tiles into the "own" DBs (would be better than Maverick ...) ?
Locus can fill SQLITEDBs on the fly - proven by the Online maps when you store the downloads permanently. So why don`t you use this feature to give more power and convenience to the user ?
TXs and best regards
Michael
I like this idea 
Hi,
sorry ... you already wrote this into another topic right? I`m finally going to answer ...
so, thanks for comparation. Just quick question: are you really comparing real size which data take on disk, not just real size of files? Because in case of SQLite, it will be same. In case of separate tiles, it will be higher.
Anyway about second part. There is major difference between Maverick and Locus. Maverick now allow to use two formats right? SQLite and separate tiles. Both formats anyway have completely same coordinate system so it`s not a problem to handle
Locus allow to use for, hmm I think 6 different formats together with WMS maps and KML GroundOverlay images where every map should use different projection. And every map should be incompatible with any online maps. So it`s aboslutely logical that there is strict space between online/personal (offline) maps.
You can anyway use your Online map with some pre-downloaded data. Locus allow you to download download map tiles directly into Online map cache, so you can then use this online map without internet. It`s just on you
Hi,
sorry ... you already wrote this into another topic right? I`m finally going to answer ...
so, thanks for comparation. Just quick question: are you really comparing real size which data take on disk, not just real size of files? Because in case of SQLite, it will be same. In case of separate tiles, it will be higher.
Anyway about second part. There is major difference between Maverick and Locus. Maverick now allow to use two formats right? SQLite and separate tiles. Both formats anyway have completely same coordinate system so it`s not a problem to handle
Locus allow to use for, hmm I think 6 different formats together with WMS maps and KML GroundOverlay images where every map should use different projection. And every map should be incompatible with any online maps. So it`s aboslutely logical that there is strict space between online/personal (offline) maps.
You can anyway use your Online map with some pre-downloaded data. Locus allow you to download download map tiles directly into Online map cache, so you can then use this online map without internet. It`s just on you
Hi,
I had piggypacked this topic to another thread on different topic, but there was no answer, so I set up a proper thread with correct title.
I compared the sizes on my PC using Treesize, which calculates the allocated space, i.e. showing the overhead of many small files.
When it comes to the formats, it seems I`m a pretty "naive" user. TXs for the insight.
Maverick can read the SQLite files I build with MOBAC, as well as Locus can.
I understand that you cannot add tiles into SQLite DB if the coordinate systems do not match. But you would know if they match or not, right ? And there are more special formats that might not have an online "feed" anyway, so the question does not arise. This for the technical side
I originally came from the use case side when I saw how Maverick deals with missing tiles. It does not add them to the SQLite DB files in the Locus directy. It simply loads dynamically what is missing.
So, e.g. I have the whole world at level 10 as offline DB. Now I dig deeper in one place - town center, levels 11 to 17 e.g. Maverick will get them dynamically, while using the offline atlas for the exisiting levels.
In Locus, this is static - if I use an offline map and hit the level limit in one place, I have to manually switch to online mode. Not very nice.
Again, I understand now why there is no easy solution for all those formats that would not mix, but I`m pretty sure there is a way to ease use in a mix of offline DBs and online DBs.
Any idea how to ?
TXs and best regards
Michael
PS: I now also start to use vector maps - impressive stuff. But still pretty greedy for battery, although I use a Galaxy Note ...
Hi,
I had piggypacked this topic to another thread on different topic, but there was no answer, so I set up a proper thread with correct title.
I compared the sizes on my PC using Treesize, which calculates the allocated space, i.e. showing the overhead of many small files.
When it comes to the formats, it seems I`m a pretty "naive" user. TXs for the insight.
Maverick can read the SQLite files I build with MOBAC, as well as Locus can.
I understand that you cannot add tiles into SQLite DB if the coordinate systems do not match. But you would know if they match or not, right ? And there are more special formats that might not have an online "feed" anyway, so the question does not arise. This for the technical side
I originally came from the use case side when I saw how Maverick deals with missing tiles. It does not add them to the SQLite DB files in the Locus directy. It simply loads dynamically what is missing.
So, e.g. I have the whole world at level 10 as offline DB. Now I dig deeper in one place - town center, levels 11 to 17 e.g. Maverick will get them dynamically, while using the offline atlas for the exisiting levels.
In Locus, this is static - if I use an offline map and hit the level limit in one place, I have to manually switch to online mode. Not very nice.
Again, I understand now why there is no easy solution for all those formats that would not mix, but I`m pretty sure there is a way to ease use in a mix of offline DBs and online DBs.
Any idea how to ?
TXs and best regards
Michael
PS: I now also start to use vector maps - impressive stuff. But still pretty greedy for battery, although I use a Galaxy Note ...
hmm as I think about it, some backend for SQLIte personal map by same type of online map is a nice idea. Anyway seems for me to be pretty hard to create because I already have quite strict separation between personal and online map handling code. Anyway I`ll change title of this idea and keep it "under consideration" because I think it`s nice idea, just right now I have no idea how to simply do it :)
hmm as I think about it, some backend for SQLIte personal map by same type of online map is a nice idea. Anyway seems for me to be pretty hard to create because I already have quite strict separation between personal and online map handling code. Anyway I`ll change title of this idea and keep it "under consideration" because I think it`s nice idea, just right now I have no idea how to simply do it :)
I got around this issue by using maps overlay.
One is google maps which made from MOBAC and another layer is online google map.
They seem to get along very well but performance drop is noticeable.
I got around this issue by using maps overlay.
One is google maps which made from MOBAC and another layer is online google map.
They seem to get along very well but performance drop is noticeable.
Hi Elda,
thank you for coming back to thsi topic !
I quickly tried and do not see how the Online Google map would help getting higher resolutions.
I have a level 10 world map on the SD card. When I go into higher zooms than 10, Locus just inflates the zoom level, but does not download the missing zoom levels (11 and up).
Can you pls. advise how you got this to work ?
The target scenario is: Locus pls. use the SQLiteDB for the zooms included there and use overlay for the missing ones. Because neither traffic nor storage must be burnt for redundancy ...
TXs and best regards
Michael
Hi Elda,
thank you for coming back to thsi topic !
I quickly tried and do not see how the Online Google map would help getting higher resolutions.
I have a level 10 world map on the SD card. When I go into higher zooms than 10, Locus just inflates the zoom level, but does not download the missing zoom levels (11 and up).
Can you pls. advise how you got this to work ?
The target scenario is: Locus pls. use the SQLiteDB for the zooms included there and use overlay for the missing ones. Because neither traffic nor storage must be burnt for redundancy ...
TXs and best regards
Michael
NeonGeo has a nice way it deals with maps and sources.
You can see in my attached picture that OVI is my primary source which uses the tiles from the offline sqlitedb or downloads them if they are missing and adds them to an internal sqlitedb separate from the offline sqlitedb.
Below zoom level 16 it switches to secondary source (Google Hybird maps) loading them from online and caching them in the same internal sqlitedb that it was caching the online OVI tiles too before.
I would go a step farther and add another offline sqlitedb for a secondary source also. Really if you had the framework setup that we could define an xml for what offline and online sources to use at XX zoom level that would be amazing! I could see some people wanting to use 2, 3 or 4 maps seamlessly as they zoom. Thanks!
-Sten
NeonGeo has a nice way it deals with maps and sources.
You can see in my attached picture that OVI is my primary source which uses the tiles from the offline sqlitedb or downloads them if they are missing and adds them to an internal sqlitedb separate from the offline sqlitedb.
Below zoom level 16 it switches to secondary source (Google Hybird maps) loading them from online and caching them in the same internal sqlitedb that it was caching the online OVI tiles too before.
I would go a step farther and add another offline sqlitedb for a secondary source also. Really if you had the framework setup that we could define an xml for what offline and online sources to use at XX zoom level that would be amazing! I could see some people wanting to use 2, 3 or 4 maps seamlessly as they zoom. Thanks!
-Sten
I fully agree, Sten, this would be a flexible and powerful tool for users. They can adapt to their habits, the profile/power of their device and their usecase.
But there has been denial since. Very unfortunate.
I fully agree, Sten, this would be a flexible and powerful tool for users. They can adapt to their habits, the profile/power of their device and their usecase.
But there has been denial since. Very unfortunate.
It would be a great added feature and maybe we`ll get it some day if Menion decides to give maps an update.
For now I can work with having just offline maps and then switching when I want a detailed satellite view of the area. I might even download a bunch of satellite tiles and have them in my offline maps sqlitedb
It would be a great added feature and maybe we`ll get it some day if Menion decides to give maps an update.
For now I can work with having just offline maps and then switching when I want a detailed satellite view of the area. I might even download a bunch of satellite tiles and have them in my offline maps sqlitedb
Yeah, you can always minimic manually here, but this is annoying.
Yeah, you can always minimic manually here, but this is annoying.
Replies have been locked on this page!