Database format - Revision history

Admin: Admin moved page Menu map view to Database format

2024-11-22T13:18:20Z

Admin moved page Menu map view to Database format

Admin: /* Cells database: */

2024-11-22T13:15:46Z

‎Cells database:

Admin: /* Columns present in database: */

2024-11-22T13:14:33Z

‎Columns present in database:

Admin: /* How to Open the Cells CSV: */

2018-07-10T07:35:31Z

‎How to Open the Cells CSV:

Admin: /* Cells database: */

2018-04-25T16:48:44Z

‎Cells database:

Admin at 10:13, 25 April 2018

2018-04-25T10:13:38Z

Admin: /* Cells database: */

2018-04-25T10:01:52Z

‎Cells database:

Admin at 10:00, 25 April 2018

2018-04-25T10:00:28Z

Admin at 09:33, 25 April 2018

2018-04-25T09:33:50Z

Admin at 08:11, 7 February 2018

2018-02-07T08:11:22Z

@@ Line 5: / Line 5: @@
 ===Cells database:===
-The entire worldwide dataset of cell towers can be downloaded from http://opencellid.org/downloads
+The dataset can be downloaded from https://opencellid.org/downloads
 A valid e-mail address is required to register for an API key; this e-mail address will neither be sold nor be distributed to a third party.
-  - The file is updated on a daily basis
+  - The file is updated on a daily basis and includes cell towers observed in the last 18 months
   - Each token will be able to download only twice per day
   - The database is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

@@ Line 18: / Line 18: @@
 ===Columns present in database:===
 {| class="wikitable sortable" style="font-size: 85%; text-align: left;"
 |-
 ! scope="col" | Parameter
 ! scope="col" | Description
 |-
-| title=Parameter | Radio
+| title="Parameter" | <radio>
-| title="Rules" | The generation of broadband cellular network technology (Eg. LTE, GSM)
+| title="Data type" | string
 |-
-| title="Parameter" | MCC
+| title="Parameter" | <mcc>
-| title="Rules" | Mobile country code. This info is publicly shared by International Telecommunication Union [https://en.wikipedia.org/wiki/Mobile_country_code (link)]
+| title="Data type" | integer
 |-
-| title="Parameter" | MNC
+| title="Parameter" | <net>
-| title="Rules" | Mobile network code. This info is publicly shared by International Telecommunication Union [https://en.wikipedia.org/wiki/Mobile_country_code (link)]
+| title="Data type" | integer
 |-
-| title="Parameter" | LAC/TAC/NID
+| title="Parameter" | <area>
-| title="Rules" | Location Area Code
+| title="Data type" | integer
 |-
-| title="Parameter" | CID
+| title="Parameter" | <cell>
-| title="Rules" | This is a unique number used to identify each Base transceiver station or sector of BTS
+| title="Data type" | integer
 |-
-| title="Parameter" | Longitude
+| title="Parameter" | <unit>
-| title="Rules" | Longitude, is a geographic coordinate that specifies the east-west position of a point on the Earth's surface
+| title="Data type" | integer
 |-
-| title="Parameter" | Longitude
+| title="Parameter" | <lon>
-| title="Rules" | Latitude is a geographic coordinate that specifies the north–south position of a point on the Earth's surface.
+| title="Data type" | double
 |-
-| title="Parameter" | Range
+| title="Parameter" | <lat>
-| title="Rules" | Approximate area within which the cell could be. (In meters)
+| title="Data type" | double
 |-
-| title="Parameter" | Samples
+| title="Parameter" | <range>
-| title="Rules" | Number of measures processed to get a particular data point
+| title="Data type" | integer
 |-
-| title="Parameter" | Changeable=1
+| title="Parameter" | <samples>
-| title="Rules" |  The location is determined by processing samples
+| title="Data type" | integer
 |-
-| title="Parameter" | Changeable=0
+| title="Parameter" | <changeable>
-| title="Rules" | The location is directly obtained from the telecom firm
+| title="Data type" | integer
 |-
-| title="Parameter" | Created
+| title="Parameter" | <created>
-| title="Rules" | When a particular cell was first added to database (UNIX timestamp)
+| title="Data type" | integer
 |-
-| title="Parameter" | Updated
+| title="Parameter" | <updated>
-| title="Rules" | When a particular cell was last seen (UNIX timestamp)
+| title="Data type" | integer
 |-
-| title="Parameter" | AverageSignal
+| title="Parameter" | <averageSignal>
-| title="Rules" | To get the positions of cells, OpenCelliD processes measurements from data contributors. Each measurement includes GPS location of device + Scanned cell identifier (MCC-MNC-LAC-CID) + Other device properties (Signal strength). In this process, signal strength of the device is averaged. Most ‘averageSignal’ values are 0 because OpenCelliD simply didn’t receive signal strength values.
+| title="Data type" | integer
 |}

@@ Line 70: / Line 70: @@
 The OpenCelliD cells database is available for download in the form of a ~900mb zipped file. On unzipping the file, the database comes down to a ~3.3 gb CSV. You’ll not be able to view/ work on this via excel as the file is too large for Microsoft Excel to handle. Microsoft Excel has an official limit of about 1 million rows. You have the following options:
   - Use a programming language (Python, R, VBA etc..)
   - Use a database (MS Access, SQL etc..)

@@ Line 9: / Line 9: @@
 A valid e-mail address is required to register for an API key; this e-mail address will neither be sold nor be distributed to a third party.
-  - The file is updated on a daily basis<br>
+  - The file is updated on a daily basis
-  - Each token will be able to download only twice per day<br>
+  - Each token will be able to download only twice per day
-  - The database is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License<br>
+  - The database is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License
 ===Signup:===

@@ Line 14: / Line 14: @@
 ===Signup:===
-You can signup for a key at http://opencellid.org/
+You can signup for a key at https://opencellid.org/
 ===Columns present in database:===
@@ Line 65: / Line 65: @@
 | title="Rules" | To get the positions of cells, OpenCelliD processes measurements from data contributors. Each measurement includes GPS location of device + Scanned cell identifier (MCC-MNC-LAC-CID) + Other device properties (Signal strength). In this process, signal strength of the device is averaged. Most ‘averageSignal’ values are 0 because OpenCelliD simply didn’t receive signal strength values.
 |}
 <!-- <s>

← Older revision	Revision as of 13:18, 22 November 2024
(No difference)

@@ Line 15: / Line 15: @@
 You can signup for a key at http://opencellid.org/
-<s>
+<!-- <s>
 ===map view===
 {| cellpadding="10" cellspacing="0" border="1" width=998px style="border: 2px solid lightgrey;"
@@ Line 525: / Line 525: @@
 </s>

@@ Line 295: / Line 295: @@
 <br>
 <br>
 ===database===
 {|style="font-size:100% border-collapse:collapse"; text-align="left" border="1" width="998px" cellspacing="0" cellpadding="0" style="border: 2px solid lightgrey;"
 |style="width:220px" | [[File:Menu database.png|220px]]
@@ Line 423: / Line 421: @@
 |}
 ===cell_towers.csv and cell_towers_diff-*.csv.gz files format===
@@ Line 526: / Line 523: @@
   |}
 |}