2016 Finnish Road Traffic Data Collection

The dataset collection at hand is a rich compilation of related data tables focused on road traffic in 2016. These tables have been sourced from 'Tilastokeskuksen palvelurajapinta (WFS)', a service interface of the Statistics Finland (Tilastokeskus) website. The tables provide a comprehensive view of road traffic data for Finland, collected throughout the year 2016. The dataset collection provides a broad perspective on road traffic, offering valuable insights into traffic trends, patterns, and metrics within Finland for the year 2016. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2016 Road Traffic Accidents DataTSV
The table in question belongs to a dataset collection focusing on road traffic accidents in 2016. The data is meticulously structured, providing detailed insights into each accident event. The table houses a vast array of columns, each offering unique pieces of data related to the accident. Key information includes the date of data extraction and the row number, which together form a unique identifier for each row, allowing for precise data referencing. Additionally, the table provides a wealth of geospatial data, such as geographical points and centroids, which use the WGS 84 coordinate reference system for accurate global positioning. This information can be invaluable in geospatial data analytics, enabling the identification of accident hotspots, for instance. The table also contains...
Road Traffic Accidents 2016 - Version HistoryTSV
The 'table__history' is the version history table of the 'Road Traffic Accidents 2016' dataset, sourced from the 'Tilastokeskus' (Statistics Finland) website of Finland. This history table provides a rich collection of related data pertaining to road traffic accidents in 2016. The table incorporates a variety of columns, each representing a unique aspect of the collected data. As a history table, it contains a pair of special columns '_start_date' and '_end_date' which represent when a row was extracted from the data source and when a new version of the row was extracted, respectively. Together with the '_row_number', which indicates the row's position in raw data, these columns help in uniquely identifying each row in this version history table. If the '_end_date' value is null, it...

Column Descriptions

2016 Road Traffic Accidents Data

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the _extract_date column. The combination of _extract_date and _row_number uniquely identifies each row.
geom_geojson	string	A GeoJSON representation of the geographical point associated with the data row.
geom_geotext	string	A textual representation of the geographical point associated with the data row.
geom_type	string	The type of the geographical data, which is a point in this case.
geom_centroid	string	The central point of the geographical data.
geom_center_x	double	The x-coordinate of the central point of the geographical data.
geom_center_y	double	The y-coordinate of the central point of the geographical data.
gml_id	string	A unique identifier for the geographical data.
kello	string	A string representing a time range.
kkonn	long	An integer value.
lkmhapa	long	An integer value.
lkmjk	long	An integer value.
lkmlaka	long	An integer value.
lkmmo	long	An integer value.
lkmmp	long	An integer value.
lkmmuukulk	long	An integer value.
lkmpp	long	An integer value.
onntyyppi	string	A string value.
vakav	string	A string value.
vvonn	string	A string representing a year.
x	double	A real number representing a geographical coordinate.
y	double	A real number representing a geographical coordinate.

Road Traffic Accidents 2016 - Version History

Column	Type	Comment
_start_date	date	This is the date when the row was extracted from the data source.
_end_date	date	This represents the date when a new version of the row was extracted from the data source. If null, the row is the most recent version.
_row_number	long	This is the number of the row in the raw data. Along with '_start_date', it uniquely identifies each row in the table.
geom_geojson	string	This contains geospatial data in GeoJSON format.
geom_geotext	string	This contains geospatial data in text format.
geom_type	string	This identifies the type of the geometric object.
geom_centroid	string	This represents the geometric center of the object.
geom_center_x	double	This is the x-coordinate of the geometric center of the object.
geom_center_y	double	This is the y-coordinate of the geometric center of the object.
gml_id	string	This is a unique identifier of the row.
kello	string	This represents the time period.
kkonn	long	This is an integer value with an unknown purpose.
lkmhapa	long	This is an integer value with an unknown purpose.
lkmjk	long	This is an integer value with an unknown use.
lkmlaka	long	This is an integer value with an unknown purpose.
lkmmo	long	This is an integer value with an unknown use.
lkmmp	long	This is an integer value with an unknown purpose.
lkmmuukulk	long	This is an integer value with an unknown use.
lkmpp	long	This is an integer value with an unknown purpose.
onntyyppi	string	This is an integer value with an unknown use.
vakav	string	This is an integer value with an unknown purpose.
vvonn	string	This is a string that could represent a year.
x	double	This is a real number representing a coordinate or other spatial data.
y	double	This is a real number representing a coordinate or other spatial data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024