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(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 |
|---|---|
| Dataset Last Updated Date | 14 April 2025 |
| Last Updated Date | 13 April 2025 |
| Publication Date | 1 January 2012 |
| Format | CSV |
| License | Creative Commons Attribution 4.0 |
| Open Data Title | Node |
| Dataset File Size | 18.4 MiB |
| Dataset Security Value | BIL1 OFFICIAL - Authorised Public Release |
| Dataset Reporting Period Start | 1 January 2012 |
| Dataset Reporting Period End | 31 August 2024 |
| Geographic Coverage | Victoria |