This tool turns your Google Maps location history into a database.
It is crafted in Clojure and executed using nbb with Node.js. Its only dependency is sql.js.
Requirement: Node.js v18 or newer.
To install the necessary dependencies, run npm install
.
Grab your location history from Google Takeout and unzip the file. Find those per-month timeline JSON files tucked away in Location History/Semantic Location History/
.
Run the script on one or more files:
npm run timeline2sqlite 2023_MAY.json 2023_JUNE.json
This will generate a database named places.sqlite
, overwriting it if it already exists. Open this file using the sqlite CLI, Datasette, or any other database management tool.