Historical Version Records of AVI Areas 2018 (1:1 000 000)

The 'table__history' is a chronologically organized data archive that tracks the version history of its base table rows. It is part of a larger dataset collection focused on statistical areas in Finland. The table content is sourced from the Finnish Statistical Office (Tilastokeskus) and it contains data about AVI areas in Finland for the year 2018 at a scale of 1:1,000,000.

The table comprises several columns which store a range of data. One of the key columns is '_row_number', which records the row number from the raw data extracted from the data source. This column, in combination with the '_start_date', forms a unique identifier for each row in the table. These identifiers are crucial for tracking the evolution of data over time.

The table also features columns that contain geographical data, identified by the prefix 'geom_'. This data can be utilized for geospatial data analytics, with geographic coordinates being presented using the WGS 84 coordinate reference system, and the axis order being longitude first, followed by latitude.

The table has two additional columns compared to its base table, namely '_start_date' and '_end_date'. These columns mark the dates when the row was extracted and when a new version of the row was extracted, respectively. If the '_end_date' value is null, this signifies that the row is the most recent version.

The 'table__history' can be utilized in various ways for data analytics. For example, it can be used to track changes in AVI areas in Finland over time, which can help in understanding trends and patterns in these areas. The geographical data can be used for geospatial analyses, such as mapping the AVI areas or analyzing their spatial distribution. Moreover, by examining the version history of the base table rows, one can gain insights into the evolution of the data, which can serve as a basis for predictive analytics.