From 9707f9ad09db935af7d06b5de08bc52de13ba6a7 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 3 Aug 2026 08:25:07 +0200 Subject: feat: Detect mountain pass crossings, name climbs after passes, render ride charts - osmpass: extract mountain_pass=yes nodes from an OSM PBF, enrich centcols passes with OSM coordinates, resumable -fetch-osm download - mountain_pass: DetectCrossings for a ride, MatchClimb to name a climb after the pass it tops - ride: expose Points(), add Climb.Top() and Climb.Name - chart: -chart renders elevation profile with climb bands and pass markers - commands: -fetch-osm, -extract-osm, -import-cached, -enrich --- db/schema.sql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'db/schema.sql') diff --git a/db/schema.sql b/db/schema.sql index e6796c8..398bfea 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -6,7 +6,16 @@ CREATE TABLE mountain_passes ( country_code text not null, department_code text not null, elevation integer not null +, latitude real, longitude real); +CREATE TABLE osm_passes ( + id integer primary key, + osm_id integer unique not null, + name text, + elevation integer, + latitude real not null, + longitude real not null ); -- Dbmate schema migrations INSERT INTO "schema_migrations" (version) VALUES - ('20250802140659'); + ('20250802140659'), + ('20260802090000'); -- cgit v1.2.3