FORUMS
Remove All Ads from XDA

Development stopped: [APP] CellTower2KML [2011-07-20] 1.0

2,854 posts
Thanks Meter: 207
 
By ZuinigeRijder, Retired Recognized Developer on 20th July 2011, 09:35 PM
Post Reply Email Thread
I did make a conversion program to convert Cell Tower information to actual locations. You can download the version on SourceForge here..

Contents of the zip:
- Cell2KML.exe: Program which converts the input.txt into output.kml
- cells.txt: cache from www.opencellid.org, but in stripped form and with format: id,mcc,mnc,lac,cellid, lat, lon
- cellsNew.txt: will be appended with found locations via internet service of Google Maps with format id,mcc,mnc,lac,cellid, lat, lon
- input.txt: input file in format: datetime,mcc,mnc,lac,cellid
- output.kml: output file suitable for Google Earth, Google Maps or Google Mobile

Some notes:
- Cell2KML.exe works on PC and on Windows Mobile, but on Windows Mobile it is really slow......and progress information is not yet available on Windows Mobile (only a debug log file)
- When location is not in cells.txt or cellsNew.txt, then internet is used for getting the actual location and the positive result is added to cellsNew.txt
- output.kml can be used immediately in Google Earth (if installed on your PC) and Google Mobile Maps by double clicking on the file
- if you want to use the output.kml in Google Maps, then your kml must be public accessible on the internet. You can use a public folder of DropBox or as in my example on SourceForge, e.g.:
<br>
Code:
http://maps.google.com/maps?q=http://touchlockpro.sourceforge.net/CellTower2KML/battclock.kml
BattClock can now monitor the nearest cell tower with your phone using GSM. Why is this interesting?
- This Cell Tower Info can be used for getting an approximate location using several services (Google, OpenCellId, Celldb, location-api)
- No GPS needed! Works on any Windows Mobile phone supported by BattClock!
- If you have a GPS this is more accurate, but also drains battery.
- No internet access needed on your phone, the monitored data can be translated offline to actual locations on a PC with internet access.
- With that you can keep track of where you have been when or which approximate route you did take.
- With triangulation in combination with Tower Signal Strength even more accurate positioning could be computed.
- If you can map the cellid to a approximate Location (Langitude, Longitude) via an offline database, you even do not need internet access.

The input.txt can you be a battclock.csv file, when you only selected to log to file mcc,mnc,lac,cellid, otherwise you must make sure the columns are in the order datetime,mcc,mnc,lac,cellid. Copy your battclock.csv file in the same directory as the Cell2KML.exe program and name it input.txt.

When you convert this Cell Tower Information to kml format, you can show this on Map applications, like Google Earth, Google Maps or an offline Map application which supports kml.
Example kml file here, which opens in Google Maps.




The following information can be monitored (displayed, logged to BattClock.csv file or to registry):
-Mobile Country Code
-Mobile Network Code
-Location Area Code
-Cell ID
-Tower Signal Strength
-Base Station ID (not filled on my Touch Diamond)
-GPRS Cell ID (not seen filled on my Touch Diamond)
-GPRS Base Station ID (not seen filled on my Touch Diamond)

The following registry values can be filled, below HKEY_CURRENT_USER\Software\ZuinigeRijder\Status, so other programs (e.g. MortScript) can react on it:
- MobileCountryCode
- MobileNetworkCode
- LocationAreaCode
- CellId
- TowerSignalStrength
- BaseStationId
- GPRSCellId
- GPRSBaseStationId

For offline converting the Cell Tower Info, you need to enable at least the logging for the following info:
- Mobile Country Code
- Mobile Network Code
- Location Area Code
- Cell ID

The default check time is once per 30 seconds (if one of the items is enabled). You can set the number of seconds via registry key or via BattConfig: "TowerInfoSeconds".
Note that the monitoring does not occur in a deep sleep. At power on after a deep sleep, the monitoring resumes immediately (without the wait of the configured seconds).
The Following 2 Users Say Thank You to ZuinigeRijder For This Useful Post: [ View ] Gift ZuinigeRijder Ad-Free
 
 
20th July 2011, 11:26 PM |#2  
jdpl@'s Avatar
Senior Member
Flag Miami, FL
Thanks Meter: 355
 
