2019 Road Traffic Data Collection
Tables
-
2019 Road Traffic Accidents Data TableTSV
The 'table' is part of a larger dataset collection which focuses on road traffic accidents in 2019. It comprises columns that contain a variety of data related to each incident, including geographic information, specific identifiers, and details about the accidents themselves. This valuable collection can be utilized for a range of data analytics purposes, such as studying traffic patterns, identifying high-risk areas, or analyzing accident trends over time. The geographic data is particularly useful for geospatial data analytics, as it is presented using WGS 84 coordinate reference system, with axis order being longitude first, followed by latitude. This allows for the precise pinpointing of accident locations and the creation of detailed, meaningful visualizations. The table also...
-
2019 Road Traffic Accidents History Version - FinlandTSV
The 'table__history' is a comprehensive record containing the version history of its base table rows. It holds significant data pertaining to road traffic accidents in 2019 (Tieliikenneonnettomuudet 2019), sourced from the Central Bureau of Statistics (Tilastokeskus) in Finland. This historical table uniquely identifies each row with a combination of the row number and the date when the row was first extracted from the source data. It also reflects when a new version of the row was extracted, providing an ongoing timeline of updates. If the end date for a row is null, it denotes the most recent version. The table is rich with geographic information, encoded in columns beginning with 'geom_', which is useful for geospatial data analytics. These columns present geographic coordinates...
Column Descriptions
2019 Road Traffic Accidents Data Table
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column records the date when the row data was extracted from the data source. |
| _row_number | long | This column records the row number in the data extracted from the source on the extraction date specified by the '_extract_date' column. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. |
| geom_geotext | string | This column holds the geometric data in a text format. |
| geom_type | string | This column specifies the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column contains the X-coordinate of the geometric center. |
| geom_center_y | double | This column contains the Y-coordinate of the geometric center. |
| gml_id | string | This column holds the unique identifier of the data row. |
| kello | string | This column represents the time of the event. |
| kkonn | long | This column is an integer type column. |
| lkmhapa | long | This column is also an integer type column. |
| lkmjk | long | This column is an integer type column. |
| lkmlaka | long | This column is an integer type column. |
| lkmmo | long | This column is an integer type column. |
| lkmmp | long | This column is an integer type column. |
| lkmmuukulk | long | This column is an integer type column. |
| lkmpp | long | This column is an integer type column. |
| onntyyppi | string | This column is a string type column. |
| vakav | string | This column is a string type column. |
| vvonn | string | This column is a string type column. |
| x | double | This column is a real type column that holds numerical data. |
| y | double | This column is a real type column that holds numerical data. |
2019 Road Traffic Accidents History Version - Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of the combination with _row_number that uniquely identifies each row in this version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the row number from the raw data extracted from the source. It forms a unique identifier for each row in combination with _start_date. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format. |
| geom_geotext | string | This column contains geometric data in text format. |
| geom_type | string | This column indicates the geometric data type. |
| geom_centroid | string | This column contains the geometric center (centroid) of the data point. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center. |
| gml_id | string | This column contains a unique identifier for the data point. |
| kello | string | This column contains the time associated with the data point. |
| kkonn | long | This column contains an integer value. |
| lkmhapa | long | This column contains an integer value. |
| lkmjk | long | This column contains an integer value. |
| lkmlaka | long | This column contains an integer value. |
| lkmmo | long | This column contains an integer value. |
| lkmmp | long | This column contains an integer value. |
| lkmmuukulk | long | This column contains an integer value. |
| lkmpp | long | This column contains an integer value. |
| onntyyppi | string | This column contains a string value. |
| vakav | string | This column contains a string value. |
| vvonn | string | This column contains a string value. |
| x | double | This column contains a real number representing the x-coordinate of the data point. |
| y | double | This column contains a real number representing the y-coordinate of the data point. |
Additional Info
| Last Updated | November 12, 2024 |
|---|---|
| Created | November 11, 2024 |