Statistics Centre Service Interface (WFS) - Dataset Collection 2020

The dataset collection is a comprehensive compilation of related data tables sourced from the 'Tilastokeskus' (Statistics Center) in Finland. The contents of this collection are derived from the Statistical Service Interface (WFS), providing insightful data relevant to large areas of statistical significance. Each table within this collection presents a wealth of organized data, structured in a coherent format of rows and columns for ease of analysis and interpretation. The dataset collection offers a robust and comprehensive data resource for those seeking detailed statistical data about significant geographic areas in Finland. 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 2020 (Scale 1:1 000 000) - Table from Dataset CollectionTSV
The table is part of a larger dataset collection, focusing on the large areas of Finland in 2020. The data in the table provides detailed geographic information, making it a valuable resource for geospatial data analytics. The geographic coordinates in the table are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table also provides unique identifiers for each entry by combining the date of data extraction and the row number. This allows for precise tracking and referencing of data. The table is sourced from the 'Tilastokeskus' (Statistics Finland) website. Examples of how this data could be utilized in analytics include identifying trends in regional data over time, mapping geographic patterns, or creating detailed...
Version History of Large Areas 2020 (1:1 000 000) TableTSV
The 'table__history' is a historical data table, part of a larger data collection named 'tilastointialueet_suuralue1000k_2020'. It is sourced from the Finnish 'Tilastokeskus' (Statistics Finland) website, and serves as a version history record of its corresponding base table. The table carries essential information about the 'Major Areas 2020' (Suuralueet 2020), presented at a scale of 1:1,000,000. It includes geographical details such as multi-polygonal geographic representations, the type of geometry, the geographic centroid, and the x and y coordinates of the geographic center. These geographic details are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. In addition, the table includes columns for the unique...

Column Descriptions

Large Areas 2020 (Scale 1:1 000 000) - Table from Dataset Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source. It aids in uniquely identifying each row in conjunction with the '_row_number' column.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in uniquely identifying each row when combined with the '_extract_date'.
geom_geojson	string	This column contains the geometric representation of data points in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric representation of data points in text format. It provides a textual representation of the geometric data present in the 'geom_geojson' column.
geom_type	string	This column indicates the type of geometric data recorded in the 'geom_geojson' and 'geom_geotext' columns, such as 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the central point, or centroid, of the geometric data represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column contains the x-coordinate (longitude) of the central point of the geometric data.
geom_center_y	double	This column contains the y-coordinate (latitude) of the central point of the geometric data.
gml_id	string	This column contains a unique identifier for each row of data.
name	string	This column contains the name of the geographic area represented by the data in English.
namn	string	This column contains the name of the geographic area represented by the data in Swedish.
nimi	string	This column contains the name of the geographic area represented by the data in Finnish.
suuralue	string	This column contains a numerical code representing the large area associated with the data row.
vuosi	long	This column contains the year associated with the data row.

Version History of Large Areas 2020 (1:1 000 000) Table

Column	Type	Comment
_start_date	date	This is the date when the row was extracted from the data source, marking the beginning of the version history for that specific row.
_end_date	date	This is the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version.
_row_number	long	This signifies the number of the row in the raw data as extracted from the data source. Together with '_start_date', this uniquely identifies each row in this version history table.
geom_geojson	string	This column contains Geographical data in GeoJSON format, which represents simple geographical features.
geom_geotext	string	This column contains Geographical data as text, often represented as shapes such as polygons.
geom_type	string	This represents the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns, for example, a multi-polygon.
geom_centroid	string	This is the centroid of the geographical data represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This represents the x-coordinate of the center of the geographical data.
geom_center_y	double	This represents the y-coordinate of the center of the geographical data.
gml_id	string	This is a unique identifier for each row in the table.
name	string	This is the English name of the region represented by the row.
namn	string	This is the Swedish name of the region represented by the row.
nimi	string	This is the Finnish name of the region represented by the row.
suuralue	string	This is a numeric identifier for the region represented by the row.
vuosi	long	This is the year of the data represented by the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024