2013 Statistical Regional Dataset Collection

This dataset collection comprises a group of related data tables, sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The tables within this collection are aligned with the Statistical Service Interface (WFS), as provided by the data source. These tables are organized in a manner that allows for easy understanding and interpretation of the data, each consisting of rows and columns that represent various data points and categories. The dataset collection is designed to provide comprehensive and detailed statistical information, suitable for various analytical 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

Historical Version Records of Subregions 2013 (1:4 500 000)TSV
The 'table__history' is a version history table belonging to the 'tilastointialueet_seutukunta4500k_2013' dataset collection. It stores historical data related to 'Seutukunnat 2013 (1:4 500 000)', a Finnish dataset that translates to the 'Regions of 2013 (1:4 500 000)'. This table holds a wealth of information with a focus on geographic details, making it an invaluable resource for geospatial data analytics. The data is sourced from 'Tilastokeskus' (Statistics Finland), a web-based data source based in Finland. The table comprises a variety of columns, each containing unique data elements. Key among them are '_start_date' and '_end_date', which record the dates of data extraction and update respectively. The '_row_number' column designates the row number in the raw data, and together...
Regional Divisions 2013 (1:4 500 000) - Data TableTSV
The table is part of a larger dataset collection and it focuses on regional data from 2013, specifically referred to as 'Seutukunnat 2013' which translates to 'Sub-regions 2013'. This information is thoughtfully organized into various columns that encompass a wealth of information. For instance, the table includes columns that provide geographic information in the form of GeoJSON, GeoText, and centroid data. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude, which can be extremely useful for geospatial data analytics. Additionally, the table includes identifiers for each region, depicted in three different languages, and a unique region code ('seutukunta'). The data also provides the...

Column Descriptions

Regional Divisions 2013 (1:4 500 000) - Data Table

Column	Type	Comment
_extract_date	date	This is a special column that contains the date when the data on the row of the table was extracted from the data source. This column, in combination with the '_row_number' column, is used to uniquely identify each row in the table.
_row_number	long	This is another special column that contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, along with the '_extract_date' column, uniquely identifies each row in the table.
geom_geojson	string	This column contains the geometric data of the regions in the MultiPolygon format in GeoJSON.
geom_geotext	string	This column contains the geometric data of the regions in the MultiPolygon format as text strings.
geom_type	string	This column specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. The type in this dataset is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygon shapes.
geom_centroid	string	This column contains the centroid point of the geometric shape representing the region. The centroid is calculated as the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column contains the x-coordinate of the centroid point of the geometric shape representing the region.
geom_center_y	double	This column contains the y-coordinate of the centroid point of the geometric shape representing the region.
gml_id	string	This column contains the unique identifier of the region. The identifier is constructed as 'seutukunta4500k_2013' followed by a unique number for each 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.
seutukunta	string	This column contains the statistical region code for the region.
vuosi	long	This column contains the year when the data was collected. In this dataset, the data was collected in the year 2013.

Historical Version Records of Subregions 2013 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column holds the date when the row was extracted from the data source. It contributes to the unique identification of each row in this version history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. A null value indicates that the 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 source. Together with '_start_date', it helps to uniquely identify each row in this version history table.
geom_geojson	string	This column stores geographic data in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geographical data in a textual format.
geom_type	string	This column specifies the type of the geographical data contained in the row.
geom_centroid	string	This column contains the coordinates of the centroid, or geometric center, of the geographical data.
geom_center_x	double	This column holds the x-coordinate of the center of the geographical data.
geom_center_y	double	This column holds the y-coordinate of the center of the geographical data.
gml_id	string	This column contains a unique identifier for each row.
name	string	This column holds the name of the geographical area in English.
namn	string	This column contains the name of the geographical area in Swedish.
nimi	string	This column contains the name of the geographical area in Finnish.
seutukunta	string	This column contains a code representing a specific geographical area.
vuosi	long	This column contains the year related to the data in the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024