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

Version History of Geological Survey of Finland - Metallic Ores Data

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

This table contains the version history of the rows in the 'rajapinnat_gtk_kalliopera_wfsjalometallit__jalometallit' table, sourced from the 'Geological Survey of Finland' website. The table provides information about the historical versions of various data related to metallic mineral occurrences. Each row has additional columns '_start_date' and '_end_date' representing the extraction dates of the row from the data source. The '_start_date' indicates when the row was initially extracted, while the '_end_date' denotes the date when a new version of the row was extracted. If the '_end_date' is null, it indicates that the row is the most recent version. The data in this table can be utilized for various data analytics tasks, such as tracking changes in mineral occurrences over time, analyzing mining trends, studying the distribution and characteristics of mineral deposits, and assessing the historical development of mining activities. The table consists of several other columns providing details about the mineral occurrences, such as their geographic coordinates, commodity types, occurrence type, mine status, discovery year, resource estimation measures, deposit types, geological characteristics, dimensions, and various other attributes. The information can be used to identify patterns, correlations, and trends related to metallic mineral occurrences in Finland, providing valuable insights for geological research, mineral exploration, and resource management.

Field Descriptions

Name	Data type	Description
_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 number assigned to each row version.
gml_id	string	The unique identifier for the row version in GML format.
objectid	int	The unique identifier for the row version.
id	int	The identifier for the row version.
name	string	The name of the row version.
easting_euref	int	The easting coordinate in EUREF format for the row version.
northing_euref	int	The northing coordinate in EUREF format for the row version.
easting_ykj	int	The easting coordinate in YKJ format for the row version.
northing_ykj	int	The northing coordinate in YKJ format for the row version.
commodity	string	The commodity associated with the row version.
size_by_commodity	string	The size of the commodity by commodity associated with the row version.
all_main_commodities	string	The main commodities associated with the row version.
ocurrence_type	string	The type of occurrence associated with the row version.
mine_status	string	The status of the mine associated with the row version.
discovery_year	int	The year of discovery for the row version.
commodity_measure_total	string	The total measure of the commodity associated with the row version.
resources_total	string	The total resources associated with the row version.
reserves_total	string	The total reserves associated with the row version.
calc_method	string	The calculation method used for the row version.
calc_year	int	The year of calculation for the row version.
current_holder	string	The current holder of the row version.
province	string	The province associated with the row version.
district	string	The district associated with the row version.
deposit_type	string	The type of deposit associated with the row version.
host_rocks	string	The host rocks associated with the row version.
wall_rocks	string	The wall rocks associated with the row version.
deposit_shape	string	The shape of the deposit associated with the row version.
dip_azim	int	The azimuth dip of the row version.
dip	int	The dip of the row version.
length_m	int	The length in meters for the row version.
width_m	int	The width in meters for the row version.
depth_m	int	The depth in meters for the row version.
date_updated	timestamp	The date of the last update for the row version.
unfc_classification	string	The UNFC (United Nations Framework Classification for Resources) classification for the row version.
other_commodities	string	Other commodities associated with the row version.
alternative_names	string	Alternative names for the row version.
plunge_azim	int	The azimuth plunge of the row version.
plunge_dip	int	The dip plunge of the row version.
thickness_m	int	The thickness in meters for the row version.
geom_geojson	string	The geometric representation in GeoJSON format for the row version.
geom_geotext	string	The geometric representation in Geotext format for the row version.
geom_type	string	The type of geometric representation for the row version.
geom_centroid	string	The centroid of the geometric representation for the row version.
geom_center_x	double	The x-coordinate of the center of the geometric representation for the row version.
geom_center_y	double	The y-coordinate of the center of the geometric representation for the row version.
geom	binary	The geometric representation for the row version.

Name

Data type

Description

_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 number assigned to each row version.

gml_id

string

The unique identifier for the row version in GML format.

objectid

int

The unique identifier for the row version.

int

The identifier for the row version.

name

string

The name of the row version.

easting_euref

int

The easting coordinate in EUREF format for the row version.

northing_euref

int

The northing coordinate in EUREF format for the row version.

easting_ykj

int

The easting coordinate in YKJ format for the row version.

northing_ykj

int

The northing coordinate in YKJ format for the row version.

commodity

string

The commodity associated with the row version.

size_by_commodity

string

The size of the commodity by commodity associated with the row version.

all_main_commodities

string

The main commodities associated with the row version.

ocurrence_type

string

The type of occurrence associated with the row version.

mine_status

string

The status of the mine associated with the row version.

discovery_year

int

The year of discovery for the row version.

commodity_measure_total

string

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

resources_total

string

The total resources associated with the row version.

reserves_total

string

The total reserves associated with the row version.

calc_method

string

The calculation method used for the row version.

calc_year

int

The year of calculation for the row version.

current_holder

string

The current holder of the row version.

province

string

The province associated with the row version.

district

string

The district associated with the row version.

deposit_type

string

The type of deposit associated with the row version.

host_rocks

string

The host rocks associated with the row version.

wall_rocks

string

The wall rocks associated with the row version.

deposit_shape

string

The shape of the deposit associated with the row version.

dip_azim

int

The azimuth dip of the row version.

dip

int

The dip of the row version.

length_m

int

The length in meters for the row version.

width_m

int

The width in meters for the row version.

depth_m

int

The depth in meters for the row version.

date_updated

timestamp

The date of the last update for the row version.

unfc_classification

string

The UNFC (United Nations Framework Classification for Resources) classification for the row version.

other_commodities

string

Other commodities associated with the row version.

alternative_names

string

Alternative names for the row version.

plunge_azim

int

The azimuth plunge of the row version.

plunge_dip

int

The dip plunge of the row version.

thickness_m

int

The thickness in meters for the row version.

geom_geojson

string

The geometric representation in GeoJSON format for the row version.

geom_geotext

string

The geometric representation in Geotext format for the row version.

geom_type

string

The type of geometric representation for the row version.

geom_centroid

string

The centroid of the geometric representation for the row version.

geom_center_x

double

The x-coordinate of the center of the geometric representation for the row version.

geom_center_y

double

The y-coordinate of the center of the geometric representation for the row version.

geom

binary

The geometric representation for the row version.

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	0967eed4-1366-4991-9070-4a03d2a4665a
Package id	3cd41891-178c-4359-9b50-e5c792630652
Position	1
Revision id	925ea858-f88b-4f1e-8209-a3d1a380de03
State	active
Table	rajapinnat_gtk_kalliopera_wfsjalometallit__jalometallit__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

0967eed4-1366-4991-9070-4a03d2a4665a

Package id

3cd41891-178c-4359-9b50-e5c792630652

Position

Revision id

925ea858-f88b-4f1e-8209-a3d1a380de03

State

active

Table

rajapinnat_gtk_kalliopera_wfsjalometallit__jalometallit__history

Version History of Geological Survey of Finland - Metallic Ores Data

Field Descriptions

No sample for this dataset

Additional Information