Historical Version of 'Karbonatiittinen REE Päätietotori - Karbonatiittinen REE Päätietotori' Table from the Geological Survey of Finland (GTK) in Finland
Click here for a data sample
This table contains the version history of the 'rajapinnat_gtk_kalliopera_wfskarbonatiittinen_ree_p__karbonatiittinen_reep' table sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). It contains information about karbonatiittinen ree p- and ree p+ locations. Each row in the table corresponds to a specific version of a karbonatiittinen ree p- and ree p+ location and includes the start date, end date, row number, GML ID, Object ID, tract type, tract name, number of deposits with 1% probability, number of deposits with 5% probability, number of deposits with 10% probability, number of deposits with 50% probability, number of deposits with 90% probability, expected number of deposits, estimated probability of deposits (10% probability), estimated probability of deposits (50% probability), estimated probability of deposits (90% probability), mean estimate of probability, estimated rare earth element (REE) value (10% probability), estimated REE value (50% probability), estimated REE value (90% probability), mean estimate of REE value, shape area, shape length, geographic JSON representation of the geometry, geotext representation of the geometry, geometry type, centroid of the geometry, center x-coordinate of the geometry centroid, center y-coordinate of the geometry centroid, and the geometry itself. The '_start_date' column represents the date when the 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' column is null, it indicates that the row is the most recent version. The data in this table can be utilized in various data analytics tasks, including analyzing the distribution of karbonatiittinen ree p- and ree p+ locations, estimating the probability of deposits at different thresholds, calculating mean estimates of probability and rare earth element values, and studying the shape and spatial characteristics of the geological features through geometric analysis.
Field Descriptions
| Name |
Data type |
Description |
| _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 | The sequential number assigned to the row version. |
|---|
| gml_id | string | The GML identifier of the row version. |
|---|
| objectid | int | The identifier of the row version. |
|---|
| tracttype | string | The type of tract for the row version. |
|---|
| tractname | string | The name of the tract for the row version. |
|---|
| number_dep_1_percent_prob | int | The number of depositions with 1 percent probability for the row version. |
|---|
| number_dep_5_percent_prob | int | The number of depositions with 5 percent probability for the row version. |
|---|
| number_dep_10_percent_prob | int | The number of depositions with 10 percent probability for the row version. |
|---|
| number_dep_50_percent_prob | int | The number of depositions with 50 percent probability for the row version. |
|---|
| number_dep_90_percent_prob | int | The number of depositions with 90 percent probability for the row version. |
|---|
| expected_number_of_dep | int | The expected number of depositions for the row version. |
|---|
| p_estim_10_percent_prob | int | The estimated probability of depositions with 10 percent probability for the row version. |
|---|
| p_estim_50_percent_prob | int | The estimated probability of depositions with 50 percent probability for the row version. |
|---|
| p_estim_90_percent_prob | int | The estimated probability of depositions with 90 percent probability for the row version. |
|---|
| p_mean_estimate | int | The mean estimated probability for the row version. |
|---|
| ree_estim_10_percent_prob | int | The estimated probability of reef erosion with 10 percent probability for the row version. |
|---|
| ree_estim_50_percent_prob | int | The estimated probability of reef erosion with 50 percent probability for the row version. |
|---|
| ree_estim_90_percent_prob | int | The estimated probability of reef erosion with 90 percent probability for the row version. |
|---|
| ree_mean_estimate | int | The mean estimated probability of reef erosion for the row version. |
|---|
| shape_area | int | The area of the shape for the row version. |
|---|
| shape_len | int | The length of the shape for 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 for the row version. |
|---|
| geom_centroid | string | The centroid of the geometry for the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry for the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry for the row version. |
|---|
| geom | binary | The geometry for the row version. |
|---|
