Victoria road crash data - Node - Victorian Government Data Directory

Table contains information about where accident is located on the map. NODE_ID is the primary key of the table. NODE_ID is referred by ACCIDENT and FATAL_ACCIDENT table. Same node_id can be assigned to more than one accident.

Data Dictionary

Field Name	Name	Type	Description	Fixed Values
ACCIDENT_NO	Accident No	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
NODE_ID	Node ID	INTEGER(10)	The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified.
NODE_TYPE	Node Type	NVARCHAR(1)	NODE_TYPE is a character field indicates location type identified by the RCIS spatial system. This field cannot contain NULL values.	Code Description I Intersection N Non-Intersection O Off Road U Unknown
AMG_X	AMG X Coordinate	NUMERIC(38)	AMG_X is a decimal field that contains AMG coordinate X value. This field cannot contain NULL values. This will have zero value for location unknown accidents.
AMG_Y	AMG Y Coordinate	NUMERIC(38)	AMG_Y is a decimal field that contains AMG coordinate Y value. This field cannot contain NULL values. This will have zero value for location unknown accidents
LGA_NAME	LGA	NVARCHAR(100)	LGA_NAME is a character field contains the LGA name for the location of the crash. This field cannot contain NULL values
DEG_URBAN_NAME	Degree Urban Name	NVARCHAR(40)	DEG_URBAN_NAME is a character field indicates degree of urban name for the location of the crash. This field refers DEG_URBAN_NAME in DEGREE_OF_URBAN table. This field cannot contain NULL values.
LATITUDE	Latitude	DECIMAL(10)	latitude coordinate of the crash
LONGITUDE	Longitude	DECIMAL(10)	Longitude coordinate of the crash
POSTCODE_CRASH	Postcode Crash	INTEGER(10)	Postcode of the crash

Field Name

Name

Type

Description

Fixed Values

ACCIDENT_NO

Accident No

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

NODE_ID

Node ID

INTEGER(10)

The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified.

NODE_TYPE

Node Type

NVARCHAR(1)

NODE_TYPE is a character field indicates location type identified by the RCIS spatial system. This field cannot contain NULL values.

Code Description I Intersection N Non-Intersection O Off Road U Unknown

AMG_X

AMG X Coordinate

NUMERIC(38)

AMG_X is a decimal field that contains AMG coordinate X value. This field cannot contain NULL values. This will have zero value for location unknown accidents.

AMG_Y

AMG Y Coordinate

NUMERIC(38)

AMG_Y is a decimal field that contains AMG coordinate Y value. This field cannot contain NULL values. This will have zero value for location unknown accidents

LGA_NAME

LGA

NVARCHAR(100)

LGA_NAME is a character field contains the LGA name for the location of the crash. This field cannot contain NULL values

DEG_URBAN_NAME

Degree Urban Name

NVARCHAR(40)

DEG_URBAN_NAME is a character field indicates degree of urban name for the location of the crash. This field refers DEG_URBAN_NAME in DEGREE_OF_URBAN table. This field cannot contain NULL values.

LATITUDE

Latitude

DECIMAL(10)

latitude coordinate of the crash

LONGITUDE

Longitude

DECIMAL(10)

Longitude coordinate of the crash

POSTCODE_CRASH

Postcode Crash

INTEGER(10)

Postcode of the crash

Additional Information

