Statistical Areas Regional Database 2022

The dataset collection at hand encompasses a series of related data tables, all of which are sourced from the website of 'Tilastokeskus' (Statistics Finland), based in Finland. The data tables entail an array of interconnected data compiled in a tabular format, consisting of multiple rows and columns. The data source describes the dataset as 'Tilastokeskuksen palvelurajapinta (WFS)', which translates to 'Statistics Finland's service interface (WFS)' in English. The tables within this dataset collection are primarily constructed to facilitate an efficient and comprehensive data analysis process. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regions of Finland 2022 (Scale 1:4 500 000) - Data TableTSV
The table in discussion forms a part of a larger dataset collection and is a structured compilation of related data from Finland. It carries a rich variety of information, mainly revolving around the geographic and administrative divisions known as 'maakunta' for the year 2022 at a scale of 1:4,500,000. The data originates from 'Tilastokeskus' (Statistics Finland), a reputable web source in Finland. Each row in the table corresponds to a unique data extraction, with the extraction date documented for reference. The rows are numbered for easy identification and retrieval, with the combination of extraction date and row number creating a unique identifier for each row. A prominent feature of this table is its geospatial data, with multiple columns dedicated to geographic information that...
Version History of Maakunnat 2022 (Provinces 2022) at 1:4 500 000 ScaleTSV
The 'table__history' is a valuable repository of historical data, part of the 'tilastointialueet_maakunta4500k_2022' dataset group. This table serves as a version history for its base table rows and includes data regarding the administrative regions of Finland, as provided by the Statistics Finland (Tilastokeskus). This history table contains an array of columns offering a wealth of information. For example, the columns beginning with 'geom_' offer geographic data that can be harnessed for geospatial analytics. These columns contain information about the geographic type, centroid, center coordinates, and geographic text and JSON data. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude....

Column Descriptions

Regions of Finland 2022 (Scale 1:4 500 000) - Data Table

Column	Type	Comment
_extract_date	date	This column indicates the date when the data in the row was extracted from the source. It allows for a temporal understanding of when the data was retrieved.
_row_number	long	This column represents the row number in the data extracted from the source. Combined with the '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains the geographic data in GeoJSON format. It represents the spatial structure of the regions.
geom_geotext	string	This column holds the geographic data in text format. It provides an alternative representation of the spatial structures.
geom_type	string	This column specifies the type of geometric representation used for the region. It can be either a 'MULTIPOLYGON' or a 'POLYGON'.
geom_centroid	string	This column contains the coordinates of the geometric center (centroid) of the region.
geom_center_x	double	This column holds the x-coordinate of the region's centroid.
geom_center_y	double	This column holds the y-coordinate of the region's centroid.
gml_id	string	This is an identifier column, which assigns a unique ID to each row. The ID is composed of the dataset name and the row number.
maakunta	string	This column contains a coded representation of the regions in the dataset.
name	string	This column includes the English names of the regions within the dataset.
namn	string	This column holds the names of the regions in Swedish.
nimi	string	This column contains the Finnish names of the regions.
vuosi	long	This column represents the year the data pertains to. In this dataset, it corresponds to the year 2022.

Version History of Maakunnat 2022 (Provinces 2022) at 1:4 500 000 Scale

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. This, in combination with the '_row_number' column, uniquely identifies each row in the history table.
_end_date	date	This column stores 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	This column contains the row number in the raw data extracted from the data source. It is used in conjunction with the '_start_date' to uniquely identify each row in the history table.
geom_geojson	string	This column contains geometric data in GeoJSON format. This data is used to visually represent the spatial characteristics of the data.
geom_geotext	string	This column stores geometric data in text format.
geom_type	string	This column specifies the type of the geometric data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the coordinates for the centroid, or geometric center, of the spatial feature.
geom_center_x	double	This column records the x-coordinate of the geometric center of the spatial feature.
geom_center_y	double	This column records the y-coordinate of the geometric center of the spatial feature.
gml_id	string	This column contains a unique identifier for each row in the table, provided by the data source.
maakunta	string	This column stores string type data and represents a specific attribute of the data source.
name	string	This column stores the English name of the spatial feature.
namn	string	This column stores the name of the spatial feature in the local language.
nimi	string	This column contains the name of the spatial feature in another local language.
vuosi	long	This column is an integer type and represents the year associated with the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024