1

enter image description herehow open file .sqlitedb in QGIS or ArcGIS? You can file convert? Database structure filesqlitedb is from DB Browser

enter image description here

closed as off-topic by Erik, whyzar, Hornbydd, xunilk, ahmadhanb Feb 13 at 6:35

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "When seeking help to debug/write/improve code always provide the desired behavior, a specific problem/error and the shortest code (as formatted text, not pictures) needed to reproduce it in the question body. Providing a clear problem statement and a code attempt helps others to help you." – Erik, whyzar, xunilk
If this question can be reworded to fit the rules in the help center, please edit the question.

  • You may have a try with Add vector layer. Your problem is most probably that you have some sort of SQLite database but it in not SpatiaLite database. Do you know from what software your data are? – user30184 Feb 12 at 13:21
  • This file *.sqlitedb is from navigation Locus for android. – Iv38 Feb 12 at 13:26
  • Are there any info available about the database structure that Locus is using or a sample database? – user30184 Feb 12 at 13:28
  • Welcome to GIS SE. As a new user, please take the tour. Please also edit your question to include what you've tried, where you've gotten stuck, and the text of any error messages. See How do I ask a good question? for useful info. – Andy Feb 12 at 13:37
  • database structure is under the title – Iv38 Feb 12 at 14:58
2

SQLiteDB can be the file extension of any SQLite database, which can in turn have map information stored in it in any number of ways.

However, the good news is that in this case, the table structure you posted seems identical with that of a tiled map generated by MOBAC (Mobile Atlas Creator) in RMaps or Galileo (now Guru) maps format. I note from https://mobac.sourceforge.io/faq.html that MOBAC can also be made to read such file formats (with a bit of fancy footwork with configuration files) and convert to a locally stored zipped set of tiles, or even easier an MBTiles format database that you should then be able to import into QGIS without any difficulty.

Of course, it's possible the Locus file format is a bit different, but MOBAC can read several different sqlitedb tile formats, so it's worth a try.

I'm not familiar with Locus since I don't use Android, but it seems its offline maps come from various sources (including OpenStreetMap), and I assume whatever GPS tracks or waypoints you may have added could be exported separately. So you could also explore going back to the source for the underlying basemap, importing that into QGIS directly, and then layering on your tracks/waypoints. But I'm making assumptions about what you're trying to do that may not be warranted.

  • Thank you for information. Mobile atlas creator can create file.sqlitedb from maps , not convert or open file.sqlitedb, can you help me? – Iv38 Feb 13 at 11:11
  • @lv38 According to mobac.sourceforge.io/MOBAC/README.HTM#FileBased (see the very last sentence at the end of the document, and example linked to there), it can be made to open sqlite in suitable formats. It does need creating/adapting your own xml settings file. – Houska Feb 13 at 15:11

Not the answer you're looking for? Browse other questions tagged or ask your own question.