Statistical Regions Municipality 1000K 2018

The dataset collection is a compilation of related data tables sourced from the Statistics Finland (Tilastokeskus) website in Finland. It encompasses a significant amount of information, arranged in a structured manner through multiple tables. Each table is a well-organized compilation of data, characterized by rows and columns that enable a clear understanding and analysis of the information. The data provided by this collection is related to the service interface (WFS) of the Statistics Finland. It's a valuable resource for anyone seeking comprehensive statistical data from Finland. 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 (1:1 000 000) Data TableTSV
The table, sourced from the 'Tilastokeskus' website based in Finland, presents a detailed dataset on the municipalities as of 2018. The data includes diverse types of information, from unique extraction dates and row numbers to geographical data and specific details about each municipality. For instance, the table houses data regarding the geographical layout of the municipalities represented in geojson and geotext formats; it also includes the geographical center points and the type of geographical shape of each municipality. These geographical coordinates are presented using the WGS 84 coordinate reference system, signifying the order of longitude first, followed by latitude. The table further details unique identifiers and names of the municipalities in different languages, and the...
Version History of Municipalities 2018 (1:1 000 000) TableTSV
The 'table__history' is a version history table that forms part of the 'tilastointialueet_kunta1000k_2018' dataset collection. This table is a record of municipalities in 2018 at a 1:1 000 000 scale, sourced from the Statistics Finland (Tilastokeskus) website. It consists of various attributes of the municipalities such as the name of the municipality in different languages and a unique identifier. It also includes geographic information which can be used for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. A unique aspect of this table is that it contains a version history of its base table rows. This is achieved through additional columns '_start_date' and...

Column Descriptions

Municipalities 2018 (1:1 000 000) Data Table

Column	Type	Comment
_extract_date	date	This column records the date when the data on the row of the table was extracted from the source. The format of the date is YYYY-MM-DD.
_row_number	long	This column indicates the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
geom_geojson	string	This column stores the geometric data in GeoJSON format, representing the geographical boundaries of the respective area.
geom_geotext	string	This column contains the geographical data in text format. It provides details about the geographical shape of the area.
geom_type	string	This column specifies the type of the geographical data. In this dataset, the geographical data type is 'ST_MULTIPOLYGON', indicating that the geographical data is a set of polygons.
geom_centroid	string	This column contains the centroid of the geographical data. The centroid is the geometric center of the area.
geom_center_x	double	This column records the x-coordinate of the center of the geographical area.
geom_center_y	double	This column records the y-coordinate of the center of the geographical area.
gml_id	string	This string column is a unique identifier for each row in the table.
kunta	string	This string column contains codes representing different municipalities in Finland.
name	string	This string column contains the names of the municipalities in English.
namn	string	This string column contains the names of the municipalities in Swedish, one of the official languages of Finland.
nimi	string	This string column contains the names of the municipalities in Finnish, the other official language of Finland.
vuosi	long	This integer column represents the year for which the data is recorded.

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

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, together with '_row_number', forms a unique identifier for each row in this history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. This column, together with '_start_date', forms a unique identifier for each row in this history table.
geom_geojson	string	The geometric representation of the area in GeoJSON format, which is a format for encoding geographic data structures.
geom_geotext	string	The geometric representation of the area in text format.
geom_type	string	The type of the geometric representation. In this case, it's a MultiPolygon.
geom_centroid	string	The central point of the area's geometric representation.
geom_center_x	double	The X-coordinate of the area's geometric center.
geom_center_y	double	The Y-coordinate of the area's geometric center.
gml_id	string	A unique identifier for each row, as provided by the source 'Tilastokeskus' (Statistics Finland).
kunta	string	A string type data representing the municipality code in Finland.
name	string	The English name of the municipality.
namn	string	The Swedish name of the municipality.
nimi	string	The Finnish name of the municipality.
vuosi	long	An integer type data representing the year of the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024