Statistics Finland Service Interface (WFS) - Regional Dataset Collection 2023

The dataset collection under review comprises a series of data tables that share a common theme, sourced from the Statistics Finland (Tilastokeskus) website. These tables contain data extracted through the Statistics Finland's service interface (WFS). The data contained within these tables is organized in rows and columns to facilitate easy analysis and interpretation. The dataset collection provides valuable insights and is an essential resource for those requiring detailed statistical data. The data provided by this collection has been curated and compiled with the utmost attention to detail and accuracy. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regional Administrative Units 2023 Version History (1:4 500 000)TSV
The 'table__history' is a comprehensive historical archive that forms part of a larger dataset known as 'tilastointialueet_maakunta4500k_2023'. This historical compilation serves as a version history for its base table rows, tracking changes and updates made over time. The information contained within this table provides insight into the regions of Finland as projected for the year 2023. This is denoted by the 'name' column which specifies the names of various regions such as 'Kanta-Häme', 'Central Finland', 'South Karelia', 'Satakunta', 'North Ostrobothnia' and more. The table also provides alternative names for these regions in the 'namn' and 'nimi' columns to cater for different languages and dialects. In addition to regional information, the table also contains geographical data in...
Regions Projection 2023 (Scale: 1:4,500,000)TSV
The table under discussion is an integral part of a larger dataset collection, which focuses on the geographical divisions of Finland in 2023. The data in the table is sourced from the Finnish statistical authority, 'Tilastokeskus' (Statistics Finland). The table contains several columns that store detailed geographical information valuable for geospatial data analytics. For instance, the table includes columns containing geographic information in both GeoJSON and GeoText formats, as well as columns indicating the type of geographical shape and their centroids. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. Other columns in the table contain unique identifiers, region codes, and...

Column Descriptions

Regions Projection 2023 (Scale: 1:4,500,000)

Column	Type	Comment
_extract_date	date	This column represents the date when the data was extracted from the data source. It helps in tracking the freshness of the data.
_row_number	long	This column indicates the row number of the data as extracted from the source on the extract date. This, in combination with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column holds the geometrical data in GeoJSON format. The data represents the geographical boundaries of the regions.
geom_geotext	string	This column contains geometrical data in text format. Just like 'geom_geojson', it represents the geographical boundaries of the regions, but in a different format.
geom_type	string	This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a multipolygon or a polygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the region. The centroid is the geometric center of a region.
geom_center_x	double	This column contains the x-coordinate (longitude) of the centroid of the region.
geom_center_y	double	This column contains the y-coordinate (latitude) of the centroid of the region.
gml_id	string	This column represents a unique identifier for each region in the dataset.
maakunta	string	This column holds codes representing different regions.
name	string	This column contains the English names of the regions.
namn	string	This column holds the names of the regions in Swedish.
nimi	string	This column stores the names of the regions in Finnish.
vuosi	long	This column indicates the year to which the data belongs.

Regional Administrative Units 2023 Version History (1:4 500 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the source. For example, a row may have been extracted on November 11, 2024.
_end_date	date	This column contains the date when a new version of the row was extracted from the source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	This column contains the number of the row as it was in the raw data extracted from the source. This number, in combination with the '_start_date', uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geographical data of the regions in GeoJSON format. The data could represent different types of geographical features, such as polygons or multipolygons.
geom_geotext	string	This column contains the geographical data of the regions in plain text format. The data could represent different types of geographical features, such as polygons or multipolygons.
geom_type	string	This column indicates the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. The types could be 'Polygon' or 'MultiPolygon'.
geom_centroid	string	This column contains the geographical coordinates of the centroid, or geometric center, of the region represented in the row.
geom_center_x	double	This column contains the X-coordinate (longitude) of the geometric center of the region.
geom_center_y	double	This column contains the Y-coordinate (latitude) of the geometric center of the region.
gml_id	string	This column contains a unique identifier for each row. For example, the ID 'maakunta4500k_2023.4' identifies one specific row.
maakunta	string	This column contains codes representing different regions or provinces in Finland.
name	string	This column contains the name of the region or province in English.
namn	string	This column contains the name of the region or province in Swedish.
nimi	string	This column contains the name of the region or province in Finnish.
vuosi	long	This column contains the year that the data represents, for example, the year 2023.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024