Statistical Area Collection - Province 1000K 2019

The dataset collection in question is a compilation of related data tables originating from the 'Tilastokeskus' (Statistics Finland) website in Finland. These tables are organized in a coherent structure with rows and columns holding related data. The dataset is provided through the Statistics Finland's service interface (WFS). This dataset collection is a valuable resource for analyzing and interpreting statistical data about regional units in Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regions 2019 (Scale 1:1 000 000) - Table from Finnish Statistical Dataset CollectionTSV
The table contains detailed information about the provinces (Maakunnat) in Finland for the year 2019. The data provided is comprehensive, with a robust set of columns providing numerous perspectives on each province. For example, the data includes not only the name of the province but also its unique identifier, the year, and translations of the name into other languages. The data further offers geospatial information about each province, including its geographical center and the shape of its boundaries in various formats, which can be useful for geospatial data analytics. This geographical information is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Two special columns, '_extract_date' and '_row_number', provide...
Version History of the Regions 2019 (1:1 000 000) Data TableTSV
The 'table__history' is a rich source of geospatial and temporal data, originating from the Finnish national statistical authority, 'Tilastokeskus' (Statistics Finland). It forms a part of a larger dataset collection that focuses on regional statistical data. This is a history table, containing the version history of its base table rows. The data it houses is a detailed snapshot of the regions of Finland, known as 'Maakunnat', as they stood in the year 2019. The data is presented in a high-resolution format, making the table suitable for various sophisticated analyses. Among the various data points, the table provides geographical details of these regions, including their names in multiple languages - Finnish, Swedish, and English. For each region, the table contains a unique...

Column Descriptions

Regions 2019 (Scale 1:1 000 000) - Table from Finnish Statistical Dataset Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. This information, combined with the '_row_number', provides a unique identifier for each row.
_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'. This information, combined with the '_extract_date', provides a unique identifier for each row.
geom_geojson	string	This column contains the geometry of the region in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometry of the region in text format.
geom_type	string	This column specifies the type of geometry used for the region, for example, 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid of the geographic region, which is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column contains the x-coordinate of the center point of the geographic region.
geom_center_y	double	This column contains the y-coordinate of the center point of the geographic region.
gml_id	string	This column contains a unique identifier for each geographic region.
maakunta	string	This column contains a coded representation of the region.
name	string	This column contains the name of the region in English.
namn	string	This column contains the name of the region in Swedish.
nimi	string	This column contains the name of the region in Finnish.
vuosi	long	This column contains the year of the data.

Version History of the Regions 2019 (1:1 000 000) Data Table

Column	Type	Comment
_start_date	date	This column contains the extraction date of each row from the data source, marking the starting point of the row's version in the history table.
_end_date	date	This column contains the date when a newer version of the row was extracted from the source. A null value in this column indicates that the current row is the most recent version.
_row_number	long	This column represents the row number in the raw data extracted from the 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 geometric data for the row in GeoJSON format, which is a format for encoding geographic data structures.
geom_geotext	string	This column stores the geometric data in a textual format.
geom_type	string	This column specifies the type of the geometric data stored in the row, for example, 'ST_MULTIPOLYGON'.
geom_centroid	string	This column stores the centroid of the geometric data, which is the geometric center of all the points that make up the shape.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the shape.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the shape.
gml_id	string	This column contains the unique identifier assigned to the row by the data source.
maakunta	string	This column contains a numerical representation of the province.
name	string	This column contains the English name of the province.
namn	string	This column contains the name of the province translated into Swedish.
nimi	string	This column includes the Finnish name of the province.
vuosi	long	This column records the year associated with the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024