Historical Version Records of Municipalities 2024 (1:1 000 000)
The 'table__history' is a history table that contains the version history of its base table rows. The table is a part of a dataset collection that focuses on the municipalities of Finland in 2024 at a scale of 1:1 000 000. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland). The data in the table is organized in rows and columns, with each row representing a unique version of a municipality and each column representing a specific attribute or characteristic of that municipality.
The table includes columns for geographic information, which can be utilized for geospatial data analytics. These columns contain data in GeoJSON format, text format, type of the geographic feature, centroid of the feature, and x and y coordinates of the feature's center. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
In addition to geographic information, the table contains columns that provide information about the municipality, including its name in different languages and its unique identifier. The table also contains a column that records the year of the data, which is particularly useful for tracking changes and trends over time.
Two special columns in the table are '_start_date' and '_end_date', which contain the dates when the row was extracted from the data source and when a new version of the row was extracted, respectively. If the '_end_date' is null, it means that the row is the most recent version. Together with the '_row_number' column, which contains the number of the row in the raw data, these columns form a combination that uniquely identifies each row in this version history table.
The data in the table could be utilized in various ways in data analytics. For example, the geographic information could be used to analyze spatial patterns and trends among municipalities, or to visualize municipal boundaries over time. The version history data could be used to track changes in municipal boundaries or names over time. Additionally, the municipal information could be used to enrich other datasets or to link with other data sources for more comprehensive analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column holds the date when the row was extracted from the data source, it acts as a timestamp for when the version of the row was created. Together with '_row_number', it uniquely identifies each row in this history table. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source, effectively indicating the end of the validity period for the current row version. If the value of the column is null, it means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data. This, in combination with '_start_date', uniquely identifies each row in the history table. |
| geom_geojson | string | This column holds geospatial data in GeoJSON format, which is a format for encoding a variety of geographic data structures. The values in this column represent different geometric shapes. |
| geom_geotext | string | This column contains geospatial data in Geotext format. The data represents different geometric shapes such as polygons and multipolygons. |
| geom_type | string | This column specifies the type of geometric shape represented in the 'geom_geojson' and 'geom_geotext' columns. It can be a multipolygon or a polygon. |
| geom_centroid | string | This column contains the centroid point of the geometric shape. It is a point in 2D space, represented in the Point format. |
| geom_center_x | double | This column represents the X coordinate of the geometric shape's center point. |
| geom_center_y | double | This column represents the Y coordinate of the geometric shape's center point. |
| gml_id | string | This column contains the unique identifier of the row in String format. The identifier is based on the year and the row number in the original data source. |
| kunta | string | This column contains a unique code associated with each municipality. |
| name | string | This column contains the name of the municipality in Finnish. |
| namn | string | This column holds the Swedish name of the municipality. |
| nimi | string | This column holds the Finnish name of the municipality. |
| vuosi | long | This column contains the year associated with the data. It is of Integer data type. |
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 | 859f005d-c4db-457e-b39d-a3cb323d62e5 |
| Package id | 4704ec8a-a1c4-49e4-a6ed-59cc0359adbe |
| Position | 1 |
| Revision id | d2f70030-8788-4132-9e1c-484281844e42 |
| State | active |
| Table | tilastointialueet_kunta1000k_2024__table__history |