Difference between revisions of "Menu map view"

From OpenCellID wiki
Jump to: navigation, search
(Created page with "500px |link=http://opencellid.org/#&action=filters.recentlyUploadedBaseStationMeasurements&time=24]]")
 
m (→‎How to Open the Cells CSV:)
 
(282 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
[[File:Opencellid statistics locations of cells.PNG|500px]]
+
{|align=right 
 +
|__TOC__
 +
|}
  
−
|link=http://opencellid.org/#&action=filters.recentlyUploadedBaseStationMeasurements&time=24]]
+
===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===
 +
{| cellpadding="10" cellspacing="0" border="1" width=998px style="border: 2px solid lightgrey;"
 +
| [[File:OpenCellID_map_view_cell_bubbles.png|400px]] || In most cases the map shows bubbles of different sizes and colour.
 +
 
 +
The bigger a bubble is, the more cells have been found close to this bubble.
 +
 
 +
Smaller bubbles are green, mid-sized bubbles are yellow, and larger bubbles are orange or red.
 +
 
 +
The screenshot shows a part of downtown Berlin, Germany, close to "Zoologischer Garten". This is an area with a high density of people living, working, and travelling there; therefore, many different cells can be found there.
 +
|-
 +
| [[File:OpenCellID_single_cells.png ‎|400px]] || Single cells are represented with these pushpin icons.<br>Most of the GSM networks have defined colours which are used for these pushpins.
 +
 
 +
Clicking on a pushpin will display additional information of the cell as well as the associated measurements (max. 500).
 +
|-
 +
| [[File:OpenCellID_single_cell_with_measurements.png|198px]]    [[File:OpenCellID_single_cell_with_measurements-2.png|198px]] || When clicking on a single cell, up to 500 measurements are displayed representing this cell.
 +
 
 +
Thin lines are shown between each measurement and the (averaged) position.
 +
|-
 +
| [[File:OpenCellID_many_cells_in_one_place.png|400px]] || If there are multiple cells shown at the same position and you click on the bubble with the map's highest zoom level, a spiral will be displayed with all known cells at that position.
 +
 
 +
Now you can click on each of the cells inside the spiral to view further details for each cell, such as:
 +
*network provider
 +
*MCC
 +
*MNC
 +
*LAC
 +
*CID
 +
*latitude
 +
*longitude
 +
*all measurements of this cell (max. 500)
 +
 
 +
And you can download the measurements of the selected cell as a CSV or KML file.
 +
|}
 +
 
 +
===map filter options===
 +
 
 +
{|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:OpenCellID menu complete.png|220px]]
 +
