Historical Version History of Metal Mines in Finland

To download the data set, please sign up or log in

Click here for a data sample

This table contains the version history of the base table 'Metallikaivokset', sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). It includes information about various metallic mines in Finland. The table has additional columns '_start_date' and '_end_date' representing the extraction dates of each row. The data is related to mining activities and includes details such as mine IDs, names, statuses, mining start and end years, years mined, main commodities mined, size by main commodity, production quantities, ore and waste mined, deposit information, geographical coordinates, dates of updates, current holders, alternative names, resources and reserves totals, calculation methods and years, as well as various geographic and geometrical data. This historical versioning allows for tracking changes in the data over time. The table provides valuable information for data analytics, such as studying the trends and patterns in mining activities, analyzing production and resource utilization, comparing different mines and their characteristics, investigating geographical distributions, and conducting spatial analyses.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe row number of the version history.
gml_idstringThe GML ID of the row version.
objectidintThe object ID of the row version.
mine_idintThe ID of the mine associated with the row version.
mine_namestringThe name of the mine associated with the row version.
mine_statusstringThe status of the mine associated with the row version.
mining_start_yearintThe start year of mining for the mine associated with the row version.
mining_end_yearintThe end year of mining for the mine associated with the row version.
years_minedintThe total number of years the mine has been in operation.
main_commodity_minedstringThe main commodity mined at the mine.
size_by_main_commoditystringThe size of the mine based on the main commodity mined.
productionstringThe production value of the mine.
total_ore_minedstringThe total amount of ore mined at the mine.
total_ore_processedstringThe total amount of ore processed at the mine.
total_waste_minedstringThe total amount of waste material mined at the mine.
main_commodities_depositstringThe main commodities found in the deposit.
deposit_namestringThe name of the deposit.
deposit_idintThe ID of the deposit.
easting_eurefintThe easting coordinate in the EUREF coordinate reference system.
northing_eurefintThe northing coordinate in the EUREF coordinate reference system.
easting_ykjintThe easting coordinate in the YKJ coordinate reference system.
northing_ykjintThe northing coordinate in the YKJ coordinate reference system.
date_updatedtimestampThe date when the row version was last updated.
current_holderstringThe current holder of the mine.
other_commodities_depositstringOther commodities found in the deposit.
resources_totalstringThe total amount of resources in the mine.
reserves_totalstringThe total amount of reserves in the mine.
calc_methodstringThe method used to calculate the resources and reserves.
calc_yearintThe year in which the resources and reserves were calculated.
mine_alternative_namesstringAlternative names for the mine.
geom_geojsonstringThe geometry of the row version in GeoJSON format.
geom_geotextstringThe geometry of the row version in geotext format.
geom_typestringThe type of geometry of the row version.
geom_centroidstringThe centroid of the row version geometry.
geom_center_xdoubleThe x-coordinate of the center of the row version geometry.
geom_center_ydoubleThe y-coordinate of the center of the row version geometry.
geombinaryThe full geometry of the row version.

No sample for this dataset

Additional Information

Last updated April 22, 2024
Created April 22, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_geologian_tutkimuskeskus
Id6836a6fb-ef6c-467a-9b5c-0aa494367965
Package idbe241633-cada-4996-a3fb-e119659ad13e
Position1
Revision id37df2239-c218-40cc-9c39-4605f4f4939e
Stateactive
Tablerajapinnat_gtk_kalliopera_wfsmetallikaivokset__metallikaivokset__history