Statistics Finland Service Interface (WFS) Dataset Collection 2024

This collection of datasets originates from the Statistics Center's service interface, known as Tilastokeskus (Statistics Finland), in Finland. The collection is composed of related data tables, with each table presenting a variety of related data in a structured format of columns and rows. The data in this collection is highly detailed and organized, providing a valuable resource for those seeking to understand specific statistical areas. The datasets in this collection are current as of 2024. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

History of AVI Areas 2024 Version Control (1:4 500 000)TSV
The 'table__history' belongs to the dataset collection 'tilastointialueet_avi4500k_2024'. This table is a history table, known for storing the version history of its base table rows. The base table contents, as described by the data source, 'Tilastokeskus' (Statistics Finland), are 'AVI-alueet 2024 (1:4 500 000)', which translates to AVI areas 2024 at the scale of 1:4,500,000. The table provides a temporal snapshot of the data, with special columns like 'start_date' and '_end_date' indicating the period during which a particular version of a row was active. For instance, if '_end_date' is null, it signifies that the version of the row is the most current. Another crucial column, '_row_number', represents the row number in the raw data. The combination of '_start_date' and '_row_number'...
Regional Administrative Divisions 2024 (Scale 1:4,500,000)TSV
The table, extracted from the Finnish Statistics Bureau (Tilastokeskus) website, provides in-depth geographical information about the AVI areas for the year 2024 at a 1:4,500,000 scale. The data includes specific designations such as the State Department of Åland, Southern Finland AVI, and Northern Finland AVI, among others, with corresponding Finnish and Swedish names. Each row in the table represents an individual AVI area, uniquely identified by the combination of the extraction date and a row number. For instance, data extracted on a particular date, say November 11, 2024, would be tagged with that date and a unique row number for identification purposes. The geographical information is presented in several formats, facilitating geospatial analytics. This includes GeoJSON and...

Column Descriptions

Regional Administrative Divisions 2024 (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date.
avi	string	Identifier code of the administrative division.
geom_geojson	string	Geographical representation of the administrative division in GeoJSON format.
geom_geotext	string	Geographical representation of the administrative division in text format.
geom_type	string	Type of the geographical representation used.
geom_centroid	string	Geographical center point of the administrative division.
geom_center_x	double	X-coordinate of the geographical center point.
geom_center_y	double	Y-coordinate of the geographical center point.
gml_id	string	Unique identifier of the geographical representation.
id	long	Unique identifier of the administrative division.
name	string	English name of the administrative division.
namn	string	Swedish name of the administrative division.
nimi	string	Finnish name of the administrative division.
vuosi	long	Year for which the data is valid.

History of AVI Areas 2024 Version Control (1:4 500 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, combined with '_row_number', uniquely identifies each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If this column's value is null, it indicates that the row is the most recent version.
_row_number	long	The number of the row as it appears in the raw data extracted from the data source. This column, combined with '_start_date', uniquely identifies each row in this version history table.
avi	string	A string type field in the dataset, likely representing some form of category or identifier.
geom_geojson	string	This column contains geometry data in GeoJSON format, a standard format for encoding geographical features.
geom_geotext	string	This column contains geometry data as text, likely in a format such as WKT (Well-Known Text).
geom_type	string	This column specifies the type of the geometry data, which can be either 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	This column contains the centroid (geometric center) of the geometry data.
geom_center_x	double	This column contains the X coordinate of the center of the geometry data.
geom_center_y	double	This column contains the Y coordinate of the center of the geometry data.
gml_id	string	A String type field representing a unique identifier in the dataset.
id	long	An Integer type field representing a unique identifier in the dataset.
name	string	A String type field representing the name of the entity in English. For example, it could be the name of a geographical region or administrative unit.
namn	string	A String type field representing the name of the entity in Swedish. For example, it could be the name of a geographical region or administrative unit.
nimi	string	A String type field representing the name of the entity in Finnish. For example, it could be the name of a geographical region or administrative unit.
vuosi	long	An Integer type field representing the year associated with the row. For example, it could be the year of data collection or the year to which the data pertains.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024