Statistical Regions ELY1000k 2024 Data Collection from Finland's Statistical Service Interface (WFS)

The dataset collection in focus consists of a group of related tables. These tables contain data sourced from the website of Tilastokeskus (Statistics Finland), based in Finland. The contents of the tables stem from a service interface, as described by the data source. This collection is significant as it brings together relevant data, organized in a tabular format with rows and columns, that allows for efficient analysis and interpretation. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

History and Version Records of ELY Areas 2024 (1:1 000 000) TableTSV
The 'table__history' is a part of the 'tilastointialueet_ely1000k_2024' dataset collection. This history table encapsulates the version history of the base table rows offering a snapshot of changes over time. The data focuses on regions defined as ELY-alueet, translated as ELY areas, for the year 2024. The table is sourced from 'Tilastokeskus' (Statistics Finland) and contains a variety of data types, including geographic and temporal data. The table features a unique identifier combination of 'start_date' and '_row_number', representing the date of extraction from the source and the row number in the raw data, respectively. The '_end_date' column indicates when a new version of a row was extracted, with a null value signifying the most recent row version. Data analytics can utilize the...
Regions of the ELY Centres in Finland for 2024 at 1:1 Million ScaleTSV
The table in question forms part of a wider dataset collection related to ELY areas in 2024 at a scale of 1:1 000 000. Sourced from the website of Statistics Finland ('Tilastokeskus') in Finland, the table contains various pieces of data organized into rows and columns. Each row of data is uniquely identified by a combination of the extraction date and row number. This allows for precise tracking and referencing of data changes over time. The table also contains several geographical columns, useful for geospatial data analytics. These geographical data points, indicated by the prefix 'geom_', are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These include data points such as the geojson, geotext, and type of the...

Column Descriptions

Regions of the ELY Centres in Finland for 2024 at 1:1 Million Scale

Column	Type	Comment
_extract_date	date	This column contains the date when the data in each row was extracted from the source. It forms a unique identifier for each row when combined with the '_row_number' column.
_row_number	long	This column contains the row number, unique to the extracted data from the source on a specific extract date as indicated by the '_extract_date' column.
ely	string	This column contains a string representation of the ELY (Centre for Economic Development, Transport and the Environment) code.
geom_geojson	string	This column contains the geometric data of the ELY region in GEOJSON format.
geom_geotext	string	This column contains the geometric data of the ELY region in a text format.
geom_type	string	This column specifies the type of the geometric data, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	This column provides the centroid, or geometric center, of the ELY region.
geom_center_x	double	This column provides the X-coordinate of the geometric center of the ELY region.
geom_center_y	double	This column provides the Y-coordinate of the geometric center of the ELY region.
gml_id	string	This column contains the unique GML identifier for each row.
id	long	This column contains an integer identifier.
name	string	This column contains the English name of the ELY center.
namn	string	This column contains the name of the ELY center in another language.
nimi	string	This column contains the Finnish name of the ELY center.
vuosi	long	This column contains the year (as an integer) associated with the data row.

History and Version Records of ELY Areas 2024 (1:1 000 000) Table

Column	Type	Comment
_start_date	date	The date when the row data was initially extracted from the source, providing a timestamp for the version of the data in the row.
_end_date	date	The date when a new version of the row data was extracted. If this column is null, it implies that the data in the row represents the most recent version.
_row_number	long	The row number in the raw data from the source. Together with '_start_date', these two columns form a unique identifier for each row in this version history table.
ely	string	The code representing a specific ELY Centre, a regional body responsible for various administrative tasks in Finland.
geom_geojson	string	The geographic shapes representing the ELY Centre's area of responsibility, formatted as GeoJSON, a standard data format for encoding geographic data structures.
geom_geotext	string	The geographic shapes representing the ELY Centre's area of responsibility, formatted as geotext.
geom_type	string	The type of geometric shape used to represent the ELY Centre's area of responsibility. This could be a polygon or a multipolygon.
geom_centroid	string	The centroid or geometric center of the shape representing the ELY Centre's area of responsibility.
geom_center_x	double	The X coordinate of the geometric center of the shape representing the ELY Centre's area of responsibility.
geom_center_y	double	The Y coordinate of the geometric center of the shape representing the ELY Centre's area of responsibility.
gml_id	string	The unique identifier for the row in GML (Geography Markup Language) format.
id	long	The unique identifier for each ELY Centre.
name	string	The English name of the ELY Centre.
namn	string	The Swedish name of the ELY Centre.
nimi	string	The Finnish name of the ELY Centre.
vuosi	long	The year the data was recorded or relevant for, indicating the temporal aspect of the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024