Geological Survey of Finland - Mineral Occurrences

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

Tables

All Mineral Occurrences in 'Geological Survey of Finland' DatabaseTSV
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...
Version History of Mineral Occurrences in FinlandTSV
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...

Column Descriptions

All Mineral Occurrences in 'Geological Survey of Finland' Database

Column	Type	Comment
_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.

Version History of Mineral Occurrences in Finland

Column	Type	Comment
_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.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024