Likes: 
This is a very pleasant surprise.
When I started this thread, I was hoping we could find a solution (through a collaborative effort) within a few weeks or months (with a little bit of luck).
Fortunately, merlinboy came across the thread and figured it out single-handedly.
This saved me (and probably some others) a lot of work. Thank you very much!
The data in the SQL (.db) files are accessible now. Great!
What Garmin did makes sense.
They saw the need to store large amounts of coordinate data in a database file.
Binary is the most efficient way to do this.
It is all clear now (with 20/20 hindsight).
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
-
24th August 2012, 08:43 AM #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).
-
25th August 2012, 07:37 AM #2Master
- Join Date
- Jun 2012
- Location
- Europe
- Posts
- 10
- Rep Power
- 0
Thank you. But do not believe that I am able to understand the data.
Look at the resulting 30 lines, when you execute the following query for the 'Sonnblick'-trail of Topo Austria v3:
1) You will see equal values of 'org_node_id' and 'dst_node_id', although the listed coordinates are different?Code:Please Login or Register to see the links
2) Furthermore 30 segments are listed with 31 different points. That's ok and my first thought was, that these segments can be linked together. But taking a closer look at the segments you will only find 28 different starting and 29 different final points. So it can't be a linked list of these segments.
3) No, there is a maximum of 19 segments, which can be linked together. You will find them in the following lines:
And there are also four shorter possibilities to link segments, but you can't link them together with other parts:Code:Please Login or Register to see the links
4) And why are starting points in the segments of lines 12 and 13, of lines 21 and 22 and the final points in lines 9 and 20 equal?Code:Please Login or Register to see the links
But be sure that all listed segments belong to this trail, which I was hiking this summer.
Bookmarks