Road Traffic Accidents 2015 - Detailed Analysis
The table, part of a larger dataset collection, contains intricately detailed data related to 'Road Traffic Accidents in 2015'. This data was sourced from the website of 'Tilastokeskus' (Statistics Finland). The table is structured with columns and rows, each row representing a unique record of a road traffic accident in 2015.
To uniquely identify each record, two special columns have been used: one containing the date when the data was extracted, and the other specifying the row number in the data extracted. These two columns combined create a unique identifier for each row of data.
A notable feature of this table is its inclusion of geospatial data. Several columns beginning with 'geom_' hold geographical information about the location of the accidents. This information is presented in the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The data contained within the table can be utilized in various ways in data analytics. For instance, the geographical data can be used to create visual representations of accident hotspots, aiding in the identification of high-risk areas. The date and time data can be analyzed to identify patterns or peak times for accidents. Additionally, the various other columns provide a wealth of information about the accidents, such as severity, type, and other specifics that can be used to understand road safety better and develop more effective preventative measures.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It helps in tracking the acquisition timeline of the data. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It serves as an unique identifier for each row. |
| geom_geojson | string | This column holds the geographic location data of each entry in GeoJSON format, which is a widely used format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geographic location data in geotext format. It provides an alternate representation of the geographic data. |
| geom_type | string | This column specifies the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns. The type is 'ST_POINT', indicating that the geographic data represents a point. |
| geom_centroid | string | This column represents the geometric center, or centroid, of the geographic data for each entry. |
| geom_center_x | double | This column represents the x-coordinate of the geometric center of the geographic data. |
| geom_center_y | double | This column represents the y-coordinate of the geometric center of the geographic data. |
| gml_id | string | This is an identifier for the geographic data associated with each entry. |
| kello | string | This column contains time data for each entry. |
| kkonn | long | This column contains integer data, specific meaning is not provided by the data source. |
| lkmhapa | long | This column contains integer data, specific meaning is not provided by the data source. |
| lkmjk | long | This column contains integer data, specific meaning is not provided by the data source. |
| lkmlaka | long | This column contains integer data, specific meaning is not provided by the data source. |
| lkmmo | long | This column contains integer data, specific meaning is not provided by the data source. |
| lkmmp | long | This column contains integer data, specific meaning is not provided by the data source. |
| lkmmuukulk | long | This column contains integer data, specific meaning is not provided by the data source. |
| lkmpp | long | This column contains integer data, specific meaning is not provided by the data source. |
| onntyyppi | string | This column contains string data, specific meaning is not provided by the data source. |
| vakav | string | This column contains string data, specific meaning is not provided by the data source. |
| vvonn | string | This column contains string data, presumably related to the year. |
| x | double | This column contains the x-coordinate of the geographic data in a real number format. |
| y | double | This column contains the y-coordinate of the geographic data in a real number format. |
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 | 74e208fb-69f8-4461-94a1-8f50272572d8 |
| Package id | e21da7ee-20ea-49a6-83f2-a4cd5fdfb6b3 |
| Revision id | 77bc7fa4-d30b-4b64-9152-cefdc7511ced |
| State | active |
| Table | tieliikenne_tieliikenne_2015__table |