Statistics Bureau Service Interface (WFS) - Dataset Collection 2022

This dataset collection comprises a group of tables sourced from the website of Tilastokeskus (Statistics Finland), located in Finland. These tables contain information provided via the service interface of Statistics Finland. The information within the tables is organized in a structured way, making it easy to analyze and understand. The tables are related, providing a comprehensive picture of the data topic they cover. The data has been meticulously gathered and compiled, ensuring a high level of accuracy and reliability. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Statistical Regions 2022 (Scale 1:1 000 000)TSV
The table, sourced from 'Tilastokeskus' (Statistics Finland) website, encapsulates comprehensive information about the 'AVI areas 2022' with a granularity of 1:1,000,000. This data is part of the 'tilastointialueet_avi1000k_2022' dataset collection. The table comprises various columns, each storing unique information. Two special columns are '_extract_date' and '_row_number'. '_extract_date' indicates the date when data was extracted, while '_row_number' denotes the row number of the extracted data, making each row unique when combined. Several columns prefixed with 'geom_' encompass geospatial data. These columns store data such as the type of the geographic area (polygon or multipolygon), its centroid, center coordinates, and geographic information in GeoJSON and GeoText formats. This...
Version History of AVI Regions 2022 (1:1 000 000)TSV
The 'table__history' is a part of a larger dataset collection that encapsulates the version history of its base table rows. This history table is sourced from 'Tilastokeskus' (Statistics Finland), based in Finland. The primary content of this table reflects the AVI areas for 2022 at a scale of 1:1 000 000, as provided by the data source. This table contains several columns with varied information. Firstly, there are columns that provide geographic information suitable for geospatial data analytics. These columns, prefixed by 'geom_', present geographic coordinates using the WGS 84 coordinate reference system, with longitude appearing first, followed by latitude. Then, there are columns that include details such as the start and end dates of the data extraction from the source, and the...

Column Descriptions

Statistical Regions 2022 (Scale 1:1 000 000)

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source.
_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.
avi	string	This column contains coded values representing different Administrative Judicial Regions in Finland.
geom_geojson	string	This column provides the geographical coordinates of the Administrative Judicial Regions in GeoJSON format.
geom_geotext	string	This column provides the geographical coordinates of the Administrative Judicial Regions in text format.
geom_type	string	This column specifies the type of the geographical coordinate, either a Polygon or a MultiPolygon.
geom_centroid	string	This column provides the centroid of the geographical coordinates of the Administrative Judicial Regions.
geom_center_x	double	This column provides the X-coordinate of the center of the Administrative Judicial Regions.
geom_center_y	double	This column provides the Y-coordinate of the center of the Administrative Judicial Regions.
gml_id	string	This column contains unique identifiers for each row in the table.
id	long	This column contains unique numerical identifiers for each Administrative Judicial Region.
name	string	This column contains the names of the Administrative Judicial Regions in English.
namn	string	This column contains the names of the Administrative Judicial Regions in Swedish.
nimi	string	This column contains the names of the Administrative Judicial Regions in Finnish.
vuosi	long	This column indicates the year that the data was collected.

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

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source, serving as a start date for the version history of a particular row.
_end_date	date	The '_end_date' column contains the date when a new version of the row was extracted from the data source. If the column value is null, it signifies that the row is the most recent version.
_row_number	long	This column holds the row number in the raw data extracted from the data source. Along with the '_start_date', it uniquely identifies each row in the version history table.
avi	string	The 'avi' column represents a unique code or identifier, possibly related to a certain geographical area or entity.
geom_geojson	string	The 'geom_geojson' column contains the geographical data in GeoJSON format, a standard format for encoding a variety of geographic data structures.
geom_geotext	string	This column, 'geom_geotext', stores geographical data in text format.
geom_type	string	The 'geom_type' column specifies the type of the geographic data represented in the 'geom_geojson' and 'geom_geotext' columns. In this case, it is a 'ST_MULTIPOLYGON', representing a multi polygon geographical entity.
geom_centroid	string	The 'geom_centroid' column contains the central point of the geographical entity represented as a point on the map.
geom_center_x	double	The 'geom_center_x' column holds the X-coordinate of the geographical entity's center point.
geom_center_y	double	The 'geom_center_y' column holds the Y-coordinate of the geographical entity's center point.
gml_id	string	The 'gml_id' column holds a unique identifier for each geographical entity.
id	long	The 'id' column contains a unique numerical identifier for each row.
name	string	The 'name' column contains the English name of the geographical entity.
namn	string	The 'namn' column contains the name of the geographical entity in another language, possibly Swedish.
nimi	string	The 'nimi' column holds the name of the geographical entity in Finnish.
vuosi	long	The 'vuosi' column represents the year associated with the row, possibly the year of data collection or the year the data pertains to.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024