2014 Road Traffic Data Collection

This dataset collection is a compilation of road traffic data from the year 2014. It is sourced from the website of Statistics Finland (Tilastokeskus) and provides valuable insights into Finnish road traffic patterns and statistics for that year. The collection is organized into tables, each offering a unique perspective and breakdown of the data. The information gathered from this dataset can aid in understanding traffic flow, congestion points, and other related aspects, making it a useful resource for traffic planners, researchers, and policymakers. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2014 Road Traffic Accidents Data TableTSV
The table is a part of a larger collection of data, which consists of several tables with related data. This particular table is focused on Road Traffic Accidents in 2014, sourced from 'Tilastokeskus' (Statistics Finland). It provides a detailed and comprehensive overview of the accidents that occurred during that year in Finland, with each row representing a unique accident event. The table includes various data points, such as the exact date when the data was extracted, the unique row number for each accident, as well as a multitude of geospatial data fields. The geospatial data fields present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude, which can be utilized for geospatial data analytics. For...
Road Traffic Accidents 2014: History VersionTSV
The 'table__history' is a significant component of the data collection named 'tieliikenne_tieliikenne_2014'. This table serves as a historical archive of road traffic accidents in 2014, sourced from 'Tilastokeskus' (Statistics Finland). It contains meticulously organized data, presented in rows and columns that offer a plethora of information for analysis. Each row in this table represents a unique incident, identified by a combination of the row number and the date the data was extracted. The rows are periodically updated, and these updates are tracked through start and end dates for each version of the row. If the end date of a row is null, it indicates that the version of the row is the most recent. The table offers a wealth of geographical details, such as geographic coordinates...

Column Descriptions

2014 Road Traffic Accidents Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date. This, along with the '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains the geographical data of the incident in GeoJSON format.
geom_geotext	string	This column contains the geographical data of the incident in textual format.
geom_type	string	This column specifies the type of the geographical data.
geom_centroid	string	This column contains the centroid of the geographical data.
geom_center_x	double	This column represents the x-coordinate of the center of the geographical data.
geom_center_y	double	This column represents the y-coordinate of the center of the geographical data.
gml_id	string	This column contains a unique identifier for each row.
kello	string	This column indicates the time of the incident.
kkonn	long	This column contains an integer value (unknown meaning).
lkmhapa	long	This column contains an integer value (unknown meaning).
lkmjk	long	This column contains an integer value (unknown meaning).
lkmlaka	long	This column contains an integer value (unknown meaning).
lkmmo	long	This column contains an integer value (unknown meaning).
lkmmp	long	This column contains an integer value (unknown meaning).
lkmmuukulk	long	This column contains an integer value (unknown meaning).
lkmpp	long	This column contains an integer value (unknown meaning).
onntyyppi	string	This column indicates the type of incident.
vakav	string	This column indicates the severity of the incident.
vvonn	string	This column indicates the year of the incident.
x	double	This column represents the x-coordinate of the incident location.
y	double	This column represents the y-coordinate of the incident location.

Road Traffic Accidents 2014: History Version

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in this version history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source, contributing to the unique identification of each row in conjunction with '_start_date'.
geom_geojson	string	This column contains the geometric data of the points in the GeoJSON format.
geom_geotext	string	This column contains the geometric data of the points in the text format.
geom_type	string	This column specifies the type of the geometric data.
geom_centroid	string	This column contains the centroid of the geometric data.
geom_center_x	double	This column contains the x-coordinate of the geometric center.
geom_center_y	double	This column contains the y-coordinate of the geometric center.
gml_id	string	This column contains the ID of the GML, a markup language for geographic information.
kello	string	This column contains data related to the time.
kkonn	long	This column contains integer data, details not provided by the data source.
lkmhapa	long	This column contains integer data, details not provided by the data source.
lkmjk	long	This column contains integer data, details not provided by the data source.
lkmlaka	long	This column contains integer data, details not provided by the data source.
lkmmo	long	This column contains integer data, details not provided by the data source.
lkmmp	long	This column contains integer data, details not provided by the data source.
lkmmuukulk	long	This column contains integer data, details not provided by the data source.
lkmpp	long	This column contains integer data, details not provided by the data source.
onntyyppi	string	This column contains data of type string, details not provided by the data source.
vakav	string	This column contains data of type string, details not provided by the data source.
vvonn	string	This column contains string data, details not provided by the data source.
x	double	This column contains real data, possibly related to geographic information.
y	double	This column contains real data, possibly related to geographic information.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024