Version History of AVI Regions 2013 (Scale 1:1,000,000)

The 'table__history' is a historical table that holds the version history of its base table rows, sourced from the 'Tilastokeskus' website in Finland. This table belongs to the 'tilastointialueet_avi1000k_2013' dataset collection and includes several notable columns.

This table is a version of the AVI areas 2013 (1:1 000 000) base table with additional columns to track changes over time. Specifically, the table has two additional date-related columns '_start_date' and '_end_date'. The '_start_date' column holds the date when the row was extracted from the source, and '_end_date' represents when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. In conjunction with the '_row_number' column, which denotes row numbers from the raw data, these columns serve to uniquely identify each row in this history table.

The table further provides detailed geographic data in columns starting with 'geom_', which can be leveraged for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the order of longitude first, followed by latitude.

The data in this table, such as AVI areas and their geographic locations, could be used for a variety of analytical purposes. For instance, analysts could track changes in geographic areas over time, comparing different versions of the data. In addition, the geospatial information could be used to visualize the spatial distribution of AVI areas, providing insights into patterns and trends. The historical data also allows for the analysis of data trends over time, which could be crucial in strategic planning and policy-making.