Version History of Energiametallit Table

This table contains the version history of the rows in the 'Geologian tutkimuskeskus' data source table 'rajapinnat_gtk_kalliopera_wfsenergiametallit__energiametallit'. It has additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row version. The table includes various columns such as 'gml_id', 'objectid', 'id', 'name', 'alternative_names', 'easting_euref', 'northing_euref', 'easting_ykj', 'northing_ykj', 'commodity', 'size_by_commodity', 'all_main_commodities', 'occurrence_type', 'mine_status', 'discovery_year', 'commodity_measure_total', 'resources_total', 'calc_method', 'calc_year', 'province', 'deposit_type', 'host_rocks', 'deposit_shape', 'length_m', 'width_m', 'thickness_m', 'depth_m', 'date_updated', 'unfc_classification', 'other_commodities', 'dip_azim', 'dip', 'plunge_azim', 'plunge_dip', 'wall_rocks', 'current_holder', 'district', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides valuable historical information, allowing data analysts to track changes over time and perform various data analytics tasks. For example, analysts can analyze the discovery years of energy metals deposits, compute the total resources based on different commodity measures, study the distribution of deposits across provinces or districts, examine the geological characteristics such as deposit shape and host rocks, and perform spatial analysis using the available geometry information. The data in this table is sourced from the website of Geologian tutkimuskeskus, which is the Geological Survey of Finland, belonging to the country Finland (ISO country code: 'FI').