int_track_geometry

Circuit geometry (gradient + curvature) from raw X/Y/Z telemetry, binned to 25m distance intervals.

Part of the Physics family.

Circuit geometry (gradient + curvature) from raw X/Y/Z telemetry, binned to 25m distance intervals. Grain is (race_year, track_id, distance_bin) — per-season, not collapsed to a single per-circuit shape, since GPS origin/heading can drift between seasons (verified at Bahrain: 2019 diverges from 2020-2024). Start/finish bin has NULL gradient/curvature (no wraparound across the lap boundary).

Lineage

Overview

Property	Value
Layer	intermediate
Family	Physics
Contract enforced	No

3 tests guard this model - 3 generic, 0 singular.

Columns

Column	Type	Nullable	Tests	Description
race_year		Yes	not_null	Season
track_id		Yes	not_null	Circuit identifier (from race_to_track)
distance_bin		Yes	not_null	Lower edge of the 25m distance bin (meters from start line)
gradient_dz_ds		Yes		Elevation gradient dZ/ds between the previous and next bin
curvature_per_m		Yes		Menger curvature (1/m) from 3 consecutive binned points. NULL at season boundaries or where points are collinear.
lateral_accel_proxy_ms2		Yes		v^2 * curvature_per_m, using median speed at the bin (m/s^2)