Saturday 7 January 2017

Strava Data Analysis - A PC Based Visual C# Solution - V1.0.0.6

See latest version here: link

Updated Version - V1.0.0.6

Please read this first post for instructions. This is needed to understand what the application does and how it works

The update is from my Google Drive here: V1.0.0.6

This version sees a number of updates:
  1. internally modified as to how the  data grid views are filled and managed. Later versions will use this further and provide additional functionality. For example exporting data is improved
  2. Added the ability to extract the raw time based data from a particular activity. This is the data that is collected during an activity. V1.0.0.1 generated a list of activities and the overall data from that activity
  3. Uses the activity data and generated a simple set of statistics
To set up and use the Application see the link above


To use the new activity data feature load in the activities in the date range required as before.
Select the activity that you want the data for
Double-click in the left most column of that activity and wait for a while. The tab "Activity Data" will contain the time based data and the tab "Activity Stats" will contain basic statistical data.


The Main Window

The Activity Data
Note here that for this ride I was not in my privacy zone so the data does start at 0 seconds. Also I started to ride then stopped and restarted. The Garmin will not log 0 speed so there is a minute "gap" in the time based data.

This exported data can the be plotted or processed in your favourite analysis tool. Here is an Excel version of the data:




The Basic Activity Statistics


Issues to be aware of:
  1. There's minimal error trapping at the moment.
  2. There's no progress indication so it might look like its hung - getting the activities over a wide date range can take quite a long time (depends on the number, connection speed etc.). This needs some improvement
  3. Your data will be exported in TAB separated format. This allows the application to retain commas if used in the activity name - i.e. "First Ride of the year, muddy" for example.
  4. If the activity name includes the " character this is replaced by the ' character -
    i.e. "First Ride of the year, to the "Big Mountain"" for example will be replaced by
    "First Ride of the year, to the 'Big Mountain'"
  5. When you export your activity data, if you have a privacy zones set up any data in this zone is not currently available.
  6.  The .Net Strava API I am using seems a little out of date. For example the official Strava API includes temperature, power etc in the streams. In the Strava API these are "watts" and "temp" but the .Net API refers to these as "Watts" and "Temperature", so even though the data stream contains the data it cannot be accessed. All the source code is provided so I suspect that I'll need to use it differently and modify the code to make it work. This looks "difficult" for someone of my current knowledge level, but is possible
Further Planned Improvements
  1. More fully test the deployment of the application and the installation process. I think the free version of Visual Studio is more limited in the respect
  2. Look for a better way to authenticate the application. Having to create your own application and paste in the token is pretty un-user friendly
  3. Using #2 get access to the private data to get a full data set irrespective of privacy zones
  4. Add simple graphs of activity data
  5. Add simple statistics and graphs of activities data
  6. Enable a means to filter activity types - i.e. Cycling, running etc, and where appropriate filter these further - i.e. for cycling split out rides and turbo trainers for example, or by year for activities
  7. Ability to delete data points where the data is redundant or un-representative
  8. Get more of the data available - so segments etc
  9. Bulk export of all activities or within a date range

Monday 2 January 2017

WInter Riding

Here's a short video of climbing Rose Hill (almost the top of the Lickey Hills) near Birmingham

Starting in Barnt Green it climbs to the foot of the Hill and then in the mist drops back down the Old Birmingham Road

As with all my rides at the moment, slow and hard work:


My 2016 Year on Strava

Here's my 2016 Year according to Strava:

Click on the Hyperlink not the picture!



 And here is my Veloviewer infographic: