Historical Versioning of Municipalities 2024 - Geometry and Metadata (1:4 500 000 scale)
The 'table__history' is a part of a larger dataset collection, which essentially is a historical repository of municipal data, revealing the progression over time. It includes a detailed version history of its base table rows, meaning it effectively tracks the changes made to the data over time. The uniqueness of each row in this table is guaranteed by a combination of the date of extraction and the row number, signifying the order of the raw data from the source.
The table comprises several columns, each serving a unique purpose. Special columns like '_start_date' and '_end_date' indicate when a row was extracted from the data source and when a newer version of the row was pulled, respectively. If the '_end_date' column shows null, it signifies that the row is the most current version.
Geographic data forms a significant portion of the table, as indicated by the columns starting with 'geom_'. These columns hold various forms of geographic information that can be leveraged for geospatial data analytics, with the geographic coordinates using the WGS 84 coordinate reference system, presenting longitude first, followed by latitude. This data can be represented in various formats, such as GeoJSON and GeoText, and can include polygons, centroids, and center coordinates.
Other columns hold specific information about municipalities, including unique identifiers and names in various languages. This data offers a snapshot of municipalities in the year 2024, as per the data source, the Finnish Statistics Bureau (Tilastokeskus).
In terms of data analytics, this table offers immense possibilities. For instance, the historical data could be used to visualize the evolution of municipal boundaries over time. The geospatial data could be used in conjunction with other data to perform spatial analytics, such as identifying patterns or trends linked to geographic location. Furthermore, the multi-lingual municipal names could be used in multilingual studies or to build applications that cater to speakers of different languages.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The column '_start_date' contains the date when the row was extracted from the data source. This, combined with '_row_number', uniquely identifies each row in the version history table. |
| _end_date | date | The column '_end_date' contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it signifies that the row is the most recent version. |
| _row_number | long | The column '_row_number' contains the number of the row in the raw data. This, combined with '_start_date', uniquely identifies each row in the version history table. |
| geom_geojson | string | The 'geom_geojson' column contains the geometric representation of the region in GeoJSON format. |
| geom_geotext | string | The 'geom_geotext' column contains the geometric representation of the region in text format. |
| geom_type | string | The 'geom_type' column specifies the type of the geometry. In this table, the type is 'ST_POLYGON' which represents a polygon. |
| geom_centroid | string | The 'geom_centroid' column contains the geometric central point (centroid) of the region. |
| geom_center_x | double | The 'geom_center_x' column contains the x-coordinate of the centroid of the region. |
| geom_center_y | double | The 'geom_center_y' column contains the y-coordinate of the centroid of the region. |
| gml_id | string | The 'gml_id' column contains a unique identifier for each row. |
| kunta | string | The 'kunta' column contains a code representing a municipality. |
| name | string | The 'name' column contains the name of the municipality in English. |
| namn | string | The 'namn' column contains the name of the municipality in Swedish. |
| nimi | string | The 'nimi' column contains the name of the municipality in Finnish. |
| vuosi | long | The 'vuosi' column contains the year related to the data. In this table, the data is for the year 2024. |
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 | 9ae1646d-4bc5-4d55-9aca-04bbd2dcc869 |
| Package id | eaf10dcc-6a86-45a6-b447-1d5ec57773bd |
| Position | 1 |
| Revision id | 865edbc9-9fc3-4f1e-9e4d-71862d7ece31 |
| State | active |
| Table | tilastointialueet_kunta4500k_2024__table__history |