Geological Survey of Finland - Mineral Occurrences - Version History of Mineral Occurrences in Finland - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Version History of Mineral Occurrences in Finland

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

This table contains the version history of the rows from the base table 'kaikki_mineraaliesiintymat'. Each row in this history table represents a version of a row from the base table at a particular point in time. The columns '_start_date' and '_end_date' indicate the start and end dates of each version. If the value in the '_end_date' column is null, it means that the row is the most recent version. The other columns in this table contain various attributes related to mineral occurrences, such as unique identifiers, names, geographical coordinates, commodity information, mining status, discovery year, geological information, dimensions, and other relevant data. This data could be utilized in data analytics to analyze trends in mineral occurrences, assess the distribution of different mineral commodities, evaluate the mining status of deposits, study geological characteristics, calculate reserves, and perform various spatial analyses. The data in this table is sourced from the website of 'Geological Survey of Finland' (Geologian tutkimuskeskus), which originates from the country with the ISO country code 'fi' (Finland).

Field Descriptions

Name	Data type	Description
_start_date	date	The start date of the validity period for the row version in the table.
_end_date	date	The end date of the validity period for the row version in the table.
_row_number	long	The unique row number of the version in the table.
gml_id	string	The GML identifier of the row version in the table.
objectid	int	The unique identifier of the object in the table.
id	int	The identifier of the row version in the table.
name	string	The name of the row version in the table.
alternative_names	string	The alternative names for the row version in the table.
easting_euref	int	The easting coordinate of the row version in the EUREF coordinate system.
northing_euref	int	The northing coordinate of the row version in the EUREF coordinate system.
easting_ykj	int	The easting coordinate of the row version in the YKJ coordinate system.
northing_ykj	int	The northing coordinate of the row version in the YKJ coordinate system.
commodity	string	The commodity associated with the row version in the table.
size_by_commodity	string	The size of the row version based on the associated commodity.
all_main_commodities	string	The main commodities associated with the row version in the table.
ocurrence_type	string	The type of occurrence of the row version in the table.
mine_status	string	The status of the mine associated with the row version in the table.
discovery_year	int	The year of discovery of the row version in the table.
commodity_measure_total	string	The total measure of the commodity associated with the row version.
resources_total	string	The total resources of the row version in the table.
calc_method	string	The calculation method used for determining the row version.
calc_year	int	The year of the calculation for the row version in the table.
deposit_type	string	The type of deposit associated with the row version in the table.
host_rocks	string	The host rocks of the row version in the table.
wall_rocks	string	The wall rocks of the row version in the table.
deposit_shape	string	The shape of the deposit associated with the row version in the table.
length_m	int	The length of the row version in meters.
thickness_m	int	The thickness of the row version in meters.
date_updated	timestamp	The date when the row version was last updated.
unfc_classification	string	The UNFC classification of the row version.
other_commodities	string	Other commodities associated with the row version in the table.
dip_azim	int	The azimuthal dip of the row version in the table.
dip	int	The dip angle of the row version in the table.
plunge_azim	int	The azimuthal plunge of the row version in the table.
plunge_dip	int	The dip angle of the plunge of the row version in the table.
depth_m	int	The depth of the row version in meters.
current_holder	string	The current holder or owner of the row version in the table.
width_m	int	The width of the row version in meters.
reserves_total	string	The total reserves of the row version in the table.
province	string	The province associated with the row version in the table.
district	string	The district associated with the row version in the table.
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 in the table.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The X-coordinate of the center of the geometry of the row version.
geom_center_y	double	The Y-coordinate of the center of the geometry of the row version.
geom	binary	The complete geometry of the row version in the table.

Name

Data type

Description

_start_date

date

The start date of the validity period for the row version in the table.

_end_date

date

The end date of the validity period for the row version in the table.

_row_number

long

The unique row number of the version in the table.

gml_id

string

The GML identifier of the row version in the table.

objectid

int

The unique identifier of the object in the table.

int

The identifier of the row version in the table.

name

string

The name of the row version in the table.

alternative_names

string

The alternative names for the row version in the table.

easting_euref

int

The easting coordinate of the row version in the EUREF coordinate system.

northing_euref

int

The northing coordinate of the row version in the EUREF coordinate system.

easting_ykj

int

The easting coordinate of the row version in the YKJ coordinate system.

northing_ykj

int

The northing coordinate of the row version in the YKJ coordinate system.

commodity

string

The commodity associated with the row version in the table.

size_by_commodity

string

The size of the row version based on the associated commodity.

all_main_commodities

string

The main commodities associated with the row version in the table.

ocurrence_type

string

The type of occurrence of the row version in the table.

mine_status

string

The status of the mine associated with the row version in the table.

discovery_year

int

The year of discovery of the row version in the table.

commodity_measure_total

string

The total measure of the commodity associated with the row version.

resources_total

string

The total resources of the row version in the table.

calc_method

string

The calculation method used for determining the row version.

calc_year

int

The year of the calculation for the row version in the table.

deposit_type

string

The type of deposit associated with the row version in the table.

host_rocks

string

The host rocks of the row version in the table.

wall_rocks

string

The wall rocks of the row version in the table.

deposit_shape

string

The shape of the deposit associated with the row version in the table.

length_m

int

The length of the row version in meters.

thickness_m

int

The thickness of the row version in meters.

date_updated

timestamp

The date when the row version was last updated.

unfc_classification

string

The UNFC classification of the row version.

other_commodities

string

Other commodities associated with the row version in the table.

dip_azim

int

The azimuthal dip of the row version in the table.

dip

int

The dip angle of the row version in the table.

plunge_azim

int

The azimuthal plunge of the row version in the table.

plunge_dip

int

The dip angle of the plunge of the row version in the table.

depth_m

int

The depth of the row version in meters.

current_holder

string

The current holder or owner of the row version in the table.

width_m

int

The width of the row version in meters.

reserves_total

string

The total reserves of the row version in the table.

province

string

The province associated with the row version in the table.

district

string

The district associated with the row version in the table.

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 in the table.

geom_centroid

string

The centroid of the geometry of the row version.

geom_center_x

double

The X-coordinate of the center of the geometry of the row version.

geom_center_y

double

The Y-coordinate of the center of the geometry of the row version.

geom

binary

The complete geometry of the row version in the table.

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
Adapter	delta
Country	fi
Database	fi_geologian_tutkimuskeskus
Id	93d3c325-5a1d-4a18-af17-801940d8941c
Package id	9598f209-f002-45d4-b64a-056b6294a496
Position	1
Revision id	ccc1a097-7810-4a68-b2b0-d95fa6a2d9e8
State	active
Table	rajapinnat_gtk_kalliopera_wfskaikki_mineraaliesiintymat__kaikki_mineraaliesiintymat__history

Last updated

April 22, 2024

Created

April 22, 2024

License

No License Provided

Geographic coverage

Geographic granularity

Temporal coverage from

Temporal coverage to

Adapter

delta

Country

Database

fi_geologian_tutkimuskeskus

93d3c325-5a1d-4a18-af17-801940d8941c

Package id

9598f209-f002-45d4-b64a-056b6294a496

Position

Revision id

ccc1a097-7810-4a68-b2b0-d95fa6a2d9e8

State

active

Table

rajapinnat_gtk_kalliopera_wfskaikki_mineraaliesiintymat__kaikki_mineraaliesiintymat__history

Version History of Mineral Occurrences in Finland

Field Descriptions

No sample for this dataset

Additional Information