Statistics Service Interface (WFS) Data Tables Collection 2021

This dataset collection is sourced from the 'Tilastokeskus' (Statistics Finland) website, located in Finland. It is comprised of a group of related tables, each containing data organized in a structured format of rows and columns. The dataset represents valuable information provided via a service interface, specifically the Statistics Finland's Web Feature Service (WFS). The information in this dataset collection is expected to be particularly useful for statistical analysis and research purposes. 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 2021 (Scale 1:1,000,000)TSV
The 'table' is part of a larger dataset collection known as 'tilastointialueet_avi1000k_2021'. This table contains important information about the AVI areas in 2021 at a scale of 1:1,000,000. It is sourced from the Statistics Finland (Tilastokeskus) web site based in Finland. This table contains geographic data that can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order of longitude first, followed by latitude. The data in the table is organized in various columns. Two special columns, '_extract_date' and '_row_number', provide key details about each row of data. The '_extract_date' indicates the date when the data on the row was extracted from the source, while the '_row_number' determines...
Version History of AVI-Regions 2021 (1:1 000 000) DatasetTSV
The history table is a part of a dataset collection that stores versioned data of its base table. The base table represents AVI areas as mapped in 2021, which can be utilized in multiple ways, such as historical trend analysis, data validation, and geospatial data analytics. The table records each version of a row from the base table, preserving the state of data as it was at the time of extraction. This is particularly useful for tracking changes over time and analyzing historical data. The columns of the table contain a wealth of information. For example, information on row versioning is provided by the '_start_date' and '_end_date' columns, which denote the lifespan of a specific version of a row. The '_row_number' column records the unique identification number of a row, which when...

Column Descriptions

Regional Administrative Agencies Areas 2021 (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. It helps in identifying the freshness of the data.
_row_number	long	A unique identifier for each row, representing the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
avi	string	A string column that presumably contains some form of identifier or code.
geom_geojson	string	This column stores the geometric data in GeoJSON format. The data represents geographical features with their non-spatial attributes.
geom_geotext	string	This column contains the geometric data in the form of text. It may include various geometrical shapes and structures.
geom_type	string	This column specifies the type of geometric data stored in the row. The types could be multipolygon, polygon etc.
geom_centroid	string	This column contains the centroid of the geometric data. The centroid is the geometric center of a plane figure or shape.
geom_center_x	double	This column represents the x-coordinate of the geometric center of the data.
geom_center_y	double	This column represents the y-coordinate of the geometric center of the data.
gml_id	string	This string column contains identifiers, likely used to link to other data or as a unique identifier for the geometric data.
id	long	An integer column, which is typically used to uniquely identify each record in the table.
name	string	A string column that presumably contains names or titles in English.
namn	string	A string column that presumably contains names or titles in another language, possibly Finnish or Swedish.
nimi	string	A string column that presumably contains names or titles in yet another language, possibly Finnish.
vuosi	long	An integer column, possibly representing a year or duration.

Version History of AVI-Regions 2021 (1:1 000 000) Dataset

Column	Type	Comment
_start_date	date	This column holds the date on which the row was extracted from the data source. Each row's uniqueness in this version history table can be identified by a combination of this column and '_row_number'.
_end_date	date	This column contains the date on which a new version of the row was extracted from the data source. If the value of this column is null, it means 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 data source. It forms a unique identifier for each row in combination with the '_start_date' column.
avi	string	This is a string column which corresponds to a specific code in the data source.
geom_geojson	string	This column contains the geometrical data in GeoJSON format.
geom_geotext	string	This column represents the geometrical data in text format.
geom_type	string	This column specifies the type of the geometry used.
geom_centroid	string	This column contains the geographical centroid point of a shape in the data.
geom_center_x	double	This column contains the X-coordinate of the center of a shape.
geom_center_y	double	This column contains the Y-coordinate of the center of a shape.
gml_id	string	This string column contains a unique identifier for each row in the base table.
id	long	This integer column serves as an identifier for each row in the base table.
name	string	This string column contains the English name of the region.
namn	string	This string column contains the Swedish name of the region.
nimi	string	This string column contains the Finnish name of the region.
vuosi	long	This integer column represents the year associated with the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024