Thread: ActiveRouting .db file - general discussion

We can copy here the interesting posts from Topo pro maps thread

Originally Posted by GPSFranz

I am getting closer to figuring out what is going on

So far, I know how to enable searching for 'Named Trails' in BaseCamp 3.3.3 for Topo Austria v3 (locked IMG file).
(The following header information for the IMG files is from GMapTool.)

Header: 11.06.2012 13:38:32, DSKIMG, XOR 00, V 3.00, Ms 0, 010-D1199-00
Mapset: Topo Österreich v3
Please note the name of the 010-D1199-00.db file in the header.

For TransAlpin 2012 Pro it is not working (it may have to do with the missing name of the 010-D1160-00.db file in the header).
Header: 25.05.2012 21:58:23, DSKIMG, XOR 00, V 3.00, Ms 0
Mapset: TransAlpin 2012 Pro

The question now is:
Why is the name of the 010-D1160-00.db file in the header of TransAlpin 2012 Pro missing in my IMG file?
Is it because my file (I am quite sure I downloaded it from the Zippyshare links in catymag's post #2) is NOT an original locked IMG file?

Please check the header information of your TransAlpin 2012 Pro IMG file with GMapTool (to see if the name of the 010-D1160-00.db file in the header is missing or not).
It would be nice to solve this problem.

Originally Posted by Ballebar

The NamedTrails SQLite DB file is named as the part number for the map.
TransAlpin 2012 Pro (Download) with part number 010-D1160-00 is using SQLite file 010-D1106-00.db.

Originally Posted by catymag

The .img isnt original coz personal unlock codes were removed with pietu's tool: it contains GMT.exe old version.

Originally Posted by merlinboy

Ok, if the part number of the map (which also defines the name of the SQL file) has been removed, we have to insert it again. Take a hexeditor and insert the following hexadecimal values beginning at position 48 (hex 0x30):

Code:

Please Login or Register to see the links

[Only registered and activated users can see links. ]

GMapTool info will now look like

Code:

Please Login or Register to see the links

and NamedTrails are working now in my unlocked image.

Originally Posted by merlinboy

And the same procedure for Topo Austria v3. Take a hexeditor and insert the following hexadecimal values beginning at position 48 (hex 0x30):

Code:

Please Login or Register to see the links

[Only registered and activated users can see links. ]

GMapTool info will now show

Code:

Please Login or Register to see the links

and NamedTrails are also working now in this unlocked image.

Originally Posted by merlinboy

so I can also add the values for the mentioned Topo France Sud-Est:

Code:

Please Login or Register to see the links

GMapTool info will now show

Code:

Please Login or Register to see the links

and NamedTrails are also working now in this unlocked image.

Originally Posted by merlinboy

and finally Topo Deutschland 2012 Pro, which is said to have the same problems:

Code:

Please Login or Register to see the links

GMapTool info will now show

Code:

Please Login or Register to see the links

Originally Posted by jonnywi

here is the screenshot of basecamp 4.0.0.5 beta
[Only registered and activated users can see links. ]

Originally Posted by syzygy

For original locked img files, gimgunlock does not change the header, so the part number should remain the same in header and the unlocked img files should still have "Named Trails". For an existing unlocked img file without part number, all you need is to write a separate tool to open the img file, fseek to offset 48 (0x30 in hex), write 9 bytes of compressed part number there, then close the file. It should be easy to do in Perl or C/C++.

Originally Posted by sherco40

I have implemented this functionality (i.e. display and change of the img part number) in [Only registered and activated users can see links. ].

It is in french...( open your img and click on "Changer le numéro de produit du fichier img")

Please, if you want to try it, back up your img before...

For me it works fine with topo Germany, Austria and France...

Originally Posted by merlinboy

Here is a Perl script to change or add the part number in an image file. It works an a Windows system with Perl installed or of course on a Linux system:

[Only registered and activated users can see links. ]

The script takes two parameter, which can be changed in the script - see the marked lines in the first part):

- the name of the image file (default: 'imagefile.img', as you always should worked with a copy)

- the part number as normal string like '010-D1160-00' for Transalpin 2012 Pro (default: empty string).

The part number will be coded (second part) and the resulting 9 bytes are written into the imagefile (third part), beginnend at position 48 (hex 0x30).

Originally Posted by catymag

SQLbrowser to open these files:

Code:

Please Login or Register to see the links

Originally Posted by Mapperoni

These are my findings so far:

• When Topo Austria v3 is the only map on SD I can search and find Trails and they are highlighted violet (as usual) when selected. When just looking at the map NO trails are highlighted (red or purple), whatever activity is chosen.
• Whe I add Topo France v3 on SD I can't find any trail in Austria anymore. Only French trails can be found.
• I didn't try TransAlpine and Austria together yet but I would expect problems since they are covering the same area partially.
• Maybe Catymag is right stating these maps are meant to be used as a single product on a single SD card.

Originally Posted by federbruch

According to the german garmin forum, more than one db file on an oregon or a montana don`t work.
The mod has informed the developers about this issue.

Originally Posted by MaxDoe

Extensive testing now shows the following for me:

1. only Transalpine (+SQL) on SD
   
   • colour highlighting works
   • trail search works
   • this is expected behaviour
2. only Austria v3 (+SQL) on SD
   
   • colour highlighting does NOT work
   • trail search works
   • this is NOT expected behaviour
3. both maps (+both SQL) on SD
   
   • both enabled
     
     • colour highlighting works for content of BOTH MAPS
     • trail search only Topo Austria Trails
     • this is expected behaviour for the highlighting and unexpected behaviour for the trail search, but could be explained by a conflict of having two SQL .db files on one card
   • Austria enabled, Transalpine disabled
     
     • colour highlighting does NOT work
     • trail search only Topo Austria Trails
     • this is NOT expected behaviour for the highlighting
   • Austria disabled, Transalpine enabled
     
     • colour highlighting works
     • trail search only Topo Austria Trails
     • this is NOT expected behaviour for the highlighting, for trail search see above
4. both maps (+ ONLY austria SQL) on SD
   
   • highlighting is EXACTLY the same as with both SQL files
   • trail search is EXACTLY the same as with both SQL files
5. both maps (+ ONLY transalpine SQL) on SD
   
   • highlighting is EXACTLY the same as with both SQL files
   • trail search now only for Transalpine
6. both maps (+ NO SQL FILE) on SD
   
   • highlighting is EXACTLY the same as with both SQL files
   • no Trails button in search available

In summary, I found the following things:

• highlighting has NOTHING to do with the SQL files, they are totally unrelated
• SQL files are only used for the trail search function
• the austria SQL file overrides the transalp SQL file
• you can only use one SQL file on the montana in trail search, how it is determined which one is used I don't yet know, but I'm investigating
• the topo austria v3 highlighting ONLY works when topo transalpine 2012 is on the same card and enabled as well

For the SQL file problem, I will look into a possibility of combining the databases in one file and report back once I know more...
But how do we solve the highlighting problem? Any ideas?

Since I don't have my original TopoAustria SD Card here right now,

could anyone confirm if the highlighting works on the original SD

cause I slowly have a suspicion that this might also not work on the original map.. maybe a bug in the firmware or in the released map?

For completeness sake, all of this was tested on a Montana 650 with FW 4.20.

Originally Posted by MaxDoe

okay, so this shows that two SQL files do not work on the same card, and this will be solved by Garmin. So this problem is done as far as I am concerned.

Leaves us with a problem that has nothing to do with the SQL files in any way, the highlighting in Topo Austria, which strangely seems to be "activated" by enabling the transalpine topo at the same time.....

Originally Posted by Mapperoni

The problem with multiple db files (only one of them gets loaded) still exists with the latest firmware releases dated 29/30 august.
I checked it myself with v4.40 on my 62s and on forum.garmin.de someone reports the same for the Montana.

We'll have to wait for Garmin to tackle this problem.

note:
ActiveRouting functionalities supported by Montana, Monterra, Edge 810/1000, GPSMAP 62/64 and Oregon 6xx/x50 series
more info about active routing and named trails:
[Only registered and activated users can see links. ]
end of the starting post

see also
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]

In 62 I disabled DEM or it's a nightmare, too slow with these maps.

I not find anywhere what FID, PID and other ID are contained in .UNL file...

If I have two image files in my Oregon, where do I put the two corresponding SQL folders? I can't have the same named folders in Garmin? (Images like Gmapsupp and Gmapsup2 or Gmapprom)

I quote here a post from Topo Germany thread:

Originally Posted by sergio2

Hi,

New Montana firmware allows several .db files in the same SQL folder to be read on GPS.
I tried with Topo France v3, Topo Germany v3, and Topo trek Map Italia v3 : the whole three maps trails were displayed when "trails" in "where to go" was selected.

Caty, Garmin developers in quiet mode as usually added this last point in change list at last week

Spoiler: CLICK

http://www8.garmin.com/support/download_details.jsp?id=5335