Consolidated.db to KML win converter: iPhone users -iOS 4- are Tracked !

Engadget submitted 4 days ago an article says that apple since the iOS 4 upgrade started storing all iPhone your movements into a file, although it’s not a GPS location data, its only Cellular network, CDMA network, & Wifi, it’s still pretty dangerous, specially when there is a time stamp for each point of existence recorded.

I’ve developed a small tool for windows users, who were able to get the consolidated.db file to converts it into .KML file to view their locations through Google Earth.

This tool is safe, its safer than previewing your history with time stamps online, i know there is already a french website for displaying it on Google Maps, but you upload the the whole thing, and you risk your self.

Enough chitchat let us go through the steps in how to do it:

1. You need Google Earth Installed, download & install Google Earth from here

2. Download iPhone backup extractor from here:
http://www.reincubate.com/res/labs/iphonebe/iphonebackupextractor-latest.zip

• Extract the tool temporary directory
• Run the tool, it will location the list of backups available on your computer, chose the latest backup
• extract the file consolidated.db located in : Library/Caches/locationd/consolidated.db  to your Desktop
• it will extract, the folder library, go inside the sub directory until you reach the .db file, move it to your desktop

3.  Download  Consolidated.db to KML Converter here:

http://cid-8b94866692f754d3.office.live.com/self.aspx/Public/Applications/Consolidated2KML.zip

• Extract both files (.exe & .dll) files to your Desktop
• run Consol2KML
• Load the file consolidated.db
• Click on Fetch
• Click Extract, this probably take sometime, depends on the .db file size (number of locations stored)
• Save the desired to . KML file

4. View .KML files in Google Earth, Enjoy revising your privacy !