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

Geological Survey of Finland - Rock Drilling Data

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

This table contains data from the 'Geological Survey of Finland' website, consisting of information related to rock drillings. The data includes various attributes such as the extract date, row number, GML ID, hole ID, hole length, organization, coordinates, drilling year, depths, azimuth, dip, target name, spatial accuracy, reliability, positioning method, elevation, purpose of data collection, surface rock name, location, analysis, report link, scanning method, scanning year, processing level, soil drilling, petrophysics, thin section, and geometry information. The table provides valuable data for performing data analytics on rock drillings, such as analyzing the distribution of drilling locations, studying the correlation between drilling depths and rock characteristics, and investigating the relationship between drilling parameters and surface rock types. The data is sourced from the Geological Survey of Finland's website and originates from Finland (ISO country code: 'fi').

Field Descriptions

Name	Data type	Description
_extract_date	date	The date when the data was extracted from the source system.
_row_number	long	The sequential number assigned to each row in the table.
gml_id	string	The unique identifier in GML (Geography Markup Language) format.
objectid	int	The unique identifier for each object in the table.
hole_id	string	The identifier for each hole in the dataset.
hole_length	int	The length of the hole in the dataset.
organization	string	The organization responsible for the data collection.
easting	int	The easting coordinate of the location where the data was collected.
northing	int	The northing coordinate of the location where the data was collected.
utm_50k_sheet	string	The UTM 50k sheet in which the data collection location falls.
kkj_100k_sheet	int	The KKJ 100k sheet in which the data collection location falls.
drilling_year	int	The year in which the drilling took place.
start_depth	int	The starting depth of the hole.
end_depth	int	The ending depth of the hole.
hole_azimuth	int	The azimuth of the hole in degrees.
hole_dip	int	The dip of the hole in degrees.
target_name	string	The name of the target or purpose of the drilling.
spatial_accuracy	string	The accuracy of the spatial data.
reliability	string	The reliability of the data.
positioning_method	string	The method used for positioning the data.
z	int	The elevation or depth value.
z_spatial_accuracy	string	The accuracy of the elevation or depth value.
purpose_of_data_collection	string	The purpose for which the data was collected.
z_reliability	string	The reliability of the elevation or depth value.
z_positioning_method	string	The method used for positioning the elevation or depth value.
surface_rock_name	string	The name of the surface rock.
location	string	The location of the data collection site.
analysis	string	The type of analysis performed on the data.
report_link	string	The link to the report associated with the data.
scanning_method	string	The method used for scanning the data.
scanning_year	int	The year in which the scanning took place.
processing_level	int	The processing level of the data.
soil_drilling	int	The type of drilling method used for soil.
petrophysics	string	The field of study concerned with the physical and chemical properties of rocks.
hole_id2	string	The identifier for each hole in the dataset (alternative).
thin_section	string	The thin section of the collected sample.
geom_geojson	string	The spatial data in GeoJSON format.
geom_geotext	string	The spatial data in Geotext format.
geom_type	string	The type of geometry of the spatial data.
geom_centroid	string	The centroid of the spatial data.
geom_center_x	double	The x-coordinate of the center of the spatial data.
geom_center_y	double	The y-coordinate of the center of the spatial data.
geom	binary	The spatial data.

Name

Data type

Description

_extract_date

date

The date when the data was extracted from the source system.

_row_number

long

The sequential number assigned to each row in the table.

gml_id

string

The unique identifier in GML (Geography Markup Language) format.

objectid

int

The unique identifier for each object in the table.

hole_id

string

The identifier for each hole in the dataset.

hole_length

int

The length of the hole in the dataset.

organization

string

The organization responsible for the data collection.

easting

int

The easting coordinate of the location where the data was collected.

northing

int

The northing coordinate of the location where the data was collected.

utm_50k_sheet

string

The UTM 50k sheet in which the data collection location falls.

kkj_100k_sheet

int

The KKJ 100k sheet in which the data collection location falls.

drilling_year

int

The year in which the drilling took place.

start_depth

int

The starting depth of the hole.

end_depth

int

The ending depth of the hole.

hole_azimuth

int

The azimuth of the hole in degrees.

hole_dip

int

The dip of the hole in degrees.

target_name

string

The name of the target or purpose of the drilling.

spatial_accuracy

string

The accuracy of the spatial data.

reliability

string

The reliability of the data.

positioning_method

string

The method used for positioning the data.

int

The elevation or depth value.

z_spatial_accuracy

string

The accuracy of the elevation or depth value.

purpose_of_data_collection

string

The purpose for which the data was collected.

z_reliability

string

The reliability of the elevation or depth value.

z_positioning_method

string

The method used for positioning the elevation or depth value.

surface_rock_name

string

The name of the surface rock.

location

string

The location of the data collection site.

analysis

string

The type of analysis performed on the data.

report_link

string

The link to the report associated with the data.

scanning_method

string

The method used for scanning the data.

scanning_year

int

The year in which the scanning took place.

processing_level

int

The processing level of the data.

soil_drilling

int

The type of drilling method used for soil.

petrophysics

string

The field of study concerned with the physical and chemical properties of rocks.

hole_id2

string

The identifier for each hole in the dataset (alternative).

thin_section

string

The thin section of the collected sample.

geom_geojson

string

The spatial data in GeoJSON format.

geom_geotext

string

The spatial data in Geotext format.

geom_type

string

The type of geometry of the spatial data.

geom_centroid

string

The centroid of the spatial data.

geom_center_x

double

The x-coordinate of the center of the spatial data.

geom_center_y

double

The y-coordinate of the center of the spatial data.

geom

binary

The spatial data.

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	df9b5236-1806-4aaf-b2e7-c13f277badaa
Package id	317ac578-ae12-4ebf-8198-44268c847fc1
Revision id	93163d7e-a553-4f7f-88d0-2ae5d09e725c
State	active
Table	rajapinnat_gtk_kalliopera_wfskallioperakairaukset__kallioperakairaukset

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

df9b5236-1806-4aaf-b2e7-c13f277badaa

Package id

317ac578-ae12-4ebf-8198-44268c847fc1

Revision id

93163d7e-a553-4f7f-88d0-2ae5d09e725c

State

active

Table

rajapinnat_gtk_kalliopera_wfskallioperakairaukset__kallioperakairaukset

Geological Survey of Finland - Rock Drilling Data

Field Descriptions

No sample for this dataset

Additional Information