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
Data last updated 18 March 2025
Metadata last updated 18 March 2025
Created 18 March 2025
Format CSV
License Creative Commons Attribution 4.0 International
Attributes[{"attribute_display_order_id": 1, "db_format": "CHAR(12)", "db_name": "ACCIDENT_NO", "definition": "ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.\nFirst 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", "fixed_values": "", "id": "7273", "name": "Accident Number", "ref_number": "AT-7273"}, {"attribute_display_order_id": 2, "db_format": "CHAR(1)", "db_name": "ATMOSPH_COND", "definition": "Weather and atmospheric conditions at the time of the crash", "fixed_values": "Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known", "id": "7271", "name": "Atmospheric Condition", "ref_number": "AT-7271"}, {"attribute_display_order_id": 3, "db_format": "INTEGER(10)", "db_name": "ATMOSPH_COND_SEQ", "definition": "1 and incremented by 1 if more than one atmospheric condition is entered for the same incident", "fixed_values": "", "id": "7272", "name": "Atmospheric Condition Sequence", "ref_number": "AT-7272"}, {"attribute_display_order_id": 4, "db_format": "VARCHAR(100)", "db_name": "ATMOSPH_COND_DESC", "definition": "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", "fixed_values": "Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known", "id": "7479", "name": "Atmospheric Condition Description", "ref_number": "AT-7479"}]
Ckan urlhttps://discover.data.vic.gov.au
Dataset last updated date3 weeks ago
Datastore activeTrue
Datastore contains all records of source fileTrue
Edc syncTrue
Has viewsFalse
Hashb2488b7d71bd03e044689b0247438b3c
HistoricalFalse
Idbf8656b4-49a2-4d64-9b87-9ca48e31ef02
Ignore hashFalse
Last updated date3 weeks ago
Mimetypetext/csv
Open dataset titleAtmospheric Condition
Original urlhttps://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/bf8656b4-49a2-4d64-9b87-9ca48e31ef02/download/atmospheric_cond.csv
Package id4de2a60e-d87e-41cb-8bb5-bca17b7f679f
Period end2024-07-31
Period start2012-01-01
Position3
Publication date13 years ago
Resource idbf8656b4-49a2-4d64-9b87-9ca48e31ef02
Set url typeFalse
Stateactive
Task created2025-03-18 11:35:49.436943
File Size 4.3 MB
Temporal Coverage Start 1 January 2012
Temporal Coverage End 31 July 2024