Geological Survey of Finland - Rock Surface Boulders Observations
Tables
-
Lohkarehavainnot - Version HistoryTSV
This table represents the version history of the 'rajapinnat_gtk_kalliopera_wfslohkarehavainnot__lohkarehavainnot' table. It contains information about the various versions of the rows in the base table along with the extraction dates. The table has additional columns '_start_date' and '_end_date' which indicate the start and end dates of each version. The data in this table can be utilized for various data analytics purposes. For example, it can be used to track the changes made to the rows over time, analyze the trends in different attributes like rock type, metal presence, grade, mineral composition, and dimensions of the samples. It can also be used to study the spatial distribution of the samples by analyzing the geographic coordinates and associated geometries. This table is...
-
Rock Observations in FinlandTSV
This table contains data about observations of boulders in the 'Geologian tutkimuskeskus' database. The data is sourced from the website of 'Geological Survey of Finland' (Geologian tutkimuskeskus) and originates from the country with ISO country code 'Finland'. The table includes various columns such as observation details, organization, purpose, data source, reference, location information, rock properties, sample details, chemical analysis, mineral composition, dimensions, petrophysical properties, and geographic information. The data can be utilized for data analytics purposes, such as analyzing the distribution of boulders based on location, exploring the relationship between rock properties and chemical composition, examining the variations in dimensions and petrophysical...
Column Descriptions
Rock Observations in Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the data entry. |
| gml_id | string | The unique identifier for each entry in GML format. |
| objectid | int | The unique identifier for each object in the table. |
| obsid | string | The identifier for each observation. |
| subtype | string | The subtype or category of the object. |
| organization | string | The organization responsible for the data entry. |
| purpose | string | The purpose of the data entry or observation. |
| datasource | string | The source of the data. |
| reference | string | The reference or source citation for the data. |
| location | string | The geographic location of the object or observation. |
| kkj_100k_sheet | int | The sheet number in KKJ 100K coordinate system. |
| utm_50k_sheet | string | The sheet number in UTM 50K coordinate system. |
| rock_name | string | The name of the rock type. |
| metal | string | The type of metal present in the sample. |
| grade | string | The grade or quality of the sample. |
| northing | int | The northing coordinate of the object. |
| easting | int | The easting coordinate of the object. |
| sampleid | string | The identifier for each sample. |
| chemical_analysis | string | The results of chemical analysis for the sample. |
| sampleno | string | The number of samples. |
| year | int | The year of the observation or data entry. |
| mineral | string | The type of mineral present in the sample. |
| length_meter | int | The length of the object in meters. |
| width_meter | int | The width of the object in meters. |
| height_meter | int | The height of the object in meters. |
| petrophysics | string | The study of physical and mechanical properties of rocks. |
| 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 for the object. |
| geom_centroid | string | The centroid of the object's 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. |
Lohkarehavainnot - Version History
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period for the row version. |
| _end_date | date | The end date of the validity period for the row version. |
| _row_number | long | A unique identifier for each row version. |
| gml_id | string | An identifier used in the Geography Markup Language (GML) for this row version. |
| objectid | int | The object identifier for this row version. |
| obsid | string | An observation identifier for this row version. |
| subtype | string | A subcategory or type for this row version. |
| organization | string | The organization associated with this row version. |
| purpose | string | The purpose or objective of this row version. |
| datasource | string | The source or origin of the data for this row version. |
| reference | string | A reference or citation for this row version. |
| location | string | The location or place associated with this row version. |
| kkj_100k_sheet | int | The sheet identifier in the KKJ coordinate system at a scale of 1:100,000 for this row version. |
| utm_50k_sheet | string | The sheet identifier in the UTM coordinate system at a scale of 1:50,000 for this row version. |
| rock_name | string | The name of the rock in this row version. |
| metal | string | The type of metal in this row version. |
| grade | string | The grade or quality of the metal in this row version. |
| northing | int | The northing coordinate value for the location of this row version. |
| easting | int | The easting coordinate value for the location of this row version. |
| sampleid | string | The identifier for the sample associated with this row version. |
| chemical_analysis | string | The results of chemical analysis for the sample in this row version. |
| sampleno | string | The sample number or code for this row version. |
| year | int | The year of data collection or observation for this row version. |
| mineral | string | The mineral type or composition in this row version. |
| length_meter | int | The length measured in meters for this row version. |
| width_meter | int | The width measured in meters for this row version. |
| height_meter | int | The height measured in meters for this row version. |
| petrophysics | string | The study of physical and chemical properties of rocks in this row version. |
| geom_geojson | string | The geometry of the row version represented in the GeoJSON format. |
| geom_geotext | string | The text representation of the geometry of the row version. |
| geom_type | string | The type of geometry for this row version. |
| geom_centroid | string | The centroid or center point of the geometry for this row version. |
| geom_center_x | double | The x-coordinate of the center point of the geometry for this row version. |
| geom_center_y | double | The y-coordinate of the center point of the geometry for this row version. |
| geom | binary | The geometry object for this row version. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |