Statistics Bureau Service Interface (WFS) - 2014 Large Area Statistical Regions Collection

The dataset collection pertains to statistical data sourced from the website of Tilastokeskus (Statistics Finland) based in Finland. The datasets encompass a range of related data tables, each organized into rows and columns for easy interpretation. These tables collectively provide comprehensive statistical data, made available through the service interface of the Tilastokeskuksen palvelurajapinta (Statistics Finland's Service Interface). This data is particularly useful for anyone looking to analyze or draw insights from a broad scope of statistical data from 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

Large Areas 2014 (Scale 1:4 500 000) - Detailed Geospatial DataTSV
The table is part of a larger dataset collection and it contains various pieces of information related to the 'Major Areas 2014' (Suuralueet 2014), which is a geographic region representation at a scale of 1:4 500 000. This table was sourced from the 'Tilastokeskus' website, a statistical database from Finland. The data in this table is organized into several columns, each representing a unique aspect of the data. There are columns containing geographic information, which can be utilized for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This includes the geographical shape of the area (represented as a multipolygon), the centroid of this shape, and the...
Version History of Large Areas 2014 (1:4 500 000)TSV
The 'table__history' is a comprehensive collection of data that encapsulates the historical developments and changes within its corresponding dataset. It is part of the 'tilastointialueet_suuralue4500k_2014' dataset collection, which is a group of interrelated data tables sourced from the 'Tilastokeskus' website based in Finland. This table provides a version history of its base table rows, recording all the iterations and updates the dataset has undergone over time. The table features a range of columns that carry significant information. To begin with, each entry is identified uniquely by a combination of the '_start_date' and '_row_number' columns, representing the date of extraction from the source and the row's position in the raw data. The '_end_date' column indicates when a new...

Column Descriptions

Large Areas 2014 (Scale 1:4 500 000) - Detailed Geospatial Data

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It allows for tracking of the extraction history and data source updates.
_row_number	long	This column contains the row number in the extracted data, which, in combination with the '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the textual representation of the geographic data, which aligns with the GeoJSON data.
geom_type	string	This column specifies the type of the geographic data, which in this case is a multi-polygon, indicating complex geographic structures.
geom_centroid	string	This column contains the geographic coordinates of the centroid, which is the geographic center of the multi-polygon.
geom_center_x	double	This column indicates the X coordinate (longitude) of the geographic center of the multi-polygon.
geom_center_y	double	This column indicates the Y coordinate (latitude) of the geographic center of the multi-polygon.
gml_id	string	This column contains a unique identifier for each row, following the GML (Geography Markup Language) standard.
name	string	This column contains the English name of the area represented by the row's geographic data.
namn	string	This column contains the name of the area in Swedish, one of the official languages in Finland.
nimi	string	This column contains the name of the area in Finnish, the other official language in Finland.
suuralue	string	This column contains a code associated with the area represented by the row's geographic data.
vuosi	long	This column contains the year associated with the data, which indicates the temporal applicability of the data.

Version History of Large Areas 2014 (1:4 500 000)

Column	Type	Comment
_start_date	date	The date when a specific row was extracted from the data source, forming a unique combination with '_row_number' for each row in this version history table.
_end_date	date	The date when a new version of a specific row was extracted from the data source. A null value in this column indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source, forming a unique combination with '_start_date' for each row in this version history table.
geom_geojson	string	Geospatial data in GeoJSON format representing the geographical area related to each row.
geom_geotext	string	Geospatial data in text format representing the geographical area related to each row.
geom_type	string	The type of the geographical data, which in this case is a multi-polygon.
geom_centroid	string	The central point of the geographical area related to each row.
geom_center_x	double	The x-coordinate of the central point of the geographical area related to each row.
geom_center_y	double	The y-coordinate of the central point of the geographical area related to each row.
gml_id	string	The unique identifier for each row in the original data source.
name	string	The English name of the statistical area related to each row.
namn	string	The Swedish name of the statistical area related to each row.
nimi	string	The Finnish name of the statistical area related to each row.
suuralue	string	A numerical identifier representing the statistical area related to each row.
vuosi	long	The year to which the data in the row relates.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024