Statistics Bureau Web Service Interface (WFS) Dataset Collection 2020

This dataset collection comprises a series of related data tables sourced from the website of 'Tilastokeskus' (Statistics Finland), based in Finland. The tables within this collection contain data retrieved from the Statistics Finland's service interface (WFS). The content of the tables is organized in a structured format with rows and columns, showcasing a correlation between different sets of data. The collection, while primarily intended for statistical analysis, can be utilized in a variety of ways, depending on the specific needs of the user. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Version Records for Subregions 2020 (1:4 500 000)TSV
The 'table__history' is part of a larger dataset collection and represents a historical record of its base table rows, providing a timeline of changes. This table is particularly useful for version control, allowing users to track changes over time to each specific row, identified by a unique combination of a start date and a row number. The start date indicates when the row data was extracted, and the end date signifies when a new version of the same row was updated. If the end date is null, it denotes that the data in the row is the most current. The table holds geographical data, specifically pertaining to regions in Finland, as sourced from the Finnish Statistics Bureau, 'Tilastokeskus'. This geographic data includes attributes like polygonal and multipolygonal shapes, centroid...
Regional Units 2020 (Scale 1:4 500 000) - Structured Data CollectionTSV
The table, part of the dataset collection 'tilastointialueet_seutukunta4500k_2020', contains a rich set of data, primarily geographic, about the Regions (Seutukunnat) in Finland as of the year 2020 at a scale of 1:4,500,000. It comprises a variety of columns including dates of data extraction, row numbers, geographical coordinates, and specific identifying information of each region. The dataset is sourced from the 'Statistics Finland' (Tilastokeskus) website, based in Finland, ensuring reliable and accurate data. The data within the table can be used to conduct geographical and statistical analysis. For example, the geographic coordinates, presented using the WGS 84 coordinate reference system with axis order longitude first, followed by latitude, can be utilized for geospatial data...

Column Descriptions

Regional Units 2020 (Scale 1:4 500 000) - Structured Data Collection

Column	Type	Comment
_extract_date	date	This column records the date when the data on each row was extracted from the source. This is part of a unique identifier for each row when combined with the '_row_number'.
_row_number	long	This column contains the numerical row identifier in the data extracted from the source on the date specified by the '_extract_date' column. This is part of a unique identifier for each row when combined with the '_extract_date'.
geom_geojson	string	This column holds geometric data for the statistical areas in the GeoJSON format, a popular open standard format designed for representing simple geographical features, along with their non-spatial attributes.
geom_geotext	string	This column contains the geometric data for the statistical areas in Well-known text (WKT) representation of geometry.
geom_type	string	This column specifies the type of geometric data used, in this case, polygon data which represents the borders of statistical areas.
geom_centroid	string	This column contains the geometric center or 'centroid' of the statistical areas in WKT format.
geom_center_x	double	This column records the X coordinate (longitude) of the geometric center of the statistical areas.
geom_center_y	double	This column records the Y coordinate (latitude) of the geometric center of the statistical areas.
gml_id	string	This column contains the unique Global Monitoring for Environment and Security ID for the statistical areas.
name	string	This column contains the English names of the statistical areas.
namn	string	This column contains the names of the statistical areas in another language.
nimi	string	This column contains the Finnish names of the statistical areas.
seutukunta	string	This column contains specific codes for the statistical areas.
vuosi	long	This column records the year for which the data was collected.

Historical Version Records for Subregions 2020 (1:4 500 000)

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 in conjunction with the '_row_number' column.
_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 extracted from the raw data. It is part of the unique identifier in combination with the '_start_date' column.
geom_geojson	string	This column contains the geographical information represented in GeoJSON format. The values could be polygons or multipolygons, representing specific areas.
geom_geotext	string	This column contains the geographical information in text format. The text is a representation of the geometry of the areas.
geom_type	string	This column specifies the type of the geographical information. It could be either a polygon or a multipolygon.
geom_centroid	string	This column contains the geographical point that represents the center of the geometrical shape. It is represented in POINT format.
geom_center_x	double	This column contains the X-coordinate of the center point of the geometrical shape.
geom_center_y	double	This column contains the Y-coordinate of the center point of the geometrical shape.
gml_id	string	This column contains the unique identifier of the row. The identifier is a string value.
name	string	This column contains the names of the areas.
namn	string	This column contains the names of the areas in a different language.
nimi	string	This column contains the names of the areas in another language.
seutukunta	string	This column contains string values. The specific meaning of these values is not provided by the data source.
vuosi	long	This column contains integer values representing years. The specific context of these years is not provided by the data source.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024