2018 Road Traffic Statistics

The 'tieliikenne_tieliikenne_2018' dataset collection encompasses a series of interconnected data tables. These tables, sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland, present a comprehensive set of data related to road traffic in the year 2018. Each table within the collection features an array of data organized in rows and columns, providing clear and concise statistical information. The dataset, provided by the 'Tilastokeskus' service interface (WFS), offers a valuable resource for anyone seeking detailed insights into road traffic in Finland for the year 2018. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2018 Road Traffic Accidents History - Versioned Record TableTSV
The 'history' table is a part of a dataset collection that stores data related to road traffic accidents in 2018. The data in this table is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish statistical organization. The table serves as a historical record of its base table rows, storing the version history of each row. This is achieved through special columns: '_start_date' and '_end_date', which respectively mark when the row was extracted from the source, and when a new version of the row was extracted. If '_end_date' is null, it implies that the row is the most recent version. The '_row_number' column helps in uniquely identifying each row, combined with '_start_date'. The table contains a wealth of information, with columns storing geographic data that can be used for...
Road Traffic Accidents 2018 Data TableTSV
The table is part of a dataset collection that focuses on road traffic accidents in 2018. This valuable information resource, sourced from Statistics Finland ('Tilastokeskus'), provides in-depth insights into various aspects of road accidents. By analyzing the diverse range of data within the table, one could identify patterns and trends related to road safety, potentially informing traffic management strategies and safety measures. The data is geospatial in nature, with several columns dedicated to geographic information. These geospatial details are presented using the WGS 84 coordinate reference system, with longitude followed by latitude. This information allows for a precise understanding of where each accident occurred, making the data particularly useful for geospatial...

Column Descriptions

Road Traffic Accidents 2018 Data Table

Column	Type	Comment
_extract_date	date	This special column contains the date when the data on the row of the table was extracted from the data source.
_row_number	long	This special column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	This column contains geometric data in GeoJSON format, representing specific geographic locations.
geom_geotext	string	This column contains textual geographic data, likely coordinates, corresponding to the GeoJSON data.
geom_type	string	This column specifies the type of the geometric data, such as point, line, or polygon.
geom_centroid	string	This column contains the geometric center or centroid of the geographic location.
geom_center_x	double	This column contains the X-coordinate of the geometric center of the geographic location.
geom_center_y	double	This column contains the Y-coordinate of the geometric center of the geographic location.
gml_id	string	This is a unique identifier for each record in the dataset.
kello	string	This column represents specific time ranges.
kkonn	long	This column contains integer values, the meaning of which is not specified by the source.
lkmhapa	long	This column contains integer values, the meaning of which is not specified by the source.
lkmjk	long	This column contains integer values, the meaning of which is not specified by the source.
lkmlaka	long	This column contains integer values, the meaning of which is not specified by the source.
lkmmo	long	This column contains integer values, the meaning of which is not specified by the source.
lkmmp	long	This column contains integer values, the meaning of which is not specified by the source.
lkmmuukulk	long	This column contains integer values, the meaning of which is not specified by the source.
lkmpp	long	This column contains integer values, the meaning of which is not specified by the source.
onntyyppi	string	This column contains integer values, the meaning of which is not specified by the source.
vakav	string	This column contains integer values, the meaning of which is not specified by the source.
vvonn	string	This column contains string values, likely representing a specific year.
x	double	This column contains real values, likely representing a specific geographic coordinate.
y	double	This column contains real values, likely representing a specific geographic coordinate.

2018 Road Traffic Accidents History - Versioned Record Table

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It is used together with '_row_number' to uniquely identify each row in this 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 of this column is null, it means 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 is used together with '_start_date' to uniquely identify each row in this history table.
geom_geojson	string	This column contains geographical data in GeoJSON format.
geom_geotext	string	This column contains geographical data in text format.
geom_type	string	This column specifies the type of geographical data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the centroid point of the geographical data.
geom_center_x	double	This column contains the x-coordinate of the center point of the geographical data.
geom_center_y	double	This column contains the y-coordinate of the center point of the geographical data.
gml_id	string	This column contains a unique identifier for the row.
kello	string	This column contains information about the hour of the day.
kkonn	long	This column contains numerical data.
lkmhapa	long	This column contains numerical data.
lkmjk	long	This column contains numerical data.
lkmlaka	long	This column contains numerical data.
lkmmo	long	This column contains numerical data.
lkmmp	long	This column contains numerical data.
lkmmuukulk	long	This column contains numerical data.
lkmpp	long	This column contains numerical data.
onntyyppi	string	This column contains numerical data.
vakav	string	This column contains numerical data.
vvonn	string	This column contains information about the year.
x	double	This column contains the x-coordinate of a point.
y	double	This column contains the y-coordinate of a point.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024