Statistics Finland Service Interface (WFS) - Regional Statistical Areas Dataset 2022

This dataset collection is sourced from the Statistics Centre (Tilastokeskus) in Finland. It comprises a group of related data tables that are organized in a structured format of columns and rows. The data tables in this collection are obtained via the Statistics Centre's service interface (WFS). The information contained in this collection is extensive and relates to various statistical areas, providing a wealth of valuable data for analysis and interpretation. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

ELY Areas 2022 (1:4 500 000) - History VersionTSV
The 'table__history' is a history table that maintains the version history of its base table rows. It belongs to a collection of related tables named 'tilastointialueet_ely4500k_2022'. This table contains additional columns, '_start_date' and '_end_date', compared to its base table, to track the version history. These columns store the date when the row was extracted from the data source and when a new version of the row was extracted, respectively. A null value in the '_end_date' column indicates that the row is the most recent version. Also, the '_row_number' column contains the number of the row in the raw data, and the combination of '_start_date' and '_row_number' uniquely identifies each row in this table. The content of the base table is about ELY areas in 2022 at a 1:4 500 000...
ELY Regions 2022 (Scale 1:4 500 000) Table - Dataset CollectionTSV
The table in question is an integral part of a dataset collection that encapsulates regional data. This table holds vital data about ELY-areas for the year 2022 at a scale of 1:4,500,000, sourced from the Statistical Center 'Tilastokeskus' in Finland. The dataset is rich with information, organized into various columns, each with unique significance. Notably, two columns, namely, the extraction date, and the row number, are of particular importance as they serve to uniquely identify each row. The extraction date refers to the specific date when the data was pulled from the source, while the row number indicates the sequence of data as it was extracted. One of the main features of the table is the geographic information. Columns beginning with 'geom_' contain various forms of geospatial...

Column Descriptions

ELY Regions 2022 (Scale 1:4 500 000) Table - Dataset Collection

Column	Type	Comment
_extract_date	date	This column specifies the date when the data on the row was extracted from the source. It is part of a unique identifier for each row when combined with the '_row_number' column.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It forms a unique identifier for each row when combined with the '_extract_date' column.
ely	string	This string column represents a specific code related to the geographical area.
geom_geojson	string	This column contains geometrical data in GeoJSON format, which describes the geographical boundaries of the area.
geom_geotext	string	This column contains geometrical data in text format, which also represents the geographical boundaries of the area.
geom_type	string	This column specifies the type of the geometrical data stored in the previous two columns ('geom_geojson' and 'geom_geotext').
geom_centroid	string	This column contains the coordinates of the centroid, or the geometric center, of the area.
geom_center_x	double	This column contains the X coordinate of the geometric center of the area.
geom_center_y	double	This column contains the Y coordinate of the geometric center of the area.
gml_id	string	This string column contains a unique identifier for each row of the table.
id	long	This integer column contains a numerical identifier corresponding to the geographical area.
name	string	This string column contains the English name of the geographical area.
namn	string	This string column contains the name of the geographical area in another language.
nimi	string	This string column contains the name of the geographical area in the Finnish language.
vuosi	long	This integer column specifies the year related to the data row.

ELY Areas 2022 (1:4 500 000) - History Version

Column	Type	Comment
_start_date	date	This column contains the date when a certain row was extracted from the data source. It's a part of a unique identifier for each row in the history table.
_end_date	date	This column holds the date when a new version of a row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	This column contains the row number from the raw data extracted from the data source. It forms a unique combination with the '_start_date' to identify each row in the version history.
ely	string	This string column contains unique codes associated with the ELY Centers in Finland.
geom_geojson	string	This column contains the geographical data in GeoJSON format. It represents the geographical boundaries associated with the ELY Centers.
geom_geotext	string	This column holds the geographical data in geotext format. Similar to 'geom_geojson', it contains the geographical boundaries of the ELY Centers.
geom_type	string	This string column describes the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, the data type is 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid points of the geographical areas associated with the ELY Centers.
geom_center_x	double	This column contains the x-coordinate of the center point of the geographical area related to the ELY Centers.
geom_center_y	double	This column contains the y-coordinate of the center point of the geographical area related to the ELY Centers.
gml_id	string	This string column contains unique identifiers for each row.
id	long	This integer column contains identifiers for each row.
name	string	This string column contains the English names of the ELY Centers in Finland.
namn	string	This column contains the names of the ELY Centers in Swedish.
nimi	string	This column contains the names of the ELY Centers in Finnish.
vuosi	long	This integer column contains the year of the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024