OK. So generating kmz is time taking?
And is it effective from traditional manual KPI monitoring?
1 Like
Depends on the information you put in it.
You can do it by Visual Basic (Excel) also by Python.
Easier to implement.
It depends on your experience and knowledge. At the end of the day this is another tool.
Is this method implemented for KPI Monitoring in any Operator / Country?
This is a complementary tool in several Operators.
It is better to do it in QGIS.
After, if you want, you can pass to kml only that you need.
QGIS means?
QGIS is a free software, similar to Mapinfo:
Do a search here in forum: Search results for 'QGIS' - telecomHall Forum or see this: QGIS - Free and Open Source Geographic Information System
I think that QGIS is a good alternative to Mapinfo.
1 Like
This is a good solution!
QGIS is Python enabled so you can do scripts for example to find PCI collision and all in every efficient manner.
You can upload performance data like KPI and all and see in geographically on map.
1 Like
OK.
So can we do connectivity of Google Earth with OSS to fetch KPI’s & counters?
I don’t think so.
Due to cyber security rules with operators.
But what you can do is to import Excel of KPIs in Google Earth separately for thematical presentations and all.
OK. Then how Google Earth could be used for KPI Monitoring?
As I said this a matter of acceptance from Operator end.
What tool they allow to use in their network.
Rare example.
Use QGIS and generate KPIs maps. After, pass to KML.
No more.
You take 30 seconds pass from QGIS to KML.
Perfect. 
And automate with Python.
You don’t.
You connect your KML script generator with your KPI database.
And then the results are *kmz with your KPIs.
Please tell us how to make it, thx
U can use Tableau visualization Software.
Yes @Makki_Ahmed, we can use Tableau… and yes, it is a Great visualization tool. Unfortunately, it is very expensive.
For those who want, can develop their own applications, using Google Earth, QGIS, Mapinfo, ArcGIS, whatever…
And can do it for free.
More than 10 years ago i developed a complete system, getting data from OSS, importing into Access databases and generating KML files, which were called but Google Earth “Network Links”. You can see a sample here: Hunter 038 - Google Earth Performance KPI Plot (Application) in case you want to do your solution with VBA too.
Currently I am using a solution with Python.
Anyway, your limit is your creativity.
2 Likes
That s very helpfull Leo,
Could you please help to create such tool, I suggest a python script wich takes information from an excel file with many columns for KPI.
and a second sheet for engineeribg information (Azimuth, X, Y)
The script will plot the sectors in Qgis and allow to choose between columns for kpi visualisation
I’ll be ready to help for devellopement too.
Best regards,
1 Like