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 16 November 2024
Metadata last updated 20 November 2024
Created 16 November 2024
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 date2 weeks ago
Datastore activeTrue
Datastore contains all records of source fileTrue
Filesize4,368,468
Has viewsTrue
Hash7b01e91b594ac6962a68d7c1864e9d50
HistoricalFalse
Id800e3caf-10a7-4be5-99ee-3f2d095bbc12
Ignore hashFalse
Last updated date1 week ago
Mimetypetext/csv
Open dataset titleAtmospheric Condition
Original urlhttps://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/800e3caf-10a7-4be5-99ee-3f2d095bbc12/download/atmospheric_cond.csv
Package ide03104fe-fd02-4045-aa05-e916c6d46433
Period end2024-03-31
Period start2012-01-01
Position3
Publication date13 years ago
Resource id800e3caf-10a7-4be5-99ee-3f2d095bbc12
Set url typeFalse
Stateactive
Task created2024-11-20 01:44:33.046692
Filesize 4.2 MB
Release Date
Temporal Coverage Start 1 January 2012
Temporal Coverage End 31 March 2024
Data Quality Statement
Attribution Statement