Coverage map · what's on disk and what isn't

Environment.

The road, weather and light a crash happens in.

Physical-environment SETTINGS — roadway class, alignment, lighting, weather and time-of-day — that shape how drivers behave and how a crash plays out. Light and weather are now decoded across all 50 census years; roadway inventory and real weather need external joins.

Coverage map

Light condition

covered

source crashes.lgt_cond — decoded ALL years 1975-2024 (backfilled to 100%)

Weather

covered

source crashes.weather — decoded all years (99.5%)

Roadway class & alignment

partial

source crashes.func_sys/rur_urb/typ_int; raw SP_LIMIT/ALIGNMNT/PROFILE not curated

Blindspot: Roadway inventory (curve, lighting deployment, AADT) needs MIRE/HSIS — not in FARS.

Time & daylight

partial

source crashes.crash_hour/day_of_week; solar/DST derivable from date+lat/long

Blindspot: Solar-geometry / glare derivation not yet computed.

Known blindspots — future work

What we do not yet have. These are explicit so the gaps stay visible and become the agenda for future DB and knowledge-integration work.