Victoria road crash data - Node - Victorian Government Data Vic

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	9 December 2025
Metadata last updated	9 December 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	8779469e2da3f52d6f99e380033d9bf7
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-04-30
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-12-09 06:05:55.395871
File Size	21.1 MB
Temporal Coverage Start	1 January 2012
Temporal Coverage End	30 April 2025

Field

Value

Data last updated

9 December 2025

Metadata last updated

9 December 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

8779469e2da3f52d6f99e380033d9bf7

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-04-30

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-12-09 06:05:55.395871

File Size

21.1 MB

Temporal Coverage Start

1 January 2012

Temporal Coverage End

30 April 2025