History of Regions 2014: Version History of Base Table Rows
The 'table__history' is a rich source of geospatial data, offering a version history of its base table rows. Sourced from the 'Tilastokeskus' (Statistics Finland) website, it covers an array of geographic and demographic data related to the Finnish provinces as of 2014. The table includes geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, which can be utilized for geospatial data analytics.
Notably, the table features columns for the start and end dates of data extraction from the source, providing insights into the evolution of data over time. It also includes a unique row number for each data entry, which together with the start date, provides a unique identification for each row in this version history table.
The geographic data in the table includes information on the type, centroid, center x and y coordinates, and a geojson representation of the provinces. Other valuable data includes the provinces' names in Finnish and Swedish languages, and a unique identifier for each province.
In terms of data analytics, this table can prove instrumental in studying temporal changes in the geographic data of Finnish provinces, enabling analysts to track shifts in boundaries or center coordinates over time. Additionally, the multilingual province names can support multilingual data analysis or localization efforts. Lastly, the unique identifiers can be used to cross-reference this data with other datasets for more comprehensive analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. Along with the '_row_number', it forms a unique identifier for each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. This column forms a unique combination with '_start_date' to identify each row in the version history table. |
| geom_geojson | string | Contains geometric data in GeoJSON format, representing geographic features. |
| geom_geotext | string | Contains geometric data as text, representing geographic features. |
| geom_type | string | Specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | Contains the central point of the geometric features represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | The X-coordinate of the central point of the geometric features. |
| geom_center_y | double | The Y-coordinate of the central point of the geometric features. |
| gml_id | string | A unique identifier for each row in the base table. |
| maakunta | string | Contains data related to the region. |
| name | string | The English name of the region. |
| namn | string | The Swedish name of the region. |
| nimi | string | The Finnish name of the region. |
| vuosi | long | The year for which the data of the row is relevant. |
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 | 647278bf-3aa2-44e9-af0e-3e2ba3777483 |
| Package id | 26b736d5-1838-4b9e-97e3-14afc409368a |
| Position | 1 |
| Revision id | 876ae8e1-8b98-4ba2-a78f-41cf846efe45 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2014__table__history |