Geological Survey of Finland - Rock Drilling Data
Tables
-
Geological Survey of Finland - Rock Drilling DataTSV
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...
-
Version History of Rock Boreholes TableTSV
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...
Column Descriptions
Geological Survey of Finland - Rock Drilling Data
| Column | Type | Comment |
|---|---|---|
| _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. |
Version History of Rock Boreholes Table
| Column | Type | Comment |
|---|---|---|
| _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. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |