mbirth/php-owntracks-recorder
Archived
1
0
Fork 0
Code Issues 1 Pull Requests Activity
This repository has been archived on 2025-03-31. You can view files and clone it, but cannot push or open issues or pull requests.
php-owntracks-recorder/tools
History

README.md

Google Location History Import

This allows you to import your Google Location History (incl. old Google Latitude) data into the database.

  1. Go to Google Takeout.
  2. Disable all options by clicking on "SELECT NONE".
  3. Find the entry "Location History" and enable it. Make sure the format is set to "JSON".
  4. Go to the bottom and click "NEXT". Follow the steps to the end.
  5. Wait until you get the completion notification and download the file.
  6. Unpack the file and find the Location History.json.
  7. Put the Location History.json in this directory.
  8. Modify the import_google_history.php and set your desired tracker id in line 5.
  9. Run: 
    php import_google_history.php

Notes

  • LatitudeE7 and LongitudeE7 have to be divided by 1e7 to get the float value
  • velocity is in metres per second (multiply by 3.6 to get km/h)
  • Importing a 500 MiB JSON file with 2.3m records into SQLite takes about 22 minutes