Introduction

• This main script take data from various databases present in the iOS file system and pulls the location data and formats the data into .kml files.
• The user will have the option to save the parsed data into a .csv file by using the --csv y option.

Syntax

python .\create_kml_from_data.py --source "[FILE-PATH-TO-DATABASE]" --dest "[DIRECTORY-WHERE-OUTPUT-SAVED]" --destf "[OUTPUT-FILE-NAME]" --csv ['y','n'] --database [1,2,3,4,5,6] --btime [TIME-OF-FIRST-RECORD-TO-QUERY] --etime [TIME-OF-LAST-RECORD-TO-QUERY]

Script Help

create_kml_from_data.py

---

• Create a .kml file by reading the location records from the database specified by the user.
• The --btime and --etime values should be given in "Apple Absolute Time" (a/k/a) "Cocoa Core Data" format. To convert time values to/from the required input, see: https://www.gaijin.at/en/tools/time-converter.
• For the --database argument, enter the corresponding number for the database you want to examine: 1=Cache.sqlite (Location History), 2=cache_encryptedB.db (WiFi locations), 3=cache_encryptedB.db (LTE locations), 4=Cloud-V2.sqlite (Significant Locations), 5=Local.sqlite (Significant Location Visits), or 6=Local.sqlite (Vehicle Locations)