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

Statistical Interface Service 2014 Dataset Collection

This dataset collection is a comprehensive group of related data tables sourced from the Statistics Centre (Tilastokeskus) in Finland. The information within these tables is organized in a structured manner, with data divided into columns and rows for easy accessibility and understanding. The contents of the dataset collection are provided through Statistics Centre's service interface (WFS). These data tables have been meticulously compiled to provide a detailed and thorough overview of the subject matter, making it an invaluable resource for research and 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

  • Statistical Areas 2014 (Scale 1:4 500 000)TSV

    The table provides data on AVI regions in 2014, at a scale of 1:4,500,000. This data is part of a larger collection of related tables, indicating a comprehensive approach to data organization. Key features of the table include temporal data, geographical coordinates, and specific regional information. The table includes a unique pair of columns, '_extract_date' and '_row_number', which together provide a precise reference point for each row of data. For instance, '_extract_date' specifies the date the data was extracted and '_row_number' indicates the row's position in the extracted data. Geographical information is a significant part of the table content. Columns starting with 'geom_' contain geographical data, which can be analyzed for spatial patterns and trends, such as regional...

  • Version History of AVI Regions 2014 (1:4 500 000)TSV

    The 'table__history' is a history table offering an important historical record of the dataset 'tilastointialueet_avi4500k_2014'. The data contained in this table provides the version history of its base table rows, making it a rich resource for tracking changes over time. The base table is titled as 'AVI-alueet 2014 (1:4 500 000)', which translates to 'AVI Areas 2014 (1:4 500 000)' in English, indicating the geographical focus of the dataset. The table records a variety of data, including geographical information with WGS 84 coordinate reference system, longitude first, followed by latitude, which can be utilized for geospatial data analytics. This can be seen in the columns beginning with 'geom_', which contains geographic information in various formats such as 'geojson', 'geotext'...

Column Descriptions

Statistical Areas 2014 (Scale 1:4 500 000)

Column Type Comment
_extract_date date This column contains the date when the data on the row was extracted from the source. It plays a crucial role in identifying each row of data uniquely in combination with the '_row_number' column.
_row_number long This column contains the row number for the data extracted from the source. It is used in conjunction with the '_extract_date' column to uniquely identify each row of data.
avi string This column signifies a unique string identifier.
geom_geojson string This is a geographical data column in GeoJSON format, representing geographical features.
geom_geotext string This is a geographical data column in geotext format, representing geographical features.
geom_type string This column specifies the type of the geography stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column records the centroid point of the geographical object being represented.
geom_center_x double This column represents the X coordinate of the center point of the geographical object.
geom_center_y double This column represents the Y coordinate of the center point of the geographical object.
gml_id string This column stores unique identification strings.
name string This column stores the name of the geographical area in English.
namn string This column stores the name of the geographical area in a foreign language.
nimi string This column stores the name of the geographical area in another foreign language.
vuosi long This column indicates the year associated with the data row.

Version History of AVI Regions 2014 (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 is part of the combination with '_row_number' that uniquely identifies each row in this version history table.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it means 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. This number, in combination with the '_start_date', uniquely identifies each row in this version history table.
avi string This column contains a string identifier, possibly related to a specific regional or administrative value.
geom_geojson string This column contains geographical data in the GeoJSON format. This data likely represents specific geographical areas.
geom_geotext string This column contains geographical data in the text format. This data likely represents specific geographical areas.
geom_type string This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column contains the geographical point that represents the center of the geographical area. The point is provided in the format 'POINT (longitude latitude)'.
geom_center_x double This column contains the longitude of the center of the geographical area.
geom_center_y double This column contains the latitude of the center of the geographical area.
gml_id string This column contains a unique string identifier for each row.
name string This column contains the name of the geographical area in English.
namn string This column contains the name of the geographical area in another language, possibly Swedish or Finnish.
nimi string This column contains the name of the geographical area in another language, possibly Finnish.
vuosi long This column contains an integer value, likely representing the year associated with the data in the row.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024