Statistics Center Interface (WFS) - Regional Statistical Data Collection 2020

The dataset collection is a compilation of related data tables sourced from the Statistics Centre (Tilastokeskus) of Finland. The contents of this collection are primarily focused on data in a tabular format, with each table comprising of various rows and columns. This organization of data aids in better understanding and extraction of specific information. The dataset is also characterized by its service interface (WFS), an element that contributes to its overall functionality. The data tables in this collection are interconnected, offering a comprehensive overview of the subject in focus. The dataset collection contains a wealth of information and is an invaluable resource for those seeking in-depth knowledge about specific data in Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Provinces 2020 - Geographical Data and Attributes (Scale 1:4,500,000)TSV
The table under consideration houses data that pertains to the 'Regions 2020 (1:4 500 000)' dataset, which is part of a larger dataset collection sourced from the 'Tilastokeskus' (Statistics Finland) website. This table is a structured arrangement of related data with several columns, each containing unique information. The table's content includes geographic and demographic data about various regions in Finland for the year 2020. One of the notable features of this table is its geospatial data columns, which contain geographic information useful for geospatial data analytics. These 'geom_' columns include details about geographic shapes (polygons and multipolygons), geographic center points, and the X and Y coordinates of these center points. All geographic coordinates are presented...
Version History of Regional Boundaries 2020 (1:4 500 000) - History TableTSV
The 'table__history' is a history table that contains the version history of its base rows, sourced from the 'Tilastokeskus' website in Finland. The table is part of a larger dataset collection that presents the regional statistical areas in Finland for the year 2020 at a scale of 1:4,500,000. The data includes information about different regions, such as North Ostrobothnia, South Savo, Central Finland, South Karelia, and Lapland, in various languages. The table has a unique combination of the '_start_date' and '_row_number' columns that helps to identify each row in the version history table. The '_start_date' column refers to the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted from the...

Column Descriptions

Provinces 2020 - Geographical Data and Attributes (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	This is a special column that holds the date when the data row was extracted from the data source.
_row_number	long	This special column contains the row number in the data extracted from the source on the extraction date specified by the column '_extract_date'. Together with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column stores the geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column represents the geographical data in a textual format.
geom_type	string	This column indicates the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns, for example, whether it's a polygon or a multipolygon.
geom_centroid	string	This column holds the geographical center point of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column contains the x-coordinate of the center point of the geographical shape.
geom_center_y	double	This column contains the y-coordinate of the center point of the geographical shape.
gml_id	string	This string column holds a unique identifier for the geographical data.
maakunta	string	This string column represents the province code based on the Finnish province division.
name	string	This string column contains the English name of the province.
namn	string	This string column holds the Swedish name of the province.
nimi	string	This string column represents the Finnish name of the province.
vuosi	long	This integer column holds the year related to the data row.

Version History of Regional Boundaries 2020 (1:4 500 000) - History Table

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms part of a combination with '_row_number' that uniquely identifies each row in the version history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value of the column is null, it indicates that the row is the most recent version.
_row_number	long	Contains the number of the row in the raw data extracted from the data source. This, in combination with '_start_date', uniquely identifies each row in the version history table.
geom_geojson	string	Stores geometric data in the GeoJSON format, typically representing geographical features.
geom_geotext	string	Contains the geometric data in text format.
geom_type	string	Indicates the type of geometry stored in the 'geom' columns, such as polygons or multipolygons.
geom_centroid	string	This column contains the geometric central point of the geographical feature.
geom_center_x	double	Stores the X-coordinate of the geometric center of the geographical feature.
geom_center_y	double	Stores the Y-coordinate of the geometric center of the geographical feature.
gml_id	string	This is an identifier for the row, typically a combination of the dataset name and the row number.
maakunta	string	This column contains codes representing different regions or provinces.
name	string	This column contains the English names of the regions or provinces.
namn	string	This column contains the Swedish names for the regions or provinces.
nimi	string	This column contains the Finnish names for the regions or provinces.
vuosi	long	This column contains the year related to the data in the respective row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024