2011 Road Traffic Data Collection

The dataset collection is an amalgamation of interconnected data tables sourced from 'Tilastokeskus' (the Statistical Bureau) in Finland. It includes comprehensive information from the year 2011 related to road traffic. The data within the collection is arranged in a tabular format, with each table comprising of rows and columns containing related data. This organized structure allows for easy access, analysis and interpretation of the data. The data source, the Statistical Bureau's web service interface (WFS), provides an authoritative and reliable basis for these traffic related datasets. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2011 Road Traffic Accidents History - FinlandTSV
The 'table__history' is a rich historical record of road traffic accidents in 2011. It is part of a larger dataset collection, showcasing a comprehensive view of road traffic safety dynamics in Finland. The table contains unique information about each accident, including time, location, and specific details about the incident. With the use of geographic information available in the dataset, the table can provide valuable insights for geospatial data analytics. Each row represents a unique accident event, with geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These geographic coordinates can be utilized to map road accidents, identify accident-prone areas, and study patterns in road safety. The table also...
Road Traffic Accidents 2011 - Comprehensive Data TableTSV
The table, coming from the Finnish 'Tilastokeskus' web site, contains an assortment of data related to 'Road Traffic Accidents in 2011'. This table is a part of a larger dataset collection which holds similar tables. The data in the table is organized into several columns, each containing specific types of information. For instance, two special columns '_extract_date' and '_row_number' hold the date of data extraction and the row's unique identifier in the extracted data, respectively. Therefore, combining these two columns can uniquely identify each row in the table. Several columns in the table begin with 'geom_' and these columns contain geographic information relevant to each road accident. This geospatial data, presented using the WGS 84 coordinate reference system (longitude...

Column Descriptions

Road Traffic Accidents 2011 - Comprehensive Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the specific row of data was extracted from the source.
_row_number	long	This column contains the row number from the data extracted from the source on the date specified in the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains geographical data in GeoJSON format.
geom_geotext	string	This column contains geographical data in Geotext format.
geom_type	string	This column specifies the type of the geographical data stored in the row.
geom_centroid	string	This column contains the centroid of the geographical data.
geom_center_x	double	This column contains the X coordinate of the center of the geographical data.
geom_center_y	double	This column contains the Y coordinate of the center of the geographical data.
gml_id	string	This column contains the GML ID of the data row.
kello	string	This column contains time information.
kkonn	long	This column contains integer data.
lkmhapa	long	This column contains integer data.
lkmjk	long	This column contains integer data.
lkmlaka	long	This column contains integer data.
lkmmo	long	This column contains integer data.
lkmmp	long	This column contains integer data.
lkmmuukulk	long	This column contains integer data.
lkmpp	long	This column contains integer data.
onntyyppi	string	This column contains string data.
vakav	string	This column contains string data.
vvonn	string	This column contains string data, likely related to year information.
x	double	This column contains the X coordinate in a geolocation point.
y	double	This column contains the Y coordinate in a geolocation point.

2011 Road Traffic Accidents History - Finland

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source. This, in combination with the '_row_number' column, uniquely identifies each row in the version history table.
_end_date	date	This column represents the date when a new version of the row was extracted from the data source. If the value of this column is null, it signifies 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. It forms a unique combination with the '_start_date' column to identify each row in the version history table.
geom_geojson	string	This column holds the geographical data in GeoJSON format, which represents the location related to the data row.
geom_geotext	string	This column contains the geographical data in a text format, generally representing a point in geographical space.
geom_type	string	This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, the type is 'ST_POINT', indicating the data represents a point.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the geographical feature related to the data row.
geom_center_x	double	This column represents the X coordinate of the center point of the geographical feature.
geom_center_y	double	This column represents the Y coordinate of the center point of the geographical feature.
gml_id	string	This column contains a unique identifier for each data row, which is used for reference purposes.
kello	string	This column represents a specific time interval.
kkonn	long	This integer column represents a specific attribute related to the data row.
lkmhapa	long	This integer column represents a specific attribute related to the data row.
lkmjk	long	This integer column represents a specific attribute related to the data row.
lkmlaka	long	This integer column represents a specific attribute related to the data row.
lkmmo	long	This integer column represents a specific attribute related to the data row.
lkmmp	long	This integer column represents a specific attribute related to the data row.
lkmmuukulk	long	This integer column represents a specific attribute related to the data row.
lkmpp	long	This integer column represents a specific attribute related to the data row.
onntyyppi	string	This column represents a specific attribute related to the data row.
vakav	string	This column represents a specific attribute related to the data row.
vvonn	string	This column represents a specific year related to the data row.
x	double	This column represents the X coordinate of a geographical point related to the data row.
y	double	This column represents the Y coordinate of a geographical point related to the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024