History Version Record of ELY Areas 2021 (Scale 1:1,000,000)

The 'table__history' is a part of a dataset collection, which contains historical and geographical data. The contents of the table are derived from the ELY-areas 2021 (1:1 000 000) which gives an overview of different regions in Finland, as obtained from the 'Statistics Finland' (Tilastokeskus) website. This history table maintains the version history of the base table rows, including the date of extraction from the data source and the date when a new version of the row was extracted. The most recent version of the row is indicated by a null value in the '_end_date' column.

The table uniquely identifies each row using the combination of '_start_date' and '_row_number', where '_row_number' represents the sequence of the row as it was in the raw data.

In addition to historical data, the table provides extensive geographical information. The geographical data includes the type of geographical shape ('ST_POLYGON', 'ST_MULTIPOLYGON'), geographical coordinates (longitude first, then latitude, per WGS 84 coordinate reference system), and a textual representation of the geographic shape, among other things. This information can be particularly useful for geospatial data analytics.

As an example, this table could be utilized in analyzing the changes in the regions over time, by leveraging the '_start_date' and '_end_date' columns. The geographical data can be used in spatial analytics to assess the spatial distribution and characteristics of the regions. Moreover, the evolution of specific regions could be traced by using the unique identifiers in the table, providing valuable insights for urban planning, policy-making, or environmental studies.