> ## Documentation Index
> Fetch the complete documentation index at: https://offthepace.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# stg_telemetry_position

> Phase 10c, the channel split.

<Note>Part of the [Staging](/transform/families/staging) family.</Note>

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

```mermaid theme={null}
flowchart LR
  stg_telemetry_position --> int_lap_proximity
  style stg_telemetry_position fill:#e40404,stroke:#e40404,color:#fff
```

## Overview

| Property          | Value                                  |
| ----------------- | -------------------------------------- |
| Layer             | `staging`                              |
| Family            | [Staging](/transform/families/staging) |
| Contract enforced | No                                     |

**1 tests** [guard](/transform/ci/overview) 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.                                                                                                                            |