Statistics Central Service Interface (WFS) 2020 Data Collection

This dataset collection encompasses a group of interrelated tables sourced from the Statistics Centre (Tilastokeskus) in Finland. The tables contain a wealth of information pulled from the Statistics Centre's service interface (WFS). The data is meticulously organized into columns and rows within the tables, each one presenting a comprehensive view of specific statistical areas. The data within this collection provides a detailed insight into various statistical areas, making it an invaluable resource for anyone seeking thorough knowledge in this domain. 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 of Municipalities 2020 (1:1 000 000): Version History of Base Table RowsTSV
The 'table__history' is a meticulous compilation of data that traces the version history of its base table rows, which is particularly critical for tracking changes over time. Originating from 'Tilastokeskus' (Statistics Finland), the table forms an integral part of the 'tilastointialueet_kunta1000k_2020' dataset collection. The base table contents, defined as 'Kunnat 2020 (1:1 000 000)', translate to 'Municipalities 2020 (1:1 000 000)' in English, which provides a glimpse into the geographical distribution of municipalities in Finland during the year 2020. Each row in the table is uniquely identified by the combination of start date and row number, allowing for efficient data extraction and version tracking. The start and end dates indicate when the row was extracted from the source...
Municipalities 2020 (Scale 1:1,000,000) - Data TableTSV
The 'table' is part of the 'tilastointialueet_kunta1000k_2020' dataset collection. The table comprises of structured data focusing on municipalities in 2020, as described by the original data source, 'Tilastokeskus' from Finland. Each row in the table represents a unique data entry, identifiable by the combination of two special columns, 'extract_date' and '_row_number'. The '_extract_date' indicates the date when the data was extracted, and the '_row_number' represents the row number in the data extracted on the specified date. The data contained within the table is enriched with a variety of columns providing detailed information about each municipality. This includes its name, ID, geographic coordinates, and more. The table also includes multiple columns starting with 'geom', which...

Column Descriptions

Municipalities 2020 (Scale 1:1,000,000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It helps in keeping track of the data extraction history.
_row_number	long	This column holds the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column stores the geometric representation of the data in GeoJSON format. This format is useful for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric data in text format. It provides another way to visualize the geographic data.
geom_type	string	This column specifies the type of the geometric data. It helps in understanding the nature of the geographic data.
geom_centroid	string	This column includes the centroid of the geometric data. The centroid is the geographical center point of the data.
geom_center_x	double	This column contains the x-coordinate of the center of the geometric data. It aids in pinpointing the geographic location.
geom_center_y	double	This column holds the y-coordinate of the center of the geometric data. It helps in locating the geographic position.
gml_id	string	This column includes a unique identifier for each row. It helps in easy identification and referencing of the data.
kunta	string	This column stores a string value. The exact meaning and use of this column are not provided by the data source.
name	string	This column includes the name associated with the data. It could be the name of a place, person, event, or other entities.
namn	string	This column contains a string value. The specific meaning and usage of this column are not provided by the data source.
nimi	string	This column holds a string value. The exact meaning and use of this column are not provided by the data source.
vuosi	long	This column contains an integer value. The specific meaning and use of this column are not provided by the data source.

History of Municipalities 2020 (1:1 000 000): Version History of Base Table Rows

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in the history table.
_end_date	date	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	The number of the row in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in the history table.
geom_geojson	string	Contains the geometry of the feature in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext	string	Contains the geometry of the feature in Well-known text (WKT) format. WKT is a text markup language for representing vector geometry objects.
geom_type	string	Indicates the type of the geometry. For example, 'ST_POLYGON' represents a polygon.
geom_centroid	string	Contains the centroid coordinates of the feature. The centroid is the geometric center of a shape.
geom_center_x	double	Contains the x-coordinate value of the geometric center of the feature.
geom_center_y	double	Contains the y-coordinate value of the geometric center of the feature.
gml_id	string	A unique identifier for each row in the table. The ID is given by the data source.
kunta	string	A code representing the municipality. This is a string value as provided by the data source.
name	string	The name of the municipality in English.
namn	string	The name of the municipality in Swedish.
nimi	string	The name of the municipality in Finnish.
vuosi	long	The year the data was collected. This is an integer value.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024