Light condition
coveredsource crashes.lgt_cond — decoded ALL years 1975-2024 (backfilled to 100%)
Coverage map · what's on disk and what isn't
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.
75% backed by real data — 2 covered 2 partial 0 blindspots
Coverage map
source crashes.lgt_cond — decoded ALL years 1975-2024 (backfilled to 100%)
source crashes.weather — decoded all years (99.5%)
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.
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.