To download the data set, please sign up or log in

Statistical Region Mapping: Major Areas 2022

This dataset collection is an assembly of related data tables that originate from the 'Tilastokeskus' website, Finland. The tables are organized into columns and rows, providing a structured format for better understanding and analysis. The data source, Tilastokeskuksen palvelurajapinta (Statistics Finland Service Interface), suggests that the dataset is likely to feature statistical data. While the content specifics of each data table are not provided, the collection's composition indicates a focus on a significant area, potentially offering rich insights into specific sectors or phenomena at a substantial scale. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • Historical Version Details of Large Areas 2022 (1:1 000 000)TSV

    The 'table__history' is a historical accumulation of records, each representing a version of a row from its base table. It belongs to the dataset collection 'tilastointialueet_suuralue1000k_2022'. This history table is unique in the sense that it contains two additional columns to keep track of the version history of each row in the base table, namely the '_start_date' and '_end_date'. The '_start_date' indicates when the row was initially extracted from the data source, while the '_end_date' shows when a newer version of the row was extracted. If the '_end_date' is null, it indicates that the row is the most recent version. The table presents a detailed geographical dataset, specifically the 'Major Areas 2022 (1:1 000 000)' originating from the Finnish Statistics Bureau...

  • Large Areas 2022 (1:1 000 000) - Data Table from Finnish Statistical DatabaseTSV

    The table, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), contains comprehensive data about the 'Large Areas of 2022' at a scale of 1:1 000 000. The data is organized into several columns, each with a unique purpose. Two special columns, '_extract_date' and '_row_number', provide context about when the data was extracted and the row number within the data source, respectively. Each row is uniquely identified by the combination of these two columns. The table also includes a set of columns beginning with 'geom_', which contain geospatial data that can be utilized for geospatial data analytics. This data is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. In terms of content, the table...

Column Descriptions

Large Areas 2022 (1:1 000 000) - Data Table from Finnish Statistical Database

Column Type Comment
_extract_date date This column contains the date when the data on the row was extracted from the data source. It helps to track when the data was last updated.
_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 uniquely identifies each row.
geom_geojson string This column contains the geojson representation of the geographical area. It is a format for encoding a variety of geographic data structures.
geom_geotext string This column contains the text representation of the geographical area. It is a format for encoding complex geometric structures.
geom_type string This column defines the type of the geometric object. For example, in this table, the type is 'ST_MULTIPOLYGON' indicating that the object is a multipolygon.
geom_centroid string This column contains the geometric center or 'centroid' of the geographical area. It is typically represented as a point.
geom_center_x double This column contains the x-coordinate of the geometric center of the geographical area.
geom_center_y double This column contains the y-coordinate of the geometric center of the geographical area.
gml_id string This column contains an identifier for the geographical markup language (GML). It is a standard used for expressing geographical features.
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 Swedish.
nimi string This column contains the name of the geographical area in Finnish.
suuralue string This column contains a numerical identifier for the large area the geographical area belongs to.
vuosi long This column contains the year pertaining to the data in the row. It is an integer value.

Historical Version Details of Large Areas 2022 (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 the '_row_number' column for each row in the 'table__history' 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 in 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. It forms a unique identifier in combination with the '_start_date' column for each row in this history table.
geom_geojson string This column stores the geographical data in GeoJSON format, which represents simple geographical features.
geom_geotext string This column contains the geographical data as text, specifically the geometrical representation of the feature.
geom_type string This column specifies the type of the geographical data, which is 'ST_MULTIPOLYGON' indicating the data represents a complex geographical feature.
geom_centroid string This column contains the central point of the geographical feature.
geom_center_x double This column contains the x-coordinate of the center of the geographical feature.
geom_center_y double This column contains the y-coordinate of the center of the geographical feature.
gml_id string This column contains a unique identifier for each row in the base table.
name string This column contains the English name of the geographical region.
namn string This column contains the name of the geographical region in Swedish.
nimi string This column contains the name of the geographical region in Finnish.
suuralue string This column contains the identifier of the larger area that the region belongs to.
vuosi long This column contains the year associated with the data row, indicating the year the data represents.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024