1. Home
  2. Datasets
  3. Statistical Area Mapping: ...
To download the data set, please sign up or log in

Statistical Area Mapping: Large Region 1000k - 2017 Edition

This dataset collection, originating from Finland, is comprised of a set of related data tables. Sourced from the 'Tilastokeskus' (Statistics Finland) web site, these tables present a wide array of data in an organized, tabular format. The data is arranged in rows and columns, enabling easy analysis and interpretation. The collection's content is provided through the service interface of the Statistics Finland, ensuring robust and reliable data for use in various analytical contexts. The comprehensive nature of this collection makes it a valuable resource for those seeking in-depth insights based on 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

  • Historical Version Records of Large Areas 2017 (1:1 000 000)TSV

    The 'table__history' is a comprehensive data collection that serves as a historical record of its base table, which is a part of the 'tilastointialueet_suuralue1000k_2017' dataset. This history table captures the evolution of information over time, specifically tracking changes in the base table's rows. Each row in this history table is uniquely identified by a combination of the extraction start date and the row number from the raw data source. The table contains a wealth of information, including geographical data, names in different languages, and time-stamp data. The geographical data is particularly rich, including data types such as MultiPolygon and Point, stored in various columns. This geospatial information is represented using the WGS 84 coordinate reference system, which...

  • Spatial Data of Major Regions in Finland, 2017 (Scale 1:1 000 000)TSV

    The table in question belongs to a dataset collection that comprises related data tables. It is centered around 'Large Areas 2017' (Suuralueet 2017), with data organized into various columns, each bearing a specific meaning and relevance. Two key columns in the table are '_extract_date' and '_row_number'. The '_extract_date' column details the date when the specific row of data was extracted, while '_row_number' gives the row number in the data extracted. These two columns, taken together, allow each row to be uniquely identified. Several columns in the table start with 'geom_', indicating they contain geographic information valuable for geospatial data analytics. This includes geographic coordinates, which are given using the WGS 84 coordinate reference system, with the axis order...

Column Descriptions

Spatial Data of Major Regions in Finland, 2017 (Scale 1:1 000 000)

Column Type Comment
_extract_date date The date when the data on the row was extracted from the data source.
_row_number long The row number in the data extracted from the source on the extract date.
geom_geojson string The geographical data pertaining to the row in GeoJson format.
geom_geotext string The geographical data pertaining to the row in text format.
geom_type string The type of geometry used in the geographical data.
geom_centroid string The central point of the geographical data.
geom_center_x double The x-coordinate of the center of the geographical data.
geom_center_y double The y-coordinate of the center of the geographical data.
gml_id string The unique identifier of the row.
name string The English name of the area.
namn string The Swedish name of the area.
nimi string The Finnish name of the area.
suuralue string The large area code to which the row pertains.
vuosi double The year to which the row pertains.

Historical Version Records of Large Areas 2017 (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 part of a combination that uniquely identifies each row in this 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 is null, it means 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 source. It is part of a combination with '_start_date' that uniquely identifies each version in the history.
geom_geojson string This column contains geometric data in the GeoJSON format, which represents the physical location related to the data row.
geom_geotext string This column contains geometric data in text format, which represents the physical location related to the data row.
geom_type string This column specifies the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column contains the centroid point of the geometric shape, which is the average position of all the points in the shape.
geom_center_x double This column contains the x-coordinate of the center of the geometric shape.
geom_center_y double This column contains the y-coordinate of the center of the geometric shape.
gml_id string This column contains a unique identifier for the row.
name string This column contains the English name of the geographic area related to the data row.
namn string This column contains the Swedish name of the geographic area related to the data row.
nimi string This column contains the Finnish name of the geographic area related to the data row.
suuralue string This column contains a numerical identifier for the large area (in Finnish 'suuralue') related to the data row.
vuosi double This column contains the year related to the data row.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024