biking_home/db, branch mainUnnamed repository; edit this file 'description' to name the repository.
https://git.kagamino.dev/biking_home/atom?h=main2026-09-25T06:46:58ZChart power vs time for official climb attempts2026-09-25T06:46:58ZMartin Kagamino Lehouxmartin@lehoux.net2026-09-25T06:46:58Zurn:sha1:077aa1700fbcaf3f499c2178e0e58e89ae9dcaf8
Snapshot average power per attempt in a nullable average_power_w column (backfilled from stored rides), plot each powered attempt on the climb page as duration vs average watts with ride hover and click-through, and show avg power in the attempts table.
Match official climbs against their recorded sample2026-09-24T06:37:33ZMartin Kagamino Lehouxmartin@lehoux.net2026-09-24T06:37:33Zurn:sha1:90614736f2a0c556f31eca5361b3c032f5f309f6
An official climb matched on endpoint coordinates alone. On a loop ridden
the other way the route meets the climb's top before its bottom, so pairing
each start with the first end inside its lap window credited a 5.9 km
passage as the 850 m Chemin de la Tour Pey Blanc, and a 49 km one on
another ride.
Climbs now keep the sample of the segment they were created from: the
recorded length and elevation gain of the selected route points, captured
by the ride detail and preview handlers and stored NOT NULL. Matching takes
the whole route and drops any candidate outside ±50% of that sample on
either axis, and attempts are refreshed by upsert and prune so re-analyzing
a ride keeps the recorded-at stamp of the passages that survive.
The backfill leaves the web package: backfill.Run recomputes ride values
then official climb attempts as a single `go run . backfill` command
(climbs-backfill is gone), rideanalysis owns the attempt snapshot, and the
mountain-pass loading margin is shared. Applied to the stored rides it
stamps 78 samples, drops the four bogus attempts and leaves ride 800 with
its three Pont Rout passages.
Persist official climb attempts with climbs pages2026-09-13T19:55:59ZMartin Kagamino Lehouxmartin@lehoux.net2026-09-13T19:55:59Zurn:sha1:e3d0beee5be3dd2854b0f4fc10905a4fcdc08f47
Record one attempt row per (ride, climb, occurrence) when a ride detail
loads, snapshotting distance, elevation gain, slope, cotacol and attempt
timestamps; a climbs-backfill CLI command seeds all existing rides.
New /climbs list page aggregates attempts (medians computed in Go, best
time as min duration) with sortable columns, and /climbs/{id} shows the
median scalar stats, a median normalized elevation profile (50 steps
over each attempt's own length), the full-precision recorded route of
the median-distance attempt on an OSM map, and every attempt with time
at second precision.
Rename rides.type to external_sport_type, infer bike type from Strava sport type and display categories in UI2026-08-28T20:38:57ZMartin Kagamino Lehouxmartin@lehoux.net2026-08-28T20:38:57Zurn:sha1:827b55f610119d553b965ceb4d3631f0481bbb3bAdd touring ride type for cyclotourisme2026-08-28T08:19:15ZMartin Kagamino Lehouxmartin@lehoux.net2026-08-28T08:19:15Zurn:sha1:10806900a46b4eba197af9fc768928c57bd33982Add dual GPX/FIT exporter and backfill for rides2026-08-27T17:03:34ZMartin Kagamino Lehouxmartin@lehoux.net2026-08-27T17:03:34Zurn:sha1:d7b93325d4f70eeab369fa8a3c4cce9f0c4e0081
Phase 1 writes both .gpx and .fit on Strava import, adds fit_path
column, renames storage.gpx_dir to storage.rides_dir, and backfills
missing FIT files from existing GPX without breaking CLI progress.
FIT files are gitignored.
Categorise OSM passes by highway and colour them on the ride detail map2026-08-27T16:05:59ZMartin Kagamino Lehouxmartin@lehoux.net2026-08-27T16:05:59Zurn:sha1:558f755f5746a4ee819de87579951b7533688e5d
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.
Add hardcore ride categorisation with bike and ride types2026-08-23T19:35:59ZMartin Kagamino Lehouxmartin@lehoux.net2026-08-23T19:35:59Zurn:sha1:08fdd6964fd9ef29356420b035e2d186546f674aUse OSM as the single source of mountain passes2026-08-21T08:30:27ZMartin Kagamino Lehouxmartin@lehoux.net2026-08-21T08:30:27Zurn:sha1:44f7333d9deef81d3468e20b378c63692a9406ec
Replace the centcols CSV download/enrichment pipeline with OSM PBF
extraction as the primary (only) source: merge osmpass into mountain_pass,
drop the centcols table and model fields, filter to named passes with
elevation, and remove the centcols CLI flags.
feat(ride): persist canonical moving time, preserve Strava reference2026-08-21T04:56:12ZMartin Kagamino Lehouxmartin@lehoux.net2026-08-21T04:56:12Zurn:sha1:9da52d7355f5a77f0adc9a658619b3bfef03ba3c