Statistics Finland's Web Service Interface (WFS) Dataset Collection 2022

The dataset collection is a comprehensive assembly of interrelated data tables sourced from the Statistics Centre (Tilastokeskus) website in Finland. It consists of valuable statistical data gathered through a service interface, as described by the data source. The collected data is meticulously organized into tables, each comprising of related data presented in a structured format of columns and rows. This structured format facilitates easy data analysis and interpretation. The dataset collection contains several such tables, each providing a unique perspective and insight into the collected data, making it a rich resource for statistical 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

Large Areas 2022 (Scale 1:4,500,000) - Dataset TableTSV
The table, which is part of the 'tilastointialueet_suuralue4500k_2022' dataset collection, comprises data organized into several columns and rows. The table provides information on the 'Large Areas 2022', a geographical classification that is useful for spatial data analysis. The data in the table is sourced from the 'Tilastokeskus' website based in Finland. The table comprises a number of columns, each providing different types of information. Special columns such as '_extract_date' and '_row_number' are included, recording the date of data extraction and the row number, respectively. This combination uniquely identifies each row in the table. Some of the columns provide geographical data, including geographic coordinates presented using the WGS 84 coordinate reference system. This...
Version History of Large Areas 2022 (1:4 500 000) DatasetTSV
The 'History' table is a rich source of geospatial data, forming part of the 'Large Area Statistics' dataset. It provides a comprehensive record of changes over time, housing the version history of its base table rows. This table proves particularly invaluable for analysts keen on tracking temporal trends and conducting historical comparisons. The table's data content centers around large areas for the year 2022 at a scale of 1:4,500,000. Each row in the table represents a version of the base table row, with unique identifiers established through a combination of the row number and the start date. Among the notable features of this table are the start and end dates, indicating when data was extracted and when a new version was extracted, respectively. A null value in the end date...

Column Descriptions

Large Areas 2022 (Scale 1:4,500,000) - Dataset Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted. It helps in understanding the data collection period.
_row_number	long	This column contains the row number in the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains the geographical data in GeoJSON format. It helps in representing and visualizing complex geographical structures.
geom_geotext	string	This column holds the geographical data as text. It's primarily for representing the geographical data in a human-readable format.
geom_type	string	This column specifies the type of the geographical data. In our table, it's 'ST_MULTIPOLYGON', representing a shape formed of multiple polygons.
geom_centroid	string	This column contains the geometric centroid of the multipolygon. It's useful in determining the geographic center of the area.
geom_center_x	double	This column holds the x-coordinate of the geographical center. Along with 'geom_center_y', it provides the exact location of the center.
geom_center_y	double	This column holds the y-coordinate of the geographical center. It's used in conjunction with 'geom_center_x' to pinpoint the center of the area.
gml_id	string	This column contains a unique identifier for each row in the table.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
suuralue	string	This column contains a numeric identifier for the area.
vuosi	long	This column contains the year pertaining to the data. It helps in understanding the time relevance of the data.

Version History of Large Areas 2022 (1:4 500 000) Dataset

Column	Type	Comment
_start_date	date	This column records the date when the row was extracted from the data source. It forms a unique identifier for each row in combination with '_row_number'.
_end_date	date	This column records 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 records the number of the row in the raw data extracted from the Data Statistics Finland (Tilastokeskus) source. It forms a unique identifier for each row in combination with '_start_date'.
geom_geojson	string	This column contains the geographic information of the large area (suuralue) in GeoJSON format.
geom_geotext	string	This column contains the geographic information of the large area (suuralue) in text format.
geom_type	string	This column records the type of geometric representation used for the large area (suuralue).
geom_centroid	string	This column records the centroid point of the geometric representation of the large area (suuralue).
geom_center_x	double	This column records the x-coordinate of the center point of the geometric representation of the large area (suuralue).
geom_center_y	double	This column records the y-coordinate of the center point of the geometric representation of the large area (suuralue).
gml_id	string	This column records a unique identifier for each large area (suuralue).
name	string	This column records the name of the large area (suuralue) in English.
namn	string	This column records the name of the large area (suuralue) in Swedish.
nimi	string	This column records the name of the large area (suuralue) in Finnish.
suuralue	string	This column records an identifier for each large area (suuralue).
vuosi	long	This column records the year of the data entry.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024