SQLite structure

Started by RedSpawn, June 15, 2011, 11:55:06

0 Members and 2 Guests are viewing this topic.

RedSpawn

I'm making a tool to load a geocaching .gpx file on my PC and add missing map-tiles to the sqlite databases.

The structure of the tables is easy enough, but what is the "s" row in the tiles table?
  •  

Menion

#1
hi,
  s column was in this database since begin. I use I think structure from RMaps or similar program. Because I also do not have any idea why is there s column, I use it for storing number of hours since 1.1.2011 that tile was added to database. Good value for checking oldness of tiles and ability to refresh them ...
- Official help (ideas, questions, problems): help.locusmap.eu
- Advanced topics, sharing of knowledges: you're here!
- LM 4 Beta download, LM 4 Release download
  •  

RedSpawn

#2
thanks for the quick reply!
i'll fill in the corresponding information....

i want to congratulate you to Locus, this really is a nice piece of software!
i'm planing on using it for geocaching since it is the only one that allows for custom- (private-) servers and shows much potential with its addons-function.

i'm going to start some threads concerning geocaching and sqlite  :twisted:
  •  

Menion

#3
fine, you're welcome. Anyway when you want download only data around geocaching points, you may use downloading function where you define poi category and radius and locus will download this by itself. Anyway some posts about Geocaching and maps etc. are of course welcome
- Official help (ideas, questions, problems): help.locusmap.eu
- Advanced topics, sharing of knowledges: you're here!
- LM 4 Beta download, LM 4 Release download
  •  

RedSpawn

#4
nice! that's exactly what i want to do!
at least i guess so since i haven't bought pro yet  ;)

but i still continue work on my tool because downloads are going to be faster on desktop pc.
unless there is an option to change the speed limit (2 tiles at once) for custom servers?
but i guess you better not allow this or there will be banning from the map servers..
  •  

Menion

#5
:) nono there is no chance to actually change limit of downloading threads. And you're correct. Downloading on PC is of course faster. Question is if time you have to invest for this, cannot be invested better :). But it's up to you. Good luck
- Official help (ideas, questions, problems): help.locusmap.eu
- Advanced topics, sharing of knowledges: you're here!
- LM 4 Beta download, LM 4 Release download
  •  

RedSpawn

#6
i already made a tool to download maptiles for my old WindowsMobile phone...

now it's working for Locus:
downloading 2000 tiles and adding to Locus database: 42sec
just adding 2000 tiles from cache to database: 16sec

wooohoooooo  :D
  •