From GPS points
to coaching
20-minute tour of the development stages — with diagrams, live links and a live analysis at the end.
Position + speed is not the whole story
Seven steps down the slippery slope
Every stage kept on free tiers — swap tools when tokens/credit ran out. The geo core (PostGIS + course context tables) survived every pivot.
Raw GPS in, nothing lost
Sail_GPS/
├── data/raw, rawstage, rawstage3/ raw GPX / FIT dumps — kept immutable, never edited
├── data/Preload/ GPX + FIT + shapefiles staged for QGIS
├── data/context/race_context.gpkg course & mark context (GeoPackage)
├── etl/ scripts + sql the 4-step pipeline (next slide)
└── TrainingEventAnalysis/
├── Data/
└── IndividualAnalysis/ per-sailor sessions (slides 10–12)
Sources: handheld GPS trackers (GPX) and old phones running Sensor Logger (FIT/CSV at 1 Hz) — reference scripts: github.com/tszheichoi/awesome-sensor-logger.
PostGIS + a 4-step ETL (R1 → R2 → R3 → sailor_track)
Docker on an Ubuntu box, published through a tunnel
index.html) + Mapbox/MapLibre map views.file:// pages.Live links — click to open:
dev.sailsmart.nz /mapbox/dashboard 3D ribbon track (Ubuntu tunnel)
Key facts worth remembering
Phone IMUs turn the track into a 3D story
YOLO — you only look once
Presenation/Yolo/).One folder per sailor, one folder per session
TrainingEventAnalysis/IndividualAnalysis/ ├── Rick/ │ ├── 31 october 26/ 5 race GPX · tacks_summary.csv · rick_races.gpkg · rick_races_tacks.gpkg · tack_analysis.png · process_rick.py │ ├── Goose 2026-11-04/ Sensor Logger CSVs (accel/gyro/location) · accel3d_20261104.html/png · heel pngs │ └── Goose_11-11-2026/ + heel_20261111.csv · rick_ribbon_20261111.geojson · rick_werner_tack_report_20261111.pdf · tack_profiles/ ├── Jake/ │ ├── 31 october 26/ same shape (process_jake.py · jake_races_tacks.gpkg · tack_analysis.png) │ └── Drank 2026-11-04/ + jake_ribbon_20261104.geojson/.gpkg · jake_ribbon_map_20261104.html (MapLibre 3D ribbon) · heel_report PDF ├── SensorLogsTemp/Werner/Drank_11-11-2026/ heel CSV · tack_profiles T1–T22 · rick_werner report └── jake_rick_report_20261031/ tack report CSV + PDF (21 pp) + GPKG + 15 tack_profiles/ PNGs
Every session folder is self-contained: raw logs in, calculated tables + GeoPackages + figures + PDF report out. Same schema per sailor → comparable measures across sailors and dates.
Jake vs Rick — 5 races, tack by tack
| Measure (from tack report CSV) | Jake | Rick |
|---|---|---|
| Tacks detected | 9 | 6 |
| Avg speed drop in tack | 31.2% | 18.8% |
| Avg recovery to speed | 10.1 s | 10.0 s |
| Avg distance lost per tack | 6.5 m (max 20.5) | 3.9 m (max 11.3) |
| Grades good / average / focus | 3 / 3 / 3 | 3 / 0 / 3 |
Rick vs Werner — same course, same wind (294–295°)
| Measure (rick_werner_tack_summary_20261111.csv) | Rick | Werner |
|---|---|---|
| Tacks detected | 19 | 22 |
| Avg speed drop in tack | 33.4% (max 54.4%) | 37.1% (max 55.9%) |
| Avg recovery to speed | 7.9 s | 5.6 s |
| Avg distance lost per tack | 3.8 m | 3.9 m |
| Grades good / average / focus | 3 / 7 / 9 | 3 / 7 / 12 |
| Worst tack (lat/lon in CSV) | Rick T6 18:17:42 @ 175.27544,−37.79914 — 44% drop, 12.7 m lost · Werner T19 18:40:26 — 56% drop | |
Open the 3D ribbon track live (Ubuntu tunnel) — rick_ribbon_20261111.geojson / jake_ribbon_map_20261104.html: speed ribbon, heel-tilted, EPSG:2193 → WGS84.
Ask Mistral to analyze the GPS tracks — right now
Audience picks the question. If nobody shouts one out, use the prepared prompt:
Same prompt saved as Presenation/demo_prompt.txt — paste it into the chat verbatim.
From calculated events to a coaching agent
Questions?
dev.sailsmart.nz /mapbox/dashboard 3D ribbon (Ubuntu tunnel)