2017 Road Traffic Accidents History, Version Records Table
Click here for a data sample
The 'table__history' is a rich compendium of data pertaining to road traffic accidents in 2017. Sourced from 'Tilastokeskus' (Statistics Finland), this history table provides a detailed version history of its base table rows, offering an in-depth understanding of each data point's evolution. It is a part of a larger dataset collection focused on road traffic data from the year 2017. The table presents a robust array of data points, including geographic information useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The table also contains other vital data categories, such as the time of the accident, the type of accident, and the severity of the accident. Each row in this version history table is uniquely identified by a combination of the date when the data was extracted ('_start_date') and the row number ('_row_number'). The table also mentions when a new version of the data was extracted ('_end_date'). If the '_end_date' is null, it signifies that the row is the most recent version. This data could be instrumental in several data analytics applications. For instance, a traffic safety analyst could use this data to identify accident-prone areas and times, and propose safety measures. Similarly, urban planners could leverage the geospatial data to plan better road networks and traffic systems. Furthermore, insurance companies could utilize this data to understand accident trends and refine their risk models.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in this history table. |
|---|
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version. |
|---|
| _row_number | long | The number of the row in the raw data extracted from the data source. This column, in combination with '_start_date', uniquely identifies each row in this history table. |
|---|
| geom_geojson | string | The geographic coordinates of the data point, in GeoJSON format. |
|---|
| geom_geotext | string | The geographic coordinates of the data point, in geotext format. |
|---|
| geom_type | string | The type of geographic data stored in the row. In this dataset, all entries are of the type 'ST_POINT'. |
|---|
| geom_centroid | string | The center point of the geographic data, in geotext format. |
|---|
| geom_center_x | double | The X coordinate of the center point of the geographic data. |
|---|
| geom_center_y | double | The Y coordinate of the center point of the geographic data. |
|---|
| gml_id | string | A unique identifier for each row in the dataset. |
|---|
| kello | string | The time of day when the data was collected, in the format 'HH.MM-HH.MM'. |
|---|
| kkonn | long | An integer value with undefined meaning in this dataset. |
|---|
| lkmhapa | long | An integer value with undefined meaning in this dataset. |
|---|
| lkmjk | long | An integer value with undefined meaning in this dataset. |
|---|
| lkmlaka | long | An integer value with undefined meaning in this dataset. |
|---|
| lkmmo | long | An integer value with undefined meaning in this dataset. |
|---|
| lkmmp | long | An integer value with undefined meaning in this dataset. |
|---|
| lkmmuukulk | long | An integer value with undefined meaning in this dataset. |
|---|
| lkmpp | long | An integer value with undefined meaning in this dataset. |
|---|
| onntyyppi | string | An integer value with undefined meaning in this dataset. |
|---|
| vakav | string | An integer value with undefined meaning in this dataset. |
|---|
| vvonn | string | The year when the data was collected, in the format 'YYYY'. |
|---|
| x | double | A real number value with undefined meaning in this dataset. |
|---|
| y | double | A real number value with undefined meaning in this dataset. |
|---|
