Statistics Centre Service Interface (WFS) - Regional Statistics Compilation 2023

This dataset collection comprises a group of interrelated tables sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. Each table is a structured arrangement of data with rows and columns, presenting various statistical areas. The data is extracted from the Statistics Finland's service interface (WFS). The primary purpose of this dataset collection is to provide a comprehensive statistical overview for the year 2023. The richness of the data and its organization into tables makes it a valuable resource for in-depth analysis and research. 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 2023 at 1:1 000 000 scale - Dataset TableTSV
The table is part of a dataset collection that provides detailed geographic and provincial information, specifically related to the provinces in Finland for the year 2023. This granular data is sourced from Tilastokeskus (Statistics Finland), a credible Finnish data source. The table includes a variety of columns that provide different types of data. The columns beginning with 'geom_' provide geographic information, useful for geospatial data analytics. For instance, the 'geom_geojson' and 'geom_geotext' offer geometric data in various formats, while 'geom_type' specifies the type of geographic shape. The 'geom_centroid' gives the geographic center of the geometric shape, and 'geom_center_x' and 'geom_center_y' provide the precise coordinates of this center. It's important to note that...
Version History of Regions 2023 (1:1 000 000) TableTSV
The 'table__history' is a rich compendium of versioned data pertaining to the 'Provinces 2023' (Maakunnat 2023) at a scale of 1:1,000,000. Sourced from the Finnish Statistical Bureau (Tilastokeskus), it provides an in-depth historical record of each data row from its initial extraction till the latest update. The data within the table is beneficial for diverse analyses, including geospatial data analytics, history tracking, and province-specific studies. Each row in the table is uniquely identified through a combination of a start date and a row number, representing the date the data was first extracted, and the sequence of the row in the raw data respectively. An end date signifies if a new version of the row has been extracted. If not, the record is the most recent version. The table...

Column Descriptions

Regions 2023 at 1:1 000 000 scale - Dataset Table

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
geom_geojson	string	The geometric representation of the area in GeoJSON format, which can either be a Polygon or a MultiPolygon.
geom_geotext	string	The geometric representation of the area in textual format.
geom_type	string	The type of the geometric representation of the area, which can either be 'ST_POLYGON' or 'ST_MULTIPOLYGON'.
geom_centroid	string	The point that represents the geometric center of the area.
geom_center_x	double	The x-coordinate of the geometric center of the area.
geom_center_y	double	The y-coordinate of the geometric center of the area.
gml_id	string	The identifier of the area in the GML format.
maakunta	string	The code of the province in the dataset.
name	string	The name of the province in English.
namn	string	The name of the province in Swedish.
nimi	string	The name of the province in Finnish.
vuosi	long	The year of the data.

Version History of Regions 2023 (1:1 000 000) Table

Column	Type	Comment
_start_date	date	Contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column.
_end_date	date	Contains the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	Provides the number of the row in the raw data extracted from the data source. It forms part of the unique identifier for each row in combination with the '_start_date' column.
geom_geojson	string	Contains geometrical data in GeoJSON format, representing the spatial features of the regions.
geom_geotext	string	Provides geometrical data in plain text format, representing the spatial features of the regions.
geom_type	string	Identifies the type of geographical shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns - either a multipolygon or a polygon.
geom_centroid	string	Contains the coordinates of the central point of the geographical shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	Indicates the X-coordinate of the center of the geographical shape.
geom_center_y	double	Indicates the Y-coordinate of the center of the geographical shape.
gml_id	string	A unique identifier for each entry in the table.
maakunta	string	A code representing the region.
name	string	The English name of the region.
namn	string	The region's name in Swedish.
nimi	string	The region's name in Finnish.
vuosi	long	The year in which the data is relevant. This table's data relates to the year 2023.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024