Geological Survey of Finland - Rock Surface Boulders Observations - Lohkarehavainnot - Version History - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Lohkarehavainnot - Version History

To download the data set, please sign up or log in

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 sourced from the website of 'Geological Survey of Finland' which is the national geological survey organization of Finland (ISO country code: 'FI').

Field Descriptions

Name	Data type	Description
_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.

Name

Data type

Description

_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 Information


Last updated	April 22, 2024
Created	April 22, 2024
License	No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapter	delta
Country	fi
Database	fi_geologian_tutkimuskeskus
Id	7766023a-bb6a-457d-b0ed-a9e22c69444f
Package id	f51b9009-6e39-4bfa-8667-98f503f7b392
Position	1
Revision id	5f1ad7a1-9467-4d69-9fae-6521b6d485bd
State	active
Table	rajapinnat_gtk_kalliopera_wfslohkarehavainnot__lohkarehavainnot__history

Last updated

April 22, 2024

Created

April 22, 2024

License

No License Provided

Geographic coverage

Geographic granularity

Temporal coverage from

Temporal coverage to

Adapter

delta

Country

Database

fi_geologian_tutkimuskeskus

7766023a-bb6a-457d-b0ed-a9e22c69444f

Package id

f51b9009-6e39-4bfa-8667-98f503f7b392

Position

Revision id

5f1ad7a1-9467-4d69-9fae-6521b6d485bd

State

active

Table

rajapinnat_gtk_kalliopera_wfslohkarehavainnot__lohkarehavainnot__history

Lohkarehavainnot - Version History

Field Descriptions

No sample for this dataset

Additional Information