Road Traffic Accidents 2018 Data Table
The table is part of a dataset collection that focuses on road traffic accidents in 2018. This valuable information resource, sourced from Statistics Finland ('Tilastokeskus'), provides in-depth insights into various aspects of road accidents. By analyzing the diverse range of data within the table, one could identify patterns and trends related to road safety, potentially informing traffic management strategies and safety measures.
The data is geospatial in nature, with several columns dedicated to geographic information. These geospatial details are presented using the WGS 84 coordinate reference system, with longitude followed by latitude. This information allows for a precise understanding of where each accident occurred, making the data particularly useful for geospatial analytics. For instance, these geospatial elements could be utilized to create visualizations of accident hotspots, informing traffic planning and road safety initiatives.
The table also includes specific columns that provide unique identifiers for each row of data. The '_extract_date' column indicates when the data was extracted from the source, while the '_row_number' column denotes the row number in the data extracted on that specific date. These two columns together uniquely identify each row, ensuring the data's integrity and consistency.
In addition to these, the table contains a plethora of other detailed attributes related to each accident, such as the type of accident, severity, and the number of different types of vehicles involved. These details could be instrumental in conducting a comprehensive analysis of road traffic accidents, understanding their causes and consequences, and ultimately working towards improving road safety.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This special column contains the date when the data on the row of the table was extracted from the data source. |
| _row_number | long | This special column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, representing specific geographic locations. |
| geom_geotext | string | This column contains textual geographic data, likely coordinates, corresponding to the GeoJSON data. |
| geom_type | string | This column specifies the type of the geometric data, such as point, line, or polygon. |
| geom_centroid | string | This column contains the geometric center or centroid of the geographic location. |
| geom_center_x | double | This column contains the X-coordinate of the geometric center of the geographic location. |
| geom_center_y | double | This column contains the Y-coordinate of the geometric center of the geographic location. |
| gml_id | string | This is a unique identifier for each record in the dataset. |
| kello | string | This column represents specific time ranges. |
| kkonn | long | This column contains integer values, the meaning of which is not specified by the source. |
| lkmhapa | long | This column contains integer values, the meaning of which is not specified by the source. |
| lkmjk | long | This column contains integer values, the meaning of which is not specified by the source. |
| lkmlaka | long | This column contains integer values, the meaning of which is not specified by the source. |
| lkmmo | long | This column contains integer values, the meaning of which is not specified by the source. |
| lkmmp | long | This column contains integer values, the meaning of which is not specified by the source. |
| lkmmuukulk | long | This column contains integer values, the meaning of which is not specified by the source. |
| lkmpp | long | This column contains integer values, the meaning of which is not specified by the source. |
| onntyyppi | string | This column contains integer values, the meaning of which is not specified by the source. |
| vakav | string | This column contains integer values, the meaning of which is not specified by the source. |
| vvonn | string | This column contains string values, likely representing a specific year. |
| x | double | This column contains real values, likely representing a specific geographic coordinate. |
| y | double | This column contains real values, likely representing a specific geographic coordinate. |
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 | e1d20e9f-ba5b-4c42-83d3-5562e04943d5 |
| Package id | fcaeafc9-e25b-46e3-8449-c0db2f6b9cdd |
| Revision id | 8741eeb2-1db4-4e17-81bc-1c4ea4eaa180 |
| State | active |
| Table | tieliikenne_tieliikenne_2018__table |