Geological Survey of Finland - Metallic Elements

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

Tables

Geological Survey of Finland - Metallic MineralsTSV
This table contains data on precious metals extracted from various mining sites in Finland. The data is sourced from 'Geological Survey of Finland'. It provides information on the mining sites such as their unique identifiers, names, locations in both European and YKJ coordinate systems, respective commodities extracted, sizes of the commodities, occurrence type, mine status, discovery year, measurements and totals of the commodities, calculation methods and years, current holders of the sites, province and district where the site is located, deposit type, host and wall rocks, deposit shape, dip and azimuth, length, width, depth, last update date, UNFC classification, other commodities related to the site, alternative names, plunge azimuth and dip, thickness, and the geometrical...
Version History of Geological Survey of Finland - Metallic Ores DataTSV
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,...

Column Descriptions

Geological Survey of Finland - Metallic Minerals

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The row number
gml_id	string	The identifier of the GML object
objectid	int	The unique identifier of the object
id	int	The ID of the column
name	string	The name of the object
easting_euref	int	The easting coordinate in Euref coordinate system
northing_euref	int	The northing coordinate in Euref coordinate system
easting_ykj	int	The easting coordinate in YKJ coordinate system
northing_ykj	int	The northing coordinate in YKJ coordinate system
commodity	string	The type of commodity
size_by_commodity	string	The size of the object based on the commodity
all_main_commodities	string	The list of all main commodities
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
reserves_total	string	The total reserves
calc_method	string	The calculation method used
calc_year	int	The year of calculation
current_holder	string	The current holder of the object
province	string	The province where the object is located
district	string	The district where the object is located
deposit_type	string	The type of deposit
host_rocks	string	The rocks hosting the object
wall_rocks	string	The rocks forming the wall of the object
deposit_shape	string	The shape of the deposit
dip_azim	int	The azimuth of the dip
dip	int	The dip angle
length_m	int	The length of the object in meters
width_m	int	The width of the object in meters
depth_m	int	The depth of the object in meters
date_updated	timestamp	The date when the record was last updated
unfc_classification	string	The UNFC classification of the object
other_commodities	string	Other commodities associated with the object
alternative_names	string	Alternative names of the object
plunge_azim	int	The azimuth of the plunge
plunge_dip	int	The dip angle of the plunge
thickness_m	int	The thickness of the object in meters
geom_geojson	string	The geometry of the object in GeoJSON format
geom_geotext	string	The geometry of the object 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 object

Version History of Geological Survey of Finland - Metallic Ores Data

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

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024