humlab-sead / sead_change_control

Sane SEAD change control using Sqitch.
1 stars 0 forks source link

Check handling of MS and MS550 datasets etc for filters #265

Open visead opened 4 years ago

visead commented 4 years ago

Phil is unsure how pre treatment etc is handled and how data should be selected for range (histogram) filters for geochemical analysis methods

Loer0022 commented 4 years ago

In regard to MS and MS550 the separation between pre-treatment and heated samples can be obtained via tbl_analysis_entity_prep_methods. If added as an extra step to our current materialized views we can separate the measurements into two distinct columns (MS & MS550) that can be filtered.

Currently this step is not applied, resulting in each sample containing two sets of measurements both labled as MS which is a bit confusing.

image of export

roger-mahler commented 3 months ago

This is probably a data issue. Transfering to SEAD Change Control.

MattiasSealander commented 2 months ago

This seems to already be handled in SEAD interface by @johanvonboer as spreadsheet separates burned and unburned measurements.