|
 +
{|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
 +
|[[File:OpenCellID GPS positions of GSM base stations.png]]
 +
|| [[File:Menu map view GPS positions of GSM base stations.png|220px]]
 +
|| This filter option allows you to view all known cell towers of a particular mobile phone network operator.
 +
 
 +
<b>MCC</b><br>
 +
Please enter here the <u>[[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]]</u>.<br>
 +
The MCC defines the country where the network is located.
 +
 
 +
<b>MNC</b><br>
 +
Please enter here the <u>[[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]]</u>.<br>
 +
The MNC defines the network inside the country defined by the MCC.<br>
 +
 
 +
If you leave the MCC parameter empty and only define the MNC parameter, you will get all networks with the selected network number world wide.
 +
 
 +
If you leave the MNC parameter empty and only define the MCC parameter, you will get all cells of all networks in the selected country.<br>
 +
Please note that such cells may be seen up to 34 km in the neighbouring country.
 +
|- style="background-color:#dddddd;"
 +
|[[File:OpenCellID newly found base stations.png]]
 +
|| [[File:Menu map view newly found base stations.png|220px]]
 +
|| Show newly found base stations with the following filtering options:
 +
 
 +
<b>date from</b><br>
 +
All newly found base stations starting at 0:00:00 UTC time from the specified date will be displayed; if this field is left empty, today's date from 0:00:00 will be chosen by default.
 +
 
 +
<b>date to</b><br>
 +
All newly found base stations up until 23:59:59 UTC time on the specified date will be displayed; if this field is left empty, today's date up until 23:59:59 will be chosen by default.
 +
 
 +
<b>MCC</b><br>
 +
If selected, only cells of networks with the selected [[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]] will be displayed.
 +
 
 +
<b>MNC</b><br>
 +
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:Menu_map_view_recently_uploaded_measurements.png|220px|link=|link=http://opencellid.org/#&action=filters.recentlyUploadedBaseStationMeasurements&time=24]]
 +
|| Show recently uploaded <u>[[Glossary#Measurement|measurements]]</u>:
 +
 
 +
<b>time in hours (max 24h)</b><br>
 +
Please enter the number of hours to go back from the current moment for viewing the latest measurements on the map.
 +
 
 +
The maximum time frame is 24 hours.
 +
 
 +
The time frame is selected from the current time to the given number of hours going back in time.<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.
 +
 
 +
You can always check with [[API#Listing a user's measurements]] to see if all your points were really uploaded.
 +
|- style="background-color:#dddddd;"
 +
|[[File:OpenCellID measurements of a selected GSM base station.png]]
 +
|| [[File:Menu map view measurements of a selected GSM base station.png|220px]]
 +
|| Show <u>[[Glossary#Measurement|measurements]]</u> of a selected GSM base station
 +
 
 +
<b>MCC</b><br>
 +
Please enter here the <u>[[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]]</u>.<br>
 +
The MCC defines the country where the network is located.
 +
 
 +
<b>MNC</b><br>
 +
Please enter here the <u>[[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]]</u>.<br>
 +
The MNC defines the network inside the country defined by the MCC.<br>
 +
 
 +
<b>LAC</b><br>
 +
Please enter here the <u>[[Glossary#LAC_-_Location_Area_Code|Location Area Code]]</u>.<br>
 +
The LAC defines a group of base stations that belong together regionally.<br>
 +
 
 +
<b>cell-id</b><br>
 +
Please enter here the <u>[[Glossary#Cell-ID|Cell ID]]</u>.<br>
 +
The Cell ID defines the number of the cell of which you want to see the data.<br>
 +
 
 +
All four entry fields are obligatory. If even one field is left empty, no data will be displayed.
 +
 
 +
Maximum 500 measurements are displayed on the map for the selected cell due to restrictions of the web browsers that are currently available.
 +
  |}
 +
|}
 +
<br>
 +
<br>
 +
 
 +
===heat map===
 +
 
 +
{|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|220px]]
 +
|
 +
{|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
 +
|[[File:OpenCellID daily heat map.png|link=http://opencellid.org/#&action=heatMaps.dailyHeatmap]]
 +
|| This menu option allows you to display the latest heat map.<br>
 +
The heat map indicates the density of unique base stations world wide.
 +
*red areas have a high density of known cell towers.
 +
*yellow areas have a reasonable density of known cell towers.
 +
*blue and green areas have a low density of known cell towers.
 +
*areas which are not coloured indicate that no cell towers have been recorded as of yet.
 +
 
 +
The heat map data (the tiles) is generated in real time when requesting the map.<br>
 +
You can zoom in to the map by double clicking on any desired position on the map, by turning the mouse wheel, or by pushing the "+" or "-" button on your keyboard.
 +
 
 +
|- style="background-color:#dddddd;"
 +
|[[File:OpenCelID heat map movie.png|link=http://opencellid.org/#&action=heatMaps.heatmapMovie]]
 +
|| The heat map movie provides a good overview on how the database has been growing over time in which region.
 +
 
 +
Every day, one heat map frame is created and stored right after completing the nightly creation of the download files. In order to keep the movie length at 45 seconds, the movie only shows selected frames from the very beginning of the OpenCellID project until today.<br>The displayed frames are selected as follows: if we have frames from 4 years (365 days * 4 years = 1460 days), then the app shows frames generated every 32 days (1460 days / 45 frames total movie length).
 +
 
 +
It is not possible to zoom into the heat map movie.
 +
|}
 +
|}
 +
<br>
 +
<br>
 +
 
 +
===statistics cells===
 +
 
 +
{|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 |220px]]
 +
|
 +
{|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
 +
|[[File:OpenCellID statistics cells.png]]
 +
|| This option allows you to generate a real-time bar chart assorted by the number of cells.<br>
 +
<br>
 +
<u>The following sorting criteria can be used for the bar chart:</u>
 +
 
 +
<b>total per country</b><br>
 +
This shows the total number of cells per country stored in the database;<br>
 +
the countries are sorted descending by the total of cells per country, country name or MCC (latest date on the left side of the bar chart).
 +
 
 +
<b>total per network</b><br>
 +
This shows the total number of cells per network stored in the database;<br>
 +
the networks are sorted descending by the total of cells per network (latest date on the left side of the bar chart).
 +
 
 +
<b>new cells per day</b><br>
 +
This shows the number of newly discovered cells per calender day;<br>
 +
the calender days are sorted descending (latest date on the left side of the bar chart).
 +
 
 +
<b>total amount of cells per month</b><br>
 +
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).
 +
<br>
 +
<br>
 +
<u>The following filter criteria can be used for the bar chart:</u>
 +
 
 +
<b>date from</b><br>
 +
All newly found base stations found after the specified day at 0:00:00 UTC time will be used for the bar chart;<br>
 +
if this field is left empty, today's date at 0:00:00 will be chosen by default.
 +
 
 +
<b>date to</b><br>
 +
All newly found base stations found up until the specified day 23:59:59 UTC time will be used for the bar chart;<br>
 +
if this field is left empty, today's date until 23:59:59 will be chosen by default.
 +
 
 +
<b>MCC</b><br>
 +
If selected, only cells of networks with the selected [[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]] will be displayed.
 +
 
 +
<b>MNC</b><br>
 +
If selected, only cells of networks with the selected [[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]] will be displayed.
 +
|}
 +
|}
 +
<br>
 +
<br>
 +
 
 +
===statistics measurements===
 +
 
 +
{|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" | <u>[[File:Menu statistics measurements.png|220px]]</u>
 +
|
 +
{|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
 +
|[[File:OpenCellID statistics measurements.png]]
 +
|| This option allows you to generate a real-time bar chart assorted by the number of measurements.<br>
 +
<br>
 +
<u>The following sorting criteria can be used for the bar chart:</u>
 +
 
 +
<b>total per country</b><br>
 +
This shows the total number of measurements per country stored in the database;<br>
 +
the countries are sorted descending by the total of measurements per country, country name or MCC (latest date on the left side of the bar chart).
 +
 
 +
<b>total per network</b><br>
 +
This shows the total number of measurements per network stored in the database;<br>
 +
the networks are sorted descending by the total number of measurements per network (latest date on the left side of the bar chart).
 +
 
 +
<b>new measurements per day</b><br>
 +
This shows the number of newly discovered cells per calender day;<br>
 +
the calender days are sorted descending (latest date on the left side of the bar chart).
 +
 
 +
<b>total measurements per month</b><br>
 +
This shows the total number of measurements per calender month;
 +
the calender months are sorted ascending (latest date on the right side of the bar chart).
 +
<br>
 +
<br>
 +
<u>The following filter criteria can be used for the bar chart:</u>
 +
 
 +
<b>date from</b><br>
 +
All measurements added to the database after the specified day at 0:00:00 UTC time will be used for the bar chart;<br>
 +
if this field is left empty, today's date at 0:00:00 will be chosen by default.
 +
 
 +
<b>date to</b><br>
 +
All measurements added to the database before the specified day until 23:59:29 UTC time will be used for the bar chart;<br>
 +
if this field is left empty, today's date until 23:59:59 will be chosen by default.
 +
 
 +
<b>MCC</b><br>
 +
If selected, only cells of networks with the selected [[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]] will be displayed.
 +
 
 +
<b>MNC</b><br>
 +
If selected, only cells of networks with the selected [[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]] will be displayed.
 +
|}
 +
|}
 +
<br>
 +
<br>
 +
 
 +
===search location===
 +
 
 +
{|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 search location GPS location.png|220px]]
 +
|
 +
{|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
 +
|[[File:OpenCellID_GPS_location.png]]
 +
|| [[File:Menu map view GPS positions of GSM base stations.png|220px]]
 +
|| This menu option allows you to enter a <u>[http://en.wikipedia.org/wiki/GPS GPS]</u> coordinate, consisting of a <u>[http://en.wikipedia.org/wiki/Latitude latitude]</u> and a <u>[http://en.wikipedia.org/wiki/Longitude longitude]</u> value.
 +
 
 +
This position will then be shown on the map, indicated by a special pushpin icon.
 +
 
 +
Both input fields are obligatory.
 +
|- style="background-color:#dddddd;"
 +
|[[File:OpenCellID collect data.png]]
 +
|| [[File:Menu search location cellid entry field.png|220px]]
 +
|| Show position of selected cell
 +
 
 +
<b>MCC</b><br>
 +
Please enter here the <u>[[Glossary#MCC_-_Mobile_Country_Code|Mobile Country Code]]</u>.<br>
 +
The MCC defines the country where the network is located.
 +
 
 +
<b>MNC</b><br>
 +
Please enter here the <u>[[Glossary#MNC_-_Mobile_Network_Code|Mobile Network Code]]</u>.<br>
 +
The MNC defines the network inside the country defined by the MCC.<br>
 +
 
 +
<b>LAC</b><br>
 +
Please enter here the <u>[[Glossary#LAC_-_Location_Area_Code|Location Area Code]]</u>.<br>
 +
The LAC defines a group of base stations that belong together regionally.<br>
 +
 
 +
<b>cell-id</b><br>
 +
Please enter here the <u>[[Glossary#Cell-ID|Cell ID]]</u>.<br>
 +
The Cell ID defines the number of the cell of which you want to see the data.<br>
 +
 
 +
All input fields are obligatory.
 +
  |}
 +
|}
 +
<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]]
 +
|
 +
{|style="font-size:100% border-collapse:collapse"; text-align="left" border="0" cellspacing="0" cellpadding="10"
 +
| [[File:OpenCellID download database.png|center]]
 +
| [[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.
 +
 
 +
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.
 +
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).
 +
 
 +
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===
 +
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
 +
|-
 +
! scope="col" | Parameter
 +
! scope="col" | Data type
 +
! scope="col" | Description
 +
|-
 +
| title="Parameter" | <mcc>
 +
| title="Data type" | integer
 +
| title="Description" | Mobile Country Code, for example 260 for Poland.
 +
|-
 +
| title="Parameter" | <net>
 +
| title="Data type" | integer
 +
| 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" | <area>
 +
| title="Data type" | integer
 +
| 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" | <lon>
 +
| title="Data type" | double
 +
| title="Description" | Longitude in degrees between -180.0 and 180.0
 +
|-
 +
| title="Parameter" | <lat>
 +
| title="Data type" | double
 +
| title="Description" | Latitude in degrees between -90.0 and 90.0
 +
|-
 +
| title="Parameter" | <signal>
 +
| 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="Parameter" | <measured>
 +
| title="Data type" | integer
 +
| 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>
 +
| title="Data type" | integer
 +
| 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="Data type" | double
 +
| title="Description" | GPS quality/accuracy information (metres)
 +
|-
 +
| title="Parameter" | <speed>
 +
| title="Data type" | double
 +
| title="Description" | Speed when creating the measurement; both metres/second and km/h is accepted.
 +
|-
 +
| title="Parameter" | <direction>
 +
| 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="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 and cell_towers_diff-*.csv.gz files format===
 +
{| class="wikitable sortable" style="font-size: 85%; text-align: left;"
 +
|-
 +
! scope="col" | Parameter
 +
! scope="col" | Data type
 +
! 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="Data type" | integer
 +
| title="Description" | Mobile Country Code, for example 260 for Poland.
 +
|-
 +
| title="Parameter" | <net>
 +
| title="Data type" | integer
 +
| 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" | <area>
 +
| title="Data type" | integer
 +
| 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" | <unit>
 +
| title="Data type" | integer
 +
| 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="Data type" | double
 +
| 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="Data type" | double
 +
| 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="Data type" | integer
 +
| title="Description" | Total number of measurements assigned to the cell tower
 +
|-
 +
| title="Parameter" | <changeable>
 +
| title="Data type" | integer
 +
| 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>
 +
| title="Data type" | integer
 +
| 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>
 +
| title="Data type" | integer
 +
| 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="Data type" | integer
 +
| 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.
 +
|}
 +
 
 +
|- style="background-color:#dddddd;"
 +
| [[File:OpenCellID upload.png]]
 +
| [[File:Menu database_upload.png|220px]]
 +
| This menu option allows you to upload <u>[[Glossary#Measurement|measurements]]</u> to the OpenCellID database.
 +
 
 +
The <u>[[API#apiKey|API key]]</u> is obligatory for uploading data.
 +
 
 +
The data must be provided in a CSV file. The required format of the CSV file is specified <u>[[API#Uploading_measurements_from_CSV_file|here]]</u>.
 +
|-
 +
| [[File:OpenCellID api key.png]]
 +
| [[File:Menu database request apiKey.png|220px]]
 +
|| <b>name</b><br>
 +
Please provide a unique name or nickname;<br>
 +
this will be used later for the leader list and other personalised statistics.
 +
 
 +
<b>e-mail</b><br>
 +
A valid e-mail address is required to register for an API key;<br>
 +
this e-mail address will not be used for anything that is unrelated to OpenCellID;<br>
 +
it will neither be sold nor otherwise distributed to a third party.
 +
 +
<b>password</b><br>
 +
This password will be required later to access your personal OpenCellID data.
 +
 +
<b>confirm password</b><br>
 +
Please re-enter your password here to ensure that there are no spelling mistakes.
 +
 
 +
|- style="background-color:#dddddd;"
 +
| [[File:OpenCellID_retrieve_apiKey.png]]
 +
| [[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]].
 +
 
 +
|}
 +
|}
 +
 
 +
</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


Retrieved from "http://wiki.opencellid.org/index.php?title=Menu_map_view&oldid=3622"