Geological Survey of Finland (GTK) Rock Layers WFS Complex Suite Lithodemic Units - Version History of Geologic Units in Finland - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Version History of Geologic Units in Finland

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

This table contains the version history of the rows in the 'Geologian tutkimuskeskus' database table 'rajapinnat_gtk_kalliopera_wfskompleksi_sviitti_litodeemiset_yksikot__kompleksi_sviitti_litodeemiset_yksikot'. The table tracks changes in the base table rows over time and includes two additional columns: '_start_date' and '_end_date'. The '_start_date' column represents the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the corresponding row is the most recent version. The table contains various columns such as 'gml_id', 'objectid', 'eon', 'era', 'period', 'chronostraticraphic_unit', 'epoch', 'supersuite', 'suite', 'lithodeme', 'unit_criterion', 'original_name', 'rock_class', 'rock_name', 'shape_area', 'shape_len', 'nick_name', 'phase', 'supergroup', 'group_col', 'formation', 'member', 'complex', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table can be utilized for data analytics purposes such as trend analysis, tracking changes in geological units over time, identifying patterns in rock characteristics, calculating geometric properties of geological units, and geospatial analysis. The data source for this table is the website of 'Geological Survey of Finland' and it originates from 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	The row number of the version history.
gml_id	string	The GML ID associated with the row.
objectid	int	The ID of the object.
eon	int	The eon value associated with the row.
eon_c3	string	The eon c3 value associated with the row.
era	int	The era value associated with the row.
era_c5	string	The era c5 value associated with the row.
period	int	The period value associated with the row.
period_c7	string	The period c7 value associated with the row.
chronostraticraphic_unit	int	The chronostraticraphic unit associated with the row.
chronostraticraphic_unit_c9	string	The chronostraticraphic unit c9 value associated with the row.
epoch	int	The epoch value associated with the row.
epoch_c11	string	The epoch c11 value associated with the row.
supersuite	int	The supersuite value associated with the row.
supersuite_c13	string	The supersuite c13 value associated with the row.
suite	int	The suite value associated with the row.
suite_c15	string	The suite c15 value associated with the row.
lithodeme	int	The lithodeme value associated with the row.
lithodeme_c17	string	The lithodeme c17 value associated with the row.
unit_criterion	int	The unit criterion associated with the row.
unit_criterion_c19	string	The unit criterion c19 value associated with the row.
original_name	string	The original name associated with the row.
rock_class	int	The rock class associated with the row.
rock_class_c22	string	The rock class c22 value associated with the row.
rock_name	int	The rock name associated with the row.
rock_name_c24	string	The rock name c24 value associated with the row.
shape_area	int	The area of the shape associated with the row.
shape_len	int	The length of the shape associated with the row.
nick_name	string	The nickname associated with the row.
phase	int	The phase associated with the row.
phase_c29	string	The phase c29 value associated with the row.
supergroup	int	The supergroup associated with the row.
supergroup_c31	string	The supergroup c31 value associated with the row.
group_col	int	The group column associated with the row.
group_col_c33	string	The group column c33 value associated with the row.
formation	int	The formation associated with the row.
formation_c35	string	The formation c35 value associated with the row.
member	int	The member associated with the row.
member_c37	string	The member c37 value associated with the row.
complex	int	The complex associated with the row.
complex_c39	string	The complex c39 value associated with the row.
geom_geojson	string	The geometry in GeoJSON format associated with the row.
geom_geotext	string	The geometry in GEOTEXT format associated with the row.
geom_type	string	The type of geometry associated with the row.
geom_centroid	string	The centroid of the geometry associated with the row.
geom_center_x	double	The X-coordinate of the center of the geometry associated with the row.
geom_center_y	double	The Y-coordinate of the center of the geometry associated with the row.
geom	binary	The geometry associated with the row.

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

The row number of the version history.

gml_id

string

The GML ID associated with the row.

objectid

int

The ID of the object.

eon

int

The eon value associated with the row.

eon_c3

string

The eon c3 value associated with the row.

era

int

The era value associated with the row.

era_c5

string

The era c5 value associated with the row.

period

int

The period value associated with the row.

period_c7

string

The period c7 value associated with the row.

chronostraticraphic_unit

int

The chronostraticraphic unit associated with the row.

chronostraticraphic_unit_c9

string

The chronostraticraphic unit c9 value associated with the row.

epoch

int

The epoch value associated with the row.

epoch_c11

string

The epoch c11 value associated with the row.

supersuite

int

The supersuite value associated with the row.

supersuite_c13

string

The supersuite c13 value associated with the row.

suite

int

The suite value associated with the row.

suite_c15

string

The suite c15 value associated with the row.

lithodeme

int

The lithodeme value associated with the row.

lithodeme_c17

string

The lithodeme c17 value associated with the row.

unit_criterion

int

The unit criterion associated with the row.

unit_criterion_c19

string

The unit criterion c19 value associated with the row.

original_name

string

The original name associated with the row.

rock_class

int

The rock class associated with the row.

rock_class_c22

string

The rock class c22 value associated with the row.

rock_name

int

The rock name associated with the row.

rock_name_c24

string

The rock name c24 value associated with the row.

shape_area

int

The area of the shape associated with the row.

shape_len

int

The length of the shape associated with the row.

nick_name

string

The nickname associated with the row.

phase

int

The phase associated with the row.

phase_c29

string

The phase c29 value associated with the row.

supergroup

int

The supergroup associated with the row.

supergroup_c31

string

The supergroup c31 value associated with the row.

group_col

int

The group column associated with the row.

group_col_c33

string

The group column c33 value associated with the row.

formation

int

The formation associated with the row.

formation_c35

string

The formation c35 value associated with the row.

member

int

The member associated with the row.

member_c37

string

The member c37 value associated with the row.

complex

int

The complex associated with the row.

complex_c39

string

The complex c39 value associated with the row.

geom_geojson

string

The geometry in GeoJSON format associated with the row.

geom_geotext

string

The geometry in GEOTEXT format associated with the row.

geom_type

string

The type of geometry associated with the row.

geom_centroid

string

The centroid of the geometry associated with the row.

geom_center_x

double

The X-coordinate of the center of the geometry associated with the row.

geom_center_y

double

The Y-coordinate of the center of the geometry associated with the row.

geom

binary

The geometry associated with the row.

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	79574184-557c-46d3-a11b-3e47c6222364
Package id	95889f35-4371-41d4-a328-c10ae0dd0f60
Position	1
Revision id	8d76093c-a7b6-4651-b04f-9441ee4a9a89
State	active
Table	rajapinnat_gtk_kalliopera_wfskompleksi_sviitti_litodeemiset_yksikot__kompleksi_sviitti_litodeemiset_yksikot__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

79574184-557c-46d3-a11b-3e47c6222364

Package id

95889f35-4371-41d4-a328-c10ae0dd0f60

Position

Revision id

8d76093c-a7b6-4651-b04f-9441ee4a9a89

State

active

Table

rajapinnat_gtk_kalliopera_wfskompleksi_sviitti_litodeemiset_yksikot__kompleksi_sviitti_litodeemiset_yksikot__history

Version History of Geologic Units in Finland

Field Descriptions

No sample for this dataset

Additional Information