Statistics Bureau Service Interface (WFS) Dataset Collection for Statistical Areas

The dataset collection in question consists of a range of data tables, all of which are interconnected. These tables contain intricate data, diligently compiled from the service interface of the Statistics Centre, also known in Finnish as 'Tilastokeskus'. This data is sourced directly from Finland. The dataset is comprehensive, providing a wide scope of statistical areas and greater regions, making it an invaluable resource for those seeking detailed demographic and regional data. The year 2023 is specifically highlighted in this collection, indicating the data's relevance to that particular year. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Large Areas Forecast for 2023 at 1:4 500 000 ScaleTSV
The table, part of the dataset collection 'tilastointialueet_suuralue4500k_2023', contains data referring to the 'Large Areas 2023 (1:4 500 000)' in Finland. The data is sourced from the 'Tilastokeskus' (Statistics Finland) website. The data fields include geographical information, such as the type of geographical shape (multipolygon, for example), the centroid of the shape, and the center's x and y coordinates. This geographic information, provided in the WGS 84 coordinate reference system, is useful for geospatial data analytics, including the creation of geographic visualizations or the analysis of spatial patterns and relationships. In addition to geographical data, the table includes descriptive identifiers and attributes such as 'name', 'namn', 'nimi', and 'suuralue', which...
Version History of Major Areas 2023 (Scale 1:4 500 000)TSV
The 'table__history' is a comprehensive collection of version history data derived from the 'tilastointialueet_suuralue4500k_2023' data collection. The table is classified as a history table, storing various versions of its base table rows. The data content of this table revolves around the 'Large Areas 2023' (Suuralueet 2023) at a scale of 1:4 500 000, sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. The table holds various columns providing diverse information. It includes columns that store the number of the row in raw data and the dates when the row was extracted and updated. These columns, namely '_row_number' and '_start_date', together form a unique identifier for each row in this history table. The '_end_date' column indicates when a new version of the...

Column Descriptions

Large Areas Forecast for 2023 at 1:4 500 000 Scale

Column	Type	Comment
_extract_date	date	This column records the date when the specific row of data was extracted from the source. This allows for historical tracking of changes in the data set.
_row_number	long	This column lists the row number of the extracted data from the source. This, combined with the '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains GeoJSON formatted geographical data, representing the shape of the large areas in a multi-polygon format.
geom_geotext	string	This column features geographical data in a text-based format, specifically representing multi-polygon shapes.
geom_type	string	This column specifies the type of the geometric data stored, in this case, multi-polygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid (geometric center) of the large areas.
geom_center_x	double	This column contains the X-coordinate (longitude) of the geometric center of the large areas.
geom_center_y	double	This column contains the Y-coordinate (latitude) of the geometric center of the large areas.
gml_id	string	A unique identifier for each large area.
name	string	The English name for each large area.
namn	string	The name of each large area in Swedish.
nimi	string	The name of each large area in Finnish.
suuralue	string	A numeric identifier for each large area.
vuosi	long	The year the data pertains to.

Version History of Major Areas 2023 (Scale 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 starts from 2024-11-11.
_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. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geographical data in GeoJSON format, which represents multiple geographical shapes.
geom_geotext	string	This column contains the geographical data in text format, representing multiple geographical shapes.
geom_type	string	This column specifies the type of the geographical data. In this case, it is 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid of the geographical data, represented as a point with X and Y coordinates.
geom_center_x	double	This column contains the X-coordinate of the center of the geographical data.
geom_center_y	double	This column contains the Y-coordinate of the center of the geographical data.
gml_id	string	This column contains a unique identifier for each row in the table.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
suuralue	string	This column is a string type that contains a unique identifier for the large area.
vuosi	long	This column is an integer type that contains the year of the data. For example, 2023.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024