Road Traffic Accidents 2016 - Version History
The 'table__history' is the version history table of the 'Road Traffic Accidents 2016' dataset, sourced from the 'Tilastokeskus' (Statistics Finland) website of Finland. This history table provides a rich collection of related data pertaining to road traffic accidents in 2016. The table incorporates a variety of columns, each representing a unique aspect of the collected data.
As a history table, it contains a pair of special columns '_start_date' and '_end_date' which represent when a row was extracted from the data source and when a new version of the row was extracted, respectively. Together with the '_row_number', which indicates the row's position in raw data, these columns help in uniquely identifying each row in this version history table. If the '_end_date' value is null, it shows that the row is the most recent version.
Geospatial data analytics can greatly benefit from the columns starting with 'geom_', which contain geographic information. The geographic coordinates are presented using the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude.
The data in this table could be utilized in various ways. For instance, transportation agencies could analyze the data to identify high-risk areas for accidents and take preventive measures. Research institutions could use the data to study the correlation between various factors and road accidents. Moreover, the version history aspect of the table could help in tracking changes in road traffic accidents over time, providing valuable insights into trends and patterns.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This is the date when the row was extracted from the data source. |
| _end_date | date | This represents the date when a new version of the row was extracted from the data source. If null, the row is the most recent version. |
| _row_number | long | This is the number of the row in the raw data. Along with '_start_date', it uniquely identifies each row in the table. |
| geom_geojson | string | This contains geospatial data in GeoJSON format. |
| geom_geotext | string | This contains geospatial data in text format. |
| geom_type | string | This identifies the type of the geometric object. |
| geom_centroid | string | This represents the geometric center of the object. |
| geom_center_x | double | This is the x-coordinate of the geometric center of the object. |
| geom_center_y | double | This is the y-coordinate of the geometric center of the object. |
| gml_id | string | This is a unique identifier of the row. |
| kello | string | This represents the time period. |
| kkonn | long | This is an integer value with an unknown purpose. |
| lkmhapa | long | This is an integer value with an unknown purpose. |
| lkmjk | long | This is an integer value with an unknown use. |
| lkmlaka | long | This is an integer value with an unknown purpose. |
| lkmmo | long | This is an integer value with an unknown use. |
| lkmmp | long | This is an integer value with an unknown purpose. |
| lkmmuukulk | long | This is an integer value with an unknown use. |
| lkmpp | long | This is an integer value with an unknown purpose. |
| onntyyppi | string | This is an integer value with an unknown use. |
| vakav | string | This is an integer value with an unknown purpose. |
| vvonn | string | This is a string that could represent a year. |
| x | double | This is a real number representing a coordinate or other spatial data. |
| y | double | This is a real number representing a coordinate or other spatial data. |
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 | a675e93e-80cf-44c8-bd55-9d7a0ea477ff |
| Package id | 5e55d456-c899-4813-ad04-d526f53f5f65 |
| Position | 1 |
| Revision id | dbd00237-c7cf-4e42-9b4e-5e6e43a9e097 |
| State | active |
| Table | tieliikenne_tieliikenne_2016__table__history |