Difference between revisions of "Menu map view"
From OpenCellID wiki
(no bug) |
m (→How to Open the Cells CSV:) |
||
(11 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
|} | |} | ||
+ | ===Cells database:=== | ||
+ | |||
+ | The entire worldwide dataset of cell towers can be downloaded from http://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 | ||
+ | - 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 | ||
+ | |||
+ | ===Signup:=== | ||
+ | You can signup for a key at https://opencellid.org/ | ||
+ | |||
+ | ===Columns present in database:=== | ||
+ | |||
+ | {| class="wikitable sortable" style="font-size: 85%; text-align: left;" | ||
+ | |- | ||
+ | ! scope="col" | Parameter | ||
+ | ! scope="col" | Description | ||
+ | |- | ||
+ | | title=Parameter | Radio | ||
+ | | title="Rules" | The generation of broadband cellular network technology (Eg. LTE, GSM) | ||
+ | |- | ||
+ | | 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="Parameter" | MNC | ||
+ | | title="Rules" | Mobile network code. This info is publicly shared by International Telecommunication Union [https://en.wikipedia.org/wiki/Mobile_country_code (link)] | ||
+ | |- | ||
+ | | title="Parameter" | LAC/TAC/NID | ||
+ | | title="Rules" | Location Area Code | ||
+ | |- | ||
+ | | title="Parameter" | CID | ||
+ | | title="Rules" | This is a unique number used to identify each Base transceiver station or sector of BTS | ||
+ | |- | ||
+ | | title="Parameter" | Longitude | ||
+ | | title="Rules" | Longitude, is a geographic coordinate that specifies the east-west position of a point on the Earth's surface | ||
+ | |- | ||
+ | | title="Parameter" | Longitude | ||
+ | | title="Rules" | Latitude is a geographic coordinate that specifies the north–south position of a point on the Earth's surface. | ||
+ | |- | ||
+ | | title="Parameter" | Range | ||
+ | | title="Rules" | Approximate area within which the cell could be. (In meters) | ||
+ | |- | ||
+ | | title="Parameter" | Samples | ||
+ | | title="Rules" | Number of measures processed to get a particular data point | ||
+ | |- | ||
+ | | title="Parameter" | Changeable=1 | ||
+ | | title="Rules" | The location is determined by processing samples | ||
+ | |- | ||
+ | | title="Parameter" | Changeable=0 | ||
+ | | title="Rules" | The location is directly obtained from the telecom firm | ||
+ | |- | ||
+ | | title="Parameter" | Created | ||
+ | | title="Rules" | When a particular cell was first added to database (UNIX timestamp) | ||
+ | |- | ||
+ | | title="Parameter" | Updated | ||
+ | | title="Rules" | When a particular cell was last seen (UNIX timestamp) | ||
+ | |- | ||
+ | | 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. | ||
+ | |} | ||
+ | |||
+ | ===How to Open the Cells CSV:=== | ||
+ | |||
+ | 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 'Data Tools' in Microsoft Excel. ('Data' Tab > 'Get Data') | ||
+ | - Use a programming language (Python, R, VBA etc..) | ||
+ | - Use a database (MS Access, SQL etc..) | ||
+ | - Use a software ([http://recsveditor.sourceforge.net/ reCsvEdit], [http://www.csvviewer.com/ CSV Viewer] etc...) You can find a quick guide [https://community.opencellid.org/t/how-to-extract-specific-cells-from-the-opencellid-csv-database/183 here] | ||
+ | |||
+ | <!-- <s> | ||
===map view=== | ===map view=== | ||
{| cellpadding="10" cellspacing="0" border="1" width=998px style="border: 2px solid lightgrey;" | {| cellpadding="10" cellspacing="0" border="1" width=998px style="border: 2px solid lightgrey;" | ||
Line 284: | Line 357: | ||
===database=== | ===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="font-size:100% border-collapse:collapse"; text-align="left" border="1" width="998px" cellspacing="0" cellpadding="0" style="border: 2px solid lightgrey;" | ||
Line 336: | Line 410: | ||
| title="Parameter" | <lon> | | title="Parameter" | <lon> | ||
| title="Data type" | double | | title="Data type" | double | ||
− | | title="Description" | Longitude in degrees between -180.0 and 180.0 | + | | title="Description" | Longitude in degrees between -180.0 and 180.0 |
|- | |- | ||
| title="Parameter" | <lat> | | title="Parameter" | <lat> | ||
| title="Data type" | double | | title="Data type" | double | ||
− | | title="Description" | Latitude in degrees between -90.0 and 90.0 | + | | title="Description" | Latitude in degrees between -90.0 and 90.0 |
|- | |- | ||
| title="Parameter" | <signal> | | title="Parameter" | <signal> | ||
Line 406: | Line 480: | ||
| title="Description" | Base station id; only for CDMA | | title="Description" | Base station id; only for CDMA | ||
|} | |} | ||
+ | |||
===cell_towers.csv and cell_towers_diff-*.csv.gz files format=== | ===cell_towers.csv and cell_towers_diff-*.csv.gz files format=== | ||
Line 508: | Line 583: | ||
|} | |} | ||
|} | |} | ||
+ | |||
+ | </s> | ||
+ | --> |
Latest revision as of 13:05, 10 July 2018
Cells database:
The entire worldwide dataset of cell towers can be downloaded from http://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 - 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
Signup:
You can signup for a key at https://opencellid.org/
Columns present in database:
Parameter | Description |
---|---|
Radio | The generation of broadband cellular network technology (Eg. LTE, GSM) |
MCC | Mobile country code. This info is publicly shared by International Telecommunication Union (link) |
MNC | Mobile network code. This info is publicly shared by International Telecommunication Union (link) |
LAC/TAC/NID | Location Area Code |
CID | This is a unique number used to identify each Base transceiver station or sector of BTS |
Longitude | Longitude, is a geographic coordinate that specifies the east-west position of a point on the Earth's surface |
Longitude | Latitude is a geographic coordinate that specifies the north–south position of a point on the Earth's surface. |
Range | Approximate area within which the cell could be. (In meters) |
Samples | Number of measures processed to get a particular data point |
Changeable=1 | The location is determined by processing samples |
Changeable=0 | The location is directly obtained from the telecom firm |
Created | When a particular cell was first added to database (UNIX timestamp) |
Updated | When a particular cell was last seen (UNIX timestamp) |
AverageSignal | 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. |
How to Open the Cells CSV:
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 'Data Tools' in Microsoft Excel. ('Data' Tab > 'Get Data') - Use a programming language (Python, R, VBA etc..) - Use a database (MS Access, SQL etc..) - Use a software (reCsvEdit, CSV Viewer etc...) You can find a quick guide here