All Mineral Occurrences in 'Geological Survey of Finland' Database
Click here for a data sample
This table contains information about mineral occurrences from the web site of 'Geological Survey of Finland' (Geologian tutkimuskeskus). It provides details such as extraction date, row number, unique identifiers, names, geographic coordinates, commodity information, occurrence type, mine status, discovery year, measurements, resources, calculation method and year, deposit type, host and wall rocks, shape dimensions, date updated, classification, other commodities, dip and plunge angles, depth, current holder, reserves, province, district, geometry data in various formats. The table can be utilized for data analytics purposes such as analyzing the distribution of minerals across geographic locations, studying the relationship between commodity measures and resources, exploring the temporal trends of discoveries, investigating the geological characteristics of different deposit types and their associated rocks, determining the sizes and shapes of mineral occurrences, examining changes in classification over time, and understanding the mineral potential of specific provinces and districts within Finland (ISO country code: 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data is extracted. |
|---|
| _row_number | long | The row number of the data entry. |
|---|
| gml_id | string | The GML identifier of the entry. |
|---|
| objectid | int | The identifier of the object. |
|---|
| id | int | The unique identifier of the entry. |
|---|
| name | string | The name of the entry. |
|---|
| alternative_names | string | The alternative names of the entry. |
|---|
| easting_euref | int | The easting coordinates in EUREF reference system. |
|---|
| northing_euref | int | The northing coordinates in EUREF reference system. |
|---|
| easting_ykj | int | The easting coordinates in YKJ reference system. |
|---|
| northing_ykj | int | The northing coordinates in YKJ reference system. |
|---|
| commodity | string | The commodity associated with the entry. |
|---|
| size_by_commodity | string | The size of the entry based on its commodity. |
|---|
| all_main_commodities | string | The main commodities associated with the entry. |
|---|
| ocurrence_type | string | The type of occurrence. |
|---|
| mine_status | string | The status of the mine. |
|---|
| discovery_year | int | The year of discovery. |
|---|
| commodity_measure_total | string | The total measure of the commodity. |
|---|
| resources_total | string | The total resources of the entry. |
|---|
| calc_method | string | The method used for calculation. |
|---|
| calc_year | int | The year of calculation. |
|---|
| deposit_type | string | The type of deposit. |
|---|
| host_rocks | string | The rocks hosting the deposit. |
|---|
| wall_rocks | string | The rocks forming the walls of the deposit. |
|---|
| deposit_shape | string | The shape of the deposit. |
|---|
| length_m | int | The length of the deposit in meters. |
|---|
| thickness_m | int | The thickness of the deposit in meters. |
|---|
| date_updated | timestamp | The date when the entry was last updated. |
|---|
| unfc_classification | string | The UNFC classification of the entry. |
|---|
| other_commodities | string | Other commodities associated with the entry. |
|---|
| dip_azim | int | The azimuthal dip direction. |
|---|
| dip | int | The dip of the deposit. |
|---|
| plunge_azim | int | The azimuthal plunge direction. |
|---|
| plunge_dip | int | The dip of the plunge. |
|---|
| depth_m | int | The depth of the deposit in meters. |
|---|
| current_holder | string | The current holder of the entry. |
|---|
| width_m | int | The width of the deposit in meters. |
|---|
| reserves_total | string | The total reserves of the entry. |
|---|
| province | string | The province where the entry is located. |
|---|
| district | string | The district where the entry is located. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry of the entry. |
|---|
