14

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.

migrated from superuser.com Feb 9 '17 at 15:12

This question came from our site for computer enthusiasts and power users.

  • 2
    did you ever get this figured out? – ashleedawg Aug 12 '18 at 8:55
4

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.

  • I tried this. When I opened the LocationHistory.json file on the site it said "Not quite! LocationHistory.json does not look right. Extract LocationHistory.json from your zip file and drop it here." I downloaded the location history twice and opened both on theyhaveyour.info, trying both the .zip and .json files. – blearyeye Feb 8 '17 at 19:46
  • The problem is probably file size. It's 291MB. – blearyeye Feb 8 '17 at 20:14
  • Worked for me with a 387 MB json file – user1251007 Oct 17 '18 at 19:50
  • It's a good website, but I feel that a lot of it is not working properly (time filters for example) – matthieu Apr 12 at 0:36
3

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

3

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 !

-2

It does sound like a lot of "proof" required - who is to say you didn't pop back with your GPS turned off?

My experience of the tax office is you need to show some evidence if requested to. They don't usually ask for an arm and a leg, unless you are REALLY defrauding... 2 friends of mine were senior tax investigators!

A lot of people do log books of car mileage everyday etc just for tax evidence, or keep specific receipts etc - I am sure you know that.

My experience with the Google location data or trying to find a lost phone etc is that its hard to keep a list. Especially when trying to keep track of an errant daughter...

You could use something like Facebooks "check in" feature and do that when you are IN the area?

Or perhaps screenshot your google map with your location on every day you are either IN or OUT of the location, and keep those as a log - no more stressful or arduous than remembering to keep a mileage log!

Perhaps as simple as a photo of the place in the town with date and timestamp - it will only ever be needed if requested and then you can send them a big zip file full of pictures!
Be creative, shots by the beach, in the cafe... you can make it fun!

  • Yeah, proof is too strong. Evidence suffices. I didn't occur to me to keep a log for 2016 so I'd was hoping to track down a few days at least. – blearyeye Feb 5 '17 at 2:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.