quince-science / QuinCe

QuinCe is an online tool for processing and quality control of data from scientific instruments, with a primary focus on oceanic data.
https://quince.science
GNU General Public License v3.0
7 stars 8 forks source link

Separate measurement_values into data_reduction records in database #2767

Open squaregoldfish opened 1 year ago

squaregoldfish commented 1 year ago

With the new PERIODIC measurement mode for the SensorValuesList, it is theoretically possible that an Instrument has two different variables for the same Measurement (i.e. at the same time) that would use values from the same SensorType but at different temporal resolution. One example could be that one Variable is measured periodically and another continuously. So the periodic variable will need to average groups of values while the continuous one would use the instantaneous measurements.

At the moment the first Variable found in the DataReductionJob determines how the values for a given SensorType are extract for that measurement, whereas in reality the different setups should be recorded in the data_reduction records.

This in turn will drive a discussion of what exactly a Measurement represents, both in the database and in the code.