2017 Statistical Regions Dataset Collection

The dataset collection under consideration originates from the Statistics Center's service interface, also referred to as 'Tilastokeskus' in Finland. This collection comprises multiple interrelated data tables. The data tables within this collection are meticulously organized in a tabular format with rows and columns, each containing specific data related to the overarching theme of the dataset collection. The contents of this collection are primarily obtained from the reputable source 'Tilastokeskus', based in Finland. Its primary purpose is to provide comprehensive statistical data to facilitate various analytical and research-oriented tasks. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Provincial Boundaries 2017: Version History (1:4 500 000)TSV
The 'table__history' is a rich historical data collection that captures the version history of its base table rows. The table is part of a larger dataset collection, specifically focused on providing comprehensive statistics for the Finnish regions. The primary content of the table is derived from the base table, which is titled 'Regions 2017 (1:4 500 000)'. The table encompasses a variety of columns, each providing unique and insightful data. For instance, the table contains specific columns that record the date a row was extracted from the data source and the date a new version of the row was extracted. These columns, when combined with the column that contains the number of the row in the raw data, allow for each row in this version history table to be uniquely identified. If a row's...
Regions 2017 (Scale 1:4 500 000) - Data Collection from Finnish Statistical DatabaseTSV
The table is a part of a larger dataset called 'Regions 2017 (1:4 500 000)', which is sourced from the 'Statistics Finland' website. The data primarily represents the Finnish regions as they were in the year 2017. The table contains several columns, some of which provide geospatial data while others provide additional information about the regions. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Geospatial data is available in multiple formats, including GeoJSON and GeoText, and can be used for geospatial data analytics. The table also includes columns for region names in Finnish and Swedish, the two official languages of Finland, and a unique region identifier. Two key columns, '_extract_date'...

Column Descriptions

Regions 2017 (Scale 1:4 500 000) - Data Collection from Finnish Statistical Database

Column	Type	Comment
_extract_date	date	This column contains the date when the data in the row was extracted from the source. It plays a critical role in identifying each row uniquely when combined with the '_row_number' column.
_row_number	long	This column contains the row number for the data extracted from the source. When paired with the '_extract_date' column, it helps in uniquely identifying each row.
geom_geojson	string	This column contains geometric data in the GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column holds geometric data in text format, offering a textual representation of the geographical features.
geom_type	string	This column specifies the type of geometric data in the row, such as 'ST_MULTIPOLYGON', indicating the representation of multiple polygon areas.
geom_centroid	string	This column contains the coordinates of the centroid, or geometric center, of the given geographical feature.
geom_center_x	double	This column holds the x-coordinate of the center point of the geometric data.
geom_center_y	double	This column stores the y-coordinate of the center point of the geometric data.
gml_id	string	The 'gml_id' is a string type column that provides a unique identifier for each row.
maakunta	string	The 'maakunta' is a string type column that represents the region or province of the geographical feature.
name	string	This column contains the English name of the region or province.
namn	string	This column holds the Swedish name of the region or province.
nimi	string	The 'nimi' column represents the Finnish name of the region or province.
vuosi	double	The 'vuosi' column is a real type column that represents the year related to the data in the row.

Provincial Boundaries 2017: Version History (1:4 500 000)

Column	Type	Comment
_start_date	date	This column represents the date a row was extracted from the data source. Along with '_row_number', it forms a unique identifier for each row in the table. The date is recorded in the format 'YYYY-MM-DD'.
_end_date	date	This column records the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the current row is the most recent version.
_row_number	long	This column contains the number of the row as it appears in the raw data extracted from the data source. It is part of the unique identifier for each row when combined with '_start_date'.
geom_geojson	string	This column contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column includes geometric data in a text format. It typically represents complex geometric structures like polygons.
geom_type	string	This column describes the type of geometric data contained in the rows. For instance, 'ST_MULTIPOLYGON' indicates a collection of polygons.
geom_centroid	string	This column stores the geometric center of a shape in the format 'POINT (X Y)'. It represents the location of the centroid of a geographic feature.
geom_center_x	double	This column represents the 'x' coordinate (longitude) of the centroid of the geographic feature.
geom_center_y	double	This column represents the 'y' coordinate (latitude) of the centroid of the geographic feature.
gml_id	string	This is a unique identifier for each row, assigned by the data source.
maakunta	string	This column contains codes representing different regions in Finland.
name	string	This column contains the English names of the regions represented in the 'maakunta' column.
namn	string	This column contains the names of the regions in another language, possibly Swedish or Finnish.
nimi	string	This column contains the names of the regions in a different language, likely Finnish.
vuosi	double	This column records the year associated with the data. It is represented as a real number.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024