Statistical Regions and Urban Areas Dataset Collection, 2013 Edition

The dataset collection in question is an assemblage of related data tables sourced from the Statistics Finland (Tilastokeskus) website. This collection pertains to statistical areas at the regional level, particularly focusing on regions with a population of around 1000 in the year 2013. The data is meticulously arranged in a tabular format consisting of rows and columns, making it easy for users to understand and analyze. The information is provided through Statistics Finland's Service Interface (WFS), ensuring its authenticity and reliability. 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 Regional Units 2013 (1:1 000 000)TSV
The 'table__history' is a comprehensive chronicle of related data preserved in a structured format. This history table is sourced from 'Tilastokeskus' (Statistic Finland) and primarily focuses on the version history of its base table rows. It is an integral part of the dataset collection 'tilastointialueet_seutukunta1000k_2013' which provides a broad overview of regional units in Finland in 2013 at a scale of 1:1 000 000. In addition to the base table contents, this table has two unique columns that determine its temporal dynamism: the commencement date of data extraction and the date when a new version of the row was introduced. If the end date is not specified, it signifies that the row is the most recent version. The table comprises of several geographic information columns, which...
Regional Units 2013 (1:1 000 000) from the Statistical DatabaseTSV
The table in discussion is a part of a larger dataset collection and contains significant information about the subregions of Finland in the year 2013. The data has been sourced from the Finnish Statistical Authority, 'Tilastokeskus' (Statistics Finland). Each row in the table represents a different subregion, with the data having been extracted on specific dates. The table includes columns that provide both general and geospatial data. General data includes the unique identification of each subregion, its name in different languages including Finnish and Swedish, and the year of data collection. Geospatial data is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These columns provide a wealth of information such as the...

Column Descriptions

Regional Units 2013 (1:1 000 000) from the Statistical Database

Column	Type	Comment
_extract_date	date	This column contains the date when the row data was extracted from the dataset. It helps to track the freshness of the data.
_row_number	long	This column contains the unique row number for each data extraction. It can be used in combination with '_extract_date' to uniquely identify each row.
geom_geojson	string	This column contains geometric data in GeoJSON format, which is a standard format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geometric data as text. It is another way of representing geographic data besides GeoJSON.
geom_type	string	This column describes the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the coordinates of the centroid, or geometric center, of the area represented by the geometric data.
geom_center_x	double	This column contains the X-coordinate of the geometric center of the area.
geom_center_y	double	This column contains the Y-coordinate of the geometric center of the area.
gml_id	string	This column contains a unique identifier for each row, which can be used for referencing specific entries.
name	string	This column contains the name of the region described by the row data in English.
namn	string	This column contains the name of the region in another language, providing a multilingual aspect to the dataset.
nimi	string	This column contains the name of the region in yet another language, further enhancing the multilingual nature of the dataset.
seutukunta	string	This column contains a distinct code representing the region.
vuosi	long	This column contains the year the data was collected, which is helpful for understanding the temporal context of the data.

Historical Version Records of Regional Units 2013 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. This value, combined with '_row_number', uniquely identifies 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. If the value is null, it indicates 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, which when used in conjunction with '_start_date' uniquely identifies each row in the version history table.
geom_geojson	string	This column stores the geometric data of the region in GeoJSON format.
geom_geotext	string	This column stores the geometric data of the region in a text format.
geom_type	string	This column indicates the type of the geometric data stored.
geom_centroid	string	This column contains the centroid point of the geometric shape representing the region.
geom_center_x	double	This column contains the x-coordinate of the center of the geometric shape representing the region.
geom_center_y	double	This column contains the y-coordinate of the center of the geometric shape representing the region.
gml_id	string	This column holds the unique ID of the region as provided by the 'Tilastokeskus' (Statistics Finland) data source.
name	string	This column contains the name of the region in English.
namn	string	This column contains the name of the region in the original language from the data source.
nimi	string	This column also contains the name of the region in another language.
seutukunta	string	This column contains a specific code associated with the region, as provided by the data source.
vuosi	long	This column contains the year associated with the data row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024