Statistics Interface Collection: Municipal Area Data Tables

The dataset collection is a compilation of related data tables sourced from the Statistics Centre (Tilastokeskus) in Finland. This vast array of data is structured in a clear, table format for easy readability, with each table consisting of related data organized in rows and columns. The tables in this collection provide a wealth of information spanning different years. The data included in this collection is accessed through the Statistics Centre's service interface (WFS), providing a robust and efficient way to manage and utilize this comprehensive collection of statistical data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Versioning of Municipalities (1:1 000 000)TSV
The 'table__history' is a critical component of the dataset collection 'tilastointialueet_kunta1000k'. Sourced from the Statistical Centre's (Tilastokeskus) website in Finland, this table is specifically designed to maintain the version history of its base table rows. The information in the table is organized around municipalities, as indicated by the base table content description: 'Municipalities (1:1 000 000)'. The table comprises multiple columns, each serving a particular purpose in the data structure. For instance, there are columns that contain geographic information, which can be extremely valuable for geospatial data analytics. This could, for example, be used to track changes in municipal boundaries or to conduct spatial analyses related to population distribution. The...
Municipalities Data (1:1 000 000) - Part of Statistical Areas DatasetTSV
The table, which is part of a larger dataset collection, is a comprehensive compilation of Finnish municipalities data. It is sourced from the 'Tilastokeskus' (Statistics Finland) website. The data contained in this table is carefully organized into rows and columns, each with unique and meaningful attributes. The content of the table can be best described as information about Finnish municipalities at a 1:1 000 000 scale. The columns contain various types of data ranging from basic details to geospatial information. For instance, some columns store the extraction date and row number from the data source, uniquely identifying each row. Several other columns contain geographical data that represents the municipalities, which can be utilized for geospatial data analytics. This...

Column Descriptions

Municipalities Data (1:1 000 000) - Part of Statistical Areas Dataset

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	The column contains geographic information of the area in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext	string	The column contains text representation of the geographic information of the area.
geom_type	string	This column specifies the type of the geographic information stored in the row.
geom_centroid	string	The column contains the coordinates of the centroid, or geometric center, of the area.
geom_center_x	double	This column contains the X coordinate of the center of the area.
geom_center_y	double	This column contains the Y coordinate of the center of the area.
gml_id	string	This column contains a unique identifier for each row, corresponding to a specific geographic area.
kunta	string	This column contains a code that represents the municipality of the area.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
vuosi	long	This column contains the year when the data was collected.

Historical Versioning of Municipalities (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value 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 extracted from the data source. In combination with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geographical data of the area in GeoJSON format, a format for encoding geographic data structures.
geom_geotext	string	This column contains the geographical data of the area in textual representation.
geom_type	string	This column specifies the type of the geographical data, which could be either ST_MULTIPOLYGON or ST_POLYGON.
geom_centroid	string	This column contains the central point of the geographical area.
geom_center_x	double	This column contains the X-coordinate (longitude) of the central point of the geographical area.
geom_center_y	double	This column contains the Y-coordinate (latitude) of the central point of the geographical area.
gml_id	string	This column contains a unique identifier for each row in the base table.
kunta	string	This string column contains the municipality code.
name	string	This string column contains the English name of the municipality.
namn	string	This string column contains the Swedish name of the municipality.
nimi	string	This string column contains the Finnish name of the municipality.
vuosi	long	This integer column contains the year the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024