Field	Value
Data last updated	16 November 2024
Metadata last updated	23 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": "<p>ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.</p>\n<p>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</p>", "fixed_values": "", "id": "7278", "name": "Accident No", "ref_number": "AT-7278"}, {"attribute_display_order_id": 2, "db_format": "INTEGER(10)", "db_name": "NODE_ID", "definition": "The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified.", "fixed_values": "", "id": "7281", "name": "Node ID", "ref_number": "AT-7281"}, {"attribute_display_order_id": 3, "db_format": "NVARCHAR(1)", "db_name": "NODE_TYPE", "definition": "NODE_TYPE is a character field indicates location type identified by the RCIS spatial system. This field cannot contain NULL values.", "fixed_values": "Code Description I Intersection N Non-Intersection O Off Road U Unknown", "id": "7276", "name": "Node Type", "ref_number": "AT-7276"}, {"attribute_display_order_id": 4, "db_format": "NUMERIC(38)", "db_name": "AMG_X", "definition": "AMG_X is a decimal field that contains AMG coordinate X value. This field cannot contain NULL values. This will have zero value for location unknown accidents.", "fixed_values": "", "id": "7283", "name": "AMG X Coordinate", "ref_number": "AT-7283"}, {"attribute_display_order_id": 5, "db_format": "NUMERIC(38)", "db_name": "AMG_Y", "definition": "AMG_Y is a decimal field that contains AMG coordinate Y value. This field cannot contain NULL values. This will have zero value for location unknown accidents", "fixed_values": "", "id": "7282", "name": "AMG Y Coordinate", "ref_number": "AT-7282"}, {"attribute_display_order_id": 6, "db_format": "NVARCHAR(100)", "db_name": "LGA_NAME", "definition": "LGA_NAME is a character field contains the LGA name for the location of the crash. This field cannot contain NULL values", "fixed_values": "", "id": "7279", "name": "LGA", "ref_number": "AT-7279"}, {"attribute_display_order_id": 7, "db_format": "NVARCHAR(40)", "db_name": "DEG_URBAN_NAME", "definition": "DEG_URBAN_NAME is a character field indicates degree of urban name for the location of the crash. This field refers DEG_URBAN_NAME in DEGREE_OF_URBAN table. This field cannot contain NULL values.", "fixed_values": "", "id": "7274", "name": "Degree Urban Name", "ref_number": "AT-7274"}, {"attribute_display_order_id": 8, "db_format": "DECIMAL(10)", "db_name": "LATITUDE", "definition": "latitude coordinate of the crash", "fixed_values": "", "id": "7280", "name": "Latitude", "ref_number": "AT-7280"}, {"attribute_display_order_id": 9, "db_format": "DECIMAL(10)", "db_name": "LONGITUDE", "definition": "Longitude coordinate of the crash", "fixed_values": "", "id": "7277", "name": "Longitude", "ref_number": "AT-7277"}, {"attribute_display_order_id": 10, "db_format": "INTEGER(10)", "db_name": "POSTCODE_CRASH", "definition": "Postcode of the crash", "fixed_values": "", "id": "7275", "name": "Postcode Crash", "ref_number": "AT-7275"}]
Ckan url	https://discover.data.vic.gov.au
Dataset last updated date	2 weeks ago
Datastore active	True
Datastore contains all records of source file	True
Filesize	18,730,595
Has views	True
Hash	19f80f771527958e709727ccc53e524b
Historical	False
Id	2c04e0ff-ae07-4abd-89ab-b52e877d420b
Ignore hash	False
Last updated date	2 weeks ago
Mimetype	text/csv
Open dataset title	Node
Original url	https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/2c04e0ff-ae07-4abd-89ab-b52e877d420b/download/node.csv
Package id	e03104fe-fd02-4045-aa05-e916c6d46433
Period end	2024-03-31
Period start	2012-01-01
Position	6
Publication date	13 years ago
Resource id	2c04e0ff-ae07-4abd-89ab-b52e877d420b
Set url type	False
State	active
Task created	2024-11-22 05:18:11.456494
Filesize	17.9 MB
Release Date
Temporal Coverage Start	1 January 2012
Temporal Coverage End	31 March 2024
Data Quality Statement
Attribution Statement

Field

Value

Data last updated

16 November 2024

Metadata last updated

