Difference between revisions of "Menu map view"

From OpenCellID wiki
Jump to: navigation, search
m (How to Open the Cells CSV:)
 
(22 intermediate revisions by 4 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 70: Line 143:
  
 
<b>MCC</b><br>
 
<b>MCC</b><br>
If selected, only cells of the selected country will be displayed.  
+
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#MCC_-_Mobile_Country_Code|Mobile Country Code]] will be displayed.  
+
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 160:
 
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 119: Line 194:
  
 
{|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;"
|style="width:220px" | [[File:Menu heat map.png|318px]]
+
|style="width:220px" | [[File:Menu heat map.png|220px]]
 
|
 
|
 
  {|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"  
 
  {|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"  
Line 148: Line 223:
  
 
{|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;"
|style="width:220px" | [[File:Menu_statistics_cells.png |318px]]
+
|style="width:220px" | [[File:Menu_statistics_cells.png |220px]]
 
|
 
|
 
  {|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
 
  {|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
Line 168: Line 243:
 
the calender days are sorted descending (latest date on the left side of the bar chart).
 
the calender days are sorted descending (latest date on the left side of the bar chart).
  
<b>total cells per month</b><br>
+
<b>total amount of cells per month</b><br>
 
This shows the total number of discovered cells per calender month;
 
This shows the total number of discovered cells per calender month;
 
the calender months are sorted ascending (latest date on the right side of the bar chart).
 
the calender months are sorted ascending (latest date on the right side of the bar chart).
Line 184: Line 259:
  
 
<b>MCC</b><br>
 
<b>MCC</b><br>
If selected, only cells of the selected country will be displayed.  
+
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 <u>[[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]]</u> will be displayed.
+
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 307:
  
 
<b>MCC</b><br>
 
<b>MCC</b><br>
If selected, only measurements of the selected country will be displayed.  
+
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 measurements of networks with the selected <u>[[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]]</u> will be displayed.
+
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 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 290: Line 366:
 
  | [[File:OpenCellID_sign_in_on_download_page.png|220px]]<br><br><br><br><br><br><br><br><br><br><br><br>[[File:OpenCellID_download_database_file_list.png|220px]]
 
  | [[File:OpenCellID_sign_in_on_download_page.png|220px]]<br><br><br><br><br><br><br><br><br><br><br><br>[[File:OpenCellID_download_database_file_list.png|220px]]
 
  | This menu option allows you to download the entire database. The files are updated every night. For the measurements files the nightly update is created only for the file with the highest sequence number because the other files don´t change anymore.<br>In very rare cases we recreate all files.
 
  | This menu option allows you to download the entire database. The files are updated every night. For the measurements files the nightly update is created only for the file with the highest sequence number because the other files don´t change anymore.<br>In very rare cases we recreate all files.
 +
 +
Besides, there are periodic cells files with cells created or updated during one hour. Each such file is available 3 days and then it is deleted.
  
 
The API key is obligatory for downloading data.
 
The API key is obligatory for downloading data.
You can download cell_towers.csv.gz and last_measurements.csv.gz only once per day for free. The rest of files you can download more than once per day but you will have to pass CAPTCHA validation.
+
You can download periodic cells files (cell_towers_diff-*.csv.gz) 3 times per day, cell_towers.csv.gz and last_measurements.csv.gz only once per day for free. The rest of files you can download more than once per day but you will have to pass CAPTCHA validation.
 +
 
 +
In case you launched the download page directly thru [http://opencellid.org/downloads/] you need to enter your API key (see screenhsot on the left side).
 +
 
 +
The cell tower data file provided at [http://opencellid.org/downloads/] changes once per day at approx. 3am (UTC time) and can be downloaded once per day per API key.
 +
 
 +
The periodic cells files provided at [http://opencellid.org/downloads/] are created every hour. Creation datetime (UTC time) is included in the filename in following format: yyyymmddhh. You can download each of these files automatically (without CAPTCHA validation) maximum 3 times per day.
 +
 
 +
The export format for CSV cells files was created in collaboration with the [http://location.services.mozilla.com/ Mozilla Location Service] project.
 +
 
 +
Most of the measurements files provided at [http://opencellid.org/downloads/] do not change at all. Just the measurements file with the latest data changes once per day at approx. 3am (UTC time).
  
In case you launched the download page directly thru [http://opencellid.org/downloads/] you need to enter your API key (see screenhsot on the left side).<br><br>File formats:<br>
+
Therefore only the measurement file with the latest data can be downloaded automatically once per day per API key.<br>
 +
All other measurements files must be downloaded manually.<br><br>File formats:<br>
  
=== measurements_? CSV file format===
+
=== measurements_* CSV file format===
 
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
 
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
 
|-
 
|-
Line 305: Line 394:
 
| title="Parameter" | <mcc>
 
| title="Parameter" | <mcc>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Mobile country code
+
| title="Description" | Mobile Country Code, for example 260 for Poland.
 
|-
 
|-
| title="Parameter" | <mnc>
+
| title="Parameter" | <net>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Mobile network code
+
| title="Description" | For GSM, UMTS and LTE networks, this is the Mobile Network Code (MNC).<br>For CDMA networks, this is the System IDentification number (SID).
 
|-
 
|-
| title="Parameter" | <lac>
+
| title="Parameter" | <area>
 
| title="Data type" | integer  
 
| title="Data type" | integer  
| title="Description" | Local area code
+
| title="Description" | Location Area Code (LAC) for GSM and UMTS networks.<br>Tracking Area Code (TAC) for LTE networks.<br>Network IDenfitication number (NID) for CDMA networks.
 
|-
 
|-
| title="Parameter" | <cellid>
+
| title="Parameter" | <cell>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Cell tower id
+
| title="Description" | Cell ID (CID) for GSM and LTE networks.<br>UTRAN Cell ID / LCID for UMTS networks, which is the concatenation of 2 or 4 bytes of Radio Network Controller (RNC) code and 4 bytes of Cell ID.<br>Base station IDentifier number (BID) for CDMA networks.
 
|-
 
|-
 
| title="Parameter" | <lon>
 
| title="Parameter" | <lon>
 
| title="Data type" | double
 
| title="Data type" | double
| title="Description" | Longitude
+
| 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
+
| title="Description" | Latitude in degrees between -90.0 and 90.0
 
|-
 
|-
 
| title="Parameter" | <signal>
 
| title="Parameter" | <signal>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Signal level<br>either in dBm or as defined in TS 27.007 8.5; both is accepted.
+
| title="Description" | Signal level<br>either in dBm or as defined in TS 27.007 8.5 - both is accepted.
 
|-
 
|-
| title="Parameter" | <measured_at>
+
| title="Parameter" | <measured>
| title="Data type" | date
+
| title="Data type" | integer
| title="Description" | When the measurement was measured.<br>Returns a date in timestamp format:<br>milliseconds since 1/1/1970 00:00:00 GMT;<br>time zone: UTC
+
| title="Description" | When the measurement was measured.<br>A date in timestamp format:<br>number of seconds since the UTC Unix Epoch of 1970-01-01T00:00:00Z<br>For example 1409522613 is the timestamp for 2014-08-31T22:03:33Z.
 
|-
 
|-
| title="Parameter" | <created_at>
+
| title="Parameter" | <created>
| title="Data type" | date
+
| title="Data type" | integer
| title="Description" | When the measurement was added to OpenCellID database.<br>Returns a date in timestamp format:<br>milliseconds since 1/1/1970 00:00:00 GMT;<br>time zone: UTC
+
| title="Description" | When the measurement was added to OpenCellID database.<br>A date in timestamp format:<br>number of seconds since the UTC Unix Epoch of 1970-01-01T00:00:00Z<br>For example 1409522613 is the timestamp for 2014-08-31T22:03:33Z.
 
|-
 
|-
 
| title="Parameter" | <rating>
 
| title="Parameter" | <rating>
Line 350: Line 439:
 
| title="Data type" | double
 
| title="Data type" | double
 
| title="Description" | Heading direction of the phone / telematics device at the moment the measurement was created (0=north, 90=east, 180=south, 270=west)
 
| title="Description" | Heading direction of the phone / telematics device at the moment the measurement was created (0=north, 90=east, 180=south, 270=west)
 +
|-
 +
| title="Parameter" | <radio>
 +
| title="Data type" | string
 +
| title="Description" | Network type. One of the strings GSM, UMTS, LTE or CDMA.
 +
|-
 +
| title="Parameter" | <ta>
 +
| title="Data type" | integer
 +
| title="Description" | Timing advance; only for GSM and LTE
 +
|-
 +
| title="Parameter" | <rnc>
 +
| title="Data type" | integer
 +
| title="Description" | Radio network controller; only for UMTS
 +
|-
 +
| title="Parameter" | <cid>
 +
| title="Data type" | integer
 +
| title="Description" | Cell id (short); only for UMTS
 +
|-
 +
| title="Parameter" | <psc>
 +
| title="Data type" | integer
 +
| title="Description" | Primary scrambling code; only for UMTS
 +
|-
 +
| title="Parameter" | <tac>
 +
| title="Data type" | integer
 +
| title="Description" | Tracking area code; only for LTE
 +
|-
 +
| title="Parameter" | <pci>
 +
| title="Data type" | integer
 +
| title="Description" | Physical cell id; only for LTE
 +
|-
 +
| title="Parameter" | <sid>
 +
| title="Data type" | integer
 +
| title="Description" | System identifier; only for CDMA
 +
|-
 +
| title="Parameter" | <nid>
 +
| title="Data type" | integer
 +
| title="Description" | Network id; only for CDMA
 +
|-
 +
| title="Parameter" | <bid>
 +
| title="Data type" | integer
 +
| title="Description" | Base station id; only for CDMA
 
|}
 
|}
  
===cell_towers.csv file format===
+
 
 +
===cell_towers.csv and cell_towers_diff-*.csv.gz files format===
 
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
 
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
 
|-
 
|-
Line 358: Line 488:
 
! scope="col" | Data type
 
! scope="col" | Data type
 
! scope="col" | Description
 
! scope="col" | Description
 +
|-
 +
| title="Parameter" | <radio>
 +
| title="Data type" | string
 +
| title="Description" | Network type. One of the strings GSM, UMTS, LTE or CDMA.
 
|-
 
|-
 
| title="Parameter" | <mcc>
 
| title="Parameter" | <mcc>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Mobile country code
+
| title="Description" | Mobile Country Code, for example 260 for Poland.
 
|-
 
|-
| title="Parameter" | <mnc>
+
| title="Parameter" | <net>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Mobile network code
+
| title="Description" | For GSM, UMTS and LTE networks, this is the Mobile Network Code (MNC).<br>For CDMA networks, this is the System IDentification number (SID).
 
|-
 
|-
| title="Parameter" | <lac>
+
| title="Parameter" | <area>
 
| title="Data type" | integer  
 
| title="Data type" | integer  
| title="Description" | Local area code
+
| title="Description" | Location Area Code (LAC) for GSM and UMTS networks.<br>Tracking Area Code (TAC) for LTE networks.<br>Network IDenfitication number (NID) for CDMA networks.
 +
|-
 +
| title="Parameter" | <cell>
 +
| title="Data type" | integer
 +
| title="Description" | Cell ID (CID) for GSM and LTE networks.<br>UTRAN Cell ID / LCID for UMTS networks, which is the concatenation of 2 or 4 bytes of Radio Network Controller (RNC) code and 4 bytes of Cell ID.<br>Base station IDentifier number (BID) for CDMA networks.
 
|-
 
|-
| title="Parameter" | <cellid>
+
| title="Parameter" | <unit>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Cell tower id
+
| title="Description" | Primary Scrambling Code (PSC) for UMTS networks.<br>Physical Cell ID (PCI) for LTE networks. An empty value for GSM and CDMA networks.
 
|-
 
|-
 
| title="Parameter" | <lon>
 
| title="Parameter" | <lon>
 
| title="Data type" | double
 
| title="Data type" | double
| title="Description" | Longitude<br>changeable=1: average of longitude values of all related measurements<br>changeable=0: exact GPS position of the tower
+
| title="Description" | Longitude in degrees between -180.0 and 180.0<br>changeable=1: average of longitude values of all related measurements<br>changeable=0: exact GPS position of the cell tower
 
|-
 
|-
 
| title="Parameter" | <lat>
 
| title="Parameter" | <lat>
 
| title="Data type" | double
 
| title="Data type" | double
| title="Description" | Latitude<br>changeable=1: average of latitude values of all related measurements<br>changeable=0: exact GPS position of the tower
+
| title="Description" | Latitude in degrees between -90.0 and 90.0<br>changeable=1: average of latitude values of all related measurements<br>changeable=0: exact GPS position of the tower
 +
|-
 +
| title="Parameter" | <range>
 +
| title="Data type" | integer
 +
| title="Description" | Estimate of cell range, in meters.
 
|-
 
|-
 
| title="Parameter" | <samples>
 
| title="Parameter" | <samples>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Number of measurements assigned to the cell tower  
+
| title="Description" | Total number of measurements assigned to the cell tower  
 
|-
 
|-
 
| title="Parameter" | <changeable>
 
| title="Parameter" | <changeable>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Defines if coordinates of the cell tower are exact or approximate;<br>1: the GPS position of the cell tower has been calculated from all available measurements<br>0: the GPS position of the cell tower is precise; no measurements have been used to calculate it.
+
| title="Description" | Defines if coordinates of the cell tower are exact or approximate.<br>changeable=1: the GPS position of the cell tower has been calculated from all available measurements<br>changeable=0: the GPS position of the cell tower is precise - no measurements have been used to calculate it.
 
|-
 
|-
| title="Parameter" | <created_at>
+
| title="Parameter" | <created>
| title="Data type" | date
+
| title="Data type" | integer
| title="Description" | When the cell tower was added to the OpenCellID database.<br>Returns a date in timestamp format:<br>milliseconds since 1/1/1970 00:00:00 GMT<br>time zone: UTC
+
| title="Description" | The first time when the cell tower was seen and added to the OpenCellID database.<br>A date in timestamp format:<br>number of seconds since the UTC Unix Epoch of 1970-01-01T00:00:00Z<br>For example 1409522613 is the timestamp for 2014-08-31T22:03:33Z.
 
|-
 
|-
| title="Parameter" | <updated_at>
+
| title="Parameter" | <updated>
| title="Data type" | date
+
| title="Data type" | integer
| title="Description" | When was the last update of the cell tower.<br>Returns a date in timestamp format:<br>(milliseconds since 1/1/1970 00:00:00 GMT<br>time zone: UTC
+
| title="Description" | The last time when the cell tower was seen and update.<br>A date in timestamp format:<br>number of seconds since the UTC Unix Epoch of 1970-01-01T00:00:00Z<br>For example 1409522613 is the timestamp for 2014-08-31T22:03:33Z.
 
|-
 
|-
 
| title="Parameter" | <averageSignal>
 
| title="Parameter" | <averageSignal>
 
| title="Data type" | integer
 
| title="Data type" | integer
| title="Description" | Average signal level of assigned measurements<br>either in dBm or as defined in TS 27.007 8.5; both is accepted.
+
| title="Description" | Average signal strength from all assigned measurements for the cell.<br>Either in dBm or as defined in TS 27.007 8.5 - both is accepted.
 
|}
 
|}
  
Line 431: Line 573:
  
 
  |- style="background-color:#dddddd;"
 
  |- style="background-color:#dddddd;"
  | [[File:OpenCellID_forgot_apiKey.png]]
+
  | [[File:OpenCellID_retrieve_apiKey.png]]
  | [[File:Menu database_upload.png|220px]]  
+
  | [[File:OpenCellID_forgot_apiKey.png|220px]]
  | This menu option allows you to get your forgotten [[API#apiKey|API key]] back. You need to provide your email address you used during the registration of the [[API#apiKey|API key]]. An email will be sent to you with your [[API#apiKey|API key]].
+
  | This menu option allows you to get your forgotten [[API#apiKey|API key]] back.
 +
 
 +
You need to provide your email address you used during the registration of the [[API#apiKey|API key]].
 +
 
 +
An email will be sent to you with your [[API#apiKey|API key]].
  
 
  |}
 
  |}
 
|}
 
|}
 +
 +
</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