Statistics Area and Regional Cluster 4500k Projections for 2023

The dataset collection, sourced from the website of 'Tilastokesku' (Statistics Finland) in Finland, is a comprehensive compilation of related data tables. These intricately organized tables consist of related data, systematically arranged in columns and rows format. The dataset is primarily derived from the Statistics Finland's service interface (WFS). This dataset collection incorporates an extensive range of data, making it a valuable resource for individuals or organizations seeking in-depth information related to the specific field of study. 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 Version Records of Regions 2023 (scale 1:4,500,000)TSV
The history table, belonging to 'Seutukunnat 2023' dataset collection, stores critical data that reflects the version history of its base table rows. The table contains a variety of columns that hold valuable data, each with a unique purpose. It is sourced from the website of 'Tilastokeskus' in Finland. The table has columns that contain the date when the row was extracted from the data source and the date when a new version of the row was extracted. If the end date is null, it indicates that the row is the most recent version. Together with the row number, these date columns uniquely identify each row in this version history table. Geographic information is stored in columns that begin with 'geom_'. These columns can be used for geospatial data analytics. The geographic coordinates are...
Sub-regions 2023 Projections (Scale 1:4,500,000) - Data TableTSV
The table, a part of the dataset collection named 'tilastointialueet_seutukunta4500k_2023', is a rich source of geospatial data. It contains crucial information about the regional districts of Finland, as projected for the year 2023. The data is sourced from the Statistics Finland ('Tilastokeskus') website. The table integrates a variety of data types, including dates, numbers, and geospatial data. The geospatial data is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This makes the data particularly useful for geospatial analytics, including mapping and spatial pattern recognition. One of the unique features of the table is the inclusion of two special columns, '_extract_date' and '_row_number'. The '_extract_date'...

Column Descriptions

Sub-regions 2023 Projections (Scale 1:4,500,000) - Data Table

Column	Type	Comment
_extract_date	date	This column indicates the date when the data row was extracted from the data source. It helps to understand when the data was pulled for analysis.
_row_number	long	This column contains the row number in the data extracted from the source. It, in combination with the '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains geometric data in GeoJSON format. It represents the geographical features of the regions.
geom_geotext	string	This column contains geometric data in geotext format. It is another way to represent the geographical layout of the regions.
geom_type	string	This column describes the type of geometric data, which could be either Polygon or MultiPolygon.
geom_centroid	string	This column contains the centroid coordinates of the geometric shape representing the region. It provides the geographical center point of the regions.
geom_center_x	double	This column represents the X-coordinate of the center point of the geographic shape of the region.
geom_center_y	double	This column represents the Y-coordinate of the center point of the geographic shape of the region.
gml_id	string	This column contains a unique identifier for each region as provided by the data source.
name	string	This column contains the name of the region in English.
namn	string	This column includes the name of the region in a local language.
nimi	string	This column includes the name of the region in another local language.
seutukunta	string	This column contains a specific code assigned to each region. This serves as another way to identify the regions.
vuosi	long	This column indicates the year for which the data is relevant. It helps to understand the timeframe of the dataset.

Historical Version Records of Regions 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.
_end_date	date	This column indicates the date when a new version of the row was extracted from the data source. If it is null, it signifies that the row is the most recent version.
_row_number	long	This column represents 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 of the area in GeoJSON format, which can include various types of geographical data structures such as polygons and multipolygons.
geom_geotext	string	This column holds the geographical data of the area in GeoTEXT format, another way of representing polygon and multipolygon structures.
geom_type	string	This column describes the type of geographical data structure used in 'geom_geojson' and 'geom_geotext' columns, such as polygon or multipolygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid, or the center point, of the area.
geom_center_x	double	This column holds the x-coordinate (longitude) of the centroid of the area.
geom_center_y	double	This column contains the y-coordinate (latitude) of the centroid of the area.
gml_id	string	This column contains a unique identifier for each row.
name	string	This column holds the English name of the area.
namn	string	This column contains the area's name in another language.
nimi	string	This column has the area's name in Finnish.
seutukunta	string	This column represents a code pertaining to the area.
vuosi	long	This column contains the year pertaining to the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024