Convert Drive Test Log to Google Earth Thematic Map

Hi readers, I would like to share another case of converting drive test (DT) logfiles to be viewed in Google Earth, but this time with thematic color. Some of you guys should know how to create thematic map using Mapinfo or DT post processing tools such as Actix or Nemo Analyzer. Using this kind of thematic maps showing the distribution of signal strength or quality is a common way to understand the network behavior and their problem. It is going to be more exciting to combine thematic maps overlayed in Google Earth.

In this article, I am going to show you how to export logfile data from TEMS Investigation to thematic KML.

Before applying the steps on this tutorial please make sure that you change the No. of digits after decimal from 2 into 6.
Check it in the Control Panel -> Regional and Language Options -> Customize.

 

1. Export Logfiles to TXT

First, we need to export collected logfiles into .txt file. Choose Text file in the Format dropdown, then on the Setup->Export to Text File window select the Information Elements that you need. Longitude and Latitude is mandatory. In the example, we choose RxLevSubdBm and RxQual. After that simply choose the desired logfiles and let TEMS do the rest.

2. Using MS Access

After the export process finished, we will find the exported TXT file on the targeted directory. We can use Excel to open it. But if the file size is large, then Access is the right option. Let’s open the exported TXT using Access. First, you need to create blank database by clicking on File->New…->Blank Database. The database has been created, now we need to import the exported TXT file into the database. Right click on the Table then choose Import. For Access 2007 users use External Data then choose Text File.

Locate the exported TXT then the Import Text Wizard will appear. Choose Delimited then click Next. On the Choose the delimiter that separates your fields: choose Tab. Put a check on First Row Contains Field Names and choose Text Qualifier as {None}. Click Next.

On the next window just choose In a New Table. Click Next.

Click Next again. On the next window choose No primary key. Click Next.

Put a name in the Import to Table: field then Finish. Access will import it to a new table.

Now, we need to do simple query. Choose Create query in Design View or click the Design toolbar. Put the table into the query and put the MS, Longitude, Latitude, and RxLev Sub dBm to the fields. On the Criteria fill MS1 or desired MS for choosing the MS/UE we desire. Put also Is not null on the All RxLev Sub dBm’s criteria to select non blank data.

Press CTRL + S to save the query and give a unique name such as RxLev. Run the query and you should see something like this:

Now right click on the query, RxLev in this example and choose Export… Give a name and choose Text File in the Save as Type. Click Export.
Choose Delimited. Next.
Choose Comma  as the delimiter, put a check in the Include Field Names on First Row, and Text Qualifier=None.
In the Export to File rename the .txt extension into .csv
Finish.

Exporting CSV into Thematic KML

We need csv2kml, a fantastic tools created by CoverageTools. You can download it for free in their site or click here.

After installing this software just run it and choose File->Open CSV to locate our CSV file.

On the Source Data choose the IE, for example All-RxLev Sub (dBm).
On the Latitude select Latitude.
On the Longitude select Longitude.

We can set our standard Range Values. For example:

Just put out-of-range fields with value such as -999. What about the color? The easiest way to set the color is click on Save Values after you set the range. Then, simply go to C:\Program Files\coveragetools\csv2kml and open the saved .VAL using Notepad. It is going to be like this:

RSSI [dBm]
 6 
-68,0,347235
-72,-68,00FF00
-76,-72,D0F52F
-80,-76,F5000A
-89,-80,1F8FE
-105,-89,100FE
-999,-105,FFFFFF
-999,-999,FFFFFF
-999,-999,FFFFFF
-999,-999,FFFFFF
Basestation
 10 
 0 ,7B1284
 1 ,6FB490
 2 ,66F799
 3 ,25EADA
 4 ,ADEA52
 5 ,F1700E
 6 ,B10B4E
 7 ,61069E
 8 ,1C81E3
 9 ,5EDFA

Simply change the hexadecimal value according to the desired color. You can refer to this for color hexadecimal value.

Ready for the result? Just click Export button, KML file will be saved in the same directory of the CSV file. Give it a double click and you can see it on Google Earth!

Advertisements

