Statistics Bureau Interface (WFS) 2022: Dataset Collection on Statistical Regions

This dataset collection is a compilation of related data tables sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland. It offers a service interface (WFS) that provides statistical data. The data in this collection is arranged in table format, with each table comprising of columns and rows. The tables included in this collection offer comprehensive and related data, making this dataset an invaluable resource for those seeking statistical information. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

ELY Areas 2022 (1:1 000 000) - Table in Dataset Collection 'tilastointialueet_ely1000k_2022'TSV
The table, sourced from the 'Tilastokeskus' (Statistics Finland) website, presents a collection of data related to the ELY Centres in Finland as of 2022, providing valuable information for geographic and statistical analyses. The data is organized into a diverse range of columns, each serving a specific purpose. Two significant columns are '_extract_date' and '_row_number', which together, uniquely identify each row. The '_extract_date' indicates the date when the data was extracted, and the '_row_number' denotes the row number in the data extracted on that particular date. The table contains several columns prefixed with 'geom_', which hold geographic information. These columns provide a wealth of data for geospatial analysis, with geographic coordinates presented using the WGS 84...
ELY Regions 2022: Historical Versioning (1:1 000 000)TSV
The 'table__history' is a history table that stores the version history of its base table rows. It is part of the dataset collection 'tilastointialueet_ely1000k_2022'. The table provides a rich source of data that can be utilized for various data analytics purposes. For instance, the 'geom_' columns contain geographical information which can be used for geospatial data analytics. This includes data on geographic shapes and their types, centroids, and center coordinates. The data is presented using the WGS 84 coordinate reference system with longitude followed by latitude. The table also includes columns that store the start and end dates of each row extraction from the data source. A unique combination of the start date and the row number identifies each row in this history table. If...

Column Descriptions

ELY Areas 2022 (1:1 000 000) - Table in Dataset Collection 'tilastointialueet_ely1000k_2022'

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source. It helps to understand when the specific data was updated lastly.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This unique combination of '_extract_date' and '_row_number' helps to identify each row distinctly.
ely	string	This column contains a string value that represents a specific designation within the dataset. It appears to be a unique identifier or code for each row.
geom_geojson	string	This column contains GeoJSON data, which is a format for encoding a variety of geographic data structures. It is used to represent geometric objects such as points, lines, and shapes.
geom_geotext	string	This column contains geometric data in text format. This might represent the boundaries or coordinates of a geographical entity.
geom_type	string	This column designates the type of geometric data represented in the 'geom_geojson' and 'geom_geotext' columns. The types includes polygons and multipolygons.
geom_centroid	string	This column contains the geometric center or centroid of the geographical entity represented by the 'geom_geojson' and 'geom_geotext' columns. It is represented as a point.
geom_center_x	double	This column represents the x-coordinate of the centroid of the geographical entity.
geom_center_y	double	This column represents the y-coordinate of the centroid of the geographical entity.
gml_id	string	This column contains a unique identifier string for each row. It seems to be a technical identifier used for data management.
id	long	This column contains unique integer identifiers for each row. It may be used for indexing and data management.
name	string	This column contains the English names of the geographical entities represented in the dataset.
namn	string	This column contains names of the geographical entities in a non-English language, which may be the local or native language of the geographical area.
nimi	string	This column also contains names of the geographical entities in another non-English language, offering a multilingual approach to data representation.
vuosi	long	This column contains integer values representing the year associated with the data in the row. It might represent the year when the data was collected or the year the data refers to.

ELY Regions 2022: Historical Versioning (1:1 000 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, forming a unique identifier in combination with '_row_number'.
_end_date	date	The date when a new version of the row was extracted from the data source. If null, the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. Forms a unique identifier in combination with '_start_date'.
ely	string	String type column representing the ELY Centre code, a regional administration body in Finland.
geom_geojson	string	Geospatial data in GeoJSON format, representing the geographical boundary of the ELY Centre.
geom_geotext	string	Geospatial data in text format, representing the geographical boundary of the ELY Centre.
geom_type	string	The type of the geographical data represented, either a polygon or a multipolygon.
geom_centroid	string	The geographical center point of the ELY Centre boundary.
geom_center_x	double	The X coordinate of the geographical center point of the ELY Centre boundary.
geom_center_y	double	The Y coordinate of the geographical center point of the ELY Centre boundary.
gml_id	string	A unique string identifier for the data row.
id	long	Integer type column used as an identifier for the ELY Centre.
name	string	The English name of the ELY Centre.
namn	string	The name of the ELY Centre in Swedish.
nimi	string	The name of the ELY Centre in Finnish.
vuosi	long	Integer type column representing the year when the data was collected.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024