Geological Survey of Finland (GTK) - Rock Outcrops with Reef Types in Finland
Tables
-
Reef Type and Crustal Structure for Geological Survey of Finland in FinlandTSV
This table contains data from the 'Geological Survey of Finland' website. It provides information about various types of rock formations. The table consists of multiple columns such as '_extract_date', '_row_number', 'gml_id', 'objectid', 'tracttype', 'tractname', 'number_dep_10_percent_prob', 'number_dep_50_percent_prob', 'number_dep_90_percent_prob', 'expected_number_of_dep', 'cr_estim_10_percent_prob', 'cr_estim_50_percent_prob', 'cr_estim_90_percent_prob', 'cr_mean_estimate', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns provide various details about the rock formations, such as their names, geographic information, estimated probabilities, and shape attributes. This table can be...
-
Version History of Reef Type Data from Geological Survey of Finland in FinlandTSV
This table contains the version history of the rows extracted from the 'Geological Survey of Finland' website. The data represents information about different types of rock formations and their characteristics. The table includes various columns such as '_start_date', '_end_date', 'gml_id', 'objectid', 'tracttype', 'tractname', and several columns related to depth, estimated probabilities, mean estimates, shape area, shape length, and geometry. The '_start_date' column indicates the date when each row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version available. The table can be used for data analytics purposes, such as...
Column Descriptions
Reef Type and Crustal Structure for Geological Survey of Finland in Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | Date when the data row was extracted. |
| _row_number | long | Sequential number assigned to each row in the table. |
| gml_id | string | Unique identifier of the geometry in GML format. |
| objectid | int | Unique identifier of the object. |
| tracttype | string | Type of tract. |
| tractname | string | Name of the tract. |
| number_dep_10_percent_prob | int | Number of dependents with 10 percent probability. |
| number_dep_50_percent_prob | int | Number of dependents with 50 percent probability. |
| number_dep_90_percent_prob | int | Number of dependents with 90 percent probability. |
| expected_number_of_dep | int | Expected number of dependents. |
| cr_estim_10_percent_prob | int | Crime estimation with 10 percent probability. |
| cr_estim_50_percent_prob | int | Crime estimation with 50 percent probability. |
| cr_estim_90_percent_prob | int | Crime estimation with 90 percent probability. |
| cr_mean_estimate | int | Mean crime estimation. |
| shape_area | int | Area of the shape in square units. |
| shape_len | int | Length of the shape. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry in Geotext format. |
| geom_type | string | Type of geometry. |
| geom_centroid | string | Centroid point of the geometry. |
| geom_center_x | double | X-coordinate of the centroid. |
| geom_center_y | double | Y-coordinate of the centroid. |
| geom | binary | Geometry in serialized form. |
Version History of Reef Type Data from Geological Survey of Finland in Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date indicating the validity period of the row version. |
| _end_date | date | The end date indicating the validity period of the row version. |
| _row_number | long | The 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. |
| tracttype | string | The type of tract. |
| tractname | string | The name of the tract. |
| number_dep_10_percent_prob | int | The number of dependencies with 10 percent probability. |
| number_dep_50_percent_prob | int | The number of dependencies with 50 percent probability. |
| number_dep_90_percent_prob | int | The number of dependencies with 90 percent probability. |
| expected_number_of_dep | int | The expected number of dependencies. |
| cr_estim_10_percent_prob | int | The estimated count rate with 10 percent probability. |
| cr_estim_50_percent_prob | int | The estimated count rate with 50 percent probability. |
| cr_estim_90_percent_prob | int | The estimated count rate with 90 percent probability. |
| cr_mean_estimate | int | The mean estimate of the count rate. |
| shape_area | int | The area of the shape. |
| shape_len | int | The length of the shape. |
| 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. |
| 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 row version. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |