stg_telemetry_position

Phase 10c, the channel split.

Part of the Staging family.

Phase 10c, the channel split. The POSITION channel of raw_telemetry — 58.8M of its 118.7M rows — projected to the positional columns. Until Phase 10 these rows had no consumer at all: stg_telemetry projects all three FastF1 sample provenances un-filtered and int_lap_telemetry_aggregates then filters to ‘car’. This model is the only reader of source_channel = ‘pos’, and int_lap_proximity is its only consumer. Deliberately NOT a copy of stg_telemetry with a different WHERE clause: it carries relative_distance / pos_x / pos_y, which the car-channel path never references, and it omits the car-channel’s distance_m BETWEEN 0 AND 6500 guard because its position column is a 0..1 lap fraction that carries its own bound.

Lineage

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No

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

Columns

Column	Type	Nullable	Tests	Description
session_time_s	double	Yes		Session clock of the sample (s). The one column that makes a cross-driver comparison possible: a gap between two cars is a difference of two readings of THIS column at the same point on track, never a difference of two distances.
relative_distance	double	Yes		Lap fraction in [0, 1). Clamped rather than filtered - FastF1 emits a handful of samples at -3e-6 and 1.0000004 from float error at the lap boundary, and dropping them would punch a hole in exactly the bin (the start/finish line) where the gap matters most.
pos_x	double	Yes		Track-frame X coordinate (1/10 m). Carried for Phase 10b (racing-line deviation); no current consumer.
pos_y	double	Yes		Track-frame Y coordinate (1/10 m). Carried for Phase 10b (racing-line deviation); no current consumer.
driver_ahead_number	varchar	Yes		FastF1’s own answer to “who is ahead”. A car NUMBER, not the three-letter code driver_id uses; int_lap_proximity resolves it through stg_results. Kept so the incumbent measure can be scored against the new one rather than replaced by assertion.
distance_to_ahead_m	double	Yes		FastF1’s DistanceToDriverAhead (m). The single number every incumbent traffic feature in this warehouse descends from. Diagnostic here.