Regional Statistics Areas - Community Aggregation 2023

The dataset collection under review is a compilation of data tables sourced from 'Tilastokeskus' (Statistics Finland), a reputable statistics provider in Finland. These tables contain a wealth of information obtained from the Statistics Finland's Service Interface (WFS). This information is related and organized in a tabular format consisting of rows and columns for easy understanding and analysis. The dataset collection is designed to provide comprehensive and reliable statistical data targeted towards aiding research and decision-making processes. 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 Units 2023 (1:1 000 000) - Data Table from Finland's Statistical DatabaseTSV
The table is a comprehensive collection of related data, part of the dataset 'tilastointialueet_seutukunta1000k_2023'. It includes data on 'Regions 2023' at a scale of 1:1,000,000, sourced from the 'Tilastokeskus' website in Finland. The data is organized in a way that allows for easy analyses, with each row of data being uniquely identifiable through a combination of the 'extract_date' and '_row_number' columns, indicating the date of data extraction and the corresponding row number respectively. The table provides geographic data which can be utilized for geospatial data analytics. This information is contained in columns starting with 'geom' and is presented using WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. For instance, 'geom_geojson'...
Version History of Regional Units 2023 (1:1 000 000)TSV
The 'table__history' is a rich and diverse dataset, forming part of the 'tilastointialueet_seutukunta1000k_2023' dataset collection, sourced from 'Tilastokeskus' (Statistics Finland). It is a history table containing the version history of the rows from its base table, which is described as 'Seutukunnat 2023' (Regions 2023) on a scale of 1:1 000 000. The table is organized in a way that allows for easy tracking of changes to the base table over time. The content of the table includes various attributes of the regions, such as their names in different languages, identification numbers, and the year of data collection. A unique feature of this table is the inclusion of geographical data, specifically in the 'geom_' columns, which provide valuable geographic information. This information,...

Column Descriptions

Regional Units 2023 (1:1 000 000) - Data Table from Finland's Statistical Database

Column	Type	Comment
_extract_date	date	This column contains the date when the row data was extracted from the data source. It helps in tracking the currency of the data.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date. It, in combination with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains the geographical data of the region in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographical data of the region in text format. It helps in visualizing the region in a geospatial context.
geom_type	string	This column identifies the type of geographical shape or structure (like polygon or multipolygon) of the region represented in 'geom_geojson' and 'geom_geotext'.
geom_centroid	string	This column contains the centroid or the geometric center of the region. It is useful for identifying the central point of the region.
geom_center_x	double	This column contains the X-coordinate of the geometric center of the region. It helps in mapping the region on a geospatial plane.
geom_center_y	double	This column contains the Y-coordinate of the geometric center of the region. It helps in mapping the region on a geospatial plane.
gml_id	string	This column contains a unique identifier for each row in the table. It is used for identifying each record uniquely.
name	string	This column contains the name of the region in English. It helps in identifying the region.
namn	string	This column contains the name of the region in Swedish. It provides a multilingual perspective to the data.
nimi	string	This column contains the name of the region in Finnish. It provides a multilingual perspective to the data.
seutukunta	string	This column contains an identifier for the region. It is used for identifying each region uniquely.
vuosi	long	This column contains the year for which the data is relevant. It helps in understanding the temporal context of the data.

Version History of Regional Units 2023 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' column to identify each row in this history table.
_end_date	date	This column holds 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	This column contains the number of the row in the raw data extracted from the data source. It uniquely identifies each row in combination with the '_start_date' column.
geom_geojson	string	This column contains geometric data in GeoJSON format, which can represent simple geographical features with their non-spatial attributes.
geom_geotext	string	This column holds the geometric data in text format.
geom_type	string	This column specifies the type of the geometric data, for example, multipolygon or polygon.
geom_centroid	string	This column contains the geometric center or centroid of the geographical feature.
geom_center_x	double	This column holds the X-coordinate of the geometric center of the geographical feature.
geom_center_y	double	This column contains the Y-coordinate of the geometric center of the geographical feature.
gml_id	string	This column stores the unique identifier of the geographical feature.
name	string	This column holds the name of the geographical feature.
namn	string	This column contains the name of the geographical feature, possibly in a different language or format.
nimi	string	This column has the name of the geographical feature in another language or format.
seutukunta	string	This column contains a unique identifier related to the geographical feature.
vuosi	long	This column holds the year related to the data entry.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024