Messages

Thanks prawns. Were the maps you generated via MOBAC in sqlite format?

Sorry to reopen an old thread but I wanted to do the same thing as alf. I was trying to merge all my "personal" sqllite maps generated by Locus in to the cache sqlite database for the online map from which the personal ones were generated.

It seemed to work well. I opened the .sqlitedb file in SQLite2009 and then attached all 11 of the personal maps. One by one I ran the command:

Code Select Expand

insert into main.tiles select * from db1.tiles where not exists (select * from main.tiles where (main.tiles.x=db1.tiles.x and main.tiles.y=db1.tiles.y and main.tiles.z=db1.tiles.z))

changing "db1" to "db2", "db3", etc etc. It seemed to work as the original .sqlitedb file grew to nearly 2.5GB. Also files where I expected there to be a lot of overlap didn't alter many rows which would make sense.

However, when I came to open the file in Locus on the device, the cache was empty. Does anyone know why that might be?

Is it the file size is too big? Could it be something to do with the .sqlitedb-journal file? How does that relate to the .sqlitedb file?

Many thanks,
Will