Statistical Areas Dataset Collection 2023

This dataset collection is a compilation of related data tables, each organized in a tabular format with columns and rows. They are sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. The dataset provided by this source is described as the 'Statistical service interface (WFS)'. This description indicates that the dataset provides statistical data, possibly related to a variety of sectors or aspects, accessible through a Web Feature Service (WFS). This makes it a potentially rich source of information for a variety of analytical purposes. 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 2023: Geospatial Information at 1:1 000 000 ScaleTSV
The table, part of the dataset collection, represents the ELY (Centre for Economic Development, Transport and the Environment) areas in Finland for the year 2023, as indicated by the Finnish Statistical Central Office (Tilastokeskus). The data is organized into various columns that include unique identifiers, geographical descriptions, and other relevant information. Each row in the table is uniquely identified by a combination of the extract date and the row number, indicating the date when the data was extracted and its sequence in the extraction process. The geographic information, stored in the columns that start with 'geom_', is crucial for geospatial data analytics. These details are represented using the WGS 84 coordinate reference system, with the axis order being longitude...
Historical Versioning of ELY Areas 2023 (1:1,000,000 Scale) Data TableTSV
The 'table__history' is a rich repository of version history data, meticulously organized as part of the 'tilastointialueet_ely1000k_2023' dataset collection. This table serves as a historical archive, preserving each version of its base table rows, which pertain to the ELY areas 2023. The data is sourced from the website of Statistics Finland (Tilastokeskus). Each row in this table is uniquely identified by a combination of a '_start_date', which marks the date of extraction from the source, and a '_row_number', indicating the row's position in the raw data. The table also includes an '_end_date' column that signifies when a new version of the row was extracted, helping track changes over time. If this column's value is null, it implies that the row is the most recent version. An...

Column Descriptions

ELY Areas 2023: Geospatial Information at 1:1 000 000 Scale

Column	Type	Comment
_extract_date	date	This column contains the date when the row's data was extracted from the data source. It provides a way to understand when the data was last updated. The date is in the format YYYY-MM-DD.
_row_number	long	This column contains the row number of the extracted data, which combined with the '_extract_date' column, can be used to uniquely identify each row in the table.
ely	string	This column refers to a code, likely representing a specific geographic area or entity within Finland.
geom_geojson	string	This column contains geographical data in GeoJSON format, a common format used for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geographical data in text format. This could be coordinates or other forms of spatial data.
geom_type	string	This column specifies the type of geographical data stored in the row. The types include 'ST_MULTIPOLYGON' and 'ST_POLYGON', indicating complex geographic structures.
geom_centroid	string	This column contains the centroid of the geographical object. The centroid is the geometric center of a plane figure or shape.
geom_center_x	double	This column contains the x-coordinate (longitude) of the geographical object's center.
geom_center_y	double	This column contains the y-coordinate (latitude) of the geographical object's center.
gml_id	string	This column contains a unique identifier for each row. It appears to include a reference to the dataset collection ('ely1000k_2023') and a unique code.
id	long	This column contains an integer identifier for each row. It may be used for indexing and referencing purposes.
name	string	This column contains the English name of the entity associated with the row. The names seem to correspond to different regions or entities within Finland.
namn	string	This column contains the name of the entity in another language, likely Swedish, considering Finland's bilingual status.
nimi	string	This column contains the name of the entity in Finnish.
vuosi	long	This column contains the year associated with the data in the row. The sample year is 2023, indicating that the data is either projected or current up to that year.

Historical Versioning of ELY Areas 2023 (1:1,000,000 Scale) Data Table

Column	Type	Comment
_start_date	date	This column contains 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 column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates 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. Together with '_start_date', it forms a unique identifier for each row.
ely	string	This column contains a string representation of a unique identifier for each region.
geom_geojson	string	This column contains the geojson formatted geographical data of the regions.
geom_geotext	string	This column contains the geotext formatted geographical data of the regions.
geom_type	string	This column specifies the type of the geographical data (either 'ST_MULTIPOLYGON' or 'ST_POLYGON').
geom_centroid	string	This column contains the centroid points of the geographical data.
geom_center_x	double	This column contains the X coordinate of the center point of the geographical data.
geom_center_y	double	This column contains the Y coordinate of the center point of the geographical data.
gml_id	string	This column contains a unique string identifier for each row.
id	long	This column contains a unique integer identifier for each region.
name	string	This column contains the English names of the regions.
namn	string	This column contains the Swedish names of the regions.
nimi	string	This column contains the Finnish names of the regions.
vuosi	long	This column contains the year of the data, represented as an integer.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024