biking_home/db/migrations/20260827000000_mountain_pass_category.sql, branch mainUnnamed repository; edit this file 'description' to name the repository.
https://git.kagamino.dev/biking_home/atom?h=main2026-08-27T16:05:59ZCategorise 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.