2013 Transportation Data Collection

This dataset collection comprises multiple related data tables sourced from the web service interface (WFS) of the 'Tilastokeskus' (Statistics Finland) website in Finland. The data tables are organized in columns and rows, offering a structured format for the data. The information contained within this dataset collection primarily focuses on road traffic data for the year 2013. The data is comprehensive and could serve as a valuable resource for research and analysis related to road traffic patterns and statistics in Finland for the specified year. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Road Traffic Accidents 2013 - Data TableTSV
The table is part of a larger dataset collection and is primarily focused on Road Traffic Accidents in 2013, sourced from the Finnish 'Tilastokeskus' (Statistics Finland) website. It is a rich resource of data, providing details on a broad range of aspects related to road traffic accidents. It includes information such as the date of data extraction, the unique row number, and a variety of geographic information useful for geospatial data analytics. The geographic coordinates are aligned with the WGS 84 coordinate reference system, which places longitude first, followed by latitude. These details are captured in columns such as 'geom_geojson', 'geom_geotext', 'geom_type', and others. Besides, the table also includes columns that detail specific elements of the accidents, such as the...
Version History of Road Traffic Accidents 2013TSV
The 'table__history' is a comprehensive chronicle of traffic accidents that occurred in Finland in 2013, sourced from the Finnish statistical agency, 'Tilastokeskus'. This table forms a part of the larger 'tieliikenne_tieliikenne_2013' dataset collection. The table keeps track of the version history of each row in the base table, providing a timeline of when each piece of data was extracted and when it was updated, if applicable. Unique identifiers for each row are created through a combination of the extraction date ('_start_date') and the row number ('_row_number') in the raw data. If a row has been updated, the '_end_date' column lists the date of the new extraction; if this is null, it indicates that the row is the most recent version. In addition to the temporal metadata, the table...

Column Descriptions

Road Traffic Accidents 2013 - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the table's row was extracted from the source. It is one of the two special columns that uniquely identifies each row in the table.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It is one of the two special columns that uniquely identifies each row in the table.
geom_geojson	string	This column contains geojson data that represents a geographical feature with a point type geometry.
geom_geotext	string	This column contains the textual representation of the geographical coordinates of a feature.
geom_type	string	This column identifies the type of the geometry of the geographical feature.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the feature.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geographical feature.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geographical feature.
gml_id	string	This column contains a unique identifier for each row in the table.
kello	string	This column contains the time range during which the data was collected.
kkonn	long	This integer column contains unidentified data.
lkmhapa	long	This integer column contains unidentified data.
lkmjk	long	This integer column contains unidentified data.
lkmlaka	long	This integer column contains unidentified data.
lkmmo	long	This integer column contains unidentified data.
lkmmp	long	This integer column contains unidentified data.
lkmmuukulk	long	This integer column contains unidentified data.
lkmpp	long	This integer column contains unidentified data.
onntyyppi	string	This string column contains unidentified data.
vakav	string	This string column contains unidentified data.
vvonn	string	This string column contains the year of the data.
x	double	This real type column represents the x-coordinate in a spatial reference system.
y	double	This real type column represents the y-coordinate in a spatial reference system.

Version History of Road Traffic Accidents 2013

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source. It is a part of a unique identifier for each row in combination with the '_row_number' column in this version history table.
_end_date	date	This column represents the date when a new version of a row was extracted from the data source. If the value is null, it indicates that the row version is the most recent one.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in combination with the '_start_date' column.
geom_geojson	string	This column contains the geographical information of the data in GeoJSON format.
geom_geotext	string	This column contains the geographical information as a plain text.
geom_type	string	This column specifies the type of the geographical data. The data is of type 'ST_POINT', which represents a point in space.
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 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 each row.
kello	string	This column represents a time range.
kkonn	long	This integer column represents a specific attribute of the data, with values like 12, 7, 3, 10, 5.
lkmhapa	long	This integer column represents a specific attribute of the data, with values like 1, 0, 2.
lkmjk	long	This integer column represents a specific attribute of the data, with values like 0, 1.
lkmlaka	long	This integer column represents a specific attribute of the data, with values like 0, 1.
lkmmo	long	This integer column represents a specific attribute of the data, with values like 0.
lkmmp	long	This integer column represents a specific attribute of the data, with values like 0, 1.
lkmmuukulk	long	This integer column represents a specific attribute of the data, with values like 0.
lkmpp	long	This integer column represents a specific attribute of the data, with values like 0.
onntyyppi	string	This column represents a specific attribute of the data, with values like 8, 7, 2, 0, 1.
vakav	string	This column represents a specific attribute of the data, with values like 2, 1.
vvonn	string	This column represents the year of the event, with values like 2013.
x	double	This column contains the X coordinate of the geographical location.
y	double	This column contains the Y coordinate of the geographical location.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024