SQLite structure

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

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

RedSpawn

June 15, 2011, 11:55:06 Last Edit: January 01, 1970, 01:00:00 by Guest
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
June 15, 2011, 13:33:55 Last Edit: January 01, 1970, 01:00:00 by Guest
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
June 15, 2011, 15:02:51 Last Edit: January 01, 1970, 01:00:00 by Guest
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
June 15, 2011, 15:06:24 Last Edit: January 01, 1970, 01:00:00 by Guest
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
June 15, 2011, 15:45:05 Last Edit: January 01, 1970, 01:00:00 by Guest
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
June 15, 2011, 16:06:29 Last Edit: January 01, 1970, 01:00:00 by Guest
:) 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
June 15, 2011, 23:36:26 Last Edit: January 01, 1970, 01:00:00 by Guest
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
  •  
Print
Go Up Pages1
User actions