Geological Survey of Finland - Lithological Units - Geological Survey of Finland - Lithological Units History - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Geological Survey of Finland - Lithological Units History

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

This table contains the version history of the rows from the base table 'rajapinnat_gtk_kalliopera_wfslitologiset_yksikot__litologiset_yksikot'. It includes two additional columns compared to the base table: '_start_date' and '_end_date', which represent the extraction dates of the rows from the data source. The data in this table originates from the website of the Geological Survey of Finland (Geologian tutkimuskeskus) and is sourced from the country with the ISO country code 'fi'.

Field Descriptions

Name	Data type	Description
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	An identifier for the row version.
gml_id	string	The GML identifier of the row version.
objectid	int	The identifier of the row version.
eon	int	The eon value of the row version.
eon_c3	string	The eon_c3 value of the row version.
era	int	The era value of the row version.
era_c5	string	The era_c5 value of the row version.
period	int	The period value of the row version.
period_c7	string	The period_c7 value of the row version.
chronostraticraphic_unit	int	The chronostraticraphic unit of the row version.
chronostraticraphic_unit_c9	string	The chronostraticraphic_unit_c9 value of the row version.
epoch	int	The epoch value of the row version.
epoch_c11	string	The epoch_c11 value of the row version.
supersuite	int	The supersuite value of the row version.
supersuite_c13	string	The supersuite_c13 value of the row version.
suite	int	The suite value of the row version.
suite_c15	string	The suite_c15 value of the row version.
lithodeme	int	The lithodeme value of the row version.
lithodeme_c17	string	The lithodeme_c17 value of the row version.
unit_criterion	int	The unit criterion of the row version.
unit_criterion_c19	string	The unit_criterion_c19 value of the row version.
original_name	string	The original name of the row version.
rock_class	int	The rock class of the row version.
rock_class_c22	string	The rock_class_c22 value of the row version.
rock_name	int	The rock name of the row version.
rock_name_c24	string	The rock_name_c24 value of the row version.
shape_area	int	The shape area of the row version.
shape_len	int	The shape length of the row version.
nick_name	string	The nick name of the row version.
phase	int	The phase of the row version.
phase_c29	string	The phase_c29 value of the row version.
supergroup	int	The supergroup of the row version.
supergroup_c31	string	The supergroup_c31 value of the row version.
group_col	int	The group column of the row version.
group_col_c33	string	The group_col_c33 value of the row version.
formation	int	The formation of the row version.
formation_c35	string	The formation_c35 value of the row version.
member	int	The member of the row version.
member_c37	string	The member_c37 value of the row version.
complex	int	The complex of the row version.
complex_c39	string	The complex_c39 value of the row version.
geom_geojson	string	The geometry in GeoJSON format of the row version.
geom_geotext	string	The geometry in Geotext format of the row version.
geom_type	string	The type of the geometry of the row version.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The x-coordinate of the center of the geometry of the row version.
geom_center_y	double	The y-coordinate of the center of the geometry of the row version.
geom	binary	The geometry of the row version.

Name

Data type

Description

_start_date

date

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

_end_date

date

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

_row_number

long

An identifier for the row version.

gml_id

string

The GML identifier of the row version.

objectid

int

The identifier of the row version.

eon

int

The eon value of the row version.

eon_c3

string

The eon_c3 value of the row version.

era

int

The era value of the row version.

era_c5

string

The era_c5 value of the row version.

period

int

The period value of the row version.

period_c7

string

The period_c7 value of the row version.

chronostraticraphic_unit

int

The chronostraticraphic unit of the row version.

chronostraticraphic_unit_c9

string

The chronostraticraphic_unit_c9 value of the row version.

epoch

int

The epoch value of the row version.

epoch_c11

string

The epoch_c11 value of the row version.

supersuite

int

The supersuite value of the row version.

supersuite_c13

string

The supersuite_c13 value of the row version.

suite

int

The suite value of the row version.

suite_c15

string

The suite_c15 value of the row version.

lithodeme

int

The lithodeme value of the row version.

lithodeme_c17

string

The lithodeme_c17 value of the row version.

unit_criterion

int

The unit criterion of the row version.

unit_criterion_c19

string

The unit_criterion_c19 value of the row version.

original_name

string

The original name of the row version.

rock_class

int

The rock class of the row version.

rock_class_c22

string

The rock_class_c22 value of the row version.

rock_name

int

The rock name of the row version.

rock_name_c24

string

The rock_name_c24 value of the row version.

shape_area

int

The shape area of the row version.

shape_len

int

The shape length of the row version.

nick_name

string

The nick name of the row version.

phase

int

The phase of the row version.

phase_c29

string

The phase_c29 value of the row version.

supergroup

int

The supergroup of the row version.

supergroup_c31

string

The supergroup_c31 value of the row version.

group_col

int

The group column of the row version.

group_col_c33

string

The group_col_c33 value of the row version.

formation

int

The formation of the row version.

formation_c35

string

The formation_c35 value of the row version.

member

int

The member of the row version.

member_c37

string

The member_c37 value of the row version.

complex

int

The complex of the row version.

complex_c39

string

The complex_c39 value of the row version.

geom_geojson

string

The geometry in GeoJSON format of the row version.

geom_geotext

string

The geometry in Geotext format of the row version.

geom_type

string

The type of the geometry of the row version.

geom_centroid

string

The centroid of the geometry of the row version.

geom_center_x

double

The x-coordinate of the center of the geometry of the row version.

geom_center_y

double

The y-coordinate of the center of the geometry of the row version.

geom

binary

The geometry of the 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	55d5ff98-f850-4f96-ac7c-75722a0e1d1a
Package id	c49e656e-afe0-4517-a3c5-781e9deae146
Position	1
Revision id	137bb763-8980-4c65-ae9e-08eb8ce9ace0
State	active
Table	rajapinnat_gtk_kalliopera_wfslitologiset_yksikot__litologiset_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

55d5ff98-f850-4f96-ac7c-75722a0e1d1a

Package id

c49e656e-afe0-4517-a3c5-781e9deae146

Position

Revision id

137bb763-8980-4c65-ae9e-08eb8ce9ace0

State

active

Table

rajapinnat_gtk_kalliopera_wfslitologiset_yksikot__litologiset_yksikot__history

Geological Survey of Finland - Lithological Units History

Field Descriptions

No sample for this dataset

Additional Information