Data Dictionary

Field Name	Name	Type	Description	Fixed Values
ACCIDENT_NO	Accident Number	CHAR(12)	ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values. First character T indicates TIS incident and characters 2-5 typically represent the year in which the accident created in TIS system and characters 6-11 are a numeric sequencing number
ATMOSPH_COND	Atmospheric Condition	CHAR(1)	Weather and atmospheric conditions at the time of the crash	Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known
ATMOSPH_COND_SEQ	Atmospheric Condition Sequence	INTEGER(10)	1 and incremented by 1 if more than one atmospheric condition is entered for the same incident
ATMOSPH_COND_DESC	Atmospheric Condition Description	VARCHAR(100)	ATMOSPH_COND_DESC is a Descriptive field. it can be 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 and Not known	Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known

Additional information

Field	Value
Dataset Last Updated Date	14 April 2025
Last Updated Date	13 April 2025
Publication Date	1 January 2012
Format	CSV
License	Creative Commons Attribution 4.0
Open Data Title	Atmospheric Condition
Dataset File Size	4.3 MiB
Dataset Security Value	BIL1 OFFICIAL - Authorised Public Release
Dataset Reporting Period Start	1 January 2012
Dataset Reporting Period End	31 August 2024