2012 Road Traffic Statistics Collection
Tables
-
2012 Road Traffic Accidents - Data CollectionTSV
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...
-
2012 Road Traffic Accidents History in FinlandTSV
The 'History' table is an integral part of the 'Road Traffic 2012' dataset collection. It is a rich resource that contains the version history of base table rows, tracing changes over time. The table includes critical information about road traffic accidents in 2012, making it an essential tool for analyzing traffic safety patterns in Finland, sourced from 'Tilastokeskus' (Statistics Finland). The table is composed of numerous columns, each providing specific details about each recorded accident. For instance, it contains information such as the time of the accident, the number of involved road users, and the severity of the accident. Furthermore, it includes columns starting with 'geom_' that contain geographic information, enabling geospatial data analytics. This geographic...
Column Descriptions
2012 Road Traffic Accidents - Data Collection
| Column | Type | Comment |
|---|---|---|
| _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. |
2012 Road Traffic Accidents History in Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. The dates are formatted as 'YYYY-MM-DD'. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it forms a unique identifier for each row in this version history table. |
| geom_geojson | string | This column contains geographic data in GeoJSON format. |
| geom_geotext | string | This column contains geographic data in text format. |
| geom_type | string | This column specifies the type of the geographic data. |
| geom_centroid | string | This column contains the centroid of the geographic data. |
| geom_center_x | double | This column contains the x-coordinate of the geographic data center. |
| geom_center_y | double | This column contains the y-coordinate of the geographic data center. |
| gml_id | string | This column contains the unique identifier for each row. |
| kello | string | This column contains the time of the event. The time is formatted as 'HH.MM - HH.MM'. |
| kkonn | long | This column contains integer values. |
| lkmhapa | long | This column contains integer values. |
| lkmjk | long | This column contains integer values. |
| lkmlaka | long | This column contains integer values. |
| lkmmo | long | This column contains integer values. |
| lkmmp | long | This column contains integer values. |
| lkmmuukulk | long | This column contains integer values. |
| lkmpp | long | This column contains integer values. |
| onntyyppi | string | This column contains integer values. |
| vakav | string | This column contains integer values. |
| vvonn | string | This column contains the year of the event. The year is formatted as 'YYYY'. |
| x | double | This column contains real number values representing geographic coordinates. |
| y | double | This column contains real number values representing geographic coordinates. |
Additional Info
| Last Updated | November 12, 2024 |
|---|---|
| Created | November 11, 2024 |