Geological Survey of Finland (GTK) National Borehole Data Archive - National Borehole Data Archive
Click here for a data sample
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 table can be utilized for various data analytics tasks such as locating and analyzing specific drilling sites, calculating statistical properties of drilling attributes, visualizing geographical distribution of the drilling sites, and assessing the relationship between drilling attributes and other geological factors.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
