Road Traffic Accidents 2013 - Data Table
Click here for a data sample
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 time it occurred or the severity. Unique identifiers are also included in the 'gml_id' column. The data in this table could be used in numerous ways in data analytics. For example, it could be used to analyze the spatial distribution of accidents to identify accident hotspots, or to study the correlation between the time of day and the severity of accidents. In addition, the data could be used to analyze trends in accident occurrence over the course of the year. Two special columns, '_extract_date' and '_row_number', are included in the table. '_extract_date' contains the date when the data was extracted, and the '_row_number' indicates the specific row in the data extracted. These two columns uniquely identify each row in the table.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
