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

Apr 24

Posted by

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 !

Posted on April 24, 2011, in Computers, Geekz and tagged , , , , , , , , , , , , , , . Bookmark the permalink. 27 Comments.

  1. Roba | April 25, 2011 at 10:07 am

    Thanks for this Mesh! 🙂

  2. Andrix | April 26, 2011 at 7:55 am

    when i click “extract”, after the extracting cell data, start the “extracting cdma data”… and the program make an error

    (i have an iphone 3g)

  3. Mesh | April 26, 2011 at 3:31 pm

    maybe the 3G is not having CDMA data, i will edit the program and update you.

    thank you for your feed back

  4. Mesh | April 26, 2011 at 3:32 pm

    can you please specify the error ?

  5. Jeremy | April 26, 2011 at 4:12 pm

    I get an error too. This is what I get when I try to export to KML. I took a screenshot and put it on Flickr:
    consolidateddb_KML_error

  6. Meshx86 | April 27, 2011 at 5:48 am

    Hello Jermey,

    the error you posted, it belongs to iPhone Backup Extractor, this tool used just to extract the .db file first, i didn’t develop that, i just made the .db to KML converter.

    anyway, try to run the iphone backup extractor with Administrative priviliges, i’ve ran it in Windows 7 & XP with no issues.

    best of luck

  7. Kimzter | April 27, 2011 at 10:21 am

    Hey, Mesh, did you update the program to accommodate consolidated.db files with no CDMA-data? I’m getting the same error, “No such table, CDMACellLocation” plus the sql select statement.

    /K

  8. Mikl | April 27, 2011 at 10:28 am

    Is there time data in KML-file? As I can see, there are only longitude and altitude in KML, without timestamps.

    It would be great to get time-linked points to view track, not only places.

  9. Meshx86 | April 27, 2011 at 10:37 am

    Kitzemer, it seems the file you have don’t have the CDMA data, i will adjust the program to individually select data

    Mik: i am working on it, the time stamp is freakin apple format, need math to do the math 🙂

  10. Meshx86 | April 27, 2011 at 11:44 am

    Kimzter & Andrix

    now CDMA extract is optional, it shouldn’t give any error now.

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

  11. Andrew | April 30, 2011 at 4:08 pm

    Hi,

    I’m one of the authors of the iPhone Backup Extractor. Thanks for mentioning our software! We’ve just released an updated version which can directly extract the location data to CSV or KML data, and it’ll work with both US iPhones (which use CDMA) and non-US iPhones (which use GSM)

    Although the free version says it’s limited to only a single file, we’ve chosen not to restrict location data in this way – you can use the free version to extract all the location data you want without limitation.

    If anyone has any feedback then it’s always welcome!

    Andrew

  12. Kimzter | May 9, 2011 at 1:29 pm

    Awesome, Mesh, works like a charm!
    Thanks! 🙂

  13. Bill | July 27, 2011 at 9:06 pm

    Works great, but its hard to look at and see what is what without the dates and time of the entries. FYI. I can’t see what is new and what is old

  14. Tom | August 18, 2011 at 12:05 pm

    Bug report:

    I have an iPhone 3G, the error came up when “CDMA Data” was checked.

    Best regards, and THX very much 🙂

  15. sorin | September 1, 2011 at 1:06 am

    i have the same problem like tom.what i need to do?thanks

  16. Charity | December 20, 2011 at 5:21 pm

    Will this help me pull records of my location for a certain date and time? I need to prove where I was for an insurance claim. I was involved in an accident and the other driver is not telling the truth. My iPhone location would bring the truth to light. I just need to know how to access and read the information.

  17. Meshx86 | December 20, 2011 at 7:02 pm

    a pity i think IOS 5 has removed this tracking as far as i know, another issue is the tool i created will plot the location only with no time.

    i think there is away to plot everything using google tables

  18. Charity | December 20, 2011 at 7:13 pm

    Can you help me with that tool you created? Will that help me out? Anything you can help me with would be greatly appreciated. I still plan on seeing if the consolidated.db files are there and accessible when I get home with my phone. I have never had to access them.

  19. Frederik | October 20, 2012 at 2:09 pm

    Hey there – is this working with IO6 – I have some problems with it.

  20. Meshx86 | February 28, 2013 at 10:21 am

    if anyone is interested, please send me your files consolidated.db and the version of ios on my email mohshs86@hotmail.com i will try to modify the program accordingly, submit a comment to confirm you sent, so the email might go to junk..

    privacy is guaranteed

  21. Ray | August 12, 2013 at 12:20 pm

    i failed to view it my file consolidated.db my ios is 6.1.3 please help

  22. Meshx86 | August 12, 2013 at 1:26 pm

    Can you please send me the cons.db file i would check it out

  23. Rayan Rassam | August 12, 2013 at 3:08 pm

    please find it is attached

    Thanks

    ________________________________

  24. matt | November 28, 2013 at 12:24 am

    Hi mate,

    Cheers for the post, I am unable to view my consolidated.db file. i am on ios7.0.4. Is it possible to send it across? I have attached it in an email

    Thanks

  25. Meshx86 | November 28, 2013 at 7:47 am

    matt,

    apparently Apple is not storing those kind of information anymore on the consolidated.db file, not sure f they are storing it somewhere else. you can use an “SQLite” explorer or browser to open the database and check the tables your self, if it happened and contained a coordinates of any kind, i’ll be glad to help you extract them into a .KML

  1. Pingback: iPhone user? View the data Apple has stored | And Far Away

  2. Pingback: Proteggere iPhone: consigli dopo la scoperta di consolidated.db

Leave a comment