Version History of Municipalities 2018 (1:4 500 000) Table
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_date | date | This 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_date | date | This 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_number | long | This 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_geojson | string | This column contains the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains the geographic data in text format, specifically in the form of multipolygon data. |
geom_type | string | This column specifies the type of the geographic data, which is 'ST_MULTIPOLYGON', indicating that the data is a collection of multiple polygons. |
geom_centroid | string | This column contains the geographic centroid of the multipolygon, which is the geometric center of all the points in the shape. |
geom_center_x | double | This column contains the 'x' coordinate of the geometric center of the multipolygon. |
geom_center_y | double | This column contains the 'y' coordinate of the geometric center of the multipolygon. |
gml_id | string | This column contains the unique identifier of each row in the original data source. |
kunta | string | This column contains string type data, likely referring to a specific municipality or region. |
name | string | This column contains a name, likely referring to the name of a specific municipality or region. |
namn | string | This column contains a name, likely referring to the name of a specific municipality or region in a different language. |
nimi | string | This column contains a name, likely referring to the name of a specific municipality or region in a different language. |
vuosi | long | This 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 | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | 3dd2caa8-dca5-4185-ae3f-99ca0abdecc2 |
Package id | 812721d2-1636-47bb-9a91-d02cfd9050a5 |
Position | 1 |
Revision id | d89d073b-7824-4e74-a83a-fb1fb44b79ae |
State | active |
Table | tilastointialueet_kunta4500k_2018__table__history |