1. Home
  2. Datasets
  3. Statistics Area Large Region ...
To download the data set, please sign up or log in

Statistics Area Large Region 1000k 2016

This dataset collection is a comprehensive compilation of statistical data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The collection encompasses a group of related data tables organized in a structured format with distinct columns and rows. The data within this collection is primarily accessed through Tilastokeskuksen palvelurajapinta (Statistics Finland's Service Interface), which makes it an invaluable resource for researchers and analysts seeking detailed and reliable statistical information. 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 2016: Comprehensive Geographical and Statistical Data (1:1 000 000)TSV

    The table is part of a broader dataset collection, focusing on significant regions in Finland during the year 2016, as suggested by its Finnish title 'Suuralueet 2016'. It provides intricate data for each region, captured and extracted at a certain point in time. This table is a rich source of both geographical and demographic data. It houses geographical data such as the type of geographic feature, its centroid, center coordinates in the form of longitude (x) and latitude (y), and its geospatial representation in GeoJSON and GeoText formats. This information can be instrumental in performing geospatial data analytics, especially considering it follows the WGS 84 coordinate reference system (longitude followed by latitude). It also contains demographic data like the region's name in...

  • Version History of Major Regions 2016 (1:1 000 000)TSV

    The 'table__history' is a historical data repository of its base table. The table is part of a larger dataset collection that harbors related data tables. This particular table encapsulates the version history of its base table, tracking each modification to the table rows over time. The table is sourced from the 'Tilastokeskus' website based in Finland. The contents of the table are described as 'Suuralueet 2016 (1:1 000 000)', which translates to 'Large areas 2016 (1:1 000 000)' in English. This indicates that the data is relevant to large geographical areas as of the year 2016. The table is organized into several columns each with a unique purpose. Two of these columns, '_start_date' and '_end_date', are unique to this history table and are used to mark the lifespan of each row in...

Column Descriptions

Large Areas 2016: Comprehensive Geographical and Statistical Data (1:1 000 000)

Column Type Comment
_extract_date date The date when the data on the row of the table was extracted from the data source.
_row_number long The row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
geom_geojson string Contains a GeoJSON representation of geometry. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext string Contains a textual representation of the geometry. This is another way to describe the geographic data.
geom_type string Specifies the type of geometric feature. In this case, it is a type of MultiPolygon.
geom_centroid string Contains the calculated central point of the geometric feature.
geom_center_x double The x-coordinate of the geometric center of the feature.
geom_center_y double The y-coordinate of the geometric center of the feature.
gml_id string A unique identifier for each row in the table.
name string The English name of the area in Finland.
namn string The name of the area in Swedish, one of the official languages of Finland.
nimi string The name of the area in Finnish, the official language of Finland.
suuralue string An identifier for the large area that the data row pertains to.
vuosi double The year when the data was collected.

Version History of Major Regions 2016 (1:1 000 000)

Column Type Comment
_start_date date This column indicates 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 when combined with '_row_number'.
_end_date date This column represents the date when a new version of the row was extracted from the data source. If the value 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 part of a unique identifier for each row in conjunction with '_start_date'.
geom_geojson string This column stores the geographical data of the area in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext string This column holds the geographical data of the area in text format.
geom_type string This column indicates the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column contains the geographical center point (centroid) of the area.
geom_center_x double This column records the X coordinate of the geographical center point of the area.
geom_center_y double This column records the Y coordinate of the geographical center point of the area.
gml_id string This column holds a unique identifier for each row, provided by the data source.
name string This column contains the English name of the area.
namn string This column presents the name of the area in the local language.
nimi string This column provides the name of the area in another local language.
suuralue string This column contains a numerical code for the area.
vuosi double This column indicates the year the data was collected.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024