Statistical Regions and Provinces Data Collection 2022

The dataset collection in question is a compendium of related statistical tables sourced from the 'Tilastokeskus' website in Finland. These tables contain a variety of information that has been neatly organized into rows and columns for easy understanding and interpretation. The data within this collection is of particular interest as it is retrieved via the Statistical Centre's service interface (WFS), indicating a level of accuracy and reliability. The breadth and depth of this dataset collection make it a valuable resource for those interested in comprehensive and detailed 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

Provinces 2022 (Scale 1:1,000,000) - Data TableTSV
The table in discussion belongs to a dataset collection that encapsulates data related to statistical areas in Finland. The table, sourced from the Finnish Statistics Bureau 'Tilastokeskus', provides comprehensive information about the regions in Finland for the year 2022, as indicated by the column 'vuosi'. The regions are represented in both Finnish and Swedish, as seen in the columns 'nimi' and 'namn' respectively, as well as in English in the 'name' column. The 'maakunta' column identifies each region with a unique code. The table also includes a unique identifier for each row, denoted by the 'gml_id' column. The table is rich in geospatial data, with multiple columns dedicated to geographic information. These include 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid',...
Provinces 2022 Version History (1:1 000 000)TSV
The 'table__history' is a compelling compendium of data that keeps track of version histories of its base table rows, stemming from the dataset collection 'tilastointialueet_maakunta1000k_2022'. This history table provides a detailed temporal account of changes in the data, making it a valuable resource for trend analysis and change detection over time. The core of the table is the information related to the Finnish provinces or 'Maakunnat' as of 2022, as described by the data source. The data contained within provides a geospatial overview of these provinces, with each row representing a unique province. The table consists of several columns which encapsulate various aspects of the data. A unique combination of '_start_date' and '_row_number' identifies each row in the table, adding a...

Column Descriptions

Provinces 2022 (Scale 1:1,000,000) - Data Table

Column	Type	Comment
_extract_date	date	The date when the data row was extracted from the data source. Helps in tracking the timeliness of the data.
_row_number	long	The row number in the data extracted from the source on the specified extract date. Along with '_extract_date', it uniquely identifies each row.
geom_geojson	string	Contains geojson data specifying geographical shapes and features. The data is in the form of polygons and multipolygons.
geom_geotext	string	Geographic data represented in text format. Contains same data as 'geom_geojson' but in a different format.
geom_type	string	Specifies the geometric type of the data. It can be a polygon or a multipolygon.
geom_centroid	string	Provides the central point of the geographic feature represented in the 'geom_geojson' or 'geom_geotext' columns.
geom_center_x	double	The X-coordinate of the center of the geographical feature.
geom_center_y	double	The Y-coordinate of the center of the geographical feature.
gml_id	string	A unique identifier for each geographic feature in the dataset.
maakunta	string	Represents the region code in the dataset. Each code corresponds to a specific region in Finland.
name	string	The name of the region in English language.
namn	string	The name of the region in Swedish language.
nimi	string	The name of the region in Finnish language.
vuosi	long	The year related to the provided data. All the data in this table is for the year 2022.

Provinces 2022 Version History (1:1 000 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, playing a crucial role in uniquely identifying each row in combination with '_row_number' in this version history table. For instance, a date could be '2024-11-11'.
_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. For example, it could be 'None' indicating the row is the current version.
_row_number	long	The number of the row in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table.
geom_geojson	string	Contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	Contains geometric data in plain text format, which can be used for various geographic data operations.
geom_type	string	Indicates the type of the geometric data. For example, it could be 'ST_POLYGON' which represents a polygon shape.
geom_centroid	string	Contains the geographical point that represents the centroid of the geometric data.
geom_center_x	double	Contains the x-coordinate of the center point of the geometric data.
geom_center_y	double	Contains the y-coordinate of the center point of the geometric data.
gml_id	string	The identifier of geographic markup language data, a string type data that uniquely represents each geographic entity. For instance, it could be in the format 'maakunta1000k_2022.x'.
maakunta	string	Represents the region in Finland as a string. For instance, it could be an identifier like '10', '11', etc.
name	string	The English name of the region. For example, it could be 'South Savo', 'North Savo', etc.
namn	string	The name of the region in Swedish. For instance, it could be 'Södra Savolax', 'Norra Savolax', etc.
nimi	string	The name of the region in Finnish. For example, it could be 'Etelä-Savo', 'Pohjois-Savo', etc.
vuosi	long	The year when the data was recorded as an integer. For instance, it could be '2022'.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024