Difference between revisions of "Menu map view"
(→measurements_? CSV file format) |
|||
(44 intermediate revisions by 4 users not shown) | |||
Line 3: | Line 3: | ||
|} | |} | ||
+ | ===Cells database:=== | ||
+ | You can download the entire worldwide dataset of cell towers 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. | ||
+ | |||
+ | 1. The file is updated on a daily basis<br> | ||
+ | 2. A token will be able to download twice per day<br> | ||
+ | 3. The database is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License<br> | ||
+ | |||
+ | ===Signup:=== | ||
+ | You can signup for a key at http://opencellid.org/ | ||
+ | |||
+ | <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 83: | ||
<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 100: | ||
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 148: | Line 163: | ||
{|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|220px]] | + | |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 156: | Line 171: | ||
<u>The following sorting criteria can be used for the bar chart:</u> | <u>The following sorting criteria can be used for the bar chart:</u> | ||
− | <b> | + | <b>total per country</b><br> |
This shows the total number of cells per country stored in the database;<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. | + | 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> | + | <b>total per network</b><br> |
− | This shows the total number of cells per | + | This shows the total number of cells per network stored in the database;<br> |
− | the | + | the networks are sorted descending by the total of cells per network (latest date on the left side of the bar chart). |
− | + | ||
− | + | ||
− | + | ||
− | the | + | |
<b>new cells per day</b><br> | <b>new cells per day</b><br> | ||
This shows the number of newly discovered cells per calender day;<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). | 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> | ||
<br> | <br> | ||
Line 184: | Line 199: | ||
<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 204: | Line 219: | ||
<u>The following sorting criteria can be used for the bar chart:</u> | <u>The following sorting criteria can be used for the bar chart:</u> | ||
− | <b> | + | <b>total per country</b><br> |
This shows the total number of measurements per country stored in the database;<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. | + | 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> | + | <b>total per network</b><br> |
− | This shows the total number of measurements per | + | This shows the total number of measurements per network stored in the database;<br> |
− | the | + | the networks are sorted descending by the total number of measurements per network (latest date on the left side of the bar chart). |
− | + | ||
− | + | ||
− | + | ||
− | the | + | |
<b>new measurements per day</b><br> | <b>new measurements per day</b><br> | ||
− | This shows the number of newly | + | 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). | 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> | ||
<br> | <br> | ||
Line 232: | Line 247: | ||
<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> | ||
<br> | <br> | ||
+ | |||
===search location=== | ===search location=== | ||
Line 279: | Line 295: | ||
<br> | <br> | ||
<br> | <br> | ||
+ | |||
===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 285: | Line 303: | ||
| | | | ||
{|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" | ||
− | | [[File:OpenCellID download database.png]] | + | | [[File:OpenCellID download database.png|center]] |
− | || [[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. | |
+ | |||
+ | 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_ | + | === 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 298: | Line 334: | ||
| title="Parameter" | <mcc> | | title="Parameter" | <mcc> | ||
| title="Data type" | integer | | title="Data type" | integer | ||
− | | title="Description" | Mobile | + | | title="Description" | Mobile Country Code, for example 260 for Poland. |
|- | |- | ||
− | | title="Parameter" | < | + | | title="Parameter" | <net> |
| title="Data type" | integer | | title="Data type" | integer | ||
− | | title="Description" | Mobile | + | | 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" | < | + | | title="Parameter" | <area> |
| title="Data type" | integer | | title="Data type" | integer | ||
− | | title="Description" | | + | | 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" | < | + | | title="Parameter" | <cell> |
| title="Data type" | integer | | title="Data type" | integer | ||
− | | title="Description" | Cell | + | | 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> | + | | title="Description" | Signal level<br>either in dBm or as defined in TS 27.007 8.5 - both is accepted. |
|- | |- | ||
− | | title="Parameter" | < | + | | title="Parameter" | <measured> |
− | | title="Data type" | | + | | title="Data type" | integer |
− | | title="Description" | When the measurement was measured.<br> | + | | 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" | < | + | | title="Parameter" | <created> |
− | | title="Data type" | | + | | title="Data type" | integer |
− | | title="Description" | When the measurement was added to OpenCellID database.<br> | + | | 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> | ||
− | | title="Data type" | | + | | title="Data type" | double |
− | | title="Description" | GPS quality/accuracy information | + | | title="Description" | GPS quality/accuracy information (metres) |
|- | |- | ||
| title="Parameter" | <speed> | | title="Parameter" | <speed> | ||
− | | title="Data type" | | + | | title="Data type" | double |
− | | title="Description" | Speed when | + | | title="Description" | Speed when creating the measurement; both metres/second and km/h is accepted. |
|- | |- | ||
| title="Parameter" | <direction> | | title="Parameter" | <direction> | ||
− | | title="Data type" | | + | | 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 | + | |
+ | ===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 352: | Line 428: | ||
! 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 | + | | title="Description" | Mobile Country Code, for example 260 for Poland. |
|- | |- | ||
− | | title="Parameter" | < | + | | title="Parameter" | <net> |
| title="Data type" | integer | | title="Data type" | integer | ||
− | | title="Description" | Mobile | + | | 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" | < | + | | title="Parameter" | <area> |
| title="Data type" | integer | | title="Data type" | integer | ||
− | | title="Description" | | + | | 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" | < | + | | title="Parameter" | <cell> |
| title="Data type" | integer | | title="Data type" | integer | ||
− | | title="Description" | Cell | + | | 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="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" | | + | | 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 | + | | 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" | < | + | | title="Parameter" | <created> |
− | | title="Data type" | | + | | title="Data type" | integer |
− | | title="Description" | | + | | 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" | < | + | | title="Parameter" | <updated> |
− | | title="Data type" | | + | | title="Data type" | integer |
− | | title="Description" | | + | | 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 | + | | 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;" | |- style="background-color:#dddddd;" | ||
− | | [[File:OpenCellID upload.png]] | + | | [[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 <u>[[API#apiKey|API key]]</u> is obligatory for uploading data. | ||
Line 408: | Line 496: | ||
|- | |- | ||
| [[File:OpenCellID api key.png]] | | [[File:OpenCellID api key.png]] | ||
− | + | | [[File:Menu database request apiKey.png|220px]] | |
|| <b>name</b><br> | || <b>name</b><br> | ||
Please provide a unique name or nickname;<br> | Please provide a unique name or nickname;<br> | ||
Line 423: | Line 511: | ||
<b>confirm password</b><br> | <b>confirm password</b><br> | ||
Please re-enter your password here to ensure that there are no spelling mistakes. | 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> |
Revision as of 13:41, 7 February 2018
Cells database:
You can download the entire worldwide dataset of cell towers 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.
1. The file is updated on a daily basis
2. A token will be able to download twice per day
3. The database is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License
Signup:
You can signup for a key at http://opencellid.org/
map view
map filter options
|
heat map
statistics cells
|
statistics measurements
|
search location
|
database
|