2015 Road Traffic Data Collection

The dataset collection in focus details the data related to road traffic in the year 2015. It consists of a set of tables that encompass related data, each organized in a structured manner with columns and rows. These tables offer a comprehensive overview of road traffic data, detailing various aspects that contribute to an in-depth understanding of the traffic situation during the specified year. This data originates from the service interface of the Statistics Finland (Tilastokeskus) in Finland, a trusted and reliable source for statistical data. It is worthy to note that this dataset is rich in information and provides valuable insights into the traffic scenario of the year 2015 in Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2015 Road Traffic Accidents History in FinlandTSV
The 'table__history' is a rich repository of data pertaining to road traffic accidents in 2015, originating from the 'Tilastokeskus' (Statistics Finland) website. It serves as a history table, maintaining the version history of its base table rows. The table is part of a larger dataset collection that encapsulates related data tables focusing on road traffic for the year 2015. The table is structured in a way that each row is uniquely identifiable via a combination of the row number and the start date, the date when the row was extracted from the data source. This unique identifier enables tracking of all versions of a row. The end date signals when a new version of the row was created, with a null value indicating the most recent version. One of the table's unique features is its...
Road Traffic Accidents 2015 - Detailed AnalysisTSV
The table, part of a larger dataset collection, contains intricately detailed data related to 'Road Traffic Accidents in 2015'. This data was sourced from the website of 'Tilastokeskus' (Statistics Finland). The table is structured with columns and rows, each row representing a unique record of a road traffic accident in 2015. To uniquely identify each record, two special columns have been used: one containing the date when the data was extracted, and the other specifying the row number in the data extracted. These two columns combined create a unique identifier for each row of data. A notable feature of this table is its inclusion of geospatial data. Several columns beginning with 'geom_' hold geographical information about the location of the accidents. This information is presented...

Column Descriptions

Road Traffic Accidents 2015 - Detailed Analysis

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It helps in tracking the acquisition timeline of the data.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It serves as an unique identifier for each row.
geom_geojson	string	This column holds the geographic location data of each entry in GeoJSON format, which is a widely used format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographic location data in geotext format. It provides an alternate representation of the geographic data.
geom_type	string	This column specifies the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns. The type is 'ST_POINT', indicating that the geographic data represents a point.
geom_centroid	string	This column represents the geometric center, or centroid, of the geographic data for each entry.
geom_center_x	double	This column represents the x-coordinate of the geometric center of the geographic data.
geom_center_y	double	This column represents the y-coordinate of the geometric center of the geographic data.
gml_id	string	This is an identifier for the geographic data associated with each entry.
kello	string	This column contains time data for each entry.
kkonn	long	This column contains integer data, specific meaning is not provided by the data source.
lkmhapa	long	This column contains integer data, specific meaning is not provided by the data source.
lkmjk	long	This column contains integer data, specific meaning is not provided by the data source.
lkmlaka	long	This column contains integer data, specific meaning is not provided by the data source.
lkmmo	long	This column contains integer data, specific meaning is not provided by the data source.
lkmmp	long	This column contains integer data, specific meaning is not provided by the data source.
lkmmuukulk	long	This column contains integer data, specific meaning is not provided by the data source.
lkmpp	long	This column contains integer data, specific meaning is not provided by the data source.
onntyyppi	string	This column contains string data, specific meaning is not provided by the data source.
vakav	string	This column contains string data, specific meaning is not provided by the data source.
vvonn	string	This column contains string data, presumably related to the year.
x	double	This column contains the x-coordinate of the geographic data in a real number format.
y	double	This column contains the y-coordinate of the geographic data in a real number format.

2015 Road Traffic Accidents History in Finland

Column	Type	Comment
_start_date	date	Indicates the date when the row was extracted from the data source. This, in combination with '_row_number', uniquely identifies each row in the 'table__history' table.
_end_date	date	Specifies the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version.
_row_number	long	Contains the number of the row as it was extracted in raw form from the data source. This, in combination with '_start_date', uniquely identifies each row in the 'table__history' table.
geom_geojson	string	Stores the geometric data of the location in GeoJSON format.
geom_geotext	string	Contains the geometric point data in plain text format.
geom_type	string	Specifies the type of the geometric data. For example, 'ST_POINT' indicates a single point in space.
geom_centroid	string	Holds the central point of the geometric data.
geom_center_x	double	Specifies the X-coordinate of the center point of the geometric data.
geom_center_y	double	Specifies the Y-coordinate of the center point of the geometric data.
gml_id	string	A unique identifier for each row in the table.
kello	string	Indicates the time of the event.
kkonn	long	A numerical code representing a specific category.
lkmhapa	long	Represents a specific count or quantity related to the event.
lkmjk	long	Represents a specific count or quantity related to the event.
lkmlaka	long	Represents a specific count or quantity related to the event.
lkmmo	long	Represents a specific count or quantity related to the event.
lkmmp	long	Represents a specific count or quantity related to the event.
lkmmuukulk	long	Represents a specific count or quantity related to the event.
lkmpp	long	Represents a specific count or quantity related to the event.
onntyyppi	string	A numeric code representing the type of event.
vakav	string	A character code providing information on the severity of the event.
vvonn	string	Indicates the year of the event.
x	double	The X-coordinate of the location where the event occurred.
y	double	The Y-coordinate of the location where the event occurred.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024