Difference between revisions of "FAQ"
(→What is a CLF format?) |
(→I am an OpenStreetMap mapper. How can I also map cell towers?) |
||
Line 19: | Line 19: | ||
The most effective way to contribute to OpenCellID is to use one of the smartphone applications listed <u>[[Data_sources|here]]</u> and to collect <u>[[Glossary#Measurement|measurements]]</u> while mapping something else.<br> | The most effective way to contribute to OpenCellID is to use one of the smartphone applications listed <u>[[Data_sources|here]]</u> and to collect <u>[[Glossary#Measurement|measurements]]</u> while mapping something else.<br> | ||
The <u>[http://keypad-mapper.org/wiki/Main_Page Keypad-Mapper 3]</u>, for example, has a built-in feature to record cell tower data while mapping house numbers / addresses. | The <u>[http://keypad-mapper.org/wiki/Main_Page Keypad-Mapper 3]</u>, for example, has a built-in feature to record cell tower data while mapping house numbers / addresses. | ||
+ | |||
+ | ==How to extract all cells of one country from the cell_towers.csv file?=== | ||
+ | |||
+ | Due to the size of the cell tower file it is not possible to use common programs like Excel or Microsoft Word for this task. | ||
+ | |||
+ | One way to extract the required data is as follows:<br> | ||
+ | # Download cell_towers.csv file <u>[http://opencellid.org/#action=database.downloadDatabase here]</u>.<br> | ||
+ | # Install the free Windows software <u>[http://csved.sjfrancke.nl/ CSVed.exe]</u> on your windows PC.<br>Last version we tested successfully was version 2.3.2 (2014). It creates a shortcut on your desktop during its installation.<br> | ||
+ | # Run CSVed.exe and load the CSV file | ||
+ | # Use “Filter & Dups” feature for filtering the required data; filtering of the data takes a few minutes but works perfectly good. | ||
+ | |||
+ | Thank you very much to ?? for this great tool! | ||
===What is a CLF format?=== | ===What is a CLF format?=== |
Revision as of 13:27, 24 August 2014
ContentsI am an OpenStreetMap mapper. How can I also map cell towers?OpenCellID mainly collects MCC, MNC, LAC, and CID information combined with a GPS position.
In addition, one of the basic rules of OSM is to map visible things. This is not the case here as MCC/MNC/LAC/CID are not visible in most cases. The most effective way to contribute to OpenCellID is to use one of the smartphone applications listed here and to collect measurements while mapping something else. How to extract all cells of one country from the cell_towers.csv file?=Due to the size of the cell tower file it is not possible to use common programs like Excel or Microsoft Word for this task. One way to extract the required data is as follows:
Thank you very much to ?? for this great tool! What is a CLF format?CLF files contain information about mobile network cells. The following versions are supported: 2.0, 2.1, and 3.0. CLF version 2.0Files have the following format: CLF version 2.1Files have the same format as in version 2.0 but CellId and LAC are stored as decimal values. CLF version 3.0This format uses more information about cells. It has the following format: LAC vs. RNCOne RNC can handle multiple LACs. RNC ID does not necessarily have a connection to LAC ID - it depends how the network is planned. For example you can find in the same RNC (12) LACs 33, 21 and 78 - no connection between them. No relative connection of RNC IDs and LAC. This is based on how to plan the network. LAC depends on paging. RNC ID is same as Site IDs. It only serves as identification. |