Provinces 2022 Version History (1:1 000 000)
The 'table__history' is a compelling compendium of data that keeps track of version histories of its base table rows, stemming from the dataset collection 'tilastointialueet_maakunta1000k_2022'. This history table provides a detailed temporal account of changes in the data, making it a valuable resource for trend analysis and change detection over time.
The core of the table is the information related to the Finnish provinces or 'Maakunnat' as of 2022, as described by the data source. The data contained within provides a geospatial overview of these provinces, with each row representing a unique province.
The table consists of several columns which encapsulate various aspects of the data. A unique combination of '_start_date' and '_row_number' identifies each row in the table, adding a layer of specificity. The column '_start_date' indicates the date when a particular row was extracted from the source, while '_end_date' signifies when a new version of this row was extracted. A null value in the '_end_date' column implies that the version of the row is the most recent.
Geographical data is an integral part of this table, captured by columns with the 'geom_' prefix. These columns present geographical coordinates using the WGS 84 coordinate reference system where axis order is longitude first, followed by latitude. Such geospatial data can be utilized in a myriad of ways, including geospatial analytics, mapping, and regional studies.
The table also contains information about the Finnish provinces in multiple languages, providing a multilingual perspective of the data. This includes the Finnish names ('nimi'), Swedish names ('namn'), and the English names ('name') of the provinces.
The 'table__history' was sourced from 'Tilastokeskus' (Statistics Finland) website.
The 'table__history' is a comprehensive resource that can be utilized in various ways. For instance, historical changes in the geographical boundaries of Finnish provinces can be studied by analyzing the version history. Furthermore, the multilingual data can be used to create bilingual or trilingual maps or geographical studies focusing on Finland. Also, the geospatial data can be used in geospatial analytics to understand spatial patterns and trends over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source, playing a crucial role in uniquely identifying each row in combination with '_row_number' in this version history table. For instance, a date could be '2024-11-11'. |
| _end_date | date | 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. For example, it could be 'None' indicating the row is the current version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table. |
| geom_geojson | string | Contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | Contains geometric data in plain text format, which can be used for various geographic data operations. |
| geom_type | string | Indicates the type of the geometric data. For example, it could be 'ST_POLYGON' which represents a polygon shape. |
| geom_centroid | string | Contains the geographical point that represents the centroid of the geometric data. |
| geom_center_x | double | Contains the x-coordinate of the center point of the geometric data. |
| geom_center_y | double | Contains the y-coordinate of the center point of the geometric data. |
| gml_id | string | The identifier of geographic markup language data, a string type data that uniquely represents each geographic entity. For instance, it could be in the format 'maakunta1000k_2022.x'. |
| maakunta | string | Represents the region in Finland as a string. For instance, it could be an identifier like '10', '11', etc. |
| name | string | The English name of the region. For example, it could be 'South Savo', 'North Savo', etc. |
| namn | string | The name of the region in Swedish. For instance, it could be 'Södra Savolax', 'Norra Savolax', etc. |
| nimi | string | The name of the region in Finnish. For example, it could be 'Etelä-Savo', 'Pohjois-Savo', etc. |
| vuosi | long | The year when the data was recorded as an integer. For instance, it could be '2022'. |
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 | a6c7bb0f-5509-4865-89e7-e23f39ecc204 |
| Package id | 16ffc11f-0037-4288-8dd3-ea18af39e16b |
| Position | 1 |
| Revision id | ee1f313e-ea5a-4e18-8ac6-3aaca31ec05b |
| State | active |
| Table | tilastointialueet_maakunta1000k_2022__table__history |