The data used by the CC are stored in the table _cryosphericcommission.data2d. A detailed description of the tables can be found here.
The INSERT of the new records into _cryosphericcommission.data2d could be solved by adding trigger functions to the tables _length_change.length_changedata and _mass_balance.massbalance.
Establishing of an INSERT-Trigger on table length_change.length_change_data.
The trigger will check and insert new length-change data into the table cryospheric_commission.data2d.
Requirements:
Check if data already in table data2d. INSERT if not existing, UPDATE if existing but different, nothing if identical.
Perhaps additional table to store the required glaciers.
The length-change and mass-balance data of the 7 representative glaciers shown on the website of the Cryospheric Commission (CC) (e.g. https://naturwissenschaften.ch/topics/snow-glaciers-permafrost/glaciers/length_variation ) have to be updated automatically during inserting new data into the GLAMOS main tables.
The data used by the CC are stored in the table _cryosphericcommission.data2d. A detailed description of the tables can be found here.
The INSERT of the new records into _cryosphericcommission.data2d could be solved by adding trigger functions to the tables _length_change.length_changedata and _mass_balance.massbalance.