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

Statistics Service Interface (WFS) Dataset Collection 2014

The dataset collection in question comprises of related data tables sourced from the website of 'Tilastokeskus' (Statistical Centre), based in Finland. These tables contain valuable information provided through the Statistical Centre's service interface (WFS). The collection is organized into an accessible table format, making it easy to navigate through the columns and rows of data. This dataset collection is an invaluable resource for those looking for comprehensive statistical data from 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

  • Regional Administrative Agencies (AVI) Areas 2014 at 1:1,000,000 ScaleTSV

    The table, which is part of a larger dataset collection, contains detailed geospatial data pertaining to regions in Finland, specifically the AVI regions for the year 2014. The data has been sourced from the 'Tilastokeskus' (Statistics Finland) website. The table's comprehensive data includes unique identifiers, regional names in various languages, the year of data, and specific geospatial details. Each row in the table is distinctively identified by a unique combination of an extraction date and a row number. The table also contains several columns starting with 'geom_' that hold geographic information, crucial for geospatial data analytics. This geospatial data is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude....

  • Version History of AVI Areas 2014 (1:1 000 000) DataTSV

    The 'table__history' is a rich repository of information that forms an integral part of the dataset collection 'tilastointialueet_avi1000k_2014'. This table is specifically a history table that keeps track of the version history of its base table rows. It is contributed by 'Tilastokeskus' from Finland and contains comprehensive geographical data presented in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table's data content is aligned with the AVI-areas 2014 (1:1 000 000) theme and includes geographic information in various formats, which can be valuable for geospatial data analytics. It provides details on areas represented by different IDs, their names in various languages, and their geographical details in the form of coordinates....

Column Descriptions

Regional Administrative Agencies (AVI) Areas 2014 at 1:1,000,000 Scale

Column Type Comment
_extract_date date This column denotes the date when the data on the row was extracted from the data source. It forms a part of a unique identifier for each row when combined with '_row_number'.
_row_number long This column represents the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It forms a part of a unique identifier for each row when combined with '_extract_date'.
avi string This is a numerical column which seems to be associated with different regions of Finland.
geom_geojson string This column contains geometric data in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext string This column contains geometric data in text format, specifically, it represents multiple geographic polygons.
geom_type string This column states the type of the geometric data stored in the table. In this case, the data type is 'ST_MULTIPOLYGON', indicating that the data consists of multiple polygons.
geom_centroid string This column contains the central point (centroid) for each geographic polygon expressed as a point in a 2D space.
geom_center_x double This column represents the x-coordinate of the central point (centroid) for each geographic polygon.
geom_center_y double This column represents the y-coordinate of the central point (centroid) for each geographic polygon.
gml_id string This column contains unique identifiers for each row in the table.
name string This column contains the names of the regions in Finland in English.
namn string This column contains names of the regions in Finland in Swedish.
nimi string This column contains names of the regions in Finland in Finnish.
vuosi long This column, meaning 'year' in Finnish, likely represents the year the data was collected or relevant to.

Version History of AVI Areas 2014 (1:1 000 000) Data

Column Type Comment
_start_date date This column represents the date when the row was extracted from the data source. It is a part of a unique identifier for each row in this history table in combination 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 of this column is null, it indicates 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 for each row in combination with the '_start_date' column.
avi string This column holds a string value, representing a certain attribute of the table's base data.
geom_geojson string This column contains geometric data in GeoJSON format. This data often represents geographical shapes.
geom_geotext string This column contains geometric data as text, typically representing geographical shapes in a spatial reference system.
geom_type string This column defines the type of the geometric data contained in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column contains the central point of the geometric shapes defined in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x double This column represents the X coordinate of the center point of the geometric shapes.
geom_center_y double This column represents the Y coordinate of the center point of the geometric shapes.
gml_id string This column contains a unique identifier for each row of the table. This identifier is typically used in Geographic Markup Language (GML) format data.
name string This column contains the English names of the entities represented by the rows in the table.
namn string This column contains the names of the entities represented by the rows in the table in a different language (likely Swedish, given the source of the data).
nimi string This column contains the names of the entities represented by the rows in the table in yet another language (likely Finnish, given the source of the data).
vuosi long This column holds integer values, likely representing the year associated with the data in the row.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024