Delete certain data in winston database

[Ricardo Gabriel SIFON]

Hi Earthworm users!

What is the way to remove a certain number of days of a particular channel from a Winston database?

What I want is that those days can no longer be displayed, in Swarm or through a database query.

Regards,

Ing. Esp. Ricardo G. Sifón

MP 4031

Jefe de Área Comunicaciones y Procesamiento Sísmico

Departamento Laboratorio Sismológico
INPRES
Instituto Nacional de Prevención Sísmica
Roger Balet 47 Norte - CP 5400

San Juan - República Argentina
Tel. +54 (264) 4239010   int. 211

https://www.inpres.gob.ar/

[Stefan Lisowski]

Will the Admin tool in bin do what you want?

/opt/earthworm/winston-1.6.2/bin:$ ./Admin.sh
Winston Admin

A collection of commands for administering a Winston database.
Information about connecting to the Winston database must be present
in Winston.config in the current directory.

Usage:
java gov.usgs.volcanoes.winston.db.Admin [options] command [command
arguments]

Valid options:
--delay seconds the delay between each channel for
commands
for multiple channels

Valid commands:
--list lists all channels
--list times lists all channels with time span
--delete channel delete the specified channel
--deletex SSSS$CCC$NN[$LL] delete the specified channels where:
SSSS is the station,
CCC is the channel which may contain
a wild card (%),
SSSS is the station,
NN is the network,
LL is the optional location which may
contain
a wild card (%)
--span recalculate table spans
--purge channel days purge the specified channel for the
specified number of days
--purgex channel days purge the specified channel for the
specified number of days where the
channel
may contain a wild card (%) anywhere
--repair YYYY_MM_DD [channel] repair all tables on given day
optionally, just repair the specified
channel

If not, you can go into the MySQL database and remove specific days you
want to remove that way. You'll need to remove them from both the full
version of the data and the downsampled version.

Stefan

On 10/13/22 12:10 PM, Ricardo Gabriel SIFON wrote:
> Hi Earthworm users!
>
> What is the way to remove a certain number of days of a particular
> channel from a Winston database?
> What I want is that those days can no longer be displayed, in Swarm or
> through a database query.
>
> Regards,
>
>

> *Ing. Esp. Ricardo G. Sifón*
>
> *MP 4031*

>
> Jefe de Área Comunicaciones y Procesamiento Sísmico
>
> Departamento Laboratorio Sismológico
> INPRES
> Instituto Nacional de Prevención Sísmica
> Roger Balet 47 Norte - CP 5400
>
> San Juan - República Argentina
> Tel. +54 (264) 4239010   int. 211
>

> https://www.inpres.gob.ar/ <http://www.inpres.gov.ar/>
>
>
> --
> --
> You received this message because you are subscribed to the Google
> Groups "Earthworm Community Forum" group.
>
> To post to this group, send an email to earthwo...@googlegroups.com
>
> To unsubscribe from this group, send an email to
> earthworm_for...@googlegroups.com
>
> For more options, visit this group at
> http://groups.google.com/group/earthworm_forum?hl=en
> <http://groups.google.com/group/earthworm_forum?hl=en>
>
> ---
> You received this message because you are subscribed to the Google
> Groups "Earthworm Community Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to earthworm_for...@googlegroups.com
> <mailto:earthworm_for...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/earthworm_forum/SC1PR80MB0158B17265843722651003669F259%40SC1PR80MB0158.lamprd80.prod.outlook.com <https://groups.google.com/d/msgid/earthworm_forum/SC1PR80MB0158B17265843722651003669F259%40SC1PR80MB0158.lamprd80.prod.outlook.com?utm_medium=email&utm_source=footer>.

--








*To follow ISTI news and updates please subscribe to our newsletter
"the isti letter" at  https://www.isti.com/newsletter-sign-up
<https://www.isti.com/newsletter-sign-up>.*

[Ricardo Gabriel SIFON]

Stefan,

Thanks for your reply!

How I can remove specific days from both the full version of the data and the downsampled version of MySQL database?

I removed in winston database the table LPMA$HHN$LS$$2022_06_05 (for LPMA station, date: 2022/06/05) from database W_LPMA$HHN$LS.

I assume there is another part to remove, that you refer to.

Regards,

Ing. Esp. Ricardo G. Sifón

MP 4031

Jefe de Área Comunicaciones y Procesamiento Sísmico

Departamento Laboratorio Sismológico
INPRES
Instituto Nacional de Prevención Sísmica
Roger Balet 47 Norte - CP 5400

San Juan - República Argentina
Tel. +54 (264) 4239010   int. 211

https://www.inpres.gob.ar/

---

De: earthwo...@googlegroups.com <earthwo...@googlegroups.com> en nombre de Stefan Lisowski <stefanl...@isti.com>
Enviado: jueves, 13 de octubre de 2022 23:08
Para: earthwo...@googlegroups.com <earthwo...@googlegroups.com>
Asunto: Re: [Earthworm Forum] Delete certain data in winston database

 

To unsubscribe from this group and stop receiving emails from it, send an email to earthworm_for...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/earthworm_forum/4c33c9c2-5ed7-f136-b62c-12f964448ac8%40isti.com.

[Paul Friberg]

We do not recommend hand editing the mysql database, but using the admin tool that Stefan pointed you at. The command line for the tool should be self-explanatory.

Paul

To view this discussion on the web visit https://groups.google.com/d/msgid/earthworm_forum/SC1PR80MB01587AB4D0D1D83BC84ACD879F249%40SC1PR80MB0158.lamprd80.prod.outlook.com.

--

===================================
Paul Friberg   p.fr...@isti.com
CEO/Seismologist
ISTI==Instrumental Software Technologies, Inc.
Phone +1.518.602.0001  

[Ricardo Gabriel SIFON]

OK Paul,

Thanks! I will use the admin tool that Stefan pointed me at.

Regards,

Ing. Esp. Ricardo G. Sifón

MP 4031

Jefe de Área Comunicaciones y Procesamiento Sísmico

Departamento Laboratorio Sismológico
INPRES
Instituto Nacional de Prevención Sísmica
Roger Balet 47 Norte - CP 5400

San Juan - República Argentina
Tel. +54 (264) 4239010   int. 211

https://www.inpres.gob.ar/

---

De: earthwo...@googlegroups.com <earthwo...@googlegroups.com> en nombre de Paul Friberg <p.fr...@gmail.com>
Enviado: viernes, 14 de octubre de 2022 10:16

To view this discussion on the web visit https://groups.google.com/d/msgid/earthworm_forum/CALsXm6URJwJhv%2Bnfx%2BFXcRdhHD%2BDP4CrmwOy%3DNv7k8YwtzOrow%40mail.gmail.com.