Rock Surfaces and Energy Metals from Geological Survey of Finland

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

Tables

Energy Metals Database - Geological Survey of Finland - Rock Surfaces - Web Feature Service (WFS)TSV
This table contains data about energy metals from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The data is sourced from the country Finland (ISO country code 'fi'). The table provides information on various aspects related to energy metal deposits. The table includes columns such as 'extract date', 'row number', 'gml id', 'object id', 'id', 'name', 'alternative names', 'easting EUREF', 'northing EUREF', 'easting YKJ', 'northing YKJ', 'commodity', 'size by commodity', 'all main commodities', 'occurrence type', 'mine status', 'discovery year', 'commodity measure total', 'resources total', 'calculation method', 'calculation year', 'province', 'deposit type', 'host rocks', 'deposit shape', 'length (m)', 'width (m)', 'thickness (m)', 'depth (m)', 'date...
Version History of Energiametallit TableTSV
This table contains the version history of the rows in the 'Geologian tutkimuskeskus' data source table 'rajapinnat_gtk_kalliopera_wfsenergiametallit__energiametallit'. It has additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row version. The table includes various columns such as 'gml_id', 'objectid', 'id', 'name', 'alternative_names', 'easting_euref', 'northing_euref', 'easting_ykj', 'northing_ykj', 'commodity', 'size_by_commodity', 'all_main_commodities', 'occurrence_type', 'mine_status', 'discovery_year', 'commodity_measure_total', 'resources_total', 'calc_method', 'calc_year', 'province', 'deposit_type', 'host_rocks', 'deposit_shape', 'length_m', 'width_m', 'thickness_m', 'depth_m', 'date_updated', 'unfc_classification',...

Column Descriptions

Energy Metals Database - Geological Survey of Finland - Rock Surfaces - Web Feature Service (WFS)

Column	Type	Comment
_extract_date	date	This column stores the date that the data was extracted.
_row_number	long	This column contains the row number of the data entry.
gml_id	string	This column represents the GML identifier for the entry.
objectid	int	This column stores the unique object identifier for each entry.
id	int	This column stores the unique identifier for each entry.
name	string	This column stores the name of the entry.
alternative_names	string	This column stores the alternative names or aliases for the entry.
easting_euref	int	This column stores the easting coordinate in the EUREF coordinate system.
northing_euref	int	This column stores the northing coordinate in the EUREF coordinate system.
easting_ykj	int	This column stores the easting coordinate in the YKJ coordinate system.
northing_ykj	int	This column stores the northing coordinate in the YKJ coordinate system.
commodity	string	This column stores the type of commodity associated with the entry.
size_by_commodity	string	This column stores the size of the entry based on the commodity.
all_main_commodities	string	This column stores the main commodities associated with the entry.
ocurrence_type	string	This column stores the type of occurrence for the entry.
mine_status	string	This column stores the status of the mine associated with the entry.
discovery_year	int	This column stores the year of discovery for the entry.
commodity_measure_total	string	This column stores the total measure of the commodity for the entry.
resources_total	string	This column stores the total resources for the entry.
calc_method	string	This column stores the calculation method used for the entry.
calc_year	int	This column stores the year of calculation for the entry.
province	string	This column stores the province or region associated with the entry.
deposit_type	string	This column stores the type of deposit for the entry.
host_rocks	string	This column stores the host rocks for the entry.
deposit_shape	string	This column stores the shape of the deposit for the entry.
length_m	int	This column stores the length of the deposit in meters.
width_m	int	This column stores the width of the deposit in meters.
thickness_m	int	This column stores the thickness of the deposit in meters.
depth_m	int	This column stores the depth of the deposit in meters.
date_updated	timestamp	This column stores the date when the entry was last updated.
unfc_classification	string	This column stores the UNFC (United Nations Framework Classification) classification for the entry.
other_commodities	string	This column stores other commodities associated with the entry.
dip_azim	int	This column stores the dip azimuth for the entry.
dip	int	This column stores the dip value for the entry.
plunge_azim	int	This column stores the plunge azimuth for the entry.
plunge_dip	int	This column stores the plunge dip value for the entry.
wall_rocks	string	This column stores the wall rocks for the entry.
current_holder	string	This column stores the current holder of the entry.
district	string	This column stores the district or area associated with the entry.
geom_geojson	string	This column stores the geometry of the entry in GeoJSON format.
geom_geotext	string	This column stores the geometry of the entry in text format.
geom_type	string	This column stores the type of geometry for the entry.
geom_centroid	string	This column stores the centroid of the geometry for the entry.
geom_center_x	double	This column stores the x-coordinate of the center of the geometry for the entry.
geom_center_y	double	This column stores the y-coordinate of the center of the geometry for the entry.
geom	binary	This column stores the geometry of the entry.

Version History of Energiametallit Table

Column	Type	Comment
_start_date	date	The start date indicating the beginning of the validity period for the row version.
_end_date	date	The end date indicating the end of the validity period for the row version.
_row_number	long	The row number representing the order of the row version in the table.
gml_id	string	The GML identifier of the row.
objectid	int	The identifier of the object.
id	int	The unique identifier of the row.
name	string	The name of the row.
alternative_names	string	The alternative names associated with the row.
easting_euref	int	The easting coordinate in EUREF projection.
northing_euref	int	The northing coordinate in EUREF projection.
easting_ykj	int	The easting coordinate in YKJ projection.
northing_ykj	int	The northing coordinate in YKJ projection.
commodity	string	The commodity associated with the row.
size_by_commodity	string	The size of the row based on the associated commodity.
all_main_commodities	string	All the main commodities associated with the row.
ocurrence_type	string	The type of occurrence of the row.
mine_status	string	The status of the mine associated with the row.
discovery_year	int	The year of discovery of the row.
commodity_measure_total	string	The total measure of the commodity associated with the row.
resources_total	string	The total resources associated with the row.
calc_method	string	The calculation method used for determining the values.
calc_year	int	The year of calculation for the values.
province	string	The province where the row is located.
deposit_type	string	The type of deposit associated with the row.
host_rocks	string	The rocks hosting the deposit.
deposit_shape	string	The shape of the deposit.
length_m	int	The length of the deposit in meters.
width_m	int	The width of the deposit in meters.
thickness_m	int	The thickness of the deposit in meters.
depth_m	int	The depth of the deposit in meters.
date_updated	timestamp	The date of the last update to the row.
unfc_classification	string	The UNFC classification of the row.
other_commodities	string	The other commodities associated with the row.
dip_azim	int	The azimuth dip of the row.
dip	int	The dip of the row.
plunge_azim	int	The azimuth plunge of the row.
plunge_dip	int	The plunge dip of the row.
wall_rocks	string	The rocks forming the walls of the deposit.
current_holder	string	The current holder of the row.
district	string	The district where the row is located.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in Geotext format.
geom_type	string	The type of geometry for the row.
geom_centroid	string	The centroid of the geometry for the row.
geom_center_x	double	The x-coordinate of the center of the geometry for the row.
geom_center_y	double	The y-coordinate of the center of the geometry for the row.
geom	binary	The geometry of the row in a specific format.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024