OruxMaps
Visit the new forum: <a href="http://www.oruxmaps.com/foro">OruxMaps</a>

mbtiles - problems when reading

View previous topic View next topic Go down

mbtiles - problems when reading

Post  mj10777 on Sat Jun 22, 2013 6:55 am

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

Cantidad de envíos : 4
Fecha de inscripción : 2013-06-22

View user profile

Back to top Go down

Re: mbtiles - problems when reading

Post  orux on Sat Jun 22, 2013 9:39 am

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-->http://oruxmaps.forosactivos.net/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

_________________
Ahora puedes contribuir:--> DONACIÓN
Now you can contribute:--> DONATE

orux

Cantidad de envíos : 3946
Fecha de inscripción : 2009-07-06

View user profile

Back to top Go down

Re: mbtiles - problems when reading

Post  mj10777 on Sat Jun 22, 2013 3:58 pm

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');

mj10777

Cantidad de envíos : 4
Fecha de inscripción : 2013-06-22

View user profile

Back to top Go down

Can confirm the problem

Post  hiddenhenry on Fri Sep 20, 2013 6:33 am

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!


hiddenhenry

Cantidad de envíos : 2
Fecha de inscripción : 2013-09-20

View user profile

Back to top Go down

Re: mbtiles - problems when reading

Post  hiddenhenry on Sat Sep 21, 2013 3:06 am

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

Cantidad de envíos : 2
Fecha de inscripción : 2013-09-20

View user profile

Back to top Go down

Re: mbtiles - problems when reading

Post  orux on Sat Sep 21, 2013 10:19 am

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

_________________
Ahora puedes contribuir:--> DONACIÓN
Now you can contribute:--> DONATE

orux

Cantidad de envíos : 3946
Fecha de inscripción : 2009-07-06

View user profile

Back to top Go down

Re: mbtiles - problems when reading

Post  Sponsored content Today at 7:45 pm


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum