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

Geological Survey of Finland - Rock Outcrops in Provincial Areas

The dataset collection consists of one or more dataset tables sourced from the web site of 'Geological Survey of Finland' in Finland.

Tables

  • Rock Provinces in FinlandTSV

    This table contains data from the 'Geological Survey of Finland' website. It represents the geological provinces and subprovinces within the country with the ISO country code 'fi'. The data includes information such as the extraction date, row number, GML ID, Object ID, structural province, structural province code, structural subprovince, structural subprovince code, shape area, shape length, geoJSON format of the geometry, geotext format of the geometry, geometry type, centroid of the geometry, center x-coordinate of the centroid, center y-coordinate of the centroid, and the raw geometry data. The table provides valuable information for data analytics and can be utilized for various purposes, such as: 1. Analyzing the distribution of structural provinces and subprovinces across the...

  • Version History of Structural Provinces in Geological Survey of Finland - Rakenneprovinssit HistoryTSV

    This table contains the version history of the 'Geological Survey of Finland Rock Engineering Web Feature Service Construction Provinces' table. It provides a historical record of the various versions of the rows in the base table. The table includes additional columns '_start_date' and '_end_date' which indicate the extraction date of each row version from the data source. The rows in this version history table are associated with their corresponding base table rows through a common 'gml_id'. The table also includes other columns that store information such as the row number, object ID, structural province, structural province code level 3, structural subprovince, structural subprovince code level 5, shape area, shape length, GeoJSON geometry, Geotext geometry, geometry type, centroid...

Column Descriptions

Rock Provinces in Finland

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique row number of each record.
gml_id string The GML identifier of the geographic feature.
objectid int The unique identifier of the object.
structural_province int The province where the structure is located.
structural_province_c3 string The custom code for the province.
structural_subprovince int The subprovince where the structure is located.
structural_subprovince_c5 string The custom code for the subprovince.
shape_area int The area of the shape in square units.
shape_len int The length of the shape.
geom_geojson string The geometric representation of the shape in GeoJSON format.
geom_geotext string The geometric representation of the shape in well-known text format.
geom_type string The type of the geometric feature.
geom_centroid string The centroid coordinates of the shape.
geom_center_x double The X-coordinate of the center of the shape.
geom_center_y double The Y-coordinate of the center of the shape.
geom binary The geometric representation of the shape.

Version History of Structural Provinces in Geological Survey of Finland - Rakenneprovinssit History

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 A unique identifier for each row version.
gml_id string An identifier used for GML (Geography Markup Language) representation of the row.
objectid int A unique identifier for the row.
structural_province int The province of the structure.
structural_province_c3 string The C3 code for the province of the structure.
structural_subprovince int The subprovince of the structure.
structural_subprovince_c5 string The C5 code for the subprovince of the structure.
shape_area int The area of the shape represented by the row.
shape_len int The length of the shape represented by the row.
geom_geojson string The geometric representation of the row in GeoJSON format.
geom_geotext string The geometric representation of the row in Geotext format.
geom_type string The type of the geometric shape.
geom_centroid string The centroid of the geometric shape.
geom_center_x double The x-coordinate of the center point of the geometric shape.
geom_center_y double The y-coordinate of the center point of the geometric shape.
geom binary The complete geometric representation of the row.

Additional Info

Last Updated April 22, 2024
Created April 22, 2024