Statistics Interface (WFS) Regional Data Collection 2016

This dataset collection is a compilation of data tables sourced from the website of Tilastokeskus (Statistics Finland), in Finland. The collection comprises numerous tables, each filled with related data that's been meticulously organized into columns and rows. The data within the collection is served from the Statistics Finland's service interface (WFS). Given the nature of the source and the method of data delivery, this dataset collection provides a rich and in-depth analysis opportunity for those seeking to examine and understand the specific data field it covers. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Version Records of Finnish Regions (2016)TSV
The 'table__history' is a version history table, maintaining the historical records of its base table. It is part of a larger dataset collection focused on statistical regions in Finland, as sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains data about regions in Finland, as indicated by the base table description 'Regions 2016 (1:1 000 000)'. It includes information about each region's name in different languages, the year of the data, and unique identifiers. One of the unique aspects of this table are the geographic details presented through several columns. These details, represented in WGS 84 coordinate reference system with the order of longitude first, followed by latitude, provide a rich resource for geospatial data analytics. For instance, the...
Provinces 2016 (1:1 000 000) Table from Dataset CollectionTSV
The table named 'table' is an integral part of the dataset collection 'tilastointialueet_maakunta1000k_2016'. It provides data related to the regions of Finland in 2016 at a scale of 1:1 000 000. The data in the table is sourced from 'Tilastokeskus' (Statistics Finland). The table contains a variety of columns which store diverse types of data. It has special columns like '_extract_date' and '_row_number', which contain the extraction date of the row data and the row number respectively. These columns uniquely identify each row in the table. Geospatial data is also a significant part of this table. Columns starting with 'geom_' like 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y' hold geographic information. The geographic coordinates are...

Column Descriptions

Provinces 2016 (1:1 000 000) Table from Dataset Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of these two columns uniquely identifies each row.
geom_geojson	string	This column contains the geometric data in GeoJSON format.
geom_geotext	string	This column contains the geometric data in text format.
geom_type	string	This column specifies the type of the geometric data.
geom_centroid	string	This column contains the centroid of the geometric data.
geom_center_x	double	This column contains the X coordinate of the center of the geometric data.
geom_center_y	double	This column contains the Y coordinate of the center of the geometric data.
gml_id	string	This column contains the unique identifier for the geometric data.
maakunta	string	This column contains the province code.
name	string	This column contains the name of the province in English.
namn	string	This column contains the name of the province in Swedish.
nimi	string	This column contains the name of the province in Finnish.
vuosi	double	This column contains the year associated with the data.

Historical Version Records of Finnish Regions (2016)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. This is a part of a unique identifier for each row in the version history table, together with '_row_number'.
_end_date	date	This column contains the date when 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. Together with '_start_date', it forms a unique identifier for each row in this version history table.
geom_geojson	string	This column contains the geometry of the statistical area in GeoJSON format.
geom_geotext	string	This column contains the geometry of the statistical area as a text string.
geom_type	string	This column specifies the type of the geometry of the statistical area.
geom_centroid	string	This column contains the point that represents the centroid of the statistical area.
geom_center_x	double	The x-coordinate of the centroid of the statistical area.
geom_center_y	double	The y-coordinate of the centroid of the statistical area.
gml_id	string	The unique identifier of the region in the statistical area dataset.
maakunta	string	The code of the region in the statistical area dataset.
name	string	The English name of the region in the statistical area dataset.
namn	string	The Swedish name of the region in the statistical area dataset.
nimi	string	The Finnish name of the region in the statistical area dataset.
vuosi	double	The year when the data of the statistical area was collected or updated.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024