Exploring Cycling Data with Python, Strava and PostgreSQL →May 9, 2019 • #
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:
- Goal Progress: November — Tracking my November goal progress for the year.
- Goal Progress: October — Tracking my October goal progress for the year.
- Goal Progress: September 2020 — Tracking my September goal progress for the year.