±Forensic Focus Partners

±Your Account


Nickname
Password


Forgotten password/username?


Membership:
New Today: 0
New Yesterday: 6
Overall: 27333
Visitors: 91

±Follow Forensic Focus

Join our LinkedIn group

Subscribe to news

Subscribe to forums

Subscribe to blog

Subscribe to tweets

Convert Iphone 4 Consolidated.db file to Google earth

Discussion of forensic issues related to all types of mobile phones and underlying technologies (GSM, GPRS, UMTS/3G, HSDPA, LTE, Bluetooth etc.)
Subforums: Mobile Telephone Case Law
Reply to topicReply to topic Printer Friendly Page
Forum FAQSearchView unanswered posts
Go to page 1, 2  Next 
  

Convert Iphone 4 Consolidated.db file to Google earth

Post Posted: Thu Jan 06, 2011 12:23 pm

Is there a way to, or a program (for the PC) that can read the Consolidated.db file from the Iphone 4 backup folder and accurately translate the cell locations and timestamps into Google earth?

So far I've used Dcode to convert some of the timestamps, just to have a starting point but it only converts one timestamp at a time.

Then I converted the db file to a CSV file, then converted the CSV to KML and then imported Lat & Long into Google earth but there are multiple locations for the same timestamps, sometimes more than 80 locations and most are miles apart, even crossing into nearby states or in the middle of the ocean.

There are a few programs that will do this for other GPS devices, has anyone heard of one that will work with the Iphone 4?

Thanks in advance for your help.  

Gangstageek
Newbie
 
 
  

Re: Convert Iphone 4 Consolidated.db file to Google earth

Post Posted: Thu Jan 06, 2011 2:37 pm

.....although it doesn't translate the timestamps have you tried using iBackupBot for iTunes.....? It's a fanatastic tool for the money and I think there is a free version. It will structure all of your files in Backup and allow you to export the .db files.  

Redcelica67
Senior Member
 
 
  

Re: Convert Iphone 4 Consolidated.db file to Google earth

Post Posted: Thu Jan 06, 2011 3:08 pm

iBackupBot gives you access to the information but the problem is converting the information into a path or area that Google earth or any other map program can understand.

This is bacically what you get: Time/Lat/Long

307150235.038898 40.3551138 -73.97351944
307150235.038898 40.35205978 -73.97275948
307150235.038898 40.35778558 -73.97811537
307150235.038898 40.34804743 -73.97517013
307150235.038898 40.36346822 -73.97411775
307150235.038898 40.36423844 -73.97691071
307150235.038898 40.36409598 -73.98234236
307150235.038898 40.36541533 -73.98074167
307150235.038898 40.36503523 -73.98742842
307150235.038898 40.36726373 -73.98254436

I can import them into any map program with no problem but information is useless if it shows the phone in 80 different locations at the same time...

Let's say the next timestamp is 5 minutes later, there will just be another 80 locations for that timestamp all miles apart.

For one day alone the location and time stamps can number in the hundreds.  

Gangstageek
Newbie
 
 
  

Re: Convert Iphone 4 Consolidated.db file to Google earth

Post Posted: Thu Jan 06, 2011 4:21 pm

I'm unsure if this of any use but another member worked on consolidated.db so maybe they can advise? www.forensicfocus.com/...pic&t=6827  

Redcelica67
Senior Member
 
 
  

Re: Convert Iphone 4 Consolidated.db file to Google earth

Post Posted: Tue Jan 11, 2011 8:49 am

XRY v5.3 can do this for you as a standard export feature direct to Google Earth.

www.msab.com/products/...h/page.php

This includes exporting the consolidated database from the iPhone 4.  

XRY_Mike
Member
 
 
  

Re: Convert Iphone 4 Consolidated.db file to Google earth

Post Posted: Sat Jan 15, 2011 9:17 am

UFED PA v2.0 added geolocation and many more data types to iPhone decoding.

If you are a UFED user, ask for a beta version that is already available of the UFED PA v2.0  

RonS
Senior Member
 
 
  

Re: Convert Iphone 4 Consolidated.db file to Google earth

Post Posted: Sun Jan 16, 2011 4:26 am

you can upload your file and view it in google map:
www.courbis.fr/Localis...votre.html  

Alf95
Member
 
 
Reply to topicReply to topic

Share this forum topic to encourage more replies



Page 1 of 2
Go to page 1, 2  Next