diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-03 08:25:07 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-03 08:25:07 +0200 |
| commit | 9707f9ad09db935af7d06b5de08bc52de13ba6a7 (patch) | |
| tree | 34bcd01e5eda302a8730bf0817d5dd7e82186359 /db/schema.sql | |
| parent | f06a10982ab9d5aaa7d31cea31964431fa75f253 (diff) | |
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
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 11 |
1 files changed, 10 insertions, 1 deletions
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'); |