Geological Survey of Finland - Rock Outcrops in Provincial Areas
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 |