Difference between revisions of "Menu map view"
From OpenCellID wiki
(Update for the newest 3.4.0 version) |
(→Cells database:) |
||
(13 intermediate revisions by 3 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 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 70: | Line 142: | ||
<b>MCC</b><br> | <b>MCC</b><br> | ||
− | If selected, only cells of the selected | + | If selected, only cells of networks with the selected [[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]] will be displayed. |
<b>MNC</b><br> | <b>MNC</b><br> | ||
− | If selected, only cells of networks with the selected [[Glossary# | + | If selected, only cells of networks with the selected [[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]] will be displayed. |
|- | |- | ||
|[[File:OpenCellID recently uploaded measurements.png|link=|link=http://opencellid.org/#&action=filters.recentlyUploadedBaseStationMeasurements&time=24]] | |[[File:OpenCellID recently uploaded measurements.png|link=|link=http://opencellid.org/#&action=filters.recentlyUploadedBaseStationMeasurements&time=24]] | ||
Line 87: | Line 159: | ||
Example:<br> | Example:<br> | ||
If at 12:13:59 a time frame of 22 hours is selected, then 10:13:59 (not 10:00:00) until 12:13:59 would be the selected time frame. | If at 12:13:59 a time frame of 22 hours is selected, then 10:13:59 (not 10:00:00) until 12:13:59 would be the selected time frame. | ||
+ | |||
+ | You can always check with [[API#Listing a user's measurements]] to see if all your points were really uploaded. | ||
|- style="background-color:#dddddd;" | |- style="background-color:#dddddd;" | ||
|[[File:OpenCellID measurements of a selected GSM base station.png]] | |[[File:OpenCellID measurements of a selected GSM base station.png]] | ||
Line 184: | Line 258: | ||
<b>MCC</b><br> | <b>MCC</b><br> | ||
− | If selected, only cells of the selected | + | If selected, only cells of networks with the selected [[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]] will be displayed. |
<b>MNC</b><br> | <b>MNC</b><br> | ||
− | If selected, only cells of networks with the selected | + | If selected, only cells of networks with the selected [[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]] will be displayed. |
− | + | |} | |
|} | |} | ||
<br> | <br> | ||
Line 232: | Line 306: | ||
<b>MCC</b><br> | <b>MCC</b><br> | ||
− | If selected, only | + | If selected, only cells of networks with the selected [[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]] will be displayed. |
<b>MNC</b><br> | <b>MNC</b><br> | ||
− | If selected, only | + | If selected, only cells of networks with the selected [[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]] will be displayed. |
− | + | |} | |
|} | |} | ||
<br> | <br> | ||
Line 282: | Line 356: | ||
===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 334: | Line 409: | ||
| 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 404: | Line 479: | ||
| 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 506: | Line 582: | ||
|} | |} | ||
|} | |} | ||
+ | |||
+ | </s> | ||
+ | --> |
Revision as of 22:18, 25 April 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 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