Bug #13290
closed
Data from the article of Lachniet misinterpreted
0%
Description
The RATIO that is shown in the paper is not GE/GM.
It has to be removed in the database.
Correspondingly the paper includes data for GM that were not stored in the database.
The values for Q² are the same but for one extra measure in the case of GM (26 measures of GM, 25 measures of a specific ratio)
So 25 observables will be updated from RATIO to MAGNETIC (1), and the corresponding measure will be updated correspondingly (2). An extra observable will be inserted (3).
(1)
update db_observable set obs_type_observable='MAGNETIC' where obs_id in (select m.obs_id from db_article natural join db_mesure m where art_fic_ref like 'Lachniet%' order by obs_id);
(2)
Updated by Lafage Vincent over 8 years ago
(2)
update db_mesure set mes_valeur=1.0073, mes_incertitude_sur_valeur=0.0262 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.1364);
update db_mesure set mes_valeur=1.0319, mes_incertitude_sur_valeur=0.0231 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.2879);
update db_mesure set mes_valeur=1.0228, mes_incertitude_sur_valeur=0.021 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.4394);
update db_mesure set mes_valeur=1.0127, mes_incertitude_sur_valeur=0.020 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.5909);
update db_mesure set mes_valeur=1.0136, mes_incertitude_sur_valeur=0.020 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.7424);
update db_mesure set mes_valeur=1.0167, mes_incertitude_sur_valeur=0.020 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=1.8939);
update db_mesure set mes_valeur=1 , mes_incertitude_sur_valeur=0.022 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.0455);
update db_mesure set mes_valeur=0.9919, mes_incertitude_sur_valeur=0.022 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.197 );
update db_mesure set mes_valeur=1.0016, mes_incertitude_sur_valeur=0.023 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.3485);
update db_mesure set mes_valeur=1.0212, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.5 );
update db_mesure set mes_valeur=1.0344, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.6515);
update db_mesure set mes_valeur=1.0012, mes_incertitude_sur_valeur=0.024 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.803 );
update db_mesure set mes_valeur=0.9954, mes_incertitude_sur_valeur=0.024 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=2.9546);
update db_mesure set mes_valeur=1.0019, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.1061);
update db_mesure set mes_valeur=0.9779, mes_incertitude_sur_valeur=0.025 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.2576);
update db_mesure set mes_valeur=0.9967, mes_incertitude_sur_valeur=0.026 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.4091);
update db_mesure set mes_valeur=0.9918, mes_incertitude_sur_valeur=0.026 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.5606);
update db_mesure set mes_valeur=0.9742, mes_incertitude_sur_valeur=0.027 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.7121);
update db_mesure set mes_valeur=0.9791, mes_incertitude_sur_valeur=0.029 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=3.8636);
update db_mesure set mes_valeur=1.0285, mes_incertitude_sur_valeur=0.031 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.0152);
update db_mesure set mes_valeur=0.9193, mes_incertitude_sur_valeur=0.031 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.1667);
update db_mesure set mes_valeur=0.9079, mes_incertitude_sur_valeur=0.034 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.3182);
update db_mesure set mes_valeur=0.9903, mes_incertitude_sur_valeur=0.042 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.4697);
update db_mesure set mes_valeur=1.1074, mes_incertitude_sur_valeur=0.0998 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.6212);
update db_mesure set mes_valeur=1.0921, mes_incertitude_sur_valeur=0.1309 where obs_id = (select o.obs_id from db_article natural join db_mesure m natural join db_observable o where art_fic_ref like 'Lachniet%' and obs_q_carre=4.7727);
With check
select m.* from db_article natural join db_mesure m where art_fic_ref like 'Lachniet%' order by obs_id;
select o.*, a.art_fic_ref from db_article a natural join db_mesure m natural join db_observable o where m.obs_id between 113 and 138 order by obs_q_carre;
Updated by Lafage Vincent over 8 years ago
(3) last insert
@
insert into db_observable (obs_id, par_id, obs_q_carre, obs_signe_q_carre, obs_type_observable)
values (601, 0, 0.9848, 'SPACE LIKE', 'MAGNETIC');
select obs_id from db_observable where par_id = 0 and obs_q_carre = 0.9848 and obs_signe_q_carre = 'SPACE LIKE' and obs_type_observable = 'MAGNETIC';
select max (mes_id) from db_mesure ;
max
-----
770
insert into db_mesure (mes_id, art_id, fic_id, obs_id, mes_incertitude_sur_q_carre, mes_valeur, mes_incertitude_sur_valeur)
values (771, 49, 7, 601, 0, 0.9953, 0.0239);
@
Updated by Lafage Vincent over 8 years ago
- Status changed from Assigned to Resolved
Corrected values deployed in production version.