Likes: 
Some ideas:
The SQL file 010-D1215-00.db was good for figuring out some basic things (the different tables, their contents, etc.).
Its small size made it easy to handle and examine.
Unfortunately, it seems to be difficult to get reliable original coordinate data for the 'nodes' in its tables.
So, maybe, we should switch now to an area where reliable original coordinate information is readily available.
Such an area would be Europe.
Unfortunateley, the associated .db files are much larger.
I will look into the matter and report back here.
Welcome guest, is this your first visit? Click the "Create Account" button now to join.
Results 1 to 10 of 20
Thread: Data in SQL (.db) files
Hybrid View
-
22nd August 2012, 07:21 PM #1Master
- Join Date
- Sep 2010
- Location
- Germany
- Age
- 41
- Posts
- 51
- Rep Power
- 79
Oregon 450 and Mobile XT 5.00.20w on WM 6.5
Avatar: Yellow-bellied Marmot (Marmota flaviventris - 'Gelbbauch-Murmeltier' in German).
-
23rd August 2012, 09:05 PM #2Master
- Join Date
- Jun 2012
- Location
- Europe
- Posts
- 10
- Rep Power
- 0
These are Garmin binary coordinates, see for [Only registered and activated users can see links. ].
I have tested this with Topo Austria v3 using database '010-D1199-00.db'. In a program called 'sqlitebrowser' I searched for a known trail called 'Sonnblick
which has id 121496.Code:Please Login or Register to see the links
The borders of this trail are given with binary coordinateswhich are converted toCode:Please Login or Register to see the links
And look at the map: you will find that these values are true.Code:Please Login or Register to see the links
And you can get more segments and binary coordinates of this trail with
Code:Please Login or Register to see the links
Bookmarks