No subject


Thu Jan 8 07:27:53 CET 2009


(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

--0016e65097fe633e8d04604eb15a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Stefan,<br><br>I have to work-out the license issue as you mentioned. I rea=
lly started from the OSM one...<br>even if I have seen all the discussions =
about it.<br>I am ready to consider all the solutions to solve this license=
 problem.<br>
<br><br>&gt;So you get the confirmation that the opencellid data is also un=
der cc-at-sa?<br>&gt;We did not found a concrete statement about it and Dan=
iel already sent them a<br>&gt;mail to clarify it.<br><br>When I started <a=
 href=3D"http://www.openBmap.org">http://www.openBmap.org</a> and until a f=
ew weeks ago,<br>
there was no mention about the data license on opencellid website.<br>(and =
impossible to reach them...)<br><br>The other projects mentioned on<br><br>=
<a href=3D"http://en.wikipedia.org/wiki/GSM_localization">http://en.wikiped=
ia.org/wiki/GSM_localization</a><br>
<br>did not mention their license too.<br><br>As the logo creative commons =
appears now on the opencellid website, I have decided<br>to import their da=
ta in my database. I will still able to erase their data if needed...<br>
<br>Anyway, it will help me to raise scalability issues and define&nbsp; if=
 needed another design <br>for the mapping manager database.<br><br><br>&gt=
; The maps looks already quite nice, even if Germany is not in the db yet. =
;)<br>
<br>Thanks! and please have a look at the following url for zones in German=
y<br><br><a href=3D"http://realtimeblog.free.fr/maps/with_google_earth.php?=
mcc=3D262&amp;mnc=3D7&amp;step=3D2">http://realtimeblog.free.fr/maps/with_g=
oogle_earth.php?mcc=3D262&amp;mnc=3D7&amp;step=3D2</a><br>
or<br><a href=3D"http://realtimeblog.free.fr/cell_map.php?mcc=3D262&amp;mnc=
=3D7&amp;lac=3D&amp;cellid=3D&amp;display=3DDisplay">http://realtimeblog.fr=
ee.fr/cell_map.php?mcc=3D262&amp;mnc=3D7&amp;lac=3D&amp;cellid=3D&amp;displ=
ay=3DDisplay</a><br>
(please zoom out on Google maps to see Germany coverage for O2 operator)<br=
><br><br>&gt; Do you merge not only the data but also the projects? Having =
them co-exists with<br>&gt; the same goal is kinda pointless.<br><br>Becaus=
e <br>
1) the CC license seems &quot;all new&quot; to <a href=3D"http://opencellid=
.org">opencellid.org</a> <br>2) the way to calculate cellular &quot;average=
&quot; position and attributes are not the same...<br>3) the signal strengt=
hs are not stored at <a href=3D"http://opencellid.org">opencellid.org</a> s=
ide<br>
<br>I &#39;ll wait a little before considering a merge.<br><br><br>&gt; I l=
ike to have more data available. Can you give us some insight how big such<=
br>&gt; collections can grow. For example your current db size and the curr=
ent number of<br>
&gt; entries? I would like to have the option to have such a db on my SD ca=
rd for<br>&gt; offline use and syncing when on wifi or similar.<br><br>From=
 the information I have collected, there must be 50000 towers in France (sp=
read<br>
on 550000 km2) and I evaluate from 4 to 8 cells per tower for one operator.=
<br><br>It means from 200 000 to 400 000 entries in a database for one coun=
try (as large as France)<br>&nbsp;for one operator (to have the full countr=
y in local SD database)<br>
<br>For these 400 000 entries, you need to store <br>mcc/mnc/lac/cid and tw=
o double for latitude and longitude<br>(and perhaps other attributes such a=
s max radius...)<br><br>Probably you will not need the full country all the=
 time on your SD card. We probably can design<br>
a way to sync the local openmoko database with the openbmap database... On =
LAC basis for instance...<br><br>If you want to have a closer look at the c=
urrent local database<br>(I extracted the local database from the website),=
 please look at <br>
<br><a href=3D"http://realtimeblog.free.fr/latest/realtimeblog_23_12_2008.z=
ip">http://realtimeblog.free.fr/latest/realtimeblog_23_12_2008.zip</a><br><=
br>It is the SQL script containing all the cells (before opencellid merge)<=
br>
cell descriptions and the cell coordinates...<br><br>regards,<br>Nick<br><b=
r>

--0016e65097fe633e8d04604eb15a--



More information about the devel mailing list