Version History of National Rock Core Archive from Geological Survey of Finland (GTK) (from Finland)
Click here for a data sample
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', 'geom_center_x', and 'geom_center_y'. The table provides valuable data for data analytics, such as analyzing drilling trends over time, identifying drilling patterns in specific geographical areas, and tracking the status and organizations associated with each drilling record. It is a valuable resource for geologists and researchers interested in understanding the geological characteristics of Finland.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
