colemanm.org

  • Archive
  • Books
  • Links
  • About

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:

Strava Activity SQL Analysis

✦
Related Posts
  • 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.
  • Archive
  • Talks
© Coleman McCormick, 2010-2023. •