Road Traffic Accidents 2011 - Comprehensive Data Table
The table, coming from the Finnish 'Tilastokeskus' web site, contains an assortment of data related to 'Road Traffic Accidents in 2011'. This table is a part of a larger dataset collection which holds similar tables.
The data in the table is organized into several columns, each containing specific types of information. For instance, two special columns '_extract_date' and '_row_number' hold the date of data extraction and the row's unique identifier in the extracted data, respectively. Therefore, combining these two columns can uniquely identify each row in the table.
Several columns in the table begin with 'geom_' and these columns contain geographic information relevant to each road accident. This geospatial data, presented using the WGS 84 coordinate reference system (longitude first, followed by latitude), can be valuable for analyzing the geographic distribution and frequency of road accidents.
The data in this table can be utilized in a number of ways for data analytics. For instance, the geospatial data could be used to identify hotspots for road traffic accidents, enabling authorities to focus their efforts on improving road safety in these areas. The '_extract_date' could be used to track changes in accident rates over time, providing insights into the effectiveness of road safety measures. Moreover, other columns can be analyzed to understand the specific circumstances of each accident, such as the time of the accident, the number of people involved, and the severity of the accident. This could help in identifying patterns and trends in road accidents, potentially informing policy decisions and public safety campaigns.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the specific row of data was extracted from the source. |
| _row_number | long | This column contains the row number from the data extracted from the source on the date specified in the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row. |
| geom_geojson | string | This column contains geographical data in GeoJSON format. |
| geom_geotext | string | This column contains geographical data in Geotext format. |
| geom_type | string | This column specifies the type of the geographical data stored in the row. |
| geom_centroid | string | This column contains the centroid of the geographical data. |
| geom_center_x | double | This column contains the X coordinate of the center of the geographical data. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical data. |
| gml_id | string | This column contains the GML ID of the data row. |
| kello | string | This column contains time information. |
| kkonn | long | This column contains integer data. |
| lkmhapa | long | This column contains integer data. |
| lkmjk | long | This column contains integer data. |
| lkmlaka | long | This column contains integer data. |
| lkmmo | long | This column contains integer data. |
| lkmmp | long | This column contains integer data. |
| lkmmuukulk | long | This column contains integer data. |
| lkmpp | long | This column contains integer data. |
| onntyyppi | string | This column contains string data. |
| vakav | string | This column contains string data. |
| vvonn | string | This column contains string data, likely related to year information. |
| x | double | This column contains the X coordinate in a geolocation point. |
| y | double | This column contains the Y coordinate in a geolocation point. |
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 | 84cc721d-32cd-4450-a220-f890e4997c6a |
| Package id | fd8dc0d4-91eb-47db-bc5a-afe4a9b96589 |
| Revision id | cb0ebf8e-695f-4630-8595-d11b40dde30a |
| State | active |
| Table | tieliikenne_tieliikenne_2011__table |