Geological Survey of Finland - National Borehole Archive (WFS)

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

Tables

Geological Survey of Finland (GTK) National Borehole Data Archive - National Borehole Data ArchiveTSV
This table contains data from the 'Geological Survey of Finland' (Geologian tutkimuskeskus) website, originating from Finland (ISO country code 'fi'). It represents the 'National Drill Core Archive' (Valtakunnallinen Kairasydänarkisto) with information about rock drilling sites. The table includes various attributes such as the extraction date, row number, GML ID, object ID, archive number, hole ID, coordinates (northing, easting, northing in YKJ system, easting in YKJ system), UTM 50K sheet, drilling year, hole length, hole azimuth, hole dip, soil drilling information, organization, sender company, receiving date, number of boxes, storage place, archive place, status, drilling contractor, geometry information (geojson, geotext, type, centroid, center x, center y). The data in this...
Version History of National Rock Core Archive from Geological Survey of Finland (GTK) (from Finland)TSV
This table represents the version history of the 'valtakunnallinen_kairasydanarkisto' table sourced from the website of 'Geological Survey of Finland'. It contains historical records of various parameters related to drilling in the field of geology. The table includes columns such as '_start_date' (the date when the row was extracted), '_end_date' (the date of the next version of the row), 'gml_id', 'objectid', 'archive_number', 'hole_id2', 'northing', 'easting', 'northing_ykj', 'easting_ykj', 'utm_50k_sheet', 'drilling_year', 'hole_length', 'hole_azimuth', 'hole_dip', 'soil_drilling', 'organization', 'sender_company', 'receiving_date', 'boxes', 'storage_place', 'archive_place', 'status', 'hole_id', 'drilling_contractor', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid',...

Column Descriptions

Geological Survey of Finland (GTK) National Borehole Data Archive - National Borehole Data Archive

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
gml_id	string	The identifier for the GML object.
objectid	int	The unique identifier for each object.
archive_number	int	The archive number of the record.
hole_id2	string	The secondary identifier for the drilling hole.
northing	int	The northing coordinate of the drilling hole.
easting	int	The easting coordinate of the drilling hole.
northing_ykj	int	The northing coordinate in YKJ projection.
easting_ykj	int	The easting coordinate in YKJ projection.
utm_50k_sheet	string	The UTM 50K sheet number.
drilling_year	int	The year when the drilling took place.
hole_length	int	The length of the drilling hole.
hole_azimuth	int	The azimuth of the drilling hole.
hole_dip	int	The dip of the drilling hole.
soil_drilling	int	Indicator of soil drilling.
organization	string	The organization responsible for the drilling.
sender_company	string	The company that sent the drilling data.
receiving_date	timestamp	The date when the data was received.
boxes	int	The number of boxes containing the drilling data.
storage_place	string	The place where the drilling data is stored.
archive_place	string	The archive place of the drilling data.
status	string	The status of the record.
hole_id	string	The identifier for the drilling hole.
drilling_contractor	string	The contractor responsible for the drilling.
geom_geojson	string	The geometry of the drilling hole in GeoJSON format.
geom_geotext	string	The geometry of the drilling hole in Geotext format.
geom_type	string	The type of geometry for the drilling hole.
geom_centroid	string	The centroid of the drilling hole geometry.
geom_center_x	double	The x-coordinate of the center of the drilling hole geometry.
geom_center_y	double	The y-coordinate of the center of the drilling hole geometry.
geom	binary	The complete geometry of the drilling hole.

Version History of National Rock Core Archive from Geological Survey of Finland (GTK) (from Finland)

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 row number of the version history.
gml_id	string	The GML identifier of the row.
objectid	int	The identifier of the object.
archive_number	int	The archive number of the row.
hole_id2	string	The ID of the hole.
northing	int	The northing coordinate of the row.
easting	int	The easting coordinate of the row.
northing_ykj	int	The northing YKJ coordinate of the row.
easting_ykj	int	The easting YKJ coordinate of the row.
utm_50k_sheet	string	The UTM 50K sheet of the row.
drilling_year	int	The year of the drilling.
hole_length	int	The length of the hole.
hole_azimuth	int	The azimuth of the hole.
hole_dip	int	The dip of the hole.
soil_drilling	int	The type of soil drilling.
organization	string	The organization name.
sender_company	string	The name of the sender company.
receiving_date	timestamp	The receiving date of the row.
boxes	int	The number of boxes.
storage_place	string	The storage place of the row.
archive_place	string	The archive place of the row.
status	string	The status of the row.
hole_id	string	The ID of the hole.
drilling_contractor	string	The name of the drilling contractor.
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 row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024