Statistical Area and Regional Community Data Collection 2022

The dataset collection 'tilastointialueet_seutukunta1000k_2022' is a comprehensive grouping of related data tables sourced from the Statistics Centre (Tilastokeskus) in Finland. The statistics service interface (WFS) has provided the dataset, which is organized into tables for easy accessibility and comprehension. Each table in this collection presents relevant and correlated data, offering a broad perspective and understanding of the dataset's subject matter. The dataset collection is designed in a way that supports detailed analysis, comparison, and interpretation of the data it contains. 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 2022 (1:1 000 000) - Version HistoryTSV
The 'table__history' holds detailed history records of its base table rows, specifically focusing on the regions in Finland as per the 2022 records sourced from the Statistics Finland (Tilastokeskus) website. The table is an integral part of a larger data collection that focuses on regional statistics. The contents of the table are presented in a structured format, catering to different categories of regional data. One of the main features of this table is its ability to track changes over time, thanks to the presence of start and end dates for each data row. This feature makes the table invaluable for temporal data analysis, enabling a deep study into the changes in region data over time. Key elements of the table include geographic data, represented in various formats, including...
Regions 2022 (Scale 1:1 000 000) - Data Table from Finnish Statistical CollectionTSV
The table at hand is an integral part of a larger dataset collection and houses essential data related to 'Seutukunnat 2022' which translates to 'Regional Units 2022'. This information has been sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The table's contents are primarily organized in rows and columns, each offering unique insights. The table contains several columns which present a plethora of information. For instance, some columns provide geographic information that can be utilized for geospatial data analytics. These columns store data in the form of polygons and multipolygons, representing different shapes and areas on a map. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude mentioned first,...

Column Descriptions

Regions 2022 (Scale 1:1 000 000) - Data Table from Finnish Statistical Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the original data source. The format of the date is YYYY-MM-DD.
_row_number	long	This column stores the row number of 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 in the table.
geom_geojson	string	This column contains geographic data in the GeoJSON format. The data can represent different types of geographical shapes such as polygons or multi-polygons.
geom_geotext	string	This column holds the textual representation of the geographic data. The data is represented as polygons or multi-polygons.
geom_type	string	This column specifies the type of the geographic shape that is represented in the 'geom_geojson' and 'geom_geotext' columns. The possible values are 'ST_POLYGON' and 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the geographic coordinate of the centroid of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column holds the x-coordinate of the center of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	This column stores the y-coordinate of the center of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	This column contains a unique identifier for each row, which follows a specific naming pattern.
name	string	This column stores the name of the region.
namn	string	This column contains the name of the region in a different language.
nimi	string	This column holds another variant of the region's name in a different language.
seutukunta	string	This column contains a code that represents the region.
vuosi	long	This column holds the year that the data refers to.

Regional Units 2022 (1:1 000 000) - Version History

Column	Type	Comment
_start_date	date	This column contains the date when the row data was extracted from the source. It is used in combination with '_row_number' to uniquely identify each row in the table.
_end_date	date	This column contains the date when a newer version of the row data was extracted from the source. If the value in this column is null, it signifies that the row is the most recent version.
_row_number	long	This column represents the row number in the raw data extracted from the source. It is used in combination with '_start_date' to uniquely identify each row in the table.
geom_geojson	string	This column contains the geographical data of the region in GeoJSON format. It can be a polygon or multipolygon representing the boundaries of the region.
geom_geotext	string	This column contains the geographical data of the region in a text format. It can be either a polygon or multipolygon.
geom_type	string	This column specifies the type of geographical data stored in 'geom_geojson' and 'geom_geotext' columns. It can be either 'ST_POLYGON' or 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the region. It is in Point format.
geom_center_x	double	This column represents the x-coordinate of the centroid of the region.
geom_center_y	double	This column represents the y-coordinate of the centroid of the region.
gml_id	string	This column contains a unique identifier for each region. It is a string data type.
name	string	This column contains the name of the region. It is a string data type.
namn	string	This column contains another denomination for the region, potentially in a different language. It is a string data type.
nimi	string	This column contains another denomination for the region, potentially in a different language. It is a string data type.
seutukunta	string	This column signifies a specific code for the region. It is a string data type.
vuosi	long	This column represents the year of the data. It is an integer data type.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024