23 comments

  1. Anonymous · September 16, 2011

    Hi,

    I do it follow your instruction with Google Pro 4.2, but there is only one color appear, it is so sad !

    • Taufiq Ibrahim · September 16, 2011

      hi there, thanks for reading 🙂
      first I need to know what IE did you use? Is it RxLev or RxQual or maybe something else. I am using RxLev in this example and I need to change the range value using RxLev range. If you used different range then you need to modify also the range to match the raw data. Could you send me the raw TXT? so I can try to figure it out what is wrong. Just send it to taufiq.ibrahim@gmail.com
      thanks

  2. MIXMAX · September 21, 2011

    I do it follow your instruction BUT IN SELECT SOURCE THER IS NOTHING?????????

  3. reza · October 27, 2011

    Hi Taufiq,
    How about antenna sector in MI with thematic to google earth. Have u try this? I have try to use MI2GE but exported .kml not include thematic.

    thanks b4.
    reza

  4. ZaIs TrooPer · January 9, 2012

    hi taufiq

    I enjoyed reading your article and I’ve tried to make like the guide but I’m puzzled why it did not next to the legend as an example that you gave Can you tell his tricks and tips for me

    thanks B4.
    zais

    • Taufiq Ibrahim · January 11, 2012

      do you mean that the legend color is not the same with the example? The example use RxLevsubdBm which value range from -10 to -120, if you used another info element then the range might be different also. Just send the exported TXT to taufiq.ibrahim@gmail.com, I will try to help you 🙂

  5. zaki · March 5, 2012

    Dear Taufiq

    how I can convert TEMS export file to route or table file in Mapinfo?
    Thanks in advance

    • Taufiq Ibrahim · March 16, 2012

      I already sent the tools to your email. Please check it.

      • Imthiyaz · September 14, 2012

        Hi Toufiq,

        I want to export tems log file to excel or txt format. How can I do that? If there is any tool could you please email me.

  6. Sousa Varela · March 16, 2012

    I’m doing everything like that shown on the site, but this is the return the following error: export error: type mismatch!
    What do I do??????????

  7. Sousa Varela · March 19, 2012

    I found out later that the error was in the range, now works, but the prediction for this than the original, the result looks like a square!
    And when in MapInfo is completely different!
    thank you
    hugs

  8. amr · August 10, 2012

    thank you very much ..

  9. Kamel Mrekab · April 10, 2013

    Really Thanks

  10. roofing madison wisconsin · August 1, 2013

    I’m truly enjoying the design and layout of your blog. It’s a very easy on the eyes which makes
    it much more enjoyable for me to come here and visit
    more often. Did you hire out a designer to create your theme?
    Fantastic work!

  11. Godfrey · October 12, 2013

    Hi,
    I have tried to use this tool, i am getting the results but very slow to load on Google Earth even when i process small log-files. What could be the reason?
    Thanks though.

    • Taufiq Ibrahim · October 23, 2013

      Perhaps your sample was a large number, causing google earth slow when load

  12. Yaqubi · November 14, 2013

    Hi Taufiq ,

    Thanks for your valuable knowledge share .

    this is something even more better then ACTIX / MAPinfo.

    I followed your instruction but close to the end is not succeed .

    I found problem and I dont know how to solve it .

    Actually , the latitude , logitude and Rxlevel is comming infront of each ohter while I am running the Access .
    I am sending you the TXT file , kinldy have a look to it and let me follow the rest .
    once again thanks from your effort and KT .

    Thanks ,

    Yaqubi

  13. dueba ブログ · April 20, 2014

    芸能人叩いてる人ってどういう人生送ってきてるのかね カラコン2枚も入ってんじゃねーかw
    都合のいいことだけグローバル化かよwwワロスww せめてアキュビューのナチュラルなやつ使ってほしいわ
    ぱっと見でわからないようなフシアナならどっちでも良い話だろうな

  14. http://tinyurl.com/ · May 5, 2014

    But Fox News never lets the information get inside way of the good propaganda campaign.
    This situation triggered news programs and materials for your timely
    exchange of high demand.

  15. Masoud · February 3, 2015

    Hi taufiq,
    How to upload many piece of TEMS log file in same time to the google Earth?
    Thanks

  16. simon · July 25, 2015

    Excellent tool 5 of 5 star

  17. Syed Raghib Emam · August 30, 2016

    Dear Taufiq
    Thanks for your valuable knowledge.
    Please guide me how I can convert TEMS export file to route or table file in Mapinfo?
    Thanks in advance.

  18. quyên trần · April 25, 2017

    tôi đã làm theo nhưng không hiểu rõ nên không chuyển được bạn có thể giúp tôi

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s