Statistics Finland Service Interface (WFS) Dataset Collection

This dataset collection comprises of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. These tables form a cohesive collection that is interconnected and contains a significant amount of related data. The data in this collection is organized in a tabular format, with various columns and rows detailing different aspects of the data. The dataset description provided by the data source, Tilastokeskuksen palvelurajapinta (WFS), translates to 'Statistics Centre's Service Interface (WFS)'. This signifies that the dataset is delivered through a service interface from Finland's national statistics provider, providing a rich, reliable, and comprehensive data source. 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 Administrative Agencies' Areas Forecast for 2024 (Scale 1:1 000 000)TSV
The table under examination contains valuable data related to the AVI regions in the year 2024, as indicated by the Finnish Statistics Bureau. The information is organized in a specific structure with various columns each representing a different attribute. Two critical columns, '_extract_date' and '_row_number', provide unique identifiers for each row, representing the date of data extraction and the row number respectively. These may be used to track changes in data over time or to locate specific entries. Geographical information is comprehensively covered in columns with the prefix 'geom_'. These geographic coordinates, presented using the WGS 84 coordinate reference system (with axis order longitude first, followed by latitude), can be instrumental in geospatial data analytics....
Version History of AVI Regions 2024 (1:1 000 000)TSV
The 'table__history' is a history table presenting version history data of its base table. It belongs to a dataset collection titled 'AVI-alueet 2024 (1:1 000 000)', translated to English as 'AVI regions 2024 (1:1 000 000)'. This collection is sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland. The table includes a variety of columns, each containing specific types of data. For instance, certain columns contain geographic information that can be used for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table also holds special columns like '_start_date', '_end_date' and '_row_number'. The '_row_number' signifies the number of the row in...

Column Descriptions

Regional Administrative Agencies' Areas Forecast for 2024 (Scale 1:1 000 000)

Column	Type	Comment
_extract_date	date	This column marks the date when the data row was extracted from the source. It helps in tracking the data extraction history.
_row_number	long	This column represents the row number in the data extracted from the source. Together with '_extract_date', it uniquely identifies each row.
avi	string	This column stores a string value representing a specific identifier. The identifiers are unique within the dataset.
geom_geojson	string	This column contains the geometric representation of the data in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext	string	This column holds the geometric representation of the data in text format. It is another way of illustrating the geographical aspects of the data.
geom_type	string	This column specifies the type of the geometry being used, such as point, line, polygon, etc.
geom_centroid	string	This column contains the centroid (geometric center) of the multi-polygon shapes. The centroid is a point that defines a geometric object's center.
geom_center_x	double	This column contains the X-coordinate of the centroid. It is part of the geometric representation of the data.
geom_center_y	double	This column contains the Y-coordinate of the centroid. It is also part of the geometric representation of the data.
gml_id	string	This column contains a unique identifier for each row following the GML standard. It is used to ensure data integrity.
id	long	This column denotes an integer identifier for each row. It serves as a primary key for the data table.
name	string	This column contains the English name of the represented entity.
namn	string	This column holds the name of the represented entity in Swedish.
nimi	string	This column lists the name of the represented entity in Finnish.
vuosi	long	This column indicates the year related to the data row.

Version History of AVI Regions 2024 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column records the date when the row was extracted from the data source, marking the beginning of a version of a row in the history table.
_end_date	date	This column records the date when a new version of the row was extracted from the data source, marking the end of the current version. If this column contains a null value, it indicates that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the source. Together with '_start_date', it uniquely identifies each row in this history table.
avi	string	This column contains a string representation of a certain attribute associated with the data row.
geom_geojson	string	This column contains geometric data in GeoJSON format. The data represents the spatial characteristics of the data row.
geom_geotext	string	This column contains geometric data in text format. This is another representation of the spatial characteristics of the data row.
geom_type	string	This column describes the type of the geometric data present in the row. The data can represent various types of shapes like polygons or multipolygons.
geom_centroid	string	This column contains the geometric centroid of the spatial data associated with the data row.
geom_center_x	double	This column contains the x-coordinate of the center point of the geometric shape associated with the data row.
geom_center_y	double	This column contains the y-coordinate of the center point of the geometric shape associated with the data row.
gml_id	string	This column contains a unique identifier associated with the data row. It is a string data type.
id	long	This column contains a unique integer identifier associated with the data row.
name	string	This column contains a string representation of the name associated with the data row in English.
namn	string	This column contains a string representation of the name associated with the data row in Swedish.
nimi	string	This column contains a string representation of the name associated with the data row in Finnish.
vuosi	long	This column contains an integer representing the year associated with the data row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024