Version History - Lithological Features - Geology Survey of Finland - Finland

This table contains the version history of the rows extracted from the data source 'Geological Survey of Finland (GTK)' located in the country 'Finland'. It provides a historical record of the 'lithological_form' data from the base table 'litologiset_muotoviivat'. Each row in this table represents a specific version of the lithological form, identified by the 'gml_id' and 'objectid' columns. The '_start_date' column indicates the date when the version was extracted, while the '_end_date' column signifies the date when a new version was obtained. If the '_end_date' value is null, it indicates that the row represents the most recent version. The other columns in this table, such as 'basis', 'basis_c5', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', store additional information related to the lithological form and its geometry. This table can be utilized in various data analytics scenarios, such as tracking changes in lithological forms over time, analyzing patterns in geological formations, and conducting spatial analysis on the retrieved geometries.