More
Hi ZuinigeRijder,

Thank you very much for sharing another great app and keeping WinMo alive.

Best regards.
22nd July 2011, 08:03 AM |#3  
Hi ZuinigeRijder,

+1 for the new little WinMo app from you. Amazing and helpfull. Thank You
5th October 2011, 12:44 PM |#4  
the dragonlord's Avatar
Senior Member
Thanks Meter: 1
 
More
Location name on windows mobile?
Hi, would it be possible to use some of the cell feature combined with script or other plugin to display near the operator name or in the taskbar the name (description) of the location where "I am now"? For example if I'm in london to display somewhere "London" (in "nokia style")

Thanks
Andrea
5th October 2011, 09:03 PM |#5  
ZuinigeRijder's Avatar
OP Retired Recognized Developer
Thanks Meter: 207
 
More
Quote:
Originally Posted by the dragonlord

Hi, would it be possible to use some of the cell feature combined with script or other plugin to display near the operator name or in the taskbar the name (description) of the location where "I am now"? For example if I'm in london to display somewhere "London" (in "nokia style")

Thanks
Andrea

Currently I store the RAW data in BattClock:
YYYY-MM-DD HH:MM:SS,MOBILE_COUNTRY_CODE,MOBILE_NETWORK_CODE,L OCATION_AREA_CODE,CELLID

And transform via a local textfile (based on opencellid) to KML or if the Cell id is not in the local textfile, I use google (internet).

So I still only know the coordinates. Via internet (google maps) you can even get the approx. address via the coordinates.

In principle it would be possible to store all this data locally, and have a lookup of the approx. address or City.

But if you have internet on your mobile, even that could be used as fallback.

The question is if you want to use this functionality with or without internet on your phone

Note that till now, I kept BattClock as simple as possible, but getting this information from a local textfile will be a bit harder (consume more CPU for finding).
6th October 2011, 06:38 AM |#6  
the dragonlord's Avatar
Senior Member
Thanks Meter: 1
 
More
Quote:
Originally Posted by ZuinigeRijder

Currently I store the RAW data in BattClock:
YYYY-MM-DD HH:MM:SS,MOBILE_COUNTRY_CODE,MOBILE_NETWORK_CODE,L OCATION_AREA_CODE,CELLID

And transform via a local textfile (based on opencellid) to KML or if the Cell id is not in the local textfile, I use google (internet).

So I still only know the coordinates. Via internet (google maps) you can even get the approx. address via the coordinates.

In principle it would be possible to store all this data locally, and have a lookup of the approx. address or City.

But if you have internet on your mobile, even that could be used as fallback.

The question is if you want to use this functionality with or without internet on your phone

Note that till now, I kept BattClock as simple as possible, but getting this information from a local textfile will be a bit harder (consume more CPU for finding).

Hi, thanks for the answer! My phone is aways connected to internet...
15th January 2012, 05:35 PM |#8  
Senior Member
Flag Heart of BW
Thanks Meter: 76
 
More
Angry
For the lazy people here (like me ),
i have written an small Batch Script to convert automatically the log-file generated by Battclock and start Google Earth

1.: You have to "Google Earth" installed on your PC (if not already)
2.: Download and extract ZuinigeRijder┬┤s "CellTower2KML (if not already)
3.: Download, extract and Copy the "Run.bat" into the same folder of CellTower2KML
4.: Place your battclock.csv generated by "BattClock" in the same folder of CellTower2KML (For details what kind of data should/can be logged look at the first Post )
5.: Click on Run.bat

Thats it!
When everything is fine, Google Earth should start and show your Track
Of course for your next Tracks you have to do only Step 4 and 5, no more.

Greetz Tokl

P.S.: Maybe Zuinige is packing this batch inside his CellTower2KML.1.0.zip so its provided from start...
Attached Files
File Type: zip Run.zip - [Click for QR Code] (233 Bytes, 55 views)
The Following User Says Thank You to Tokl For This Useful Post: [ View ] Gift Tokl Ad-Free
Post Reply Subscribe to Thread

Tags
battclock, cell, gps, radio, tower

Guest Quick Reply (no urls or BBcode)
Message:
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes