Integrated Rock Surface Data from Geological Survey of Finland (Geologian tutkimuskeskus)

This dataset collection consists of one or more dataset tables sourced from the website of Geologian tutkimuskeskus, which is the Geological Survey of Finland. The dataset collection is named 'rajapinnat_gtk_kalliopera_wfsintegroidut' and is available from the country Finland.

Tables

Geological Survey of Finland - Rock Data (Integrated) - Version HistoryTSV
This table is a version history of the base table 'rajapinnat_gtk_kalliopera_wfsintegroidut__integroidut'. It contains historical versions of the rows extracted from the data source. Each row in this table has additional columns '_start_date' and '_end_date', representing the extraction dates of the versions. The data in this table provides valuable information for data analytics and insights. By analyzing the changes in the rows over time, trends, patterns, and historical data can be identified. This can be especially useful for understanding the evolution of lineament features and their characteristics. The table includes various columns such as 'gml_id', 'objectid', 'lineament_id', 'data_source', 'certainty', 'scale', 'operator', 'date_col', 'remarks', 'shape_len', 'geom_geojson',...
Integrated Rock Shaft Features from Geologian tutkimuskeskus Database - FinlandTSV
This table contains integrated lineament data related to rock operations. The data in this table includes information such as the extraction date, row number, GML ID, object ID, lineament ID, data source, certainty, scale, operator, date, remarks, shape length, the geometry in GeoJSON and GeoText format, the type of geometry, centroid coordinates, center X and Y coordinates, and the full geometry of the lineament. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution and characteristics of lineaments, studying their relationship with rock operations, identifying patterns and trends in lineament data, and conducting spatial analysis on the lineament geometry. This data is sourced from the website of the Geological Survey of Finland...

Column Descriptions

Integrated Rock Shaft Features from Geologian tutkimuskeskus Database - Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The row number of the data
gml_id	string	The GML ID of the object
objectid	int	The ID of the object
lineament_id	string	The ID of the lineament
data_source	string	The source of the data
certainty	string	The certainty level of the data
scale	string	The scale of the data
operator	string	The operator of the data
date_col	timestamp	The date of the data
remarks	string	Additional remarks on the data
shape_len	int	The length of the shape
geom_geojson	string	The geometry in GeoJSON format
geom_geotext	string	The geometry in Geotext format
geom_type	string	The type of geometry
geom_centroid	string	The centroid of the geometry
geom_center_x	double	The X coordinate of the geometry center
geom_center_y	double	The Y coordinate of the geometry center
geom	binary	The geometry in a specific format

Geological Survey of Finland - Rock Data (Integrated) - Version History

Column	Type	Comment
_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.
gml_id	string	The Global Markup Language (GML) identifier of the row.
objectid	int	The identifier of the row in the base table.
lineament_id	string	The identifier of the lineament.
data_source	string	The source of the data for the row.
certainty	string	The certainty level associated with the data.
scale	string	The scale of the data.
operator	string	The operator responsible for the row's creation.
date_col	timestamp	The date associated with the row.
remarks	string	Additional remarks or comments about the row.
shape_len	int	The length of the shape representation of the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in GeoText format.
geom_type	string	The type of geometry of the row.
geom_centroid	string	The centroid of the row's geometry.
geom_center_x	double	The x-coordinate of the center of the row's geometry.
geom_center_y	double	The y-coordinate of the center of the row's geometry.
geom	binary	The geometry of the row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024