2015 Statistical Area Collection for Major Regions

Tables

• 2015 Major Regions Data (1:4,500,000) Extracted From Finnish Statistical DatabaseTSV

  The table, sourced from the 'Tilastokeskus' (Statistics Finland) website, represents comprehensive geographical and statistical data of 'Suuralueet 2015' - Major Areas in 2015, at a scale of 1:4 500 000. This table, part of the 'tilastointialueet_suuralue4500k_2015' dataset, contains various columns that offer rich insights about each area. The table provides geographical location details through several 'geom_' prefixed columns, containing geographic coordinates in the WGS 84 coordinate reference system with axis order longitude first, followed by latitude. These columns contain information such as the geometric representation in both GeoJSON and geotext format, the geometric type, centroid of the area, and the X and Y coordinates of the center. For statistical data, the 'name',...

• Version History of Major Areas 2015 (1:4 500 000) TableTSV

  The table, named as 'table__history', is a historical data collection that tracks the changes in the rows of its base table over time. It is a part of the dataset identified as 'tilastointialueet_suuralue4500k_2015'. This table primarily focuses on the version history of the base table, which represents 'Suuralueet 2015' or 'Large Areas 2015', at a scale of 1:4,500,000. The table provides a structured and systematic record of each row's lifecycle from the raw data extracted from the source. Each row in the table is uniquely identified by a combination of the date when the row was extracted, and the row number. To track the version history of each row, two additional columns namely, the start date and end date of the row version, are included in this table. Therefore, if the end date is...