Road Traffic Data Collection 2021 - 2021 Road Traffic Accidents Data - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

2021 Road Traffic Accidents Data

To download the data set, please sign up or log in

The 'table' forms part of the dataset collection 'tieliikenne_tieliikenne_2021' and is a rich source of data pertaining to Road Traffic Accidents in 2021. This information is sourced from the website of the Statistics Finland (Tilastokeskus) in Finland. The table encompasses several columns which provide specific details about each recorded accident. For instance, it includes temporal data such as the exact time of the accident, and the date on which the data was extracted. Furthermore, it contains geographic coordinates which can be used for geospatial data analytics, presented using WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table also contains specific identifiers, such as row numbers, which together with the extraction date, uniquely identifies each row. In terms of data analytics, the diverse data contained within this table could be utilized in numerous ways. For instance, the geographical information could be used to identify accident hotspots, enabling traffic authorities to implement safety measures in high-risk areas. Additionally, the temporal information could be analyzed to identify peak times for accidents, which could inform scheduling of traffic patrols. Moreover, the details of each accident, such as number of people involved, could be used to gain insights into the severity and common characteristics of accidents, ultimately informing preventative strategies and policies.

Field Descriptions

Name	Data type	Description
_extract_date	date	This column records the date when the data on each row was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	This column contains geojson formatted geographical data, which describes the exact geographical location of the point of interest.
geom_geotext	string	This column contains geotext formatted geographical data, which essentially is a text representation of the geographical coordinates.
geom_type	string	This column describes the type of the geographical data stored in the row. For example, it could be a point, line, or polygon.
geom_centroid	string	This column contains the coordinates of the geometric center or 'centroid' of the shape described by the geographical data.
geom_center_x	double	This column contains the 'x' coordinate of the geometric center of the shape.
geom_center_y	double	This column contains the 'y' coordinate of the geometric center of the shape.
gml_id	string	This column contains a unique identifier for each row of the data, likely referring to a specific traffic incident or data point.
kello	string	This column contains the time of the day when the data was collected, represented in hour intervals.
kkonn	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
lkmhapa	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
lkmjk	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
lkmlaka	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
lkmmo	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
lkmmp	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
lkmmuukulk	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
lkmpp	long	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
onntyyppi	string	This column contains integer values, likely representing categorical data, but the exact meaning is not provided by the source.
vakav	string	This column contains string values, likely representing categorical data, but the exact meaning is not provided by the source.
vvonn	string	This column contains string values, likely representing the year when the data was collected.
x	double	This column contains real numbers, likely representing a coordinate or a measurement, but the exact meaning is not provided by the source.
y	double	This column contains real numbers, likely representing a coordinate or a measurement, but the exact meaning is not provided by the source.

Name

Data type

Description

_extract_date

date

This column records the date when the data on each row was extracted from the data source.

_row_number

long

This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.

geom_geojson

string

This column contains geojson formatted geographical data, which describes the exact geographical location of the point of interest.

geom_geotext

string

This column contains geotext formatted geographical data, which essentially is a text representation of the geographical coordinates.

geom_type

string

This column describes the type of the geographical data stored in the row. For example, it could be a point, line, or polygon.

geom_centroid

string

This column contains the coordinates of the geometric center or 'centroid' of the shape described by the geographical data.

geom_center_x

double

This column contains the 'x' coordinate of the geometric center of the shape.

geom_center_y

double

This column contains the 'y' coordinate of the geometric center of the shape.

gml_id

string

This column contains a unique identifier for each row of the data, likely referring to a specific traffic incident or data point.

kello

string

This column contains the time of the day when the data was collected, represented in hour intervals.

kkonn

long