Version History of Lidar Data in Finland from the Geological Survey of Finland

This table contains the version history of the base table rows from the 'Geological Survey of Finland - GTK' website. The table 'lidar_history' is an extension of the base table 'lidar' and includes two additional columns '_start_date' and '_end_date'. The '_start_date' column represents the date when 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 value of the '_end_date' column is null, it signifies that the row is the most recent version. The table includes various columns such as 'gml_id', 'objectid', 'lineament_id', 'data_source', 'certainty', 'scale', 'operator', 'date_col', 'remarks', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns provide valuable information for data analytics purposes. For example, data analysts can utilize the 'lineament_id' column to study the lineament characteristics in the lidar data. They can also analyze the 'certainty' column to evaluate the level of certainty associated with the data. The 'scale' column can be helpful in understanding the scale at which the lidar data was collected. The 'operator' column provides insights into the entity responsible for capturing the data. By examining the 'date_col' column, analysts can identify the date on which the data was collected or updated. The 'remarks' column can contain additional notes or descriptions related to the data. The 'shape_len' column provides the length of the geometrical shape, which can be useful in analyzing the spatial characteristics of the data. The 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' columns provide various geospatial attributes and can support spatial analysis tasks. It is worth noting that the 'geom' column contains the actual geometry data. This table originates from Finland (ISO country code: 'fi').