Version History of Regional Units 2014 (1:4 500 000)
The 'table__history' is a historical data table that forms part of a dataset collection of related tables. This table specifically deals with the version history of its base table rows, presenting a timeline of data extraction from the source. The base table content is described as 'Seutukunnat 2014 (1:4 500 000)', which translates to 'Sub-regions 2014 (1:4 500 000)' in English.
The table contains a number of columns, each providing specific information. There are columns that detail the date of data extraction ('_start_date') and the date when a new version of the row was extracted ('_end_date'). These columns together with the row number ('_row_number') provide a unique identifier for each row, allowing for precise tracking and management of data changes over time. If the '_end_date' is null, it indicates that the row is the most recent version.
The table also features geographic columns that hold valuable geospatial data. These columns begin with the prefix 'geom_' and contain information that can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
In terms of content, the table holds information on different 'Sub-regions' (Seutukunnat). It provides details such as the geographic center (longitude and latitude), the type of geographic data presented, the name of the sub-region in different languages, and a unique identifier for each sub-region ('gml_id'). The year of the data is also provided ('vuosi').
This historical data table, sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland, holds valuable insights for data analytics. For instance, the geospatial data can be used to track changes in regional boundaries over time or analyze population shifts in different sub-regions. The unique identification of each row also allows for accurate longitudinal studies. Additionally, the multilingual sub-region names could be used in research involving language usage and regional identity.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' for each row in this version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted. If the column value is null, it denotes that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| geom_geojson | string | This column contains the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geographic data as text. The data is typically represented as polygons or multipolygons. |
| geom_type | string | This column specifies the type of the geographic data. In this case, the type is ST_MULTIPOLYGON, which means the data represents multiple polygons. |
| geom_centroid | string | This column contains the centroid of the geographic data. The centroid is the geometric center of a shape. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the shape. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the shape. |
| gml_id | string | This column is a unique identifier for each row in the table. |
| name | string | This column contains the name of the region in English. |
| namn | string | This column contains the name of the region in Swedish. |
| nimi | string | This column contains the name of the region in Finnish. |
| seutukunta | string | This column contains the regional code for the region. |
| vuosi | long | This column contains the year of the data. All the data in this table is from the year 2014. |
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 | 066bfc3e-0855-4215-806a-3464fd450274 |
| Package id | afe69d93-c0e2-438b-b13d-0717f5c5a272 |
| Position | 1 |
| Revision id | c0048886-42cb-48c3-8ada-8e61a1de7faa |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2014__table__history |