Geological Survey of Finland: Metallic Mines in Finland

The dataset collection consists of one or more dataset tables sourced from the website of Geologian tutkimuskeskus (Geological Survey of Finland) in Finland.

Tables

Historical Version History of Metal Mines in FinlandTSV
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...
Metal Mines in FinlandTSV
This table contains data on metallic mines sourced from the website of the Geological Survey of Finland. The data includes information such as the extraction date, row number, unique identifier (gml_id), object id, mine id, mine name, mine status, mining start year, mining end year, years mined, main commodity mined, size by main commodity, production, total ore mined, total ore processed, total waste mined, main commodities deposit, deposit name, deposit id, easting coordinates in the EUREF system, northing coordinates in the EUREF system, easting coordinates in the YKJ system, northing coordinates in the YKJ system, date updated, current holder, other commodities deposit, total resources, total reserves, calculation method, calculation year, alternative names for the mine, geometry in...

Column Descriptions

Metal Mines in Finland

Column	Type	Comment
_extract_date	date	Date and time when the data was extracted.
_row_number	long	Unique identifier for each row in the table.
gml_id	string	GML identifier for the record.
objectid	int	Unique identifier for the mine record.
mine_id	int	Unique identifier for the mine.
mine_name	string	Name of the mine.
mine_status	string	Status of the mine.
mining_start_year	int	Year when mining operations started.
mining_end_year	int	Year when mining operations ended.
years_mined	int	Total number of years the mine was in operation.
main_commodity_mined	string	Main commodity mined at the site.
size_by_main_commodity	string	Size of the mine based on the main commodity mined.
production	string	Total production value of the mine.
total_ore_mined	string	Total amount of ore mined.
total_ore_processed	string	Total amount of ore processed.
total_waste_mined	string	Total amount of waste material mined.
main_commodities_deposit	string	Main commodities found at the mine deposit.
deposit_name	string	Name of the mine deposit.
deposit_id	int	Unique identifier for the mine deposit.
easting_euref	int	Easting coordinate in EUREF for the mining site.
northing_euref	int	Northing coordinate in EUREF for the mining site.
easting_ykj	int	Easting coordinate in YKJ for the mining site.
northing_ykj	int	Northing coordinate in YKJ for the mining site.
date_updated	timestamp	Date when the mine data was last updated.
current_holder	string	Current holder of the mine.
other_commodities_deposit	string	Other commodities found at the mine deposit.
resources_total	string	Total amount of resources in the mine deposit.
reserves_total	string	Total amount of reserves in the mine deposit.
calc_method	string	Calculation method used for estimating resources and reserves.
calc_year	int	Year when the resource and reserve calculations were made.
mine_alternative_names	string	Alternative names for the mine.
geom_geojson	string	Geometry of the mine in GeoJSON format.
geom_geotext	string	Text representation of the mine geometry.
geom_type	string	Type of geometry for the mine.
geom_centroid	string	Centroid of the mine geometry.
geom_center_x	double	X-coordinate of the centroid of the mine geometry.
geom_center_y	double	Y-coordinate of the centroid of the mine geometry.
geom	binary	Spatial representation of the mine geometry.

Historical Version History of Metal Mines in Finland

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number of the version history.
gml_id	string	The GML ID of the row version.
objectid	int	The object ID of the row version.
mine_id	int	The ID of the mine associated with the row version.
mine_name	string	The name of the mine associated with the row version.
mine_status	string	The status of the mine associated with the row version.
mining_start_year	int	The start year of mining for the mine associated with the row version.
mining_end_year	int	The end year of mining for the mine associated with the row version.
years_mined	int	The total number of years the mine has been in operation.
main_commodity_mined	string	The main commodity mined at the mine.
size_by_main_commodity	string	The size of the mine based on the main commodity mined.
production	string	The production value of the mine.
total_ore_mined	string	The total amount of ore mined at the mine.
total_ore_processed	string	The total amount of ore processed at the mine.
total_waste_mined	string	The total amount of waste material mined at the mine.
main_commodities_deposit	string	The main commodities found in the deposit.
deposit_name	string	The name of the deposit.
deposit_id	int	The ID of the deposit.
easting_euref	int	The easting coordinate in the EUREF coordinate reference system.
northing_euref	int	The northing coordinate in the EUREF coordinate reference system.
easting_ykj	int	The easting coordinate in the YKJ coordinate reference system.
northing_ykj	int	The northing coordinate in the YKJ coordinate reference system.
date_updated	timestamp	The date when the row version was last updated.
current_holder	string	The current holder of the mine.
other_commodities_deposit	string	Other commodities found in the deposit.
resources_total	string	The total amount of resources in the mine.
reserves_total	string	The total amount of reserves in the mine.
calc_method	string	The method used to calculate the resources and reserves.
calc_year	int	The year in which the resources and reserves were calculated.
mine_alternative_names	string	Alternative names for the mine.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in geotext format.
geom_type	string	The type of geometry of the row version.
geom_centroid	string	The centroid of the row version geometry.
geom_center_x	double	The x-coordinate of the center of the row version geometry.
geom_center_y	double	The y-coordinate of the center of the row version geometry.
geom	binary	The full geometry of the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024