Version History for Major Regions 2019 (1:4 500 000) Table

The table 'table__history' is a history table that is part of the dataset collection 'tilastointialueet_suuralue4500k_2019'. It contains the version history of the base table rows, including the date when each row was extracted from the source, as well as the date when a new version of the row was extracted. If the end date is null, it signifies that the row is the most recent version. The table includes a unique identifier for each row, formed by the combination of the start date and row number.

The content of the table is related to 'Major Areas 2019 (1:4 500 000)' in Finland, as sourced from the 'Statistical Centre' (Tilastokeskus) website. The data includes geographic information, such as geographic coordinates, presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This geographic information can be utilized for geospatial data analytics.

The data also includes names of major areas in Finnish and Swedish, along with an assigned numeric code and the year of the data. An example of how this data could be used in analytics would be to track changes in the geographic boundaries of these areas over time, or to associate other data with these areas based on their geographic coordinates. Additionally, the history feature of the table allows for tracking changes in the data over time, which could be useful in trend analysis or understanding the evolution of these major areas.

In summary, 'table__history' is a comprehensive data source for understanding the major areas of Finland as they evolve over time, with a specific focus on the geospatial aspects of these areas.