Historical Version History of Coordination-based Sand Table - Geologian tutkimuskeskus (Finland)

This table contains the version history of the base table rows from the 'Geological Survey of Finland' website. It includes the '_start_date' column, which indicates the date when the row was extracted, and the '_end_date' column, which shows the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The table includes various columns such as 'gml_id', 'objectid', 'arkistonumero_arkistotunnus', 'tunnus_tarra', 'originaali_havaintonro_naytenr', 'hietyyppi', 'vuosiluku', 'havaintonumero', 'karttalehti_100k_kkj', 'karttalehti_20k_kkj', 'karttalehti_50k_utm', 'pohjoiskoordinaatti_epsg3067', 'itakoordinaatti_epsg3067', 'pohjoiskoordinaatti_kkj', 'itakoordinaatti_kkj', 'hieen_sailytyspaikka', 'alkuperainen_omistaja', 'kivilaji', 'kivilaji_alkuperainen', 'hiesyvyys_metri', 'paikka', 'kairareikatunnus', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table can be utilized in data analytics to analyze changes in the extracted data over time, assess trends in geological observations, track ownership or location changes, evaluate deep drilling activities, and perform spatial analysis using the available coordinate information. The data source for this table is the website of the Geological Survey of Finland, which originates from Finland (ISO country code: FI).