2011 Road Traffic Accidents History - Finland
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 includes a unique combination of '_start_date' and '_row_number' for each row, allowing a detailed version history of each accident record. The '_start_date' indicates when the row was extracted from the data source, while the '_end_date' indicates when a new version of the row was extracted. If the '_end_date' is null, it signifies that the row is the most recent version of the record.
The data in this table can be leveraged for a variety of analytical purposes. For instance, traffic safety authorities can use this data to identify high-risk areas and times for road accidents, informing targeted interventions. Urban planners can utilize the geospatial data to assess the impact of road infrastructure on accident rates. Furthermore, researchers can use the version history to track changes in accident rates over time, providing valuable insights into the effectiveness of road safety measures.
The 'table__history' is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
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 | 9cd8f0c0-8ca3-494d-82cc-af23410b7f94 |
| Package id | fd8dc0d4-91eb-47db-bc5a-afe4a9b96589 |
| Position | 1 |
| Revision id | fece3220-b01d-4269-8ec0-24c474c9021d |
| State | active |
| Table | tieliikenne_tieliikenne_2011__table__history |