Statistics Area and Municipal Boundary Data Collection 2018

The dataset collection, sourced from the Statistics Centre (Tilastokeskus) website in Finland, holds a suite of related data tables. These tables are organized in a format that presents data in rows and columns, allowing for easy comprehension of the data's relational aspects. The dataset's primary content is derived from the Statistics Centre's service interface (WFS), indicating that the data within the tables may be statistics-focused, possibly pertaining to diverse sectors such as demographics, economics, or other areas of societal interest. Each table within the collection is interconnected, either directly or indirectly, providing a comprehensive and integrated view of the data landscape covered in the dataset. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Municipalities 2018 (Scale 1:4,500,000)TSV
The table under consideration is a part of an extensive dataset collection, which compiles related tables. This particular table focuses on the 'Municipalities 2018' data, offering a detailed view at the scale of 1:4 500 000. The table is sourced from the website of 'Tilastokeskus' in Finland. It holds unique geographic information, useful for geospatial data analytics, presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The data covers various aspects, including names of the municipalities in different languages, the year the data corresponds to, and unique identifiers for municipalities. Special columns such as '_extract_date' and '_row_number' add an extra layer of specificity. The former provides the date when the data on...
Version History of Municipalities 2018 (1:4 500 000) TableTSV
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....

Column Descriptions

Municipalities 2018 (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	This column contains the date on which the data for that particular row was extracted from the source. It plays a crucial role in uniquely identifying each row in combination with the '_row_number' column.
_row_number	long	This column contains the row number of the data extracted from the source on the extract date specified by the '_extract_date' column. It plays a vital role in uniquely identifying each row in combination with the '_extract_date' column.
geom_geojson	string	This column contains the geometric data in GeoJSON format. It provides the geographic representation of the data points.
geom_geotext	string	This column contains the geometric data in text format. It provides a textual representation of the geometric shape.
geom_type	string	This column specifies the type of the geometric shape of the data points. For example, the sample shows 'ST_MULTIPOLYGON' which indicates that the geographic representation is of a type called 'multipolygon'.
geom_centroid	string	This column contains the centroid point of the geometric shape. It can be used to find the center point of the geographic representation.
geom_center_x	double	This column records the X-coordinate of the geographic center point of the geometric shape.
geom_center_y	double	This column represents the Y-coordinate of the geographic center point of the geometric shape.
gml_id	string	This column contains the unique identifier for each row of data. The naming convention seems to include the dataset name and the row number.
kunta	string	This string-type column represents a specific attribute of the data, which could possibly relate to a region or administrative division.
name	string	This string-type column contains the English names of the entities represented in the dataset.
namn	string	This string-type column contains the names of the entities represented in the dataset, possibly in another language.
nimi	string	This column contains the names of the entities represented in the dataset. The language used for these names could be different from the 'name' and 'namn' columns.
vuosi	long	This integer-type column represents the year associated with each row of data. For example, the sample data indicates the year 2018.

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

Column	Type	Comment
_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.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024