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

Version History of Rock Boreholes Table

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

This table represents the version history of the 'kallioperakairaukset' table extracted from the web site of Geologian tutkimuskeskus (Geological Survey of Finland) in Finland. It contains information about various attributes of rock core drillings, such as hole ID, length, location, organization, drilling year, depths, azimuth, dip, target name, spatial accuracy, reliability, positioning method, surface rock name, and more. The table includes additional columns '_start_date' and '_end_date' that indicate the extraction dates of each row version. The '_end_date' column is null for the most recent row version. The table can be utilized in data analytics to analyze trends and changes in rock core drilling attributes over time, assess rock properties and characteristics, evaluate data reliability and spatial accuracy, study geological formations, perform geospatial analysis, and gain insights into the history and patterns of rock core drilling activities in Finland.

Field Descriptions

Name	Data type	Description
_start_date	date	The date when the row version starts being valid.
_end_date	date	The date when the row version ends its validity.
_row_number	long	A unique identifier for each row version.
gml_id	string	An identifier used in Geography Markup Language.
objectid	int	An identifier for the object in the table.
hole_id	string	An identifier for the hole.
hole_length	int	The length of the hole.
organization	string	The organization responsible for the data collection.
easting	int	The easting coordinate of the location.
northing	int	The northing coordinate of the location.
utm_50k_sheet	string	The UTM 50k sheet of the location.
kkj_100k_sheet	int	The KKJ 100k sheet of the location.
drilling_year	int	The year when 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.
hole_dip	int	The dip of the hole.
target_name	string	The name of the target.
spatial_accuracy	string	The spatial accuracy of the data collection.
reliability	string	The reliability of the data.
positioning_method	string	The method used for positioning.
z	int	The z-coordinate of the location.
z_spatial_accuracy	string	The spatial accuracy of the z-coordinate.
purpose_of_data_collection	string	The purpose of the data collection.
z_reliability	string	The reliability of the z-coordinate.
z_positioning_method	string	The positioning method used for the z-coordinate.
surface_rock_name	string	The name of the surface rock.
location	string	The location description.
analysis	string	The type of analysis performed.
report_link	string	The link to the report.
scanning_method	string	The scanning method used.
scanning_year	int	The year when the scanning was performed.
processing_level	int	The level of processing performed on the data.
soil_drilling	int	Indicates if the drilling was focused on soil collection.
petrophysics	string	The study of physical and chemical properties of rocks.
hole_id2	string	A secondary identifier for the hole.
thin_section	string	Indicates if a thin section was made from the sample.
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.

Name

Data type

Description

_start_date

date

The date when the row version starts being valid.

_end_date

date

The date when the row version ends its validity.

_row_number

long

A unique identifier for each row version.

gml_id

string

An identifier used in Geography Markup Language.

objectid

int

An identifier for the object in the table.

hole_id

string

An identifier for the hole.

hole_length

int

The length of the hole.

organization

string

The organization responsible for the data collection.

easting

int

The easting coordinate of the location.

northing

int

The northing coordinate of the location.

utm_50k_sheet

string

The UTM 50k sheet of the location.

kkj_100k_sheet

int

The KKJ 100k sheet of the location.

drilling_year

int

The year when 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.

hole_dip

int

The dip of the hole.

target_name

string

The name of the target.

spatial_accuracy

string

The spatial accuracy of the data collection.

reliability

string

The reliability of the data.

positioning_method

string

The method used for positioning.

int

The z-coordinate of the location.

z_spatial_accuracy

string

The spatial accuracy of the z-coordinate.

purpose_of_data_collection

string

The purpose of the data collection.

z_reliability

string

The reliability of the z-coordinate.

z_positioning_method

string

The positioning method used for the z-coordinate.

surface_rock_name

string

The name of the surface rock.

location

string

The location description.

analysis

string

The type of analysis performed.

report_link

string

The link to the report.

scanning_method

string

The scanning method used.

scanning_year

int

The year when the scanning was performed.

processing_level

int

The level of processing performed on the data.

soil_drilling

int

Indicates if the drilling was focused on soil collection.

petrophysics

string

The study of physical and chemical properties of rocks.

hole_id2

string

A secondary identifier for the hole.

thin_section

string

Indicates if a thin section was made from the sample.

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.

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	09a6e1cd-147d-4717-88f4-2f15df9cf316
Package id	317ac578-ae12-4ebf-8198-44268c847fc1
Position	1
Revision id	f4b91f02-1fa3-4d95-a558-d564dc6f4d23
State	active
Table	rajapinnat_gtk_kalliopera_wfskallioperakairaukset__kallioperakairaukset__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

09a6e1cd-147d-4717-88f4-2f15df9cf316

Package id

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

Position

Revision id

f4b91f02-1fa3-4d95-a558-d564dc6f4d23

State

active

Table

rajapinnat_gtk_kalliopera_wfskallioperakairaukset__kallioperakairaukset__history

Version History of Rock Boreholes Table

Field Descriptions

No sample for this dataset

Additional Information