Road Traffic Data Collection 2021

The dataset collection is a compilation of data tables related to road traffic in 2021. These tables are sourced from the Statistics Finland (Tilastokeskus) website in Finland. The data in the tables are organized and structured in a manner that allows for easy analysis and interpretation. It provides valuable information from the Statistical Service Interface (WFS), offering insights into various aspects of road traffic for the year 2021. The collection is a robust resource for anyone interested in understanding traffic patterns, statistics, and related data in Finland for the stated period. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2021 Road Traffic Accidents DataTSV
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,...
2021 Road Traffic Accidents History - Version History of Base Table RowsTSV
The 'table__history' is a critical component of the dataset collection, focusing specifically on historical data. It comprises a record of traffic accidents in 2021, sourced from the Finnish Statistics Bureau ('Tilastokeskus'). This information is essential in analyzing trends, forecasting, and making data-driven decisions related to road safety and traffic management. The table primarily captures the version history of its base table rows, which is instrumental in tracking changes over time. It uses unique identifiers for each row, provided by the combination of '_start_date' and '_row_number'. The '_start_date' indicates when the row was first extracted from the data source, while the '_end_date' shows when a new version of the row was extracted. If '_end_date' is null, it implies...

Column Descriptions

2021 Road Traffic Accidents Data

Column	Type	Comment
_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.

2021 Road Traffic Accidents History - Version History of Base Table Rows

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. It aids in uniquely identifying each row in the version history table when combined with the '_row_number'.
_end_date	date	The date when a new version of the row was extracted from the data source. If this column contains a null value, it signifies that the row is the most recent version.
_row_number	long	The number of the row as it appears in the raw data extracted from the data source. This row number, when combined with the '_start_date', uniquely identifies each row in this version history table.
geom_geojson	string	A GeoJSON representation of the geometric shape associated with the row.
geom_geotext	string	A textual representation of the geometric shape associated with the row.
geom_type	string	The type of the geometric shape associated with the row.
geom_centroid	string	The centroid of the geometric shape associated with the row.
geom_center_x	double	The x-coordinate of the center of the geometric shape associated with the row.
geom_center_y	double	The y-coordinate of the center of the geometric shape associated with the row.
gml_id	string	A unique identifier for the row.
kello	string	The time period during which the event recorded in the row occurred.
kkonn	long	An integer value associated with the row.
lkmhapa	long	An integer value associated with the row.
lkmjk	long	An integer value associated with the row.
lkmlaka	long	An integer value associated with the row.
lkmmo	long	An integer value associated with the row.
lkmmp	long	An integer value associated with the row.
lkmmuukulk	long	An integer value associated with the row.
lkmpp	long	An integer value associated with the row.
onntyyppi	string	An integer value associated with the row.
vakav	string	An integer value associated with the row.
vvonn	string	A string value representing the year associated with the row.
x	double	A real number representing a coordinate associated with the row.
y	double	A real number representing a coordinate associated with the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024