Version History of Pegmatite LCT Pegmatite Li
Click here for a data sample
This table represents the version history for the base table 'rajapinnat_gtk_kalliopera_wfslct_pegmatiitti_li__lctpegmatiitti_li'. It contains information about various geological parameters related to pegmatite rocks. The data in this table is sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The data originates from Finland (ISO country code: FI). The table includes columns such as '_start_date' and '_end_date', which indicate the extraction dates of each row. Other columns store data related to the geological tract types, tract names, probabilities of deposit occurrence, estimated values, shape area and length, and various geometry attributes. This table allows for keeping track of changes made to the base table and enables further analysis and comparison of different versions of the data. By analyzing this table, data scientists and researchers can gain insights into the temporal evolution of pegmatite rocks, assess changes in deposit probabilities, estimate geological values, and analyze the spatial distribution and attributes of the rocks.
Field Descriptions
| Name |
Data type |
Description |
| _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 row number indicating the position of 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. |
|---|
| tractname | string | The name of the tract. |
|---|
| number_dep_1_percent_prob | int | The number of depositions with 1 percent probability. |
|---|
| number_dep_5_percent_prob | int | The number of depositions with 5 percent probability. |
|---|
| number_dep_10_percent_prob | int | The number of depositions with 10 percent probability. |
|---|
| number_dep_50_percent_prob | int | The number of depositions with 50 percent probability. |
|---|
| number_dep_90_percent_prob | int | The number of depositions with 90 percent probability. |
|---|
| expected_number_of_dep | int | The expected number of depositions. |
|---|
| li_estim_10_percent_prob | int | The estimated land instability with 10 percent probability. |
|---|
| li_estim_50_percent_prob | int | The estimated land instability with 50 percent probability. |
|---|
| li_estim_90_percent_prob | int | The estimated land instability with 90 percent probability. |
|---|
| li_mean_estimate | int | The mean estimate of land instability. |
|---|
| shape_area | int | The area of the row version shape. |
|---|
| shape_len | int | The length of the row version shape. |
|---|
| geom_geojson | string | The row version geometry in GeoJSON format. |
|---|
| geom_geotext | string | The row version geometry in GeoText format. |
|---|
| geom_type | string | The type of the row version geometry. |
|---|
| geom_centroid | string | The centroid of the row version geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the row version geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the row version geometry. |
|---|
| geom | binary | The row version geometry. |
|---|
