Geological Survey of Finland - Tectonic Provinces Dataset Collection

The dataset collection contains one or more dataset tables sourced from the web site of Geologian tutkimuskeskus in Finland.

Tables

Tectonic Province History from 'Geological Survey of Finland' in FinlandTSV
This table contains the version history of the rows extracted from the 'Geological Survey of Finland - Tectonic Provinces' dataset. The table provides information about the tectonic provinces and subprovinces within Finland. It includes the start and end dates, row numbers, unique identifiers, tectonic province names, tectonic province codes, area and length measurements, tectonic subprovince names, tectonic subprovince codes, geographic information in GeoJSON and geotext formats, geometric type, centroid coordinates, and the geometric representation. The data in this table can be utilized in various data analytics scenarios, such as analyzing the changes in tectonic province boundaries over time, identifying the most recent versions of the provinces, calculating the area and length of...
Tectonic Provinces in FinlandTSV
This table contains data on tectonic provinces and subprovinces sourced from the Geological Survey of Finland. It includes information such as the extraction date, row number, GML ID, object ID, tectonic province and subprovince, shape area, shape length, geometries, and centroid coordinates. The data can be utilized in various data analytics tasks, such as analyzing the distribution and characteristics of tectonic provinces and subprovinces in Finland. It can be used to study geological patterns, identify trends, and make spatial analyses related to tectonic activities. This dataset provides valuable information for geological research and understanding the geology of the country.

Column Descriptions

Tectonic Provinces in Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source system.
_row_number	long	The row number of the record.
gml_id	string	The GML ID of the record.
objectid	int	The unique identifier of the record.
tectonic_province	int	The tectonic province of the record.
tectonic_province_c3	string	The C3 tectonic province of the record.
shape_area	int	The area of the shape.
shape_len	int	The length of the shape.
tectonic_subprovince	int	The tectonic subprovince of the record.
tectonic_subprovince_c7	string	The C7 tectonic subprovince of the record.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry 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 record.

Tectonic Province History from 'Geological Survey of Finland' in Finland

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	The internal row number of the versioned row.
gml_id	string	The unique identifier of the row version in GML format.
objectid	int	The unique identifier of the row version.
tectonic_province	int	The tectonic province associated with the row.
tectonic_province_c3	string	The code representing the tectonic province associated with the row.
shape_area	int	The area of the row geometry shape.
shape_len	int	The length of the row geometry shape.
tectonic_subprovince	int	The tectonic subprovince associated with the row.
tectonic_subprovince_c7	string	The code representing the tectonic subprovince associated with the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The text representation of the geometry of the row.
geom_type	string	The type of the row geometry.
geom_centroid	string	The centroid of the row geometry.
geom_center_x	double	The x-coordinate of the center point of the row geometry.
geom_center_y	double	The y-coordinate of the center point of the row geometry.
geom	binary	The full geometry representation of the row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024