Statistics Centre's Service Interface (WFS) - Dataset Collection 2019

The dataset collection at hand comprises a set of related data tables, sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The contents of these tables are derived from the Statistical Service Interface (WFS), as described by the data source. As a collection, these tables form a comprehensive and interconnected group of data, providing a detailed and extensive statistical overview. The data is arranged in a tabular format, with rows and columns for easy interpretation and analysis. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regional Development Areas in Finland, 2019 (Scale: 1:4,500,000)TSV
The table is an organized collection of data that forms part of a larger dataset related to ELY areas in 2019 at a scale of 1:4,500,000. It is sourced from 'Tilastokeskus' (Statistics Finland) in Finland. Each row in the table represents a specific geographical area and includes a variety of data on that area. Two special columns, '_extract_date' and '_row_number', provide context for the data: the former shows when the data was extracted, the latter indicates the row number in the data extracted on the specified date. These two columns together uniquely identify each row. The table also contains multiple columns with geographic data, which can be used for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the...
Version History of ELY Areas 2019 (Scale 1:4,500,000)TSV
The 'table__history' is a rich data repository that captures the version history of its base table rows. It is part of the 'tilastointialueet_ely4500k_2019' dataset, which is sourced from the Finnish statistics agency, 'Tilastokeskus'. The information in this table is an invaluable resource for understanding the ELY Centres in Finland, as described by the data source. ELY Centres are responsible for the regional implementation and development of administrative sector tasks of the Finnish government. The table is composed of various columns that provide comprehensive details about each row from the base table. It includes geographic information, which could be utilized for geospatial data analytics. This geographic data is presented using the WGS 84 coordinate reference system, with axis...

Column Descriptions

Regional Development Areas in Finland, 2019 (Scale: 1:4,500,000)

Column	Type	Comment
_extract_date	date	The date when the data in the row was extracted from the source. This is a special column in the table.
_row_number	long	The row number in the data extracted from the source on the specific extract date. This is a special column in the table that, combined with the '_extract_date' column, uniquely identifies each row.
ely	string	A string representing the ELY code, which is a geographical identification code.
geom_geojson	string	A representation of the geographical shape of the ELY area in GeoJSON format.
geom_geotext	string	A textual representation of the geographical shape of the ELY area.
geom_type	string	The type of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. For example, 'ST_MULTIPOLYGON' indicates that the shape is a multipolygon.
geom_centroid	string	The geographical coordinates of the centroid (geographical center) of the ELY area.
geom_center_x	double	The x-coordinate (longitude) of the centroid of the ELY area.
geom_center_y	double	The y-coordinate (latitude) of the centroid of the ELY area.
gml_id	string	A unique identifier for the row, provided in the GML format.
id	long	A unique identifier for each row in the table, represented as an integer.
name	string	The English name of the ELY center.
namn	string	The name of the ELY center in Swedish.
nimi	string	The name of the ELY center in Finnish.
vuosi	long	The year when the data was collected, represented as an integer.

Version History of ELY Areas 2019 (Scale 1:4,500,000)

Column	Type	Comment
_start_date	date	This column marks the date when the row was extracted from the data source. It helps in tracking the chronology of the data extracted.
_end_date	date	This column indicates the date when a new version of the row was extracted from the data source. If the value here is null, it signifies 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 data source. It works in conjunction with '_start_date' to uniquely identify each row in this version history table.
ely	string	This refers to a unique identifier for different regions in Finland.
geom_geojson	string	This column contains the geometrical representation of the region in GeoJSON format.
geom_geotext	string	This column contains the geometrical representation of the region in text format.
geom_type	string	This column specifies the type of geometry used for the region, for example, 'ST_MULTIPOLYGON'.
geom_centroid	string	This column provides the centroid or the geometric center of the region.
geom_center_x	double	This column shows the x-coordinate of the geometric center of the region.
geom_center_y	double	This column shows the y-coordinate of the geometric center of the region.
gml_id	string	This is a unique identifier for each row in the table.
id	long	This is the numerical ID for each row in the table.
name	string	This column contains the English name of the region.
namn	string	This column contains the name of the region in Swedish.
nimi	string	This column contains the name of the region in Finnish.
vuosi	long	This column represents the year to which the data pertains.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024