Version History of Regional Units 2023 (1:1 000 000)
The 'table__history' is a rich and diverse dataset, forming part of the 'tilastointialueet_seutukunta1000k_2023' dataset collection, sourced from 'Tilastokeskus' (Statistics Finland). It is a history table containing the version history of the rows from its base table, which is described as 'Seutukunnat 2023' (Regions 2023) on a scale of 1:1 000 000. The table is organized in a way that allows for easy tracking of changes to the base table over time.
The content of the table includes various attributes of the regions, such as their names in different languages, identification numbers, and the year of data collection. A unique feature of this table is the inclusion of geographical data, specifically in the 'geom_' columns, which provide valuable geographic information. This information, presented using the WGS 84 coordinate reference system, can be utilized for geospatial data analytics.
The table also has special columns like '_start_date', '_end_date', and '_row_number'. The '_start_date' and '_row_number' together uniquely identify each row in this version history table. The '_start_date' refers to the date when the row was extracted from the data source, while the '_end_date' signals when a new version of the row was extracted. If '_end_date' is null, it means that the row is the most recent version.
This table is a valuable resource for data analysts. For instance, the geospatial data can be used to map changes in regional boundaries over time or analyze spatial patterns and trends. The version history can be used to track changes and updates made to the regions' data over time, providing insights into how the regions have evolved. The combination of geographical and historical data makes this table a great tool for multidimensional analysis in various domains, including urban planning, environmental studies, and social sciences.
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 combination with the '_row_number' column to identify each row in this history table. |
| _end_date | date | This column holds the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It uniquely identifies each row in combination with the '_start_date' column. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which can represent simple geographical features with their non-spatial attributes. |
| geom_geotext | string | This column holds the geometric data in text format. |
| geom_type | string | This column specifies the type of the geometric data, for example, multipolygon or polygon. |
| geom_centroid | string | This column contains the geometric center or centroid of the geographical feature. |
| geom_center_x | double | This column holds the X-coordinate of the geometric center of the geographical feature. |
| geom_center_y | double | This column contains the Y-coordinate of the geometric center of the geographical feature. |
| gml_id | string | This column stores the unique identifier of the geographical feature. |
| name | string | This column holds the name of the geographical feature. |
| namn | string | This column contains the name of the geographical feature, possibly in a different language or format. |
| nimi | string | This column has the name of the geographical feature in another language or format. |
| seutukunta | string | This column contains a unique identifier related to the geographical feature. |
| vuosi | long | This column holds the year related to the data entry. |
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 | 75cc1bb9-02ee-4681-b5ed-f0321468d924 |
| Package id | 50d486c9-1d68-47b1-bfe2-54dc6cafd363 |
| Position | 1 |
| Revision id | c389efe7-f4af-4c2e-8ed1-ebc3b91b19cf |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2023__table__history |