Geological Survey of Finland Rock data from web service for 200k data

The rajapinnat_gtk_kalliopera_wfsjuoniparvet_200k dataset collection consists of one or more dataset tables sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus) in Finland.

Tables

Geological Surveys - Rock Formations Database (200k) in FinlandTSV
This table contains geological data sourced from the website of Geologian tutkimuskeskus, which is a research center for geology in Finland (ISO country code: 'fi'). The table stores information about different rock formations, their names, classifications, ages, and other relevant attributes. The data can be utilized for various data analytics purposes such as analyzing the distribution of rock types, studying geological periods, identifying lithodemes, assessing dyke widths, and conducting spatial analysis using the provided geometries. The table also includes additional metadata fields like extraction date, row number, and unique identifiers for each record. The 'geom' column contains geometry information in GeoJSON format, which can be used for performing spatial operations and...
Version History of Geologic Features in 'Geological Survey of Finland' Database for 'Rock Layers 200k' (200k Scale) in FinlandTSV
This table represents the version history of the 'Geological Survey of Finland' dataset named 'Geological map 1:200 000 - Line features'. It contains the historical information about the base table rows of the dataset. The table includes columns such as '_start_date' and '_end_date' that represent the extraction dates of each row. The 'rajapinnat_gtk_kalliopera_wfsjuoniparvet_200kjuoniparvet_200khistory' table originates from 'Geological Survey of Finland' website which is based in Finland (ISO country code: 'fi'). The data in this table can be used for various data analytics purposes. For example, it can be utilized to analyze changes over time in the geological features presented in the dataset. By examining the historical versions of the rows, researchers can investigate the...

Column Descriptions

Geological Surveys - Rock Formations Database (200k) in Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
gml_id	string	The GML ID of the object.
objectid	int	The unique identifier of the object.
eon	int	The eon to which the data belongs.
eon_c3	string	The C3 category of eon.
era	int	The era to which the data belongs.
era_c5	string	The C5 category of era.
period	int	The period to which the data belongs.
period_c7	string	The C7 category of period.
supersuite	int	The supersuite to which the data belongs.
supersuite_c9	string	The C9 category of supersuite.
suite	int	The suite to which the data belongs.
suite_c11	string	The C11 category of suite.
lithodeme	int	The lithodeme to which the data belongs.
lithodeme_c13	string	The C13 category of lithodeme.
original_rock_name	string	The original name of the rock.
rock_class	int	The class of the rock.
rock_class_c16	string	The C16 category of rock class.
rock_name	int	The name of the rock.
rock_name_c18	string	The C18 category of rock name.
basis	int	The basis of the data.
basis_c20	string	The C20 category of basis.
dyke_width	int	The width of the dyke.
dyke_width_c22	string	The C22 category of dyke width.
shape_len	int	The length of the shape.
age	string	The age of the data.
remarks	string	Any remarks or comments.
geom_geojson	string	The geometric representation of the data in GeoJSON format.
geom_geotext	string	The geometric representation of the data in Geotext format.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid of the 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 data.

Version History of Geologic Features in 'Geological Survey of Finland' Database for 'Rock Layers 200k' (200k Scale) in Finland

Column	Type	Comment
_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 identifier for the row version.
objectid	int	The identifier of the row version.
eon	int	The eon data.
eon_c3	string	The eon data (alternative column).
era	int	The era data.
era_c5	string	The era data (alternative column).
period	int	The period data.
period_c7	string	The period data (alternative column).
supersuite	int	The supersuite data.
supersuite_c9	string	The supersuite data (alternative column).
suite	int	The suite data.
suite_c11	string	The suite data (alternative column).
lithodeme	int	The lithodeme data.
lithodeme_c13	string	The lithodeme data (alternative column).
original_rock_name	string	The original rock name.
rock_class	int	The rock class.
rock_class_c16	string	The rock class (alternative column).
rock_name	int	The rock name.
rock_name_c18	string	The rock name (alternative column).
basis	int	The basis data.
basis_c20	string	The basis data (alternative column).
dyke_width	int	The width of the dyke.
dyke_width_c22	string	The width of the dyke (alternative column).
shape_len	int	The length of the shape.
age	string	The age data.
remarks	string	Remarks about the data.
geom_geojson	string	The geometry data in GEOJSON format.
geom_geotext	string	The geometry data in GEOTEXT format.
geom_type	string	The type of the geometry data.
geom_centroid	string	The centroid of the geometry data.
geom_center_x	double	The x-coordinate of the center of the geometry data.
geom_center_y	double	The y-coordinate of the center of the geometry data.
geom	binary	The geometry data.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024