Road Surface Condition
Road surface conditions on which the crash occurred e.g. dry, wet, muddy
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 | |
| SURFACE_COND | Surface Condition | CHAR(1) | 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(10) | Starts with 1 and incremented by 1 if more than one road surface condition is entered for the same incident. | |
| SURFACE_COND_DESC | SURFACE COND DESC | VARCHAR(100) | 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 | 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 | Road Surface Condition |
| Dataset File Size | 3.8 MiB |
| Dataset Security Value | BIL1 OFFICIAL - Authorised Public Release |
| Dataset Reporting Period Start | 1 January 2012 |
| Dataset Reporting Period End | 31 August 2024 |