Geological Survey of Finland (GTK) - Geological Interpretation of Rock Structures at 100k Scale - Version History of Geological Survey of Finland Rock Interpretation 100k Rock Phase - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Version History of Geological Survey of Finland Rock Interpretation 100k Rock Phase

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

This table contains the version history of the base table 'kallioperan_rakennetulkinta_100k_rakennevaihe', sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). It includes information about various structural elements, fault types, fault movement senses, fault movement types, fold types, structure names, and geometries. The table has additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The '_end_date' column contains null for the most recent version of the row. The table provides valuable data for data analytics and geological analysis, allowing users to analyze the evolution of geological structures over time, identify structural patterns, investigate fault movements, study fold types, and perform spatial analysis using the geometry columns. Using this data, researchers and analysts can gain valuable insights into the geological composition and changes in the specified region in Finland (Country ISO code: 'fi').

Field Descriptions

Name	Data type	Description
_start_date	date	Indicates the start date of the validity period of the row version.
_end_date	date	Indicates the end date of the validity period of the row version.
_row_number	long	The row number of the version in the history.
gml_id	string	The unique identifier of the version entry in GML format.
objectid	int	The unique identifier of the version entry.
reactivation	int	Indicates if the row version represents a reactivation of an object.
reactivation_c3	string	Indicates the type of reactivation of the object in version C3.
structure_type_19201900	int	The structure type of the object in the year range 1920-1900.
structure_type_19201900_c5	string	The structure type of the object in version C5 in the year range 1920-1900.
main_structure_name_19201900	string	The name of the main structure of the object in the year range 1920-1900.
cgi_fault_type_19201900	string	The type of CGI (Computer-Generated Imagery) fault of the object in the year range 1920-1900.
cgi_fault_movement_sense_19201900	string	Indicates the movement sense of the CGI fault of the object in the year range 1920-1900.
cgi_fault_movement_type_19201900	string	Indicates the movement type of the CGI fault of the object in the year range 1920-1900.
shape_len	int	The length of the shape representation of the object.
structure_type_18301800	int	The structure type of the object in the year range 1830-1800.
structure_type_18301800_c12	string	The structure type of the object in version C12 in the year range 1830-1800.
main_structure_name_18301800	string	The name of the main structure of the object in the year range 1830-1800.
cgi_fault_type_18301800	string	The type of CGI fault of the object in the year range 1830-1800.
cgi_fault_movement_sense_18301800	string	Indicates the movement sense of the CGI fault of the object in the year range 1830-1800.
cgi_fault_movement_type_18301800	string	Indicates the movement type of the CGI fault of the object in the year range 1830-1800.
reference	string	A reference value associated with the object.
structure_type_18901860	int	The structure type of the object in the year range 1890-1860.
structure_type_18901860_c19	string	The structure type of the object in version C19 in the year range 1890-1860.
cgi_fault_type_18901860	string	The type of CGI fault of the object in the year range 1890-1860.
cgi_fault_movement_sense_18901860	string	Indicates the movement sense of the CGI fault of the object in the year range 1890-1860.
cgi_fault_movement_type_18901860	string	Indicates the movement type of the CGI fault of the object in the year range 1890-1860.
main_structure_name_18901860	string	The name of the main structure of the object in the year range 1890-1860.
structure_type_17901770	int	The structure type of the object in the year range 1790-1770.
structure_type_17901770_c25	string	The structure type of the object in version C25 in the year range 1790-1770.
cgi_fault_type_17901770	string	The type of CGI fault of the object in the year range 1790-1770.
cgi_fault_movement_sense_17901770	string	Indicates the movement sense of the CGI fault of the object in the year range 1790-1770.
cgi_fault_movement_type_17901770	string	Indicates the movement type of the CGI fault of the object in the year range 1790-1770.
main_structure_name_17901770	string	The name of the main structure of the object in the year range 1790-1770.
cgi_fold_type_19201900	string	The fold type of the object in the year range 1920-1900 using CGI.
cgi_fold_type_18901860	string	The fold type of the object in the year range 1890-1860 using CGI.
structure_name_18901860	string	The name of the structure of the object in the year range 1890-1860.
structure_name_17901770	string	The name of the structure of the object in the year range 1790-1770.
cgi_fold_type_18301800	string	The fold type of the object in the year range 1830-1800 using CGI.
structure_type_1700542	int	The structure type of the object in the category 1700542.
structure_type_1700542_c36	string	The structure type of the object in version C36 in the category 1700542.
cgi_fault_type_1700542	string	The type of CGI fault of the object in the category 1700542.
cgi_fault_movement_sense_1700542	string	Indicates the movement sense of the CGI fault of the object in the category 1700542.
cgi_fault_movement_type_1700542	string	Indicates the movement type of the CGI fault of the object in the category 1700542.
geom_geojson	string	The geometry representation of the object in GeoJSON format.
geom_geotext	string	The geometry representation of the object in GeoText format.
geom_type	string	The type of the object's geometry.
geom_centroid	string	The centroid of the object's geometry.
geom_center_x	double	The X-coordinate of the center of the object's geometry.
geom_center_y	double	The Y-coordinate of the center of the object's geometry.
geom	binary	The geometry representation of the object.

Name

Data type

Description

_start_date

date

