Metal Mines in Finland
Click here for a data sample
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 GeoJSON format, geometry in Geotext format, geometry type, centroid of the geometry, center x-coordinate of the geometry, center y-coordinate of the geometry, and the geometry itself. This data can be utilized in various data analytics tasks such as analyzing the production and size of mines, studying the distribution of mines across the country, investigating the relationship between mining start/end years and mine status, examining the total ore and waste mined, exploring the main commodities associated with different deposits, and analyzing the spatial distribution of mines using the geometry information.
Field Descriptions
Name |
Data type |
Description |
_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. |