Sunday, January 20, 2013

Disdplay CDMA drive test log data in Google Earth layer - A Coverage Tool

Csv to Kml Converter - A Coverage Tool

Csv to Kml converter is a coverage tool which is used to display Drive Test log data in Google earth map. The plot of Rx power, Ms Tx Power, F-FER, Tx AdjdB  , Strongest pilot Ec/Io are viewed in graphical form in GE layer. This application is very useful for analysis of live mobile network.

So first of all download the Csv2Kml converter install it . Here I am going to tell you how to use this software to view Rx power of CDMA mobile Network.

Pre –Requisite:

     1. CSV2KML Installation.
           Download Csv2Kml

     2. MapInfo Software. 
           Download Mapinfo Professional

     3 .Drive Test Log Data.

     4. MS Excel Software. 
     
     5.  Google Earth Software.
           Download Google Earth 

     6. DT Analyzer Software

After installation of CSV2KML Software, a desktop shortcut icon appears.

-          Click the icon of csv2Kml.

Csv to Kml Converter

Fig 1: Csv2Kml software window




       -   Save DT log data in CSV format using DT analyzer Software.

   -        - Go to File Menu of CSV2KML SW and Click On Open CSV menu.

Opening CSV File

Fig 2: Opening Csv file

-Select the CSV file and Open it.

CSV to Kml Converter

Fig 3: CSV2KML  Main Window , opening ,selecting and exporting Csv file


 -Select Source Data : RX Power for example

-Select Latitude.

-Select Longitude.

-Click on Range Value.

-Select the parameter you want see ex Rx Power.

-Set range values .

-Export it.

-The Kml file is created in your folder where your CSV is located.

- Now you can click the KML file saved in your directory and viewed in google earth layer.

Rx power in google earth


Fig 4: Rx power in Google Earth map window