Geological Survey of Finland - Special Metals History

This table contains the version history of the rows extracted from the 'Geological Survey of Finland' website, which originates from the country 'Finland' (ISO country code 'fi'). It is a historical record of the 'Rajapinnat GTK Kalliopera WFSErikoismetallit Erikoismetallit' base table. The table has additional columns compared to its base table, which include '_start_date' and '_end_date'. The '_start_date' column stores the extraction date of the row, while the '_end_date' column stores the date when a new version of the row was extracted. If the '_end_date' column is null, it indicates that the row is the most recent version. The table provides valuable data for data analytics applications. For instance, it can be used to analyze the occurrence and distribution of different commodities, their sizes, and types of occurrences. It also offers insights into the discovery years, provinces, deposit types, host rocks, wall rocks, deposit shapes, dips, and other geological characteristics. Moreover, the table includes information on date updates, measures of commodities, total resources, calculation methods, calculation years, UNFC classifications, current holders, dimensions (length and width in meters), geometry in GeoJSON and geotext formats, and other geometric properties. The data in this table can support various analytical studies related to geological resources, providing valuable insights for researchers, analysts, and decision-makers.