Historical Versioning of Alkaline Rock Deposits in Finland
Click here for a data sample
This table contains the version history of the 'Geologian tutkimuskeskus' data related to 'rajapinnat_gtk_kalliopera_wfsperalkalinen_ree_p__peralkalinen_reep'. It stores the historical data extracted from the source website for data analytics purposes. Each row in the table represents a specific version of the data, identified by its start and end dates. The '_start_date' column indicates when the data version was extracted, while the '_end_date' column represents the date when a new version of the data was extracted. If the '_end_date' value is null, it means that the row represents the most recent version of the data. Along with the versioning columns, the table includes various attributes such as 'gml_id', 'objectid', 'tracttype', 'tractname', 'number_dep_1_percent_prob', 'number_dep_5_percent_prob', 'number_dep_10_percent_prob', 'number_dep_50_percent_prob', 'number_dep_90_percent_prob', 'expected_number_of_dep', 'p_estim_10_percent_prob', 'p_estim_50_percent_prob', 'p_estim_90_percent_prob', 'p_mean_estimate', 'ree_estim_10_percent_prob', 'ree_estim_50_percent_prob', 'ree_estim_90_percent_prob', 'ree_mean_estimate', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table can be utilized in data analytics to track changes and trends in the geological data, perform historical analysis, and compare different versions of the data over time. The source of this table is the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The data originates from Finland (ISO country code: 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _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 row number of the version. |
|---|
| gml_id | string | The GML identifier. |
|---|
| objectid | int | The identifier of the object. |
|---|
| tracttype | string | The type of the tract. |
|---|
| tractname | string | The name of the tract. |
|---|
| number_dep_1_percent_prob | int | The number of dependencies with 1 percent probability. |
|---|
| number_dep_5_percent_prob | int | The number of dependencies with 5 percent probability. |
|---|
| 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. |
|---|
| p_estim_10_percent_prob | int | The estimated probability with 10 percent probability. |
|---|
| p_estim_50_percent_prob | int | The estimated probability with 50 percent probability. |
|---|
| p_estim_90_percent_prob | int | The estimated probability with 90 percent probability. |
|---|
| p_mean_estimate | int | The mean estimate of the probability. |
|---|
| ree_estim_10_percent_prob | int | The estimated number of reentries with 10 percent probability. |
|---|
| ree_estim_50_percent_prob | int | The estimated number of reentries with 50 percent probability. |
|---|
| ree_estim_90_percent_prob | int | The estimated number of reentries with 90 percent probability. |
|---|
| ree_mean_estimate | int | The mean estimate of the reentry number. |
|---|
| shape_area | int | The area of the shape. |
|---|
| shape_len | int | The length of the shape. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext format. |
|---|
| geom_type | string | The type of the 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 object. |
|---|
