Training Data – OpenClimbing Bolts AI

Database schema (download climbing_paths.sqlite)

-- Main annotation table
CREATE TABLE crop_labels (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  image       TEXT NOT NULL,   -- "File:Photo_name.jpg" (Wikimedia Commons key)
  position    TEXT NOT NULL,   -- "0.432,0.651B" (normalized x,y + bolt suffix)
  cx          REAL,            -- refined bolt center x (normalized 0–1)
  cy          REAL,            -- refined bolt center y (normalized 0–1)
  type        TEXT,            -- "bolt" | "no-bolt" | "undecided"
  radius_px   REAL,            -- bolt radius in original image pixels
  radius_src  TEXT,            -- "manual" | "sam"
  osm_source  TEXT,            -- source OSM path URL
  updated_at  TEXT
);

-- OSM climbing path → image mapping
CREATE TABLE climbing_paths (
  osmId       TEXT,
  osmType     TEXT,
  image       TEXT,            -- Wikimedia Commons filename
  path        TEXT             -- OSM path URL
);