Statistics Bureau Interface (WFS) - Data Collection for 2024

This dataset collection consists of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The tables contain data from the Statistical Service Interface (WFS). The tables are arranged in a structured format with columns and rows that allow for easy data analysis and interpretation. The contents of these data tables are closely related, making the dataset collection a comprehensive source of information. The information contained in this dataset collection presents a wealth of valuable data for statistical analysis. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Versioning of Municipalities 2024 - Geometry and Metadata (1:4 500 000 scale)TSV
The 'table__history' is a part of a larger dataset collection, which essentially is a historical repository of municipal data, revealing the progression over time. It includes a detailed version history of its base table rows, meaning it effectively tracks the changes made to the data over time. The uniqueness of each row in this table is guaranteed by a combination of the date of extraction and the row number, signifying the order of the raw data from the source. The table comprises several columns, each serving a unique purpose. Special columns like '_start_date' and '_end_date' indicate when a row was extracted from the data source and when a newer version of the row was pulled, respectively. If the '_end_date' column shows null, it signifies that the row is the most current version....
Municipalities Projection for 2024 (Scale 1:4,500,000)TSV
The table in question is part of a dataset that encapsulates data related to municipalities as projected for the year 2024 at a scale of 1:4,500,000. This data is sourced from 'Tilastokeskus' (Statistics Finland), a reliable data provider in Finland. The table includes a variety of columns carrying distinct types of data. For instance, it features columns that store geographic data. This geospatial data, represented using the WGS 84 coordinate reference system, could be instrumental in conducting geospatial data analytics. It includes aspects such as 'geojson' and 'geotext' data types, the type of the geographic data, and even the centroid and center coordinates of the geometric shape representing a municipality. In addition to this, the table also accommodates information about the...

Column Descriptions

Municipalities Projection for 2024 (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	The date on which the data in the row was extracted from the source. This, in combination with '_row_number', uniquely identifies each row.
_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 is a popular open standard format designed for representing simple geographical features.
geom_geotext	string	The geometric representation of the area in text format.
geom_type	string	The type of geometric shape that represents the area. This could be either a Polygon or MultiPolygon.
geom_centroid	string	The geographical point that represents the centroid of the area.
geom_center_x	double	The X-coordinate of the geographical point that represents the center of the area.
geom_center_y	double	The Y-coordinate of the geographical point that represents the center of the area.
gml_id	string	An identifier for each row that is unique within the dataset.
kunta	string	The code that represents the municipality.
name	string	The name of the municipality in English.
namn	string	The name of the municipality in Swedish.
nimi	string	The name of the municipality in Finnish.
vuosi	long	The year of the data.

Historical Versioning of Municipalities 2024 - Geometry and Metadata (1:4 500 000 scale)

Column	Type	Comment
_start_date	date	The column '_start_date' contains the date when the row was extracted from the data source. This, combined with '_row_number', uniquely identifies each row in the version history table.
_end_date	date	The column '_end_date' contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it signifies that the row is the most recent version.
_row_number	long	The column '_row_number' contains the number of the row in the raw data. This, combined with '_start_date', uniquely identifies each row in the version history table.
geom_geojson	string	The 'geom_geojson' column contains the geometric representation of the region in GeoJSON format.
geom_geotext	string	The 'geom_geotext' column contains the geometric representation of the region in text format.
geom_type	string	The 'geom_type' column specifies the type of the geometry. In this table, the type is 'ST_POLYGON' which represents a polygon.
geom_centroid	string	The 'geom_centroid' column contains the geometric central point (centroid) of the region.
geom_center_x	double	The 'geom_center_x' column contains the x-coordinate of the centroid of the region.
geom_center_y	double	The 'geom_center_y' column contains the y-coordinate of the centroid of the region.
gml_id	string	The 'gml_id' column contains a unique identifier for each row.
kunta	string	The 'kunta' column contains a code representing a municipality.
name	string	The 'name' column contains the name of the municipality in English.
namn	string	The 'namn' column contains the name of the municipality in Swedish.
nimi	string	The 'nimi' column contains the name of the municipality in Finnish.
vuosi	long	The 'vuosi' column contains the year related to the data. In this table, the data is for the year 2024.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024