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
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@lists.osgeo.org] On Behalf Of Alex Willen
Sent: Monday, March 22, 2021 07:10
To: qgis-us-user@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