1. Home
  2. Datasets
  3. Statistics Bureau Service ...
To download the data set, please sign up or log in

Statistics Bureau Service Interface (WFS) - Dataset Collection

This dataset collection is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The data tables in the collection provide a wealth of statistical information. The data, organized in a table format consisting of columns and rows, was originally provided via Tilastokeskuksen palvelurajapinta (Statistics Finland's service interface). Each table in the collection presents a unique set of related data, making this collection a versatile and valuable resource for various data analysis tasks. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • Regional Administrative Agencies Areas 2020 (Scale 1:1 000 000)TSV

    The table under consideration is a part of a larger dataset collection and comprises data related to AVI regions in 2020 at a scale of 1:1,000,000. It is sourced from the website of the Statistical Centre (Tilastokeskus) in Finland. The table contains key columns that store specific data such as the AVI region identifier, the name of the AVI region in multiple languages, and the year of data collection. The table also includes geospatial data columns that contain geographic coordinates in the WGS 84 coordinate reference system, which positions longitude first, followed by latitude. This geospatial data can be useful for geospatial data analytics. For instance, it can be used to visualize the spatial distribution of AVI regions on a map or to analyze geographic trends and patterns. Two...

  • Version History of AVI Regions 2020 (Scale 1:1,000,000)TSV

    The 'table__history' is a comprehensive record of the version history of AVI areas in 2020 at a scale of 1:1 000 000, sourced from the 'Tilastokeskus' (Statistics Finland) website. The table is part of the 'tilastointialueet_avi1000k_2020' dataset collection. It contains geographic data, which can be analyzed to gain a spatial understanding of different regions within Finland. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The table also includes unique identifiers for each row, along with the start and end dates for each version of the row. If the end date for a row is null, it signifies that the row is the most recent version. This feature enables tracking changes over time and...

Column Descriptions

Regional Administrative Agencies Areas 2020 (Scale 1:1 000 000)

Column Type Comment
_extract_date date The date when the data on the row was extracted from the source. This is part of the unique identifier for each row along with the '_row_number'.
_row_number long The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This is part of the unique identifier for each row along with the '_extract_date'.
avi string An identifier for the administrative region. Example values include 6, 2, 1, 7.
geom_geojson string The geographical coordinates in geojson format. Represents the shape of the administrative region.
geom_geotext string The geographical coordinates in text format. Represents the shape of the administrative region.
geom_type string The type of the geographical shape. In this table, it is 'ST_MULTIPOLYGON', representing multiple polygon shapes.
geom_centroid string The geographical point that represents the center of the administrative region.
geom_center_x double The x-coordinate of the geographical center of the administrative region.
geom_center_y double The y-coordinate of the geographical center of the administrative region.
gml_id string A unique identifier for each row, example values include avi1000k_2020.fi..6be_784b, avi1000k_2020.fi..6be_784a.
id long An integer identifier for each row. Example values include 6, 2, 1, 7.
name string The English name of the administrative region. Example names include 'Lapland AVI', 'Southwestern Finland AVI', 'Southern Finland AVI', 'State Department of Åland'.
namn string The name of the administrative region in the local language.
nimi string The Finnish name of the administrative region. Example names include 'Lapin AVI', 'Lounais-Suomen AVI', 'Etelä-Suomen AVI', 'Ahvenanmaan valt..nvirasto'.
vuosi long The year of the data. All sample values are 2020 in this table.

Version History of AVI Regions 2020 (Scale 1:1,000,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 combination 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 implies that the row is the most recent version.
_row_number long This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with '_start_date'.
avi string This column contains a string value, possibly representing a specific region or area.
geom_geojson string This column contains geometric data in GeoJSON format, possibly representing the geographic boundaries of the area defined in the 'avi' column.
geom_geotext string This column contains geometric data in text format, likely mirroring the data in the 'geom_geojson' column.
geom_type string This column specifies the type of the geometric data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column contains the geographical point that represents the center of the area defined in the 'avi' column.
geom_center_x double This column contains the X-coordinate of the geographical center of the area defined in the 'avi' column.
geom_center_y double This column contains the Y-coordinate of the geographical center of the area defined in the 'avi' column.
gml_id string This is a unique string identifier for each row.
id long This is a unique integer identifier for each row.
name string This column contains the name of the area defined in the 'avi' column in English.
namn string This column contains the name of the area defined in the 'avi' column in Swedish.
nimi string This column contains the name of the area defined in the 'avi' column in Finnish.
vuosi long This column contains an integer value, possibly representing the year of the data.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024