This is a small python project which allows you to easily collect your activity data using the offical strava API.
The data is collected and stored to a sqlite Database using the following Datamodel.
| Table | Column | Datatype |
|---|---|---|
| ACTIVITIES_META | device_name | text |
| ACTIVITIES_META | distance | real |
| ACTIVITIES_META | moving_time | int |
| ACTIVITIES_META | elapsed_time | int |
| ACTIVITIES_META | total_elevation_gain | real |
| ACTIVITIES_META | type | text |
| ACTIVITIES_META | start_date_local | timestamp |
| ACTIVITIES_META | average_speed | real |
| ACTIVITIES_META | max_speed | real |
| ACTIVITIES_META | average_cadence | real |
| ACTIVITIES_META | average_watts | real |
| ACTIVITIES_META | weighted_average_watts | int |
| ACTIVITIES_META | kilojoules | real |
| ACTIVITIES_META | device_watts | int |
| ACTIVITIES_META | has_heartrate | int |
| ACTIVITIES_META | calories | real |
| ACTIVITIES_META | max_watts | int |
| ACTIVITIES_META | gear | text |
| ACTIVITIES_META | id | integer |
| ACTIVITIES_META | last_update | timestamp |
| Table | Column | Datatype |
|---|---|---|
| ACTIVITIES_RAW | altitude | real |
| ACTIVITIES_RAW | velocity_smooth | real |
| ACTIVITIES_RAW | cadence | int |
| ACTIVITIES_RAW | grade_smooth | real |
| ACTIVITIES_RAW | heartrate | int |
| ACTIVITIES_RAW | watts | int |
| ACTIVITIES_RAW | distance | real |
| ACTIVITIES_RAW | moving | int |
| ACTIVITIES_RAW | time | int |
| ACTIVITIES_RAW | lat | real |
| ACTIVITIES_RAW | long | real |
| ACTIVITIES_RAW | temp | real |
| ACTIVITIES_RAW | id | int |
| ACTIVITIES_RAW | last_update | timestamp |
| Table | Column | Datatype |
|---|---|---|
| AUTH_INFO | token_type | text |
| AUTH_INFO | access_token | text |
| AUTH_INFO | refresh_token | text |
| AUTH_INFO | expires_at | text |
| AUTH_INFO | last_update | text |
| AUTH_INFO | user_id | text |
- You have to create a own application to use the strava API. Please follow the official instructions and make sure that you and your usage of this project agree with their ToS and API Agreement.
- In order to use this project I would strongly recommend to use Docker.
Using the project is very simple with docker.
- In the base folder add a .env File with the following content:
CLIENT_ID=yourclientid(like 123456)
CLIENT_SECRET=yourclientsecret(like as1231asdfasd9)
- Build the application with
docker-compose buildfrom base level - Run the application with
docker-compose run strava-datacollect
After oauth2 authentication to your application a initialization step is conducted querying all your data from the in the configuration specified years (defaults to 2018, 2019, 2020). This might take several hours as the application does a lot of waiting to not conflict with the API limits. You might want the use less conservative settings changing the configuration parameters. After initialization it is checked hourly if new data is available from strava. If so it will automatically be added to your Database.
When running the application the first time you need to use oauth2 to provide your application access. Follow the instructions given.
The configuration of the application lives in the config folder. You might want to change things there like the years to collect data from when instantiating the application.
You might not want to use a volume manged by docker (due to accessiablity issues depending on what you are planning to do with your data). Simply changing the strava-database volume to a full path at your local file system should to the job. You can then remove the section in the docker-compose file where the docker volume is defined.
docker-compose up is not working because we lose the stdin needed to get the oauth response url.