Version History of the Regions 2019 (1:1 000 000) Data Table
The 'table__history' is a rich source of geospatial and temporal data, originating from the Finnish national statistical authority, 'Tilastokeskus' (Statistics Finland). It forms a part of a larger dataset collection that focuses on regional statistical data.
This is a history table, containing the version history of its base table rows. The data it houses is a detailed snapshot of the regions of Finland, known as 'Maakunnat', as they stood in the year 2019. The data is presented in a high-resolution format, making the table suitable for various sophisticated analyses.
Among the various data points, the table provides geographical details of these regions, including their names in multiple languages - Finnish, Swedish, and English. For each region, the table contains a unique identifier, geographic coordinates, and shape information. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This allows for the use of the data in geospatial analytics, for example, in mapping, spatial correlation studies, or environmental analysis.
The table also includes temporal data - specifically, the date when a row was first extracted and, if applicable, the date when a new version of the row was extracted. This allows for time-series analyses, such as tracking changes in regional boundaries or names over time.
Each row in the table has a unique identifier, formed by a combination of the date of extraction and the row number in the raw data. This ensures data integrity and allows for precise tracking and versioning of data.
In terms of potential data analytics applications, this table could be used in studies of regional development, urban planning, environmental impact assessments, or in demographic studies to understand population movement and trends. With the rich geospatial data, it could also be used in the creation of detailed maps, or in spatial data mining to identify patterns or anomalies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the extraction date of each row from the data source, marking the starting point of the row's version in the history table. |
| _end_date | date | This column contains the date when a newer version of the row was extracted from the source. A null value in this column indicates that the current row is the most recent version. |
| _row_number | long | This column represents the row number in the raw data extracted from the source. Together with '_start_date', it forms a unique identifier for each row in this version history table. |
| geom_geojson | string | This column contains the geometric data for the row in GeoJSON format, which is a format for encoding geographic data structures. |
| geom_geotext | string | This column stores the geometric data in a textual format. |
| geom_type | string | This column specifies the type of the geometric data stored in the row, for example, 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column stores the centroid of the geometric data, which is the geometric center of all the points that make up the 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 contains the unique identifier assigned to the row by the data source. |
| maakunta | string | This column contains a numerical representation of the province. |
| name | string | This column contains the English name of the province. |
| namn | string | This column contains the name of the province translated into Swedish. |
| nimi | string | This column includes the Finnish name of the province. |
| vuosi | long | This column records the year associated with the data. |
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 | 2aa1ef67-4fd3-4945-a008-2d8fe3904ac0 |
| Package id | c01ea545-68f5-41c5-9712-4af5233a0c80 |
| Position | 1 |
| Revision id | df902be0-ef80-4b33-bb81-58cd6fc4dd2c |
| State | active |
| Table | tilastointialueet_maakunta1000k_2019__table__history |