mbtiles - problems when reading

After installing OruxMaps on a new machine this morning, I was looking for a way to port my 'tiles collection' in a portable sqlite format.
I therefore downloaded some sample mbtiles's and tried loading them in OruxMaps.

I always receive a 'problems when reading' error when I attempt to load the offline-map.

gdalinfo geography-class.mbtiles

returns a correct result from the file that can be downloaded here:

http://projects.bryanmcbride.com/php-mbtiles-server/leaflet.html

In May, when I first used the program while travelling, and again today, I noticed that when creating a map
 the 1GB maximum size given in the documentation is not correct.
It seems that the limit is 500 MB.

Mark

mj10777 wrote:After installing OruxMaps on a new machine this morning, I was looking for a way to port my 'tiles collection' in a portable sqlite format.
I therefore downloaded some sample mbtiles's and tried loading them in OruxMaps.

I always receive a 'problems when reading' error when I attempt to load the offline-map.

gdalinfo geography-class.mbtiles

returns a correct result from the file that can be downloaded here:

http://projects.bryanmcbride.com/php-mbtiles-server/leaflet.html

In May, when I first used the program while travelling, and again today, I noticed that when creating a map
 the 1GB maximum size given in the documentation is not correct.
It seems that the limit is 500 MB.

Mark

Hi, Mark, check this-->https://oruxmaps.forumotion.com/t3011-a-very-large-increase-size-of-oruxsqlite-map-by-mobac#12301

do de maps include metadata table?

you can send me a map for testing-->oruxuro@gmail.com


I will check the documentation; the limit is 512mb,

orux


orux

Sorry, adding the file in gmail is not possible, to big.

Adding the create table command to all the files resolved the problem for all three of the files.

I did have to rename the first files, since OruxMaps seems to have remembered them to be invalid.
- I made the change on the pc and copied over.

Only after the rename could they be read.


http://projects.bryanmcbride.com/php-mbtiles-server/leaflet.html

is the link to download the file I wanted to send to you.

In the mean time I saw the there was a discussion about supporting rmaps,
but I have not found a way to read a, from Mobile Atlas Creator, create rmaps.db

This would be the best solution, since the z/x/y values corresponds to the normal osm naming convention.
I have an application that read tiles using this convention and so I will be adding the functionality to read a rmaps.db also.
The OruxMaps format needs an external file to know where the position 0,0 is and is therefore very impracticable for a general solution.
- this is a pity since it make it impossible for other Applications to share the same tiles.

It is also impracticable to have an android specific table. the reading should NOT fail - since it is not needed to read the data.

Code:

create table android_metadata (locale text);
insert into android_metadata values ('en_US');

Hey,

I ran into the same problem with mbtiles files created by TileMill.
I was able to get them to work by adding the suggested metadata_android sqlite-table.

I agree that this must be a bug, because this table is not necessary for the display of the data. Is a fix planned in an upcoming Oruxmaps Version?

Greets and thanks for the hint!

Found the following which might help to resolve the issue in the code:

http://stackoverflow.com/questions/2528489/no-such-table-android-metadata-whats-the-problem

Cheers

hiddenhenry wrote:Found the following which might help to resolve the issue in the code:

http://stackoverflow.com/questions/2528489/no-such-table-android-metadata-whats-the-problem

Cheers

Thanks;

I am going to add this sentences in next version,


orux