Version History of Municipalities 2018 (1:4 500 000) Table

To download the data set, please sign up or log in

Click here for a data sample

The 'table__history' is a version history table which belongs to the 'tilastointialueet_kunta4500k_2018' dataset collection. The table contains the version history of its base table rows, thus allowing users to track changes over time.

The data content of this table is rich and diverse. It includes geographic information useful for geospatial data analytics. This geographic information is represented in several columns, each providing a unique perspective. For instance, some columns provide geographic coordinates based on the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This data can be used, for example, to analyze spatial patterns or trends over time.

Moreover, the table includes specific columns that store the version history of each row. These special columns help to identify when data was extracted and when new versions were created. For example, one column contains the date when the row was extracted, while another indicates when a new version of the row was extracted. If the latter column contains a null value, it signals that the row is the most recent version.

This table also contains information about municipalities, as indicated by the base table content description 'Kunnat 2018 (1:4 500 000)', which translates to 'Municipalities 2018 (1:4 500 000)'. This data can be useful for demographic analysis, urban planning, or policy-making studies, among other things.

The data in this table is sourced from the 'Tilastokeskus' website, which is the Statistics Finland in the country of Finland. The potential of this rich dataset for various analytical purposes is vast, making it an invaluable tool for data analysts and researchers alike.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when a specific row was extracted from the source data. It is part of a unique identifier for each record in this table.
_end_datedateThis column contains the date when a new version of the row was extracted from the source data. If the value is null, it signifies that the row is the most recent version.
_row_numberlongThis column contains the number of the row as it appears in the raw data from the source. It forms part of a unique identifier for each row in this table when combined with the '_start_date' column.
geom_geojsonstringThis column contains the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotextstringThis column contains the geographic data in text format, specifically in the form of multipolygon data.
geom_typestringThis column specifies the type of the geographic data, which is 'ST_MULTIPOLYGON', indicating that the data is a collection of multiple polygons.
geom_centroidstringThis column contains the geographic centroid of the multipolygon, which is the geometric center of all the points in the shape.
geom_center_xdoubleThis column contains the 'x' coordinate of the geometric center of the multipolygon.
geom_center_ydoubleThis column contains the 'y' coordinate of the geometric center of the multipolygon.
gml_idstringThis column contains the unique identifier of each row in the original data source.
kuntastringThis column contains string type data, likely referring to a specific municipality or region.
namestringThis column contains a name, likely referring to the name of a specific municipality or region.
namnstringThis column contains a name, likely referring to the name of a specific municipality or region in a different language.
nimistringThis column contains a name, likely referring to the name of a specific municipality or region in a different language.
vuosilongThis column contains integer data, likely referring to a specific year.

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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id3dd2caa8-dca5-4185-ae3f-99ca0abdecc2
Package id812721d2-1636-47bb-9a91-d02cfd9050a5
Position1
Revision idd89d073b-7824-4e74-a83a-fb1fb44b79ae
Stateactive
Tabletilastointialueet_kunta4500k_2018__table__history