stg_circuit_info

Corner geometry from FastF1 circuit_info.corners.

Part of the Staging family.

Corner geometry from FastF1 circuit_info.corners. One row per corner per race, ordered by distance along the lap. race_year is part of the key geometry can vary slightly year to year. Not yet read by any downstream dbt model or app feature.

Lineage

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No

6 tests guard this model - 5 generic, 1 singular.

Columns

Column	Type	Nullable	Tests	Description
corner_id	varchar	Yes	not_null, unique	Surrogate key {race_id}_{corner_number}{corner_letter}.
race_year	integer	Yes	not_null	Season year.
race_id	varchar	Yes	not_null	Numeric FastF1 event id cast to string; matches stg_laps.race_id.
race_slug	varchar	Yes		Human-readable event name.
corner_number	integer	Yes		Corner number along the lap.
corner_letter	varchar	Yes		Optional suffix distinguishing corners that share a number (e.g. 7a/7b); NULL when absent.
corner_x	double	Yes		Corner x-coordinate in the FastF1 track frame.
corner_y	double	Yes		Corner y-coordinate in the FastF1 track frame.
corner_angle_deg	double	Yes		Corner orientation angle (degrees) in the track frame.
corner_distance_m	double	Yes	not_null	Distance of the corner along the lap from start/finish (m).