Database format

map view

	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.
	Single cells are represented with these pushpin icons. 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).
	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.
	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

This filter option allows you to view all known cell towers of a particular mobile phone network operator. MCC Please enter here the Mobile Country Code. The MCC defines the country where the network is located. MNC Please enter here the Mobile Network Code. The MNC defines the network inside the country defined by the MCC. 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. Please note that such cells may be seen up to 34 km in the neighbouring country. Show newly found base stations with the following filtering options: date from 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. date to 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. MCC If selected, only cells of the selected country will be displayed. MNC If selected, only cells of networks with the selected Mobile Country Code will be displayed. Show recently uploaded measurements: time in hours (max 24h) 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. Example: 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. Show measurements of a selected GSM base station MCC Please enter here the Mobile Country Code. The MCC defines the country where the network is located. MNC Please enter here the Mobile Network Code. The MNC defines the network inside the country defined by the MCC. LAC Please enter here the Location Area Code. The LAC defines a group of base stations that belong together regionally. cell-id Please enter here the Cell ID. The Cell ID defines the number of the cell of which you want to see the data. 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.

heat map

This menu option allows you to display the latest heat map. 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. 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. 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. 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.

statistics cells

This option allows you to generate a real-time bar chart assorted by the number of cells. The following sorting criteria can be used for the bar chart: total per country This shows the total number of cells per country stored in the database; 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). total per network This shows the total number of cells per network stored in the database; the networks are sorted descending by the total of cells per network (latest date on the left side of the bar chart). new cells per day This shows the number of newly discovered cells per calender day; the calender days are sorted descending (latest date on the left side of the bar chart). total cells per month This shows the number of newly discovered cells per calender month; the calender months are sorted descending (latest date on the right side of the bar chart). The following filter criteria can be used for the bar chart: date from All newly found base stations found after the specified day at 0:00:00 UTC time will be used for the bar chart; if this field is left empty, today's date at 0:00:00 will be chosen by default. date to All newly found base stations found up until the specified day 23:59:59 UTC time will be used for the bar chart; if this field is left empty, today's date until 23:59:59 will be chosen by default. MCC If selected, only cells of the selected country will be displayed. MNC If selected, only cells of networks with the selected Mobile Country Code will be displayed.

statistics measurements

This option allows you to generate a real-time bar chart assorted by the number of measurements. The following sorting criteria can be used for the bar chart: sorted by the total This shows the total number of measurements per country stored in the database; the countries are sorted descending by the total of measurements per country. sorted by country name This shows the total number of measurements per country stored in the database; the countries are sorted alphabetically ascending by country name. sorted by MCC This shows the total number of measurements per country stored in the database; the countries are sorted ascending by MCC. new measurements per day This shows the number of newly added measurements per calender day; the calender days are sorted descending (latest date on the left side of the bar chart). The following filter criteria can be used for the bar chart: date from All measurements added to the database after the specified day at 0:00:00 UTC time will be used for the bar chart; if this field is left empty, today's date at 0:00:00 will be chosen by default. date to All measurements added to the database before the specified day until 23:59:29 UTC time will be used for the bar chart; if this field is left empty, today's date until 23:59:59 will be chosen by default. MCC If selected, only measurements of the selected country will be displayed. MNC If selected, only measurements of networks with the selected Mobile Country Code will be displayed.

search location

This menu option allows you to enter a GPS coordinate, consisting of a latitude and a longitude value. This position will then be shown on the map, indicated by a special pushpin icon. Both input fields are obligatory. Show position of selected cell MCC Please enter here the Mobile Country Code. The MCC defines the country where the network is located. MNC Please enter here the Mobile Network Code. The MNC defines the network inside the country defined by the MCC. LAC Please enter here the Location Area Code. The LAC defines a group of base stations that belong together regionally. cell-id Please enter here the Cell ID. The Cell ID defines the number of the cell of which you want to see the data. All input fields are obligatory.

database

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. In very rare cases we recreate all files. File formats: measurements_? CSV file format Parameter Data type Description <mcc> integer Mobile country code <mnc> integer Mobile network code <lac> integer Local area code <cellid> integer Cell tower id <lon> double Longitude <lat> double Latitude <signal> integer Signal level either in dBm or as defined in TS 27.007 8.5; both is accepted. <measured_at> date When the measurement was measured. Returns a date in timestamp format: milliseconds since 1/1/1970 00:00:00 GMT; time zone: UTC <created_at> date When the measurement was added to OpenCellID database. Returns a date in timestamp format: milliseconds since 1/1/1970 00:00:00 GMT; time zone: UTC <rating> integer GPS quality/accuracy information (metres) <speed> integer Speed when measuring the measurement <direction> integer Heading direction of the phone / telematics device at the moment the measurement was created (0=north, 90=east, 180=south, 270=west) cell_towers.csv file format Parameter Data type Description <mcc> integer Mobile country code <mnc> integer Mobile network code <lac> integer Local area code <cellid> integer Cell tower id <lon> double Longitude changeable=1: average of longitude values of all related measurements changeable=0: exact GPS position of the tower <lat> double Latitude changeable=1: average of latitude values of all related measurements changeable=0: exact GPS position of the tower <samples> integer Number of measurements assigned to the cell tower <changeable> integer Defines if coordinates of the cell tower are exact or approximate; 1: the GPS position of the cell tower has been calculated from all available measurements 0: the GPS position of the cell tower is precise; no measurements have been used to calculate it. <created_at> date When the cell tower was added to the OpenCellID database. Returns a date in timestamp format: milliseconds since 1/1/1970 00:00:00 GMT time zone: UTC <updated_at> date When was the last update of the cell tower. Returns a date in timestamp format: (milliseconds since 1/1/1970 00:00:00 GMT time zone: UTC <averageSignal> integer Average signal level of assigned measurements either in dBm or as defined in TS 27.007 8.5; both is accepted. This menu option allows you to upload measurements to the OpenCellID database. The API key is obligatory for uploading data. The data must be provided in a CSV file. The required format of the CSV file is specified here. name Please provide a unique name or nickname; this will be used later for the leader list and other personalised statistics. e-mail A valid e-mail address is required to register for an API key; this e-mail address will not be used for anything that is unrelated to OpenCellID; it will neither be sold nor otherwise distributed to a third party. password This password will be required later to access your personal OpenCellID data. confirm password Please re-enter your password here to ensure that there are no spelling mistakes.