Statistics Bureau Service Interface (WFS) Dataset Collection 2024

The dataset collection in question comprises of a series of related data tables, which are gathered from the website of Tilastokeskus (Statistics Finland) based in Finland. These tables are interconnected and organized meticulously into columns and rows, making the data accessible and easy to comprehend. The data within these tables primarily come from the service interface of the Finnish Statistics Bureau, which is known as the 'Tilastokeskuksen palvelurajapinta (WFS)'. This dataset collection offers valuable statistical data that could serve a variety of purposes, including research, planning, decision-making, and more. 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 2024 Dataset: Geographic and Demographic Details (1:4 500 000 scale)TSV
The table in focus is a constituent of a dataset collection, comprising related data tables. This table, specifically, holds an array of data related to 'Regions 2024' at a scale of 1:4,500,000, sourced from the Finnish statistical agency 'Tilastokeskus'. The data represents a detailed geographical and statistical outlook of various regions, with the scope of this data spanning to the year 2024. The table includes columns that store the date of data extraction and the row number from the original data source, providing a unique identifier for each row of data. The table incorporates a rich set of geographical data, with several columns storing geospatial information. This information can be leveraged for geospatial data analytics, exploring geographical patterns and trends. The data...
Version History of Regions 2024 (1:4 500 000)TSV
The table 'table__history' is a rich compilation of version history data from its base table, interspersed with geospatial attributes. The base table presents data on provinces of Finland as projected for the year 2024. The data in the table is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish government agency. The table records include several key attributes such as the date of data extraction, the unique row number, and geospatial data. The date of data extraction is split into two columns, indicating the start and end date of each table row's life cycle. When a row ends with no designated end date, it signifies that the row represents the most recent version of the data. The table also incorporates geographic information in columns beginning with 'geom_', where the...

Column Descriptions

Provinces 2024 Dataset: Geographic and Demographic Details (1:4 500 000 scale)

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source. It plays a critical role in uniquely identifying each row in combination with '_row_number'.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in combination with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains the geometric representation of the area in GeoJSON format. This is a standard format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric information in text format. It provides a human-readable representation of the geographic data.
geom_type	string	This column specifies the type of the geometric information stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a polygon or a multipolygon.
geom_centroid	string	This column contains the geometric center, or centroid, of the area represented by the geometric information in the row. The centroid is a single point that defines the geometric center of all points in the object.
geom_center_x	double	This column contains the x-coordinate of the centroid of the area. It is a part of the geometric center information.
geom_center_y	double	This column contains the y-coordinate of the centroid of the area. It is a part of the geometric center information.
gml_id	string	This is a string column which contains a unique identifier for each row.
maakunta	string	This is a string column which contains the name of the region in local language.
name	string	This column contains the name of the region in English.
namn	string	This column contains the name of the region in another local language.
nimi	string	This column contains the name of the region in a different local language.
vuosi	long	This is an integer column which contains the year for which the data was collected.

Version History of Regions 2024 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' that uniquely identifies each row in the version history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version of the row.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. It forms a unique pair with '_start_date' to identify each row in this version history table.
geom_geojson	string	This column contains geometry data in GeoJSON format. The values represent various types of geographical shapes such as polygons and multipolygons.
geom_geotext	string	This column contains textual representation of the geometry data in various formats such as polygons and multipolygons.
geom_type	string	This column indicates the type of the geometry object used to represent the geographical data. It could be either a polygon or a multipolygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the geometry object. The centroid is the geometric center of a shape.
geom_center_x	double	This column contains the x-coordinate of the center of the geometry object.
geom_center_y	double	This column contains the y-coordinate of the center of the geometry object.
gml_id	string	This column contains a unique identifier of the geometry object.
maakunta	string	This column holds the region code. The value corresponds to a specific region in Finland.
name	string	This column contains the English name of the region represented by the 'maakunta' code.
namn	string	This column holds the Swedish name of the region represented by the 'maakunta' code.
nimi	string	This column contains the Finnish name of the region represented by the 'maakunta' code.
vuosi	long	This column contains the year associated with the data row. It indicates the year of the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024