From 9707f9ad09db935af7d06b5de08bc52de13ba6a7 Mon Sep 17 00:00:00 2001
From: Martin Kagamino Lehoux <martin@lehoux.net>
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/migrations/20260802090000_osm_passes.sql | 17 +++++++++++++++++
 db/schema.sql                               | 11 ++++++++++-
 2 files changed, 27 insertions(+), 1 deletion(-)
 create mode 100644 db/migrations/20260802090000_osm_passes.sql

(limited to 'db')

diff --git a/db/migrations/20260802090000_osm_passes.sql b/db/migrations/20260802090000_osm_passes.sql
new file mode 100644
index 0000000..873e80a
--- /dev/null
+++ b/db/migrations/20260802090000_osm_passes.sql
@@ -0,0 +1,17 @@
+-- migrate:up
+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
+);
+
+alter table mountain_passes add column latitude real;
+alter table mountain_passes add column longitude real;
+
+-- migrate:down
+alter table mountain_passes drop column latitude;
+alter table mountain_passes drop column longitude;
+drop table osm_passes;
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