History of Geologic Survey Rock Types in Kuusamo, Finland
Click here for a data sample
This table contains the version history of the rows extracted from the dataset sourced from the website of the 'Geological Survey of Finland', originating from the country with the ISO country code 'FI'. The table '_rajapinnat_gtk_kalliopera_wfskuusamo_tyypin_co_aukuusamotyypin_coauhistory' is derived from the base table '_rajapinnat_gtk_kalliopera_wfskuusamo_tyypin_co_au__kuusamotyypin_coau', and it includes additional columns '_start_date' and '_end_date'. The '_start_date' column contains the date when the row was extracted, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' column has a null value, it indicates that the row is the most recent version. The table contains various columns such as 'gml_id', 'objectid', 'tracttype', 'tractname', 'number_dep_10_percent_prob', 'number_dep_50_percent_prob', 'number_dep_90_percent_prob', 'expected_number_of_dep', 'au_estim_10_percent_prob', 'au_estim_50_percent_prob', 'au_estim_90_percent_prob', 'au_mean_estimate', 'co_estim_10_percent_prob', 'co_estim_50_percent_prob', 'co_estim_90_percent_prob', 'co_mean_estimate', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns include various data related to geology and surveys, such as the probability and estimated number of deposits, mean estimates, shape area and length, as well as various geometrical data. The historical data in this table can be utilized in data analytics to analyze changes over time, track trends, perform geospatial analysis, and gain insights into geological observations and patterns.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date indicating the beginning of the validity period of the row version. |
_end_date | date | The end date indicating the end of the validity period of the row version. |
_row_number | long | The number assigned to each row in the table. |
gml_id | string | The GML ID of the row. |
objectid | int | The ID of the object in the table. |
tracttype | string | The type of tract. |
tractname | string | The name of the tract. |
number_dep_10_percent_prob | int | The number of dependencies with a 10 percent probability. |
number_dep_50_percent_prob | int | The number of dependencies with a 50 percent probability. |
number_dep_90_percent_prob | int | The number of dependencies with a 90 percent probability. |
expected_number_of_dep | int | The expected number of dependencies. |
au_estim_10_percent_prob | int | The estimated area unit with a 10 percent probability. |
au_estim_50_percent_prob | int | The estimated area unit with a 50 percent probability. |
au_estim_90_percent_prob | int | The estimated area unit with a 90 percent probability. |
au_mean_estimate | int | The mean estimate of the area unit. |
co_estim_10_percent_prob | int | The estimated count with a 10 percent probability. |
co_estim_50_percent_prob | int | The estimated count with a 50 percent probability. |
co_estim_90_percent_prob | int | The estimated count with a 90 percent probability. |
co_mean_estimate | int | The mean estimate of the count. |
shape_area | int | The area of the shape. |
shape_len | int | The length of the shape. |
geom_geojson | string | The geometry of the row in GeoJSON format. |
geom_geotext | string | The geometry of the row 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. |