Statistics Service Interface (WFS) - Regional Statistics Collection 2017

The dataset collection in consideration is a comprehensive compilation of related data tables. These tables are meticulously sourced from 'Tilastokeskus' (Statistics Finland), a reliable and credible website based in Finland. The dataset collection presents a range of organized data, arranged in a table format with distinct columns and rows for ease of interpretation. The data within these tables are fetched from a service interface, known in the Finnish language as 'Tilastokeskuksen palvelurajapinta (WFS)'. This essentially means it's a Statistics Finland's service interface, which is a testament to the authenticity and quality of the dataset collection. The comprehensive nature of this dataset collection makes it a valuable resource for anyone seeking in-depth knowledge and understanding of the specific area it covers. 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 Records of Regional Divisions in Finland (2017)TSV
The 'table__history' is a historical data storage that archives the changes in its base table over time. It is a part of a larger dataset collection, which can be utilized to study the regional statistical areas in Finland, based on the 2017 data at a scale of 1:1,000,000. The historical table records the version history of each row in the base table, allowing users to track changes over time. Each row is uniquely identifiable through a combination of the extraction date and the row number from the raw data. The extraction date indicates when the data was first recorded, while the end date denotes when a new version of the same row was extracted, if any. Rows without an end date represent the most recent versions. The table contains geographic information that can be used for geospatial...
Regions 2017 (Scale 1:1,000,000) - Part of Dataset on Statistical Areas in FinlandTSV
The table, sourced from Finland's 'Tilastokeskus' (Statistics Finland), provides a comprehensive set of data relating to the 'Seutukunnat 2017' (Regions 2017) on a scale of 1:1 000 000. This table is part of a larger dataset collection named 'tilastointialueet_seutukunta1000k_2017'. The data within the table is organized into various columns each with a specific focus. Key columns include 'extract_date' and '_row_number' which provide information about when the data was extracted and the row number in the extracted data respectively. These two columns together uniquely identify each row. Other columns provide geographical data that can be utilized for geospatial data analytics. For instance, columns starting with 'geom' contain geographical information, including longitude and latitude,...

Column Descriptions

Regions 2017 (Scale 1:1,000,000) - Part of Dataset on Statistical Areas in Finland

Column	Type	Comment
_extract_date	date	This column represents the date when the data was extracted from the source. It provides a reference point for when the data was fetched, and can be used to track changes in the data over time.
_row_number	long	This column contains the row numbers from the original data source, giving a unique identifier for each data entry when combined with the extract date.
geom_geojson	string	This column stores the geographical data in GeoJSON format, a widely used format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geographical data in text format, specifically in the MULTIPOLYGON format, which defines multiple polygon areas.
geom_type	string	This column specifies the type of the geographical data. In this case, it is 'ST_MULTIPOLYGON', indicating that the geographic data is a collection of multiple polygons.
geom_centroid	string	This column contains the centroid of the geographical data, representing the geometric center of the set of polygons.
geom_center_x	double	This column represents the X-coordinate of the geometric center of the set of polygons.
geom_center_y	double	This column represents the Y-coordinate of the geometric center of the set of polygons.
gml_id	string	This column holds a unique identifier for each entry in the dataset, which is based on the 'seutukunta1000k_2017' dataset collection.
name	string	This column contains the names of the geographical areas in English.
namn	string	This column contains the names of the geographical areas in Swedish.
nimi	string	This column contains the names of the geographical areas in Finnish.
seutukunta	string	This column contains unique codes that represent different districts in Finland.
vuosi	double	This column represents the year when the data was collected.

Historical Records of Regional Divisions in Finland (2017)

Column	Type	Comment
_start_date	date	This is the date when the row was extracted from the data source. It forms a unique identifier for each row in conjunction with '_row_number'
_end_date	date	This represents the date when a new version of the row was extracted from the data source. If it is null, it signifies that the row is the latest version.
_row_number	long	This stands for the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row.
geom_geojson	string	This contains the geographical representation of the region in GeoJSON format.
geom_geotext	string	This represents the geographical shape of the region in text format, specifically in 'MULTIPOLYGON' format.
geom_type	string	This column specifies the type of geometric data stored, which is 'ST_MULTIPOLYGON' in this case.
geom_centroid	string	This contains the center point of the geographical region, represented as a 'POINT' with coordinates.
geom_center_x	double	This represents the x-coordinate of the center point of the geographical region.
geom_center_y	double	This represents the y-coordinate of the center point of the geographical region.
gml_id	string	This is a unique identifier for each row, provided by the 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 another language.
nimi	string	This column contains the name of the region in another language, possibly Finnish given the data source.
seutukunta	string	This is a string type column, though its exact content is unclear without further context.
vuosi	double	This is a numerical column representing the year, probably related to the data collected or the version of the dataset.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024