Data Dictionary

Field Name	Name	Type	Description	Fixed Values
ACCIDENT_NO	Accident Number	CHAR	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	None
SURFACE_COND	Surface Condition	CHAR	Road surface conditions on which the crash occurred e.g. dry, wet, muddy	Code Description 1 Dry 2 Wet 3 Muddy 4 Snowy 5 Icy 9 Unknown
SURFACE_COND_SEQ	Surface Condition Sequence	INTEGER	Starts with 1 and incremented by 1 if more than one road surface condition is entered for the same incident.	None
SURFACE_COND_DESC	SURFACE COND DESC	VARCHAR	A descriptive field that indicates Road surface conditions on which the crash occurred e.g. dry, wet, muddy	Code Description 1 Dry 2 Wet 3 Muddy 4 Snowy 5 Icy 9 Unknown

Additional information

Field	Value
Dataset Last Updated Date	10 November 2025
Publication Date	1 January 2012
Format	CSV
License	Creative Commons Attribution 4.0
Open Data Title	Road Surface Condition
Dataset File Size	4 MiB
Dataset Security Value	BIL1 OFFICIAL - Authorised Public Release
Dataset Reporting Period Start	1 January 2012
Dataset Reporting Period End	31 March 2025