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	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	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	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	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	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	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	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	latitude coordinate of the crash
LONGITUDE	Longitude	DECIMAL	Longitude coordinate of the crash
POSTCODE_CRASH	Postcode Crash	INTEGER	Postcode of the crash

Field Name

Name

Type

Description

Fixed Values

ACCIDENT_NO

Accident No

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.

NODE_ID

Node ID

INTEGER

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

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

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

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

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

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

latitude coordinate of the crash

LONGITUDE

Longitude

DECIMAL

Longitude coordinate of the crash

POSTCODE_CRASH

Postcode Crash

INTEGER

Postcode of the crash

Additional Information

Field	Value
Data last updated	20 October 2025
Metadata last updated	21 October 2025
Created	18 March 2025
Format	CSV
License	Creative Commons Attribution 4.0 International
Attributes	[{"attribute_display_order_id": 1, "db_format": "CHAR", "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.", "id": "7278", "name": "Accident No", "ref_number": "AT-7278"}, {"attribute_display_order_id": 2, "db_format": "INTEGER", "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.", "id": "7281", "name": "Node ID", "ref_number": "AT-7281"}, {"attribute_display_order_id": 3, "db_format": "NVARCHAR", "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", "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.", "id": "7283", "name": "AMG X Coordinate", "ref_number": "AT-7283"}, {"attribute_display_order_id": 5, "db_format": "NUMERIC", "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", "id": "7282", "name": "AMG Y Coordinate", "ref_number": "AT-7282"}, {"attribute_display_order_id": 6, "db_format": "NVARCHAR", "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", "id": "7279", "name": "LGA", "ref_number": "AT-7279"}, {"attribute_display_order_id": 8, "db_format": "NVARCHAR", "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.", "id": "7274", "name": "Degree Urban Name", "ref_number": "AT-7274"}, {"attribute_display_order_id": 9, "db_format": "DECIMAL", "db_name": "LATITUDE", "definition": "latitude coordinate of the crash", "id": "7280", "name": "Latitude", "ref_number": "AT-7280"}, {"attribute_display_order_id": 10, "db_format": "DECIMAL", "db_name": "LONGITUDE", "definition": "Longitude coordinate of the crash", "id": "7277", "name": "Longitude", "ref_number": "AT-7277"}, {"attribute_display_order_id": 11, "db_format": "INTEGER", "db_name": "POSTCODE_CRASH", "definition": "Postcode of the crash", "id": "7275", "name": "Postcode Crash", "ref_number": "AT-7275"}]
Ckan url	https://discover.data.vic.gov.au
Dataset last updated date	1 week ago
Datastore active	True
Datastore contains all records of source file	True
Edc sync	True
Has views	False
Hash	b2c8423d6539c317409589b644151d4f
Historical	False
Id	466fd3b5-201b-42b5-b10d-e926324fa215
Ignore hash	False
Mimetype	text/csv
Open dataset title	Node
Original url	https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/466fd3b5-201b-42b5-b10d-e926324fa215/download/node.csv
Package id	e0880296-585d-47bd-8e72-fc1b2045f53d
Period end	2025-02-28
Period start	2012-01-01
Position	4
Publication date	14 years ago
Resource id	466fd3b5-201b-42b5-b10d-e926324fa215
Set url type	False
State	active
Task created	2025-10-20 15:05:38.726351
File Size	20.8 MB
Temporal Coverage Start	1 January 2012
Temporal Coverage End	28 February 2025

Field

Value

Data last updated

20 October 2025

Metadata last updated

21 October 2025

Created

18 March 2025

Format

CSV

License

Creative Commons Attribution 4.0 International

Attributes

[{"attribute_display_order_id": 1, "db_format": "CHAR", "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.", "id": "7278", "name": "Accident No", "ref_number": "AT-7278"}, {"attribute_display_order_id": 2, "db_format": "INTEGER", "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.", "id": "7281", "name": "Node ID", "ref_number": "AT-7281"}, {"attribute_display_order_id": 3, "db_format": "NVARCHAR", "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", "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.", "id": "7283", "name": "AMG X Coordinate", "ref_number": "AT-7283"}, {"attribute_display_order_id": 5, "db_format": "NUMERIC", "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", "id": "7282", "name": "AMG Y Coordinate", "ref_number": "AT-7282"}, {"attribute_display_order_id": 6, "db_format": "NVARCHAR", "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", "id": "7279", "name": "LGA", "ref_number": "AT-7279"}, {"attribute_display_order_id": 8, "db_format": "NVARCHAR", "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.", "id": "7274", "name": "Degree Urban Name", "ref_number": "AT-7274"}, {"attribute_display_order_id": 9, "db_format": "DECIMAL", "db_name": "LATITUDE", "definition": "latitude coordinate of the crash", "id": "7280", "name": "Latitude", "ref_number": "AT-7280"}, {"attribute_display_order_id": 10, "db_format": "DECIMAL", "db_name": "LONGITUDE", "definition": "Longitude coordinate of the crash", "id": "7277", "name": "Longitude", "ref_number": "AT-7277"}, {"attribute_display_order_id": 11, "db_format": "INTEGER", "db_name": "POSTCODE_CRASH", "definition": "Postcode of the crash", "id": "7275", "name": "Postcode Crash", "ref_number": "AT-7275"}]

Ckan url

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

Dataset last updated date

1 week ago

Datastore active

True

Datastore contains all records of source file

True

Edc sync

True

Has views

False

Hash

b2c8423d6539c317409589b644151d4f

Historical

False

466fd3b5-201b-42b5-b10d-e926324fa215

Ignore hash

False

Mimetype

text/csv

Open dataset title

Node

Original url

https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/466fd3b5-201b-42b5-b10d-e926324fa215/download/node.csv

Package id

e0880296-585d-47bd-8e72-fc1b2045f53d

Period end

2025-02-28

Period start

2012-01-01

Position

Publication date

14 years ago

Resource id

466fd3b5-201b-42b5-b10d-e926324fa215

Set url type

False

State

active

Task created

2025-10-20 15:05:38.726351

File Size

20.8 MB

Temporal Coverage Start

1 January 2012

Temporal Coverage End

28 February 2025