Welcome guest, is this your first visit? Click the "Create Account" button now to join.
Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 41
  1. #21
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Quote Originally Posted by merlinboy View Post
    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
    Code:
    Please Login or Register to see the links
    which has id 121496.

    The borders of this trail are given with binary coordinates
    Code:
    Please Login or Register to see the links
    which are converted to
    Code:
    Please Login or Register to see the links
    And look at the map: you will find that these values are true.

    And you can get more segments and binary coordinates of this trail with
    Code:
    Please Login or Register to see the links
    Hi!! very interesting post.... I'm trying to get waypoints from db archives, and I understand the most of this post, but... How can I convert from binary format? There is some conversor or utility?? If not, what is the relationship between both formats?? Thanks!!!

  2.    Advertissements


  3. #22
    Important User haute's Avatar
    Join Date
    Mar 2010
    Location
    Spain
    Age
    44
    Posts
    481
    Rep Power
    400

    Default

    I think you need to use some interpreted language to do what you wish, I recommend python, is the easiest and powerful for what you're looking.

  4. #23
    Important User

    osiris4isis's Avatar
    Join Date
    Apr 2012
    Location
    Farside of the Sun
    Posts
    2,645
    Rep Power
    635

    Default

    Quote Originally Posted by vadiniense View Post
    Hi!! very interesting post.... I'm trying to get waypoints from db archives, and I understand the most of this post, but... How can I convert from binary format? There is some conversor or utility?? If not, what is the relationship between both formats?? Thanks!!!
    Answer
    Spoiler: .

    This post requires you to click the "LIKE this post" button and hit F5 to read this content.
    "You know the very powerful and the very stupid have one thing in common. They don't alter their views to fit the facts. They alter the facts to fit the views." -DrWho

    Do NOT PM me with requests or for fixes to your problem. Post in thread instead. All communications in English only!

  5. #24
    Member +
    Join Date
    Apr 2010
    Location
    earth
    Posts
    38
    Rep Power
    17

    Default

    Quote Originally Posted by haute View Post
    I think you need to use some interpreted language to do what you wish, I recommend python, is the easiest and powerful for what you're looking.
    A very good tool to edit/browse sqlite (.db) files
    [Only registered and activated users can see links. ]

  6. #25
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Thanks @haute... Too much complicated and I don't know anything about Python. If there isn't a conversor or utility that do it for me, it's better I forget the question. Thanks!!

  7. #26
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Quote Originally Posted by raioxis View Post
    A very good tool to edit/browse sqlite (.db) files
    [Only registered and activated users can see links. ]
    Yes, I download and open de DB Browser but I don't know how proceed to do masive conversions....

  8. #27
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Quote Originally Posted by osiris4isis View Post
    Answer
    Spoiler: .

    -= Hidden Content =-
    Ohhh thanks my friend!! I try make masive conversion of table data using this relationship. Its just what I needed.
    I expect It works, later I tell you!! THANKS for the trick!!!!

    [Only registered and activated users can see links. ]

  9. #28
    Important User

    osiris4isis's Avatar
    Join Date
    Apr 2012
    Location
    Farside of the Sun
    Posts
    2,645
    Rep Power
    635

    Default

    Maybe I can help, post your *.db and I'll have a look at it.
    "You know the very powerful and the very stupid have one thing in common. They don't alter their views to fit the facts. They alter the facts to fit the views." -DrWho

    Do NOT PM me with requests or for fixes to your problem. Post in thread instead. All communications in English only!

  10. #29
    Important User haute's Avatar
    Join Date
    Mar 2010
    Location
    Spain
    Age
    44
    Posts
    481
    Rep Power
    400

    Default

    More interesting it would be to use a tool to create db files

  11. #30
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Quote Originally Posted by osiris4isis View Post
    Maybe I can help, post your *.db and I'll have a look at it.
    I tell you... I want to extract points from Topo Spain V6 db file that contains traces data (because extract lines I think its not possible cause db only contains points). Open db in QGIS let me extract data and export in csv format, then I can import as txt file and display points, but the projection is a crazy due the binary coordinates format.
    Now, with your relationship number, I gonna try make new columns in table expecting new coordinates are in a "normal" projection and I can display data in a correct way...
    Its this way correct?

    [Only registered and activated users can see links. ]

 

 
Page 3 of 5 FirstFirst 12345 LastLast

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.