Geological Survey of Finland Rock Structure WFS - Point Structures (Version History)

This table contains the version history of the rows from the 'Geological Survey of Finland' (Geologian tutkimuskeskus) pertaining to the 'Fold Structure Points' (Finstructure Poimurakenteet). It is a historical record of changes made to the base table 'Fold Structure Points'. The table maintains the previous versions of each row along with the start and end dates. The '_start_date' column represents the date when a particular version of 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' value is null, it indicates that the row is the most recent version.

This table can be useful for data analytics purposes. For example, it can help in analyzing the historical changes and evolution of fold types, fold systems, basis, shape lengths, and geometry associated with the fold structures in Finland. By comparing different versions of the rows, trends, patterns, and changes over time in various attributes of fold structures can be observed and studied. Additionally, it can assist in understanding the spatial distribution and characteristics of fold structures by analyzing the geometry and centroid of each version of the rows. The 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_center_x', 'geom_center_y', and 'geom' columns in particular provide valuable location and geometry information that can be utilized in spatial analysis and visualization. Furthermore, the '_row_number' column can be used for tracking the order and sequence of the historical versions of the rows.

Please note that this table is sourced from the website of the Geological Survey of Finland, which is the national geological survey organization of Finland (ISO country code 'fi').