[MSNoise] Running MWCS and DTT only on a single station pair

[Thomas Lecocq]

Dear Alec & Michelle

Please also note that the msnoise command allows to pass those SQL 
commands using

msnoise db execute "sql command here, without double quotes;"

and it should work smooth

Thomas

Le 20/11/2021 à 20:57, Michelle Lee a écrit :
> Thanks Alec!
>
> I'll give that a try!
>
> Best Wishes,
> Michelle Lee
> ----------------------------------------------------------------------------
> Ph.D. Candidate
> Columbia University: Lamont-Doherty Earth Observatory
> Department of Earth and Environmental Science
> Marine Geology and Geophysics
> c: (206)397-2488
> alt. email:mkl2158 at columbia.edu
>
>
> On Sat, Nov 20, 2021 at 8:11 AM Alec Yates<alec_yates at hotmail.co.uk>  wrote:
>
>> Hi Michelle,
>>
>> Unless there is another way I'm unaware of, I usually edit the flags in
>> the 'jobs' sql table.
>>
>> For example, if I only wanted one pair to be processed for MWCS and DTT
>> step i can use the sql commands:
>>
>> UPDATE jobs SET flag='T' WHERE jobtype='MWCS' AND
>> pair='NZ.STAT.00:NZ.STAT.00';
>> UPDATE jobs SET flag='T' WHERE jobtype='DTT' AND
>> pair='NZ.STAT.00:NZ.STAT.00';
>>
>> where 'T' indicates 'ToDo'. Note that prior to running for the first time,
>> all pairs will have flag='T', in which case you have to first set the flag
>> to 'D' (Done) for all pairs and then run the above commands so that only
>> the pair of interest will have flag='T' i.e.
>>
>> UPDATE jobs SET flag='D' WHERE jobtype='MWCS';
>> UPDATE jobs SET flag='D' WHERE jobtype='DTT';
>>
>> Then running compute_mwcs and compute_dtt should just process the single
>> station pair (i.e. the only ones with flag='T').
>>
>> Hope that helps.
>>
>> Cheers,
>> Alec
>>
>> PhD Student
>> ISTerre, France
>> alexander.yates at univ-smb.fr
>>
>> ________________________________
>> From:msnoise-bounces at mailman-as.oma.be  <msnoise-bounces at mailman-as.oma.be>
>> on behalf of Michelle Lee<mlee at ldeo.columbia.edu>
>> Sent: Saturday, 20 November 2021 4:04 AM
>> To: Python Package for Monitoring Seismic Velocity Changes using Ambient
>> Seismic Noise<msnoise at mailman-as.oma.be>
>> Subject: [MSNoise] Running MWCS and DTT only on a single station pair
>>
>> Hello,
>>
>> Hope everyone is doing well. I was wondering if there is any way to only
>> run a compute_mwcs and compute_dtt on just a single station pair. I tried
>> putting the station from "use" to "unuse" in the admin interface but that
>> didn't work. Thanks in advance.
>>
>> Best Wishes,
>> Michelle Lee
>>
>> ----------------------------------------------------------------------------
>> Ph.D. Candidate
>> Columbia University: Lamont-Doherty Earth Observatory
>> Department of Earth and Environmental Science
>> Marine Geology and Geophysics
>> c: (206)397-2488
>> alt. email:mkl2158 at columbia.edu
>> _______________________________________________
>> MSNoise mailing list
>> MSNoise at mailman-as.oma.be
>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>> _______________________________________________
>> MSNoise mailing list
>> MSNoise at mailman-as.oma.be
>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>
> _______________________________________________
> MSNoise mailing list
> MSNoise at mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise