Road Traffic Accidents 2017 - Data Collection
The table presents a collection of related data on Road Traffic Accidents of 2017, originally obtained from the website of Statistics Finland (Tilastokeskus). The data include a variety of columns providing comprehensive information on the traffic accidents.
A couple of special columns that are worth mentioning are: '_extract_date', which provides the specific date when the data row was extracted and '_row_number', which stands for the row number in the data extracted on the specific extraction date. These two columns jointly identify each data row in a unique manner.
Additionally, the table includes several columns storing geographic information. These columns, all commencing with the prefix 'geom_', contain geospatial data that can be utilized for geospatial data analytics. The geographic coordinates, for instance, are presented using the WGS 84 coordinate reference system, with the order being longitude first, followed by latitude.
The table can be utilized in numerous ways for data analytics. For instance, the data on the accidents can be analyzed to identify patterns or trends over time, which might help in implementing measures to reduce such incidents. Similarly, the geospatial data can be used to identify specific locations with a high incidence of accidents, thereby providing a basis for targeted interventions. Furthermore, the data can be used to study the correlation between different variables, such as the severity of the accident and the time of the day or the location of the accident, leading to valuable insights for traffic management and road safety.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | The date when the data on the row was extracted from the source. |
| _row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| geom_geojson | string | The geographical coordinates in GeoJson format. |
| geom_geotext | string | The geographical coordinates in textual format. |
| geom_type | string | The type of geometrical data, for instance, a point. |
| geom_centroid | string | The centroid of the geographical data. |
| geom_center_x | double | The X coordinate of the center of the geographical data. |
| geom_center_y | double | The Y coordinate of the center of the geographical data. |
| gml_id | string | A unique identifier for the data row. |
| kello | string | Time information related to the data. |
| kkonn | long | An integer value with no provided description. |
| lkmhapa | long | An integer value with no provided description. |
| lkmjk | long | An integer value with no provided description. |
| lkmlaka | long | An integer value with no provided description. |
| lkmmo | long | An integer value with no provided description. |
| lkmmp | long | An integer value with no provided description. |
| lkmmuukulk | long | An integer value with no provided description. |
| lkmpp | long | An integer value with no provided description. |
| onntyyppi | string | A string value with no provided description. |
| vakav | string | A string value with no provided description. |
| vvonn | string | A string value with no provided description. |
| x | double | A real number representing a coordinate or a similar numerical value. |
| y | double | A real number representing a coordinate or a similar numerical value. |
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 | 07cba280-382c-4502-b7f9-a1b80d70b2cd |
| Package id | 528a1c54-800f-46bf-8b46-85ade699b7b7 |
| Revision id | 17c6346d-c33b-4e12-90a5-1ae15475dc6a |
| State | active |
| Table | tieliikenne_tieliikenne_2017__table |