Google Map's Timeline records where I (or at least my phone) has been throughout the day every day. Given a particular location, I'd like to see a list of times when I've been there. To get tax credit for days not spent working in a municipality I need to prove that I was out of the city on each day.
No, Google Maps doesn't let you do that. It frustrated me as well, so I've written a python script that does just that.
You can find it here: https://github.com/matthieuheitz/google-data-analyses/blob/master/get_visit_times.py
You give it the point of interest (latitude/longitude), a date range, and you get what you want!
A brief overview of what is involved, if you have not used Python before:
- Install Python (the basic GUI provided is adequate)
- Install numpy (Windows guide)
Edit get_visit_times.py with the basic Python editor with your:
a. Location of your Google Location History JSON file
b. Desired date range with dates in the format YYYY,M,D
c. Point of Interest (Use the "right-click > What's here" feature on Google maps to get the GPS coordinates, and paste into the Python script)
d. Timestamp grouping (output detail verbosity)
Run the script (Run tab > Run module)
An example of the output (with medium detail (level 2), and the timeframe set to one day) is:
Loading 'C:\<your folder path>\Location History.json' ... JSON file loaded Extracting relevant data... Total of points: 310779 Number of close points: 72 Point 124834 -- Date: 2018-11-24 00:24:03 -- Distance to POI: 1532m Group of 60 points Point 129468 -- Date: 2018-12-01 02:58:17 -- Distance to POI: 1401m Group of 12 points
You can upload your Google location history (just follow the instructions) to this website: http://theyhaveyour.info/ then you can zoom in to find the location you are interested in and if you click on it you can see the list of the "timepoints" for that location.
https://social.technet.microsoft.com/Forums/en-US/ad13ae2c-d437-4d53-8622-923943938ca4/converting-json-to-csv?forum=winserverpowershell shows a way to do it in PowerShell.
$in = Get-Content -Raw -Path '<input file>.json' $injson = convertfrom-json $in $injson.Locations | export-csv locations.csv -notypeinformation
locations.csv has 4 columns: timestampMS, latitudeE7, longitudeE7, accuracy
Maybe the Elcomsoft Cloud eXplorer can do it.
Its mentioned in this article Google Timeline: How Law Enforcement Can Use Google Data.