From 558f755f5746a4ee819de87579951b7533688e5d Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Thu, 27 Aug 2026 18:05:59 +0200 Subject: Categorise OSM passes by highway and colour them on the ride detail map Passes are extracted from OSM PBF nodes (mountain_pass=yes) and linked to containing ways; highway road values map to road, track to track, path/footway to path, plus hiking for rock/climbing. All passes are kept, coloured distinctly (road/track/path/hiking/unknown) for road-bike validation on ride 397. Single squashed migration adds category column, cheap to re-extract. --- README.md | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) (limited to 'README.md') diff --git a/README.md b/README.md index deaa9fb..8744938 100644 --- a/README.md +++ b/README.md @@ -49,6 +49,12 @@ The Strava v3 API (OAuth2) is the platform's public access point; scopes gate ea Standard apps are rate-limited to 100 calls per 15 minutes and 1,000 per day. +## OSM + +Passes are French OSM PBF nodes with `mountain_pass=yes` (or legacy `natural=mountain_pass`), stored with name, elevation and coordinates. + +An OSM way is an ordered list of nodes; its `highway` tag describes the road type. For each pass we collect the ways containing its node ID and map `highway` road values (`primary`/`secondary`/…/`service`) → `road`, `track` → `track`, `path`/`footway` → `path` (plus `natural=rock`/`sport=climbing` → `hiking`, no way → `unknown`), coloured distinctly on the ride detail map. + ## Architecture - Go 1.27; SQLite via `mattn/go-sqlite3` @@ -159,6 +165,9 @@ go tool pprof -http=:8081 http://localhost:8080/debug/pprof/heap # allocs ## TODO +- Garmin GPX: elevation, time, temp, HR, cadence +- Garmin TCX: stats (cal, HR, time, cadence) + pos, alt, distance, HR, cadence, speed +- Garmin FIT: time, sport, lap/split, gps, sensor, events - screaming archi + hexagon - Compute estimated power, speed - For a ride, scatter, one point per 100m segment. Slope vs speed @@ -174,8 +183,6 @@ go tool pprof -http=:8081 http://localhost:8080/debug/pprof/heap # allocs - Profile - Adaptative to show ramps - Record ride times on official climbs - Destination via Start -- Mountain pass - - issue: many passes are pedestrian (cf Marseille Calanques, http://localhost:8080/rides/397) - Ride planning - Road quality (Arbois = 2/5, Roquefavour = 4/5) - Blog with pictures and markdown -- cgit v1.3