Future of location services on OM

Nick realtimeblog at gmail.com
Mon Jan 12 21:27:34 CET 2009


sorry for the gmail glitch ! here is the end of my answer...

 > I like to have more data available. Can you give us some insight how 
big such
 > collections can grow. For example your current db size and the 
current number of
 > entries? I would like to have the option to have such a db on my SD 
card for
 > offline use and syncing when on wifi or similar.

 From the information I have collected, there must be 50000 towers in 
France (spread
on 550000 km2) and I evaluate from 4 to 8 cells per tower for one operator.

It means from 200 000 to 400 000 entries in a database for one country 
(as large as France)
for one operator (to have the full country in local SD database)

For these 400 000 entries, you need to store
mcc/mnc/lac/cid and two double for latitude and longitude
(and perhaps other attributes such as max radius...)

Probably you will not need the full country all the time on your SD 
card. We probably can design
a way to sync the local openmoko database with the openbmap database... 
On LAC basis for instance...

If you want to have a closer look at the current local database
(I extracted the local database from the website), please look at

http://realtimeblog.free.fr/latest/realtimeblog_23_12_2008.zip

It is the SQL script containing all the cells (before opencellid merge)
cell descriptions and the cell coordinates...

regards,
Nick




More information about the devel mailing list