[Qgis-us-user] Extracting Google Maps/Timeline data

[karsten]

Hi Alex,
 
I have to admit that I never looked at such data from Goggle before (nor did
I know how big brother like this is, at least you need to activate on the
phone the tracking).
That said I took  a brief look at it and form the timeline Google page you
can export that to a  kml format (Google earth format). This results in
potentially huge files and a very verbose format. Alternatively check if you
can export as a comma separated text file (csv) directly from there
(including the x/y location columns)

You can load such a kml into QGIS natively (add vector file), form there you
might be able to export to excel as attribute only and then save in that
format and do the next (scrubbing) step in excel or libre office. Those data
you should then be able to load into QGIS as csv files
see and example here
https://www.qgistutorials.com/en/docs/3/importing_spreadsheets_csv.html
 
If you need more help you are welcome to contact me off channel privately by
email ;)
 
Cheers
Karsten
 
 

  _____  

From: Qgis-us-user [mailto:qgis-us-user-bounces at lists.osgeo.org] On Behalf
Of Alex Willen
Sent: Monday, March 22, 2021 07:10
To: qgis-us-user at lists.osgeo.org
Subject: [Qgis-us-user] Extracting Google Maps/Timeline data


Hi - My name is Alex and I'm new to the QGIS USA group and QGIS software.
I'm in search of a way to take GPS data Google tracks from my phone (date,
travel origin, travel destination, and distance traveled), converting that
data into a spreadsheet format, scrubbing the spreadsheet for business
related travel, and using that data for tax purposes. Is this something that
could be quazi easily done with QGIS? If not easily done, would anyone be
interested in being hired to do this for me? I imagine this is a lower level
task for a software and user group with higher level abilities, and I
therefore mean no offense in asking these questions. Regardless of response,
I appreciate your time and insights, Alex
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-us-user/attachments/20210322/39a66030/attachment.html>