Welcome guest, is this your first visit? Click the "Create Account" button now to join.
Page 4 of 5 FirstFirst ... 2345 LastLast
Results 31 to 40 of 41
  1. #31
    Important User

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

    Default

    Sound reasonable assuming QGIS knows how to build relationship from Garmin *.db. Don't know until I look at *.db and verified some theory.
    "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!

  2.    Advertissements


  3. #32
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Quote Originally Posted by osiris4isis View Post
    Sound reasonable assuming QGIS knows how to build relationship from Garmin *.db. Don't know until I look at *.db and verified some theory.
    The table contains binary coordinates. Simply I make new columns for X and Y coordinates that contains the binary value divided for the number you post. If this relationship is correct, importing new CSV and give new values for x and Y would work. I am creating new columns (more than 270000 files!). In a while I tell If this works and If not...

    [Only registered and activated users can see links. ]

  4. #33
    Important User

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

    Default

    You can check a few to see if they are correct lat and lon. If so, go for 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!

  5. #34
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Quote Originally Posted by osiris4isis View Post
    You can check a few to see if they are correct lat and lon. If so, go for it!
    Hohohooooo!!! It seems finally works!!!
    Here, the table with the old and original binary coordinates (yellow) and the new coordinates (green) thanks to your magical, great, marvellous number!!
    sql0
    And here the table displayed at least and compatible with other maps.... It seems really points are in the right place!! Oh, what pleasure, jaja...
    sql1
    sql2
    Thank you so much one more time @osiris4isis !!

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

    Default

    The interesting thing would be to create a tool to convert .DB to GPX and GPX to .DB. ¿Some volunteer programmer?
    Edit and convert GPX trails in the end to .DB.
    Basecamp should have implemented this option, like other GPS software, such as Land 8 or Oziexplorer.

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

    Default

    Quote Originally Posted by haute View Post
    The interesting thing would be to create a tool to convert .DB to GPX and GPX to .DB. ¿Some volunteer programmer?
    Edit and convert GPX trails in the end to .DB.
    Basecamp should have implemented this option, like other GPS software, such as Land 8 or Oziexplorer.
    db Garmin files don't contain lines, only points. I think is impossible extract tracks from it, only waypoints. And this I can make easily in the way I wrote....
    If someone can extract the tracks, perfect!! But for only waypoints any software is needed.
    What would be the reason for convert tracks to db format?

    [Only registered and activated users can see links. ]

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

    Default

    Have db only points but it is correct.
    There is a start point and an end point, which form a node line. After this line is another line formed by in initial and one final point.
    So you're creating a path linking points.
    We have 6 or more points. The db file on each line orders it so.
    1 to 2
    2 to 3
    3 to 4
    4 to 5
    5 to 6
    6 to ...
    e470b9bfdf65a5fe6f1b8edecae8b73f
    it is a example.
    10068 is id trail (V.V. de Piquillo) Topo Spain V6 Pro
    Node origen to node destine
    507834 to 175196
    175196 to 175215
    175215 to 175226
    175226 to 175237
    175237 to 386262
    This trail is defined only by 5 node points.

    trail db format is similar that route, use the autorouter dbase for print the trail
    Last edited by haute; 7th September 2016 at 15:34.

  9. #38
    Important User

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

    Default

    This thread is about extracting and building routes, so it's possible. I think I already asked, but I will again Please post your *.db and I'll look into it.

    BTW, congrats
    Spoiler: Dancing in the Street

    [Only registered and activated users can see links. ]
    Last edited by osiris4isis; 7th September 2016 at 20:22.
    "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. #39
    Member
    Join Date
    Jul 2016
    Location
    spain
    Posts
    13
    Rep Power
    0

    Default

    Its all too much easy... In Basecamp you can view a list of named trails simply from menú Find...Named Trails. Then, select the desired trail we can convert It in route and then in track. That's all.

    [Only registered and activated users can see links. ]
    Last edited by vadiniense; 8th September 2016 at 13:26.

  11. #40
    Junior Member
    Join Date
    Aug 2016
    Location
    London
    Posts
    1
    Rep Power
    0

    Default

    Is there any way to make a route or track exactly like a trail named in basecamp?

 

 
Page 4 of 5 FirstFirst ... 2345 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.