Node
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. | None |
| 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. | None |
| 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. | None |
| 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 | None |
| 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 | None |
| 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. | None |
| LATITUDE | Latitude | DECIMAL | latitude coordinate of the crash | None |
| LONGITUDE | Longitude | DECIMAL | Longitude coordinate of the crash | None |
| POSTCODE_CRASH | Postcode Crash | INTEGER | Postcode of the crash | None |
Additional information
| Field | Value |
|---|---|
| Dataset Last Updated Date | 16 October 2025 |
| Publication Date | 1 January 2012 |
| Format | CSV |
| License | Creative Commons Attribution 4.0 |
| Open Data Title | Node |
| Dataset File Size | 20.8 MiB |
| Dataset Security Value | BIL1 OFFICIAL - Authorised Public Release |
| Dataset Reporting Period Start | 1 January 2012 |
| Dataset Reporting Period End | 28 February 2025 |
| Geographic Coverage | Victoria |