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

Statistical Service Interface (WFS) - Large Area Statistics Collection

The dataset collection in question is a comprehensive assembly of related data tables sourced from Statistics Finland (Tilastokeskus). This collection includes several tables that contain related data, structured in a format that utilizes columns and rows for organization. The data within these tables is derived from the Statistics Finland's service interface (WFS). This collection provides a wealth of statistical information, potentially spanning various years, as suggested by the inclusion of 2013 and 2015 in some of the table names. Given the source, this dataset collection is likely to contain a wealth of valuable statistical data pertinent to 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

  • Large Areas Geospatial Data (Scale 1:1 000 000)TSV

    The table belongs to a dataset that contains information on 'Major Areas' at a 1:1,000,000 scale. This dataset is sourced from the 'Tilastokeskus' (Statistics Finland) website from Finland. The table encapsulates various types of data including geographical, temporal, and textual data. It has several columns that store distinct pieces of information. For instance, there are columns that provide the date when the data was extracted and the row number in the extracted data, which uniquely identify each row. There are also columns that contain geographical data, such as geographical coordinates, presented using the WGS 84 coordinate reference system, where longitude is presented first, followed by latitude. This information can be used for geospatial data analytics. Furthermore, the table...

  • Version History of Large Areas (1:1 000 000)TSV

    The 'table__history' is a comprehensive historical data table that belongs to the 'tilastointialueet_suuralue1000k' dataset collection. This table serves as a historical archive of the base table rows, preserving the version history of each row. The table presents a rich set of data features including geographic information and other attribute data. The major regions (1:1 000 000) of Finland, as provided by the Finnish national statistical institute 'Tilastokeskus', are the primary focus of the table. The table contains a unique combination of '_start_date' and '_row_number' for each row, marking the extraction date of the row from the data source and the row's position in the raw data respectively. This combination enables each row in the table to be distinctly identified....

Column Descriptions

Large Areas Geospatial Data (Scale 1:1 000 000)

Column Type Comment
_extract_date date This column captures the date when the data on the row of the table was extracted. This helps track the timeliness of each data entry.
_row_number long This column represents the row number in the data extracted. It, along with the '_extract_date', uniquely identifies each row.
geom_geojson string This column holds geographical data in the GeoJSON format, a type of open standard format designed for representing simple geographical features.
geom_geotext string This column contains geometric data in text format, providing another modality for representing geographical features.
geom_type string This column specifies the type of the geometric data. In this case, it's 'ST_MULTIPOLYGON', indicating that the data represents a figure with multiple polygonal faces.
geom_centroid string This column holds the centroid coordinates of the geographical feature. It can be used to determine the central point of the feature.
geom_center_x double This column represents the X-coordinate of the center of the geographical feature.
geom_center_y double This column represents the Y-coordinate of the center of the geographical feature.
gml_id string This column contains a unique identifier for each geographical feature.
name string This column holds the English name of the geographical feature or area.
namn string This column contains the name of the geographical feature or area in Swedish.
nimi string This column provides the name of the geographical feature or area in Finnish.
suuralue string This column contains a numerical identifier for each geographical feature or area.
vuosi long This column indicates the year associated with the data entry.

Version History of Large Areas (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 is one of the two additional columns in the history table, which contains the version history of the base table rows.
_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 signifies 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. Along with '_start_date', it forms a unique identifier for each row in the history table.
geom_geojson string This column contains geographical data in the GeoJSON format, an open standard format designed for representing simple geographical features.
geom_geotext string This column represents geographical data in text form, specifically in the format of a MultiPolygon.
geom_type string This column categorizes the type of the geographical data, for example, a MultiPolygon.
geom_centroid string This column contains the centroid, or the geometric center, of the geographical data represented as a point.
geom_center_x double This column represents the 'x' coordinate of the center of the geographical data.
geom_center_y double This column represents the 'y' coordinate of the center of the geographical data.
gml_id string This column contains a unique identifier for the data row.
name string This column contains the name of the region in English.
namn string This column contains the name of the region in Swedish.
nimi string This column contains the name of the region in Finnish.
suuralue string This column represents a code assigned to the major area that the data row pertains to.
vuosi long This column contains the year related to the data row, represented as an integer.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024