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

Statistical Service Interface (WFS) 2013 Dataset Collection

The dataset collection is a comprehensive compilation of related data tables derived from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. The tables in the collection provide a wealth of information, organised in an easy-to-digest tabulated format. Each table is composed of interconnected rows and columns, each filled with related data. The dataset was originally presented in Finnish, however, for the purpose of accessibility, it has been translated into English. 'Tilastokeskus' is a reliable data source, well-known for its statistical interface (WFS). This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • AVI Regions 2013 Dataset (1:4 500 000 Scale)TSV

    The table is part of a larger dataset collection and contains data related to the administrative regions in Finland for the year 2013. It includes a variety of columns with different types of data. Some key columns include the date of data extraction, the row number, and geographic information. The table has a special column that notes the date when the data was extracted, allowing users to understand the timeline of the dataset's creation. Another column provides the specific row number of each entry, ensuring each row's uniqueness in the table. In addition, the table presents geographic data in several formats, including GeoJSON, geotext, and coordinates. This geospatial information, provided in the WGS 84 coordinate reference system, can be utilized to perform in-depth geographic...

  • History of AVI Areas 2013 (1:4 500 000) Version ChangesTSV

    The 'table__history' is part of a dataset collection aimed at preserving and providing insights into historical data. This particular table serves as a historical archive for its base table, storing a version history of each row. The table is a rich source of information, presenting data related to the AVI regions in 2013 at a scale of 1:4,500,000. The content of the table can be broadly classified into three categories: version information, geographical data, and general information. The version information includes details about when a row was extracted from the data source and when a new version of the row was extracted. This is made possible through a combination of the 'start date' and 'end date' columns, which also enable the unique identification of each row in the history...

Column Descriptions

AVI Regions 2013 Dataset (1:4 500 000 Scale)

Column Type Comment
_extract_date date This column holds the date when the data on the row of the table was extracted from the source. It aids in uniquely identifying each row in combination with the '_row_number' column.
_row_number long This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It assists in uniquely identifying each row when used in combination with the '_extract_date' column.
avi string This string type column holds some unique identifiers, possibly related to the geographical area.
geom_geojson string This column contains geographical data in the GeoJSON format, which represents simple geographical features.
geom_geotext string This column holds geographical data in a textual format. The data appears to represent various multi-polygon geographical shapes.
geom_type string This column specifies the type of the geographical data present in the table. For example, 'ST_MULTIPOLYGON' represents a type of complex geographical shape.
geom_centroid string This column contains the coordinates of the centroid, or geometric center, of the geographical shape represented in the row.
geom_center_x double This column holds the x-coordinate of the geometric center of the geographical shape represented in the row.
geom_center_y double This column holds the y-coordinate of the geometric center of the geographical shape represented in the row.
gid long This is an integer type column that may serve as a unique identifier for each row.
gml_id string This string type column seems to contain a unique identifier for each geographical shape represented in the table.
name string This column contains names in English, possibly of the geographical areas represented in the table.
namn string This column contains names in a non-English language, possibly Finnish or Swedish, which may correspond to the geographical areas represented in the table.
nimi string This column contains names in another non-English language, possibly Finnish, which may correspond to the geographical areas represented in the table.
vuosi long This integer type column holds what appears to be years, possibly indicating the year of data collection or a relevant event for the geographical area.

History of AVI Areas 2013 (1:4 500 000) Version Changes

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It is part of a unique identifier for each row in this version history table, along 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 represents the row number 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 is a string type column and it is likely to represent a code or identifier corresponding to a particular region or area.
geom_geojson string This column contains geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext string This column contains geographical data represented as text. It is likely to correspond to the 'geom_geojson' column.
geom_type string This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this table, it appears to be 'ST_MULTIPOLYGON', indicating that the geographical data represents multiple polygons.
geom_centroid string This column contains the geographical coordinates of the centroid, or geometric center, of the geographic areas represented by the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x double This column contains the x-coordinate (longitude) of the geometric center of the geographic areas represented by the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y double This column contains the y-coordinate (latitude) of the geometric center of the geographic areas represented by the 'geom_geojson' and 'geom_geotext' columns.
gid long This is an integer type column. It could be an identifier for the geographical areas represented in the 'geom_geojson' and 'geom_geotext' columns.
gml_id string This is a string type column. It seems to be a unique identifier for each row in this table.
name string This is a string type column, containing the English names of the regions or areas represented in the rows.
namn string This is a string type column, containing the names of the regions or areas in a different language, possibly Swedish.
nimi string This is a string type column, containing the names of the regions or areas in a different language, possibly Finnish.
vuosi long This is an integer type column. It could represent the year associated with the data in the row, based on the sample values provided.

Additional Info

Last Updated November 26, 2024
Created November 8, 2024