23 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": "<p>ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.</p>\n<p>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</p>", "fixed_values": "", "id": "7278", "name": "Accident No", "ref_number": "AT-7278"}, {"attribute_display_order_id": 2, "db_format": "INTEGER(10)", "db_name": "NODE_ID", "definition": "The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified.", "fixed_values": "", "id": "7281", "name": "Node ID", "ref_number": "AT-7281"}, {"attribute_display_order_id": 3, "db_format": "NVARCHAR(1)", "db_name": "NODE_TYPE", "definition": "NODE_TYPE is a character field indicates location type identified by the RCIS spatial system. This field cannot contain NULL values.", "fixed_values": "Code Description I Intersection N Non-Intersection O Off Road U Unknown", "id": "7276", "name": "Node Type", "ref_number": "AT-7276"}, {"attribute_display_order_id": 4, "db_format": "NUMERIC(38)", "db_name": "AMG_X", "definition": "AMG_X is a decimal field that contains AMG coordinate X value. This field cannot contain NULL values. This will have zero value for location unknown accidents.", "fixed_values": "", "id": "7283", "name": "AMG X Coordinate", "ref_number": "AT-7283"}, {"attribute_display_order_id": 5, "db_format": "NUMERIC(38)", "db_name": "AMG_Y", "definition": "AMG_Y is a decimal field that contains AMG coordinate Y value. This field cannot contain NULL values. This will have zero value for location unknown accidents", "fixed_values": "", "id": "7282", "name": "AMG Y Coordinate", "ref_number": "AT-7282"}, {"attribute_display_order_id": 6, "db_format": "NVARCHAR(100)", "db_name": "LGA_NAME", "definition": "LGA_NAME is a character field contains the LGA name for the location of the crash. This field cannot contain NULL values", "fixed_values": "", "id": "7279", "name": "LGA", "ref_number": "AT-7279"}, {"attribute_display_order_id": 7, "db_format": "NVARCHAR(40)", "db_name": "DEG_URBAN_NAME", "definition": "DEG_URBAN_NAME is a character field indicates degree of urban name for the location of the crash. This field refers DEG_URBAN_NAME in DEGREE_OF_URBAN table. This field cannot contain NULL values.", "fixed_values": "", "id": "7274", "name": "Degree Urban Name", "ref_number": "AT-7274"}, {"attribute_display_order_id": 8, "db_format": "DECIMAL(10)", "db_name": "LATITUDE", "definition": "latitude coordinate of the crash", "fixed_values": "", "id": "7280", "name": "Latitude", "ref_number": "AT-7280"}, {"attribute_display_order_id": 9, "db_format": "DECIMAL(10)", "db_name": "LONGITUDE", "definition": "Longitude coordinate of the crash", "fixed_values": "", "id": "7277", "name": "Longitude", "ref_number": "AT-7277"}, {"attribute_display_order_id": 10, "db_format": "INTEGER(10)", "db_name": "POSTCODE_CRASH", "definition": "Postcode of the crash", "fixed_values": "", "id": "7275", "name": "Postcode Crash", "ref_number": "AT-7275"}]

Ckan url

https://discover.data.vic.gov.au

Dataset last updated date

2 weeks ago

Datastore active

True

Datastore contains all records of source file

True

Filesize

18,730,595

Has views

True

Hash

19f80f771527958e709727ccc53e524b

Historical

False

2c04e0ff-ae07-4abd-89ab-b52e877d420b

Ignore hash

False

Last updated date

2 weeks ago

Mimetype

text/csv

Open dataset title

Node

Original url

https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/2c04e0ff-ae07-4abd-89ab-b52e877d420b/download/node.csv

Package id

e03104fe-fd02-4045-aa05-e916c6d46433

Period end

2024-03-31

Period start

2012-01-01

Position

Publication date

13 years ago

Resource id

2c04e0ff-ae07-4abd-89ab-b52e877d420b

Set url type

False

State

active

Task created

2024-11-22 05:18:11.456494

Filesize

17.9 MB

Release Date

Temporal Coverage Start

1 January 2012

Temporal Coverage End

31 March 2024

Data Quality Statement

Attribution Statement

Node

Embed resource view

Data Dictionary

Additional Information