Convert Iphone 4 Co...
 
Notifications
Clear all

Convert Iphone 4 Consolidated.db file to Google earth

12 Posts
9 Users
0 Likes
1,656 Views
(@gangstageek)
Posts: 2
New Member
Topic starter
 

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.

 
Posted : 06/01/2011 10:23 pm
Redcelica67
(@redcelica67)
Posts: 130
Estimable Member
 

…..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.

 
Posted : 07/01/2011 12:37 am
(@gangstageek)
Posts: 2
New Member
Topic starter
 

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.

 
Posted : 07/01/2011 1:08 am
Redcelica67
(@redcelica67)
Posts: 130
Estimable Member
 

I'm unsure if this of any use but another member worked on consolidated.db so maybe they can advise? http//www.forensicfocus.com/index.php?name=Forums&file=viewtopic&t=6827

 
Posted : 07/01/2011 2:21 am
XRY_Mike
(@xry_mike)
Posts: 28
Eminent Member
 

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

http//www.msab.com/products/overview/google-earth/page.php

This includes exporting the consolidated database from the iPhone 4.

 
Posted : 11/01/2011 6:49 pm
 RonS
(@rons)
Posts: 358
Reputable Member
 

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

 
Posted : 15/01/2011 7:17 pm
(@alf95)
Posts: 43
Eminent Member
 

you can upload your file and view it in google map
http//www.courbis.fr/Localisation-iPhone-votre.html

 
Posted : 16/01/2011 2:26 pm
(@chrisholt)
Posts: 1
New Member
 

you can upload your file and view it in google map
http//www.courbis.fr/Localisation-iPhone-votre.html

#

Is there anyway to download this to view off line, don't feel comfortable uploading details anywhere.

 
Posted : 27/04/2011 8:13 pm
ForensicRanger
(@forensicranger)
Posts: 122
Estimable Member
 

Perhaps this can help
http//meshx86.wordpress.com/2011/04/24/iphone-users-ios-4-aretracked/

 
Posted : 29/04/2011 3:47 am
(@jdcoulthard)
Posts: 98
Trusted Member
 

Hi There

I have been playing around with this and put a quick app together called iStalkr.

You can download it from here

The application has a built in map viewer to display individual locations and allows the user to export data to Google Earth (KML) with a number of grouping and filtering options.

Let me know what you think D

 
Posted : 29/04/2011 1:39 pm
Page 1 / 2
Share: