2017 Road Traffic Data Collection

The dataset collection in question comprises of several closely linked data tables. These tables are primarily sourced from the website of 'Tilastokeskus' (Statistics Finland), based in Finland. The content within these tables is organized in rows and columns, offering a structured and systematic representation of the data. The provided data is a compilation of road traffic information for the year 2017. This essential collection provides valuable insights into the traffic patterns and road usage in Finland during this 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

2017 Road Traffic Accidents History, Version Records TableTSV
The 'table__history' is a rich compendium of data pertaining to road traffic accidents in 2017. Sourced from 'Tilastokeskus' (Statistics Finland), this history table provides a detailed version history of its base table rows, offering an in-depth understanding of each data point's evolution. It is a part of a larger dataset collection focused on road traffic data from the year 2017. The table presents a robust array of data points, including geographic information useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The table also contains other vital data categories, such as the time of the accident, the type of accident, and the severity of the...
Road Traffic Accidents 2017 - Data CollectionTSV
The table presents a collection of related data on Road Traffic Accidents of 2017, originally obtained from the website of Statistics Finland (Tilastokeskus). The data include a variety of columns providing comprehensive information on the traffic accidents. A couple of special columns that are worth mentioning are: '_extract_date', which provides the specific date when the data row was extracted and '_row_number', which stands for the row number in the data extracted on the specific extraction date. These two columns jointly identify each data row in a unique manner. Additionally, the table includes several columns storing geographic information. These columns, all commencing with the prefix 'geom_', contain geospatial data that can be utilized for geospatial data analytics. The...

Column Descriptions

Road Traffic Accidents 2017 - Data Collection

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 column '_extract_date'.
geom_geojson	string	The geographical coordinates in GeoJson format.
geom_geotext	string	The geographical coordinates in textual format.
geom_type	string	The type of geometrical data, for instance, a point.
geom_centroid	string	The centroid of the geographical data.
geom_center_x	double	The X coordinate of the center of the geographical data.
geom_center_y	double	The Y coordinate of the center of the geographical data.
gml_id	string	A unique identifier for the data row.
kello	string	Time information related to the data.
kkonn	long	An integer value with no provided description.
lkmhapa	long	An integer value with no provided description.
lkmjk	long	An integer value with no provided description.
lkmlaka	long	An integer value with no provided description.
lkmmo	long	An integer value with no provided description.
lkmmp	long	An integer value with no provided description.
lkmmuukulk	long	An integer value with no provided description.
lkmpp	long	An integer value with no provided description.
onntyyppi	string	A string value with no provided description.
vakav	string	A string value with no provided description.
vvonn	string	A string value with no provided description.
x	double	A real number representing a coordinate or a similar numerical value.
y	double	A real number representing a coordinate or a similar numerical value.

2017 Road Traffic Accidents History, Version Records Table

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in this history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. This column, in combination with '_start_date', uniquely identifies each row in this history table.
geom_geojson	string	The geographic coordinates of the data point, in GeoJSON format.
geom_geotext	string	The geographic coordinates of the data point, in geotext format.
geom_type	string	The type of geographic data stored in the row. In this dataset, all entries are of the type 'ST_POINT'.
geom_centroid	string	The center point of the geographic data, in geotext format.
geom_center_x	double	The X coordinate of the center point of the geographic data.
geom_center_y	double	The Y coordinate of the center point of the geographic data.
gml_id	string	A unique identifier for each row in the dataset.
kello	string	The time of day when the data was collected, in the format 'HH.MM-HH.MM'.
kkonn	long	An integer value with undefined meaning in this dataset.
lkmhapa	long	An integer value with undefined meaning in this dataset.
lkmjk	long	An integer value with undefined meaning in this dataset.
lkmlaka	long	An integer value with undefined meaning in this dataset.
lkmmo	long	An integer value with undefined meaning in this dataset.
lkmmp	long	An integer value with undefined meaning in this dataset.
lkmmuukulk	long	An integer value with undefined meaning in this dataset.
lkmpp	long	An integer value with undefined meaning in this dataset.
onntyyppi	string	An integer value with undefined meaning in this dataset.
vakav	string	An integer value with undefined meaning in this dataset.
vvonn	string	The year when the data was collected, in the format 'YYYY'.
x	double	A real number value with undefined meaning in this dataset.
y	double	A real number value with undefined meaning in this dataset.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024