Rock Observations in Finland
Click here for a data sample
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 properties, and visualizing the distribution of boulders on a map.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
