droll | # 781 | 2011-07-23, 14:15 | Report

try copying the tiles to a pc and running your script there.

MartinK | # 782 | 2011-07-23, 17:18 | Report

Thanks !

So this is basically current bearing vs north ? How useful is it actually ?

This info should be hopefully available once modRana starts using Monav. BTW, I'm already starting to test it's Python bindings.

The zoom buttons in modRana are IMO already far enough - but is shows nicely how elaborately is the TomTom GUI designed.

And maybe automatically switch to the bottom once the device is rotated to portrait ?

Well not that difficult IMO.
Actually, thanks to your speed based voice message triggering patch modRana no longer needs the Google provided triggering distances. So a simple GPX file with some points having routing messages (using the <cmt>, <desc> or eveng <extension> tag ? GPX 1.1 schema) should be now quite easily usable for routing.

Some notes to this:

• modRana already does GPX loading for the tracklogs
• the Turn-by-Turn navigation module currently just processes the raw Google Directions result
  • a simple generic class for storing route/tracklog info might be needed
  • which would also help adding new online/offline routing providers, storing and loading routes, automatic route reloading at startup, etc.

Thanks for reporting! I'll check it out - looks like a Unicode conversion error to me.

---

Last edited by MartinK; 2011-07-23 at 17:22.

sajk | # 783 | 2011-07-23, 18:21 | Report

each time I try routing I always get "no route found". can someone tell me where I am going wrong?

MartinK | # 784 | 2011-07-23, 18:22 | Report

There is some rough sqlite tile storage documentation on t the modRana project website.
Its currently quite basic so please let me know if you find any errors or omissions.

It lists the folder for available store files, then it checks them sequentially until it finds one that is under the maximum size threshold. If no such store is found, new one is created. Maximum store size threshold is 3.7 GB.

The Python code that does this in modRana is here:
http://modrana.org/trac/browser/trun...eTiles.py#L200

Can including it in the modRana package once it's done ? - Only if you don't mind, of course.
This way it could be placed in /usr/bin and would be easily callable as it would be in $PATH.

I hit something similar - the solution was not to commit after every tile but just once every 50 or so tiles. This made the process quite faster IIRC.

---

Last edited by MartinK; 2011-07-23 at 18:31.

beermad | # 785 | 2011-07-24, 09:32 | Report

Ah, good. Nice and big. I wondered if maybe the size was restricted for performance reasons

Quite happy with that in principle. In practice it may be tricky as the script has dependencies on the Perl DBI and DBD-SQLite libraries, so my original design is for it to be run on a normal Linux system rather than on the N900 (probably rather faster there as well). But I'll see if I can port the necessary libraries and bundle up what's needed.


Good point. I need to build in a restart facility as well; a long-running process like this needs to be interruptible.

jj0 | # 786 | 2011-07-26, 09:23 | Report

Is there a problem in the latest version with displaying composite tiles?

I haven't used it in a long time, just using OSM, but tried just now a couple of times with OSM and Virtual Earth Sat and it just gets stuck on Loading... for each tile. Individually both work, but composite doesn't...

jj0 | # 787 | 2011-07-26, 10:34 | Report

It seems the display fails for overlaid images, when one doesn't have the tiles to display, i.e. you zoom too much in for instance, so that no sat images are available.

Whereas before it overlaid also the not-available tile info, not it just shows loading...

But when I zoom out a level, it works.

beermad | # 788 | 2011-07-26, 15:15 | Report

OK, I've got a working Perl script to import map tiles into the database.

At the moment, it won't run on the N900 itself, as I'm having a few problems getting the SQLite module to build on my scratchbox installation; I'll work on that over the next few days when I have spare time and see if I can get that working.

Dependencies: You'll need to install the Perl DBI and DBD-SQLite modules. These should be available from your disto's repositories (otherwise, get them from CPAN).

It took about 75 minutes to import my 200 000 tiles into the database on my dual-core Athlon machine; obviously this will vary depending on the speed of the machine it's done on. The script is interruptible - just hit Control-C and it'll shut down cleanly. Then restart at your leisure.

Getting it to work on an OS other than Linux is left as an exercise for the reader, as I'm happily Microsoft-free.

It demonstrates well the oft-mentioned clustering problem with FAT partitions; my tile files allocated 12.5G of space, whereas the store file is only 543M.

Instructions:

Download the script from http://www.beermad.org.uk/mapconvert

Either copy your ~/MyDocs/.maps directory to your Linux box or mount your MyDocs partition on it. Try to preserve the timestamps if copying (as they're recorded in the database, I assume they're used to work out if a new copy of any tile is needed if they've changed on the tile server) - for example, if using scp:
The script only works on tiles in the current working directory, so for each map-type, cd into the relevant directory:
Then run the script (no parameters needed).

If necessary, copy the lookup.sqlite and store.sqlite.* files back to your N900.

If there are any tiles already in the database, it leaves them there and it doesn't try to over-write any if one it finds already exists (at some time I should change this so it does over-write if the tile file is newer).

If you already have tiles in a database, I recommend making a copy first, just in case anything goes wrong. I've tested the script a fair bit, but can't guarantee something won't screw up.

---

Last edited by beermad; 2011-07-26 at 15:25.

MartinK | # 789 | 2011-07-26, 17:45 | Report

ModRana now overlays the two tiles only once and then caches the result & displays the result. Before the tiles are combined, only the loading tile is shown.

Like this, when tiles from one layer are missing, nothing is shown.
This can be IMO improved:

• just showing the "good" layer
• overlaying with the error tile to inform the user that one layer is broken

Can I put your script & HOWTO on the modRana wiki ?

beermad | # 790 | 2011-07-26, 18:10 | Report

Certainly. Be my guest. Hope it's useful to a few people.