Indicates the start date of the validity period of the row version.

_end_date

date

Indicates the end date of the validity period of the row version.

_row_number

long

The row number of the version in the history.

gml_id

string

The unique identifier of the version entry in GML format.

objectid

int

The unique identifier of the version entry.

reactivation

int

Indicates if the row version represents a reactivation of an object.

reactivation_c3

string

Indicates the type of reactivation of the object in version C3.

structure_type_19201900

int

The structure type of the object in the year range 1920-1900.

structure_type_19201900_c5

string

The structure type of the object in version C5 in the year range 1920-1900.

main_structure_name_19201900

string

The name of the main structure of the object in the year range 1920-1900.

cgi_fault_type_19201900

string

The type of CGI (Computer-Generated Imagery) fault of the object in the year range 1920-1900.

cgi_fault_movement_sense_19201900

string

Indicates the movement sense of the CGI fault of the object in the year range 1920-1900.

cgi_fault_movement_type_19201900

string

Indicates the movement type of the CGI fault of the object in the year range 1920-1900.

shape_len

int

The length of the shape representation of the object.

structure_type_18301800

int

The structure type of the object in the year range 1830-1800.

structure_type_18301800_c12

string

The structure type of the object in version C12 in the year range 1830-1800.

main_structure_name_18301800

string

The name of the main structure of the object in the year range 1830-1800.

cgi_fault_type_18301800

string

The type of CGI fault of the object in the year range 1830-1800.

cgi_fault_movement_sense_18301800

string

Indicates the movement sense of the CGI fault of the object in the year range 1830-1800.

cgi_fault_movement_type_18301800

string

Indicates the movement type of the CGI fault of the object in the year range 1830-1800.

reference

string

A reference value associated with the object.

structure_type_18901860

int

The structure type of the object in the year range 1890-1860.

structure_type_18901860_c19

string

The structure type of the object in version C19 in the year range 1890-1860.

cgi_fault_type_18901860

string

The type of CGI fault of the object in the year range 1890-1860.

cgi_fault_movement_sense_18901860

string

Indicates the movement sense of the CGI fault of the object in the year range 1890-1860.

cgi_fault_movement_type_18901860

string

Indicates the movement type of the CGI fault of the object in the year range 1890-1860.

main_structure_name_18901860

string

The name of the main structure of the object in the year range 1890-1860.

structure_type_17901770

int

The structure type of the object in the year range 1790-1770.

structure_type_17901770_c25

string

The structure type of the object in version C25 in the year range 1790-1770.

cgi_fault_type_17901770

string

The type of CGI fault of the object in the year range 1790-1770.

cgi_fault_movement_sense_17901770

string

Indicates the movement sense of the CGI fault of the object in the year range 1790-1770.

cgi_fault_movement_type_17901770

string

Indicates the movement type of the CGI fault of the object in the year range 1790-1770.

main_structure_name_17901770

string

The name of the main structure of the object in the year range 1790-1770.

cgi_fold_type_19201900

string

The fold type of the object in the year range 1920-1900 using CGI.

cgi_fold_type_18901860

string

The fold type of the object in the year range 1890-1860 using CGI.

structure_name_18901860

string

The name of the structure of the object in the year range 1890-1860.

structure_name_17901770

string

The name of the structure of the object in the year range 1790-1770.

cgi_fold_type_18301800

string

The fold type of the object in the year range 1830-1800 using CGI.

structure_type_1700542

int

The structure type of the object in the category 1700542.

structure_type_1700542_c36

string

The structure type of the object in version C36 in the category 1700542.

cgi_fault_type_1700542

string

The type of CGI fault of the object in the category 1700542.

cgi_fault_movement_sense_1700542

string

Indicates the movement sense of the CGI fault of the object in the category 1700542.

cgi_fault_movement_type_1700542

string

Indicates the movement type of the CGI fault of the object in the category 1700542.

geom_geojson

string

The geometry representation of the object in GeoJSON format.

geom_geotext

string

The geometry representation of the object in GeoText format.

geom_type

string

The type of the object's geometry.

geom_centroid

string

The centroid of the object's geometry.

geom_center_x

double

The X-coordinate of the center of the object's geometry.

geom_center_y

double

The Y-coordinate of the center of the object's geometry.

geom

binary

The geometry representation of the object.

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	26c22a2d-254c-4f3e-97c6-097b140f2a87
Package id	30c00afb-3562-462f-8c0d-af76466af7bc
Position	1
Revision id	d26b74ee-7e2a-444f-b53b-cfef92fd3081
State	active
Table	rajapinnat_gtk_kalliopera_wfskallioperan_rakennetulkinta_100k_rakennevaihe__kallioperan_rakennetulkinta_100k_rakennevaihe__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

26c22a2d-254c-4f3e-97c6-097b140f2a87

Package id

30c00afb-3562-462f-8c0d-af76466af7bc

Position

Revision id

d26b74ee-7e2a-444f-b53b-cfef92fd3081

State

active

Table

rajapinnat_gtk_kalliopera_wfskallioperan_rakennetulkinta_100k_rakennevaihe__kallioperan_rakennetulkinta_100k_rakennevaihe__history

Version History of Geological Survey of Finland Rock Interpretation 100k Rock Phase

Field Descriptions

No sample for this dataset

Additional Information