# jnyambok/my-strava-running-stats architecture

> Architecture diagram of the GitHub repository jnyambok/my-strava-running-stats, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/jnyambok/my-strava-running-stats
- Repository: https://github.com/jnyambok/my-strava-running-stats

## Overview

This project turns a periodic Strava export into a public running-stats dashboard: Python reads activity and GPS data into BigQuery, dbt models it into analytics, Python exports dashboard data, and the static site presents it. The graph preserves the documented metric branches. Source excerpts show the Python extraction, loading, and export calls; dbt model contents and dashboard wiring were not sampled, so those relationships are shown only where the README documents them or are left unlinked.

Main entry points: [`export/export_data.py`](https://github.com/jnyambok/my-strava-running-stats/blob/main/export/export_data.py) (Mart exporter), [`strava_dbt/models/marts/fct_runs.sql`](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_runs.sql) (Run facts), [`extract/tracks.py`](https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/tracks.py) (GPS track reader), [`extract/activities.py`](https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/activities.py) (Activity reader)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingest["Extract and load"]
  node_activity_reader["Activity reader<br/>[activities.py]"]
  node_track_reader["GPS track reader<br/>[tracks.py]"]
  node_raw_loader["Raw table loader<br/>[load.py]"]
  node_raw_bigquery[("BigQuery raw tables")]
end

subgraph group_model["dbt analytics"]
  node_stg_activities["Activity staging"]
  node_stg_tracks["Track-point staging"]
  node_track_distances["Track distances"]
  node_runs["Run facts<br/>[fct_runs.sql]"]
  node_weekly_runs["Weekly runs"]
  node_running_totals["Running totals"]
  node_best_efforts["Best efforts"]
  node_daily_fitness["Daily fitness"]
  node_monthly_pace["Monthly pace"]
end

subgraph group_publish["Dashboard publishing"]
  node_exporter["Mart exporter<br/>[export_data.py]"]
  node_dashboard_data["Dashboard JSON<br/>[data.json]"]
  node_dashboard_page["Public dashboard<br/>[index.html]"]
end

subgraph group_external["External data"]
  node_strava_export["Strava export"]
end

node_strava_export -->|"provides archive"| node_activity_reader
node_strava_export -->|"provides archive"| node_track_reader
node_activity_reader -->|"returns activities"| node_raw_loader
node_track_reader -->|"returns track points"| node_raw_loader
node_track_reader -->|"reads activity map"| node_activity_reader
node_raw_loader -->|"replaces raw tables"| node_raw_bigquery
node_raw_bigquery -.->|"stages activity rows"| node_stg_activities
node_raw_bigquery -.->|"stages track points"| node_stg_tracks
node_stg_tracks -.->|"derives distances"| node_track_distances
node_stg_activities -.->|"models run facts"| node_runs
node_track_distances -.->|"supports efforts"| node_best_efforts
node_runs -.->|"aggregates weekly"| node_weekly_runs
node_runs -.->|"aggregates totals"| node_running_totals
node_runs -.->|"models training load"| node_daily_fitness
node_runs -.->|"aggregates monthly pace"| node_monthly_pace
node_exporter -->|"queries totals"| node_running_totals
node_exporter -->|"queries runs"| node_runs
node_exporter -->|"queries weekly data"| node_weekly_runs
node_exporter -->|"queries fitness"| node_daily_fitness
node_exporter -->|"queries pace"| node_monthly_pace
node_exporter -->|"queries best efforts"| node_best_efforts
node_exporter -->|"writes JSON"| node_dashboard_data
node_dashboard_data -.->|"feeds dashboard"| node_dashboard_page

click node_activity_reader "https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/activities.py"
click node_track_reader "https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/tracks.py"
click node_raw_loader "https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/load.py"
click node_stg_activities "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/staging/stg_strava__activities.sql"
click node_stg_tracks "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/staging/stg_strava__track_points.sql"
click node_track_distances "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/intermediate/int_track_point_distances.sql"
click node_runs "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_runs.sql"
click node_weekly_runs "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_weekly_runs.sql"
click node_running_totals "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_running_totals.sql"
click node_best_efforts "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_best_efforts.sql"
click node_daily_fitness "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_daily_fitness.sql"
click node_monthly_pace "https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_monthly_pace.sql"
click node_exporter "https://github.com/jnyambok/my-strava-running-stats/blob/main/export/export_data.py"
click node_dashboard_data "https://github.com/jnyambok/my-strava-running-stats/blob/main/docs/data.json"
click node_dashboard_page "https://github.com/jnyambok/my-strava-running-stats/blob/main/docs/index.html"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_activity_reader,node_track_reader,node_raw_loader,node_raw_bigquery toneBlue
class node_stg_activities,node_stg_tracks,node_track_distances,node_runs,node_weekly_runs,node_running_totals,node_best_efforts,node_daily_fitness,node_monthly_pace toneAmber
class node_exporter,node_dashboard_data,node_dashboard_page toneMint
class node_strava_export toneRose
```

## Components

### Extract and load

- [Activity reader](https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/activities.py): `extract/activities.py`
- [GPS track reader](https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/tracks.py): `extract/tracks.py`
- [Raw table loader](https://github.com/jnyambok/my-strava-running-stats/blob/main/extract/load.py): `extract/load.py`
- **BigQuery raw tables**

### dbt analytics

- [Activity staging](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/staging/stg_strava__activities.sql): `strava_dbt/models/staging/stg_strava__activities.sql`
- [Track-point staging](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/staging/stg_strava__track_points.sql): `strava_dbt/models/staging/stg_strava__track_points.sql`
- [Track distances](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/intermediate/int_track_point_distances.sql): `strava_dbt/models/intermediate/int_track_point_distances.sql`
- [Run facts](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_runs.sql): `strava_dbt/models/marts/fct_runs.sql`
- [Weekly runs](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_weekly_runs.sql): `strava_dbt/models/marts/fct_weekly_runs.sql`
- [Running totals](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_running_totals.sql): `strava_dbt/models/marts/fct_running_totals.sql`
- [Best efforts](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_best_efforts.sql): `strava_dbt/models/marts/fct_best_efforts.sql`
- [Daily fitness](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_daily_fitness.sql): `strava_dbt/models/marts/fct_daily_fitness.sql`
- [Monthly pace](https://github.com/jnyambok/my-strava-running-stats/blob/main/strava_dbt/models/marts/fct_monthly_pace.sql): `strava_dbt/models/marts/fct_monthly_pace.sql`

### Dashboard publishing

- [Mart exporter](https://github.com/jnyambok/my-strava-running-stats/blob/main/export/export_data.py): `export/export_data.py`
- [Dashboard JSON](https://github.com/jnyambok/my-strava-running-stats/blob/main/docs/data.json): `docs/data.json`
- [Public dashboard](https://github.com/jnyambok/my-strava-running-stats/blob/main/docs/index.html): `docs/index.html`

### External data

- **Strava export**

## Connections

- Strava export → Activity reader: provides archive (evidence: `README.md`)
- Strava export → GPS track reader: provides archive (evidence: `README.md`)
- Activity reader → Raw table loader: returns activities (evidence: `extract/load.py`)
- GPS track reader → Raw table loader: returns track points (evidence: `extract/load.py`)
- GPS track reader → Activity reader: reads activity map (evidence: `extract/tracks.py`)
- Raw table loader → BigQuery raw tables: replaces raw tables (evidence: `extract/load.py`)
- BigQuery raw tables → Activity staging: stages activity rows (evidence: `README.md`)
- BigQuery raw tables → Track-point staging: stages track points (evidence: `README.md`)
- Track-point staging → Track distances: derives distances
- Activity staging → Run facts: models run facts (evidence: `README.md`)
- Track distances → Best efforts: supports efforts (evidence: `README.md`)
- Run facts → Weekly runs: aggregates weekly
- Run facts → Running totals: aggregates totals
- Run facts → Daily fitness: models training load (evidence: `README.md`)
- Run facts → Monthly pace: aggregates monthly pace
- Mart exporter → Running totals: queries totals (evidence: `export/export_data.py`)
- Mart exporter → Run facts: queries runs (evidence: `export/export_data.py`)
- Mart exporter → Weekly runs: queries weekly data (evidence: `export/export_data.py`)
- Mart exporter → Daily fitness: queries fitness (evidence: `export/export_data.py`)
- Mart exporter → Monthly pace: queries pace (evidence: `export/export_data.py`)
- Mart exporter → Best efforts: queries best efforts (evidence: `export/export_data.py`)
- Mart exporter → Dashboard JSON: writes JSON (evidence: `export/export_data.py`)
- Dashboard JSON → Public dashboard: feeds dashboard (evidence: `README.md`)
