2012 Road Traffic Accidents - Data Collection
The table under consideration contains detailed information about road traffic accidents in 2012, sourced from the 'Tilastokeskus' website in Finland. It's part of a larger dataset collection related to road traffic in the same year.
The table is structured with several columns, each carrying unique information. There are columns that hold the date of data extraction and the corresponding row number from the original data source. These two columns, namely '_extract_date' and '_row_number', are vital as they uniquely identify each record in the table.
Geographic data is also a key aspect of this table. There are multiple 'geom_' prefixed columns that store geospatial details which can be used for geospatial data analytics. This information is presented in the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude.
Other columns carry information about the specifics of the accidents, such as the time of the accident, the number of people involved, and the severity of the accident. There's also a column for the unique identifier of each accident record in the form 'tieliikenne_2012.x'.
All this information combined gives a comprehensive view of the road traffic accidents in 2012 in Finland. This data can be utilized in various ways. For instance, data analysts could use the geospatial data to map the areas with the most accidents, which could then be used by transportation departments to improve road safety. The time and severity data could be used to identify patterns in accident occurrences and severity, which could inform road safety campaigns or policies. Lastly, the unique identifiers can help in tracking specific incidents and studying them in detail for further insights.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column indicates the date when the data on the row was extracted from the source. The data is formatted as a date. |
| _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. This column, in combination with '_extract_date', can be used to uniquely identify each row. |
| geom_geojson | string | This column contains geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geometric data in plain text format. |
| geom_type | string | The type of the geographic data is stored in this column. |
| geom_centroid | string | This column contains the centroid of the geographic data. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographic data. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographic data. |
| gml_id | string | This string column contains the ID of the Geographic Markup Language (GML) data. |
| kello | string | This string column contains the time-related information. |
| kkonn | long | This integer column contains specific data related to the dataset. |
| lkmhapa | long | This integer column contains specific data related to the dataset. |
| lkmjk | long | This integer column contains specific data related to the dataset. |
| lkmlaka | long | This integer column contains specific data related to the dataset. |
| lkmmo | long | This integer column contains specific data related to the dataset. |
| lkmmp | long | This integer column contains specific data related to the dataset. |
| lkmmuukulk | long | This integer column contains specific data related to the dataset. |
| lkmpp | long | This integer column contains specific data related to the dataset. |
| onntyyppi | string | This string column contains specific data related to the dataset. |
| vakav | string | This string column contains specific data related to the dataset. |
| vvonn | string | This string column contains specific data related to the dataset. |
| x | double | This real column contains specific data related to the dataset. |
| y | double | This real column contains specific data related to the dataset. |
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 | cf486467-0b6b-402b-8af9-e132510c1053 |
| Package id | 461aa410-5b72-426c-8c92-ab99cf21b8a0 |
| Revision id | 184671c7-a91d-4540-8018-1bc9cc065304 |
| State | active |
| Table | tieliikenne_tieliikenne_2012__table |