2014 Road Traffic Accidents Data Table
The table is a part of a larger collection of data, which consists of several tables with related data. This particular table is focused on Road Traffic Accidents in 2014, sourced from 'Tilastokeskus' (Statistics Finland). It provides a detailed and comprehensive overview of the accidents that occurred during that year in Finland, with each row representing a unique accident event.
The table includes various data points, such as the exact date when the data was extracted, the unique row number for each accident, as well as a multitude of geospatial data fields. The geospatial data fields present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude, which can be utilized for geospatial data analytics. For example, one could visualize the locations of accidents on a map or analyze geographical patterns and trends related to road traffic accidents.
Other data fields cover more specific details about each accident, such as the time it occurred, the severity, and the type of accident. This data could be used in a variety of analytical applications, from studying the correlation between the time of day and accident severity, to creating predictive models for future accidents based on historical data.
A unique feature of this table is the combination of the '_extract_date' and '_row_number' columns, which together uniquely identify each row. This allows for precise tracking and referencing of each individual accident event, which can be crucial in both data management and more advanced analytical tasks.
In conclusion, the table offers a rich source of data for a wide range of analytical applications, particularly those related to road safety and geospatial analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date. This, along with the '_extract_date', uniquely identifies each row. |
| geom_geojson | string | This column contains the geographical data of the incident in GeoJSON format. |
| geom_geotext | string | This column contains the geographical data of the incident in textual format. |
| geom_type | string | This column specifies the type of the geographical data. |
| geom_centroid | string | This column contains the centroid of the geographical data. |
| geom_center_x | double | This column represents the x-coordinate of the center of the geographical data. |
| geom_center_y | double | This column represents the y-coordinate of the center of the geographical data. |
| gml_id | string | This column contains a unique identifier for each row. |
| kello | string | This column indicates the time of the incident. |
| kkonn | long | This column contains an integer value (unknown meaning). |
| lkmhapa | long | This column contains an integer value (unknown meaning). |
| lkmjk | long | This column contains an integer value (unknown meaning). |
| lkmlaka | long | This column contains an integer value (unknown meaning). |
| lkmmo | long | This column contains an integer value (unknown meaning). |
| lkmmp | long | This column contains an integer value (unknown meaning). |
| lkmmuukulk | long | This column contains an integer value (unknown meaning). |
| lkmpp | long | This column contains an integer value (unknown meaning). |
| onntyyppi | string | This column indicates the type of incident. |
| vakav | string | This column indicates the severity of the incident. |
| vvonn | string | This column indicates the year of the incident. |
| x | double | This column represents the x-coordinate of the incident location. |
| y | double | This column represents the y-coordinate of the incident location. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | ad8e1b49-82e6-4987-865f-fdd2dd07bef4 |
| Package id | e65283ee-be7a-42a8-95b1-754da7b0303e |
| Revision id | bde53429-5922-401d-bdac-3c9857c9c297 |
| State | active |
| Table | tieliikenne_tieliikenne_2014__table |