Geological Survey of Finland - Rock Permits Dataset

The dataset collection contains one or more dataset tables sourced from the website of 'Geological Survey of Finland' in Finland.

Tables

Tektonic Provinces in Finland - 1m ResolutionTSV
This table contains data on the rock provinces from the Geological Survey of Finland (GTK). The data is sourced from the website of the Geological Survey of Finland and originates from Finland (ISO country code: 'FI'). The table provides information on various attributes including the extraction date, row number, province name, shape length, shape area, GIS geometries in GeoJSON and Geotext formats, the type of geometry, centroid coordinates, center x and y coordinates, as well as the original geometry. This data can be used for various data analytics purposes such as analyzing the distribution and characteristics of rock provinces, conducting spatial analysis, calculating the size and shape of provinces, and identifying relationships between provinces based on their attributes.
Version History of Tektonic Provinces of Rock Operations in FinlandTSV
This table stores the version history of the base table 'Kalliopera 1m tektoniset provinssit'. It contains rows with information about the geological provinces in Finland. The data is sourced from 'Geological Survey of Finland' which is the national geological survey organization of Finland. The table tracks changes made to the base table rows over time, indicating when a new version was extracted from the data source. Each row in this table has additional columns '_start_date' and '_end_date' indicating the dates when the row was extracted and when a new version was extracted respectively. The table can be utilized in data analytics to analyze the evolution of geological provinces over time, identify changes in shape length and shape area of provinces, and analyze the distribution of...

Column Descriptions

Tektonic Provinces in Finland - 1m Resolution

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The sequential number of the row in the table.
gml_id	string	A unique identifier for each feature in the table.
objectid	int	The primary key of the table.
province_name	string	The name of the province.
shape_length	int	The length of the shape.
shape_area	int	The area of the shape.
geom_geojson	string	The geometry of the feature in GeoJSON format.
geom_geotext	string	The geometry of the feature in GeoText format.
geom_type	string	The type of the geometry (e.g., polygon, point, line).
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the centroid.
geom_center_y	double	The y-coordinate of the centroid.
geom	binary	The full geometry of the feature.

Version History of Tektonic Provinces of Rock Operations 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 sequence number assigned to each row version.
gml_id	string	The ID of the row version in GML format.
objectid	int	The unique identifier of the row version.
province_name	string	The name of the province associated with the row version.
shape_length	int	The length of the shape geometry of the row version.
shape_area	int	The area of the shape geometry of the row version.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in geotext format.
geom_type	string	The type of geometry (point, line, polygon) of the row version.
geom_centroid	string	The centroid point of the geometry of the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry of the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry of the row version.
geom	binary	The geometry of the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024