This is an interesting project on GitHub for syncing data from the Strava API for analysis from a local database. I’ve had my eye out for some way to do this cleanly — to use the Strava Activities API to sync each track and its metadata to a local Postgres database. My interest is in being able to put the tracks on a map (mostly), but some of the analysis shown here is pretty cool, too.
In this author’s case it’s about cycling data. I want to be able to run SQL on the global archive of activity data, like so: