Hi, Here are some updates on pending SCWG requests. 1.- Requests #104 & #105 (D. Oppenheimer): ========================================== After feedback from Peggy and Allan, here is the updated list of event types: > ETYPE NAME DESCRIPTION CATEGORY > ===================================================================================== > le local local earthquake earthquake > re regional regional earthquake earthquake > ts teleseism teleseismic earthquake earthquake > se slow slow earthquake earthquake > lp longperiod long period volcanic earthquake earthquake > to tornillo tormillo wavelet earthquake > tr nv-tremor non-volcanic tremor tremor > vt v-tremor volcanic tremor tremor > nt nuke nuclear test explosion > qb quarry quarry blast explosion > ce calibr calibration explosion > ex explosion generic chemical blast explosion > sh shot refraction/reflection survey shot explosion > sn sonic sonic shockwave atmospheric > th thunder thunder atmospheric > ve eruption volcanic eruption earth movement > co m-collapse mine/tunnel collapse earth movement > df debris debris flow/avalanche earth movement > av snow-ice snow/ice avalanche earth movement > ls landslide landslide earth movement > rb rockburst rockburst earth movement > rs rockslide rockslide earth movement > bc bldg building collapse/demolition impact > pc plane plane crash impact > mi meteor meteor/comet impact impact > st trigger subnet trigger unknown > uk unknown unknown type unknown > ot other other miscellaneous unknown - If nobody sees any problem with this list by the end of October, request #104 will be approved and the Event.etype constraint should then be updated in NC and SC. - Ellen sent a proposal on how to implement event categories. This will be discussed during our next conference call. 2.- Request #120 (D. Given): ============================ Nobody seems to have any objections about the new table CubeMessageText (besides its name). > CUBEMESSAGETEXT > Name Null? Type > ----------------------- -------- ---------------- > SRCNET NOT NULL VARCHAR2(2) > TEXTTYPE NOT NULL VARCHAR2(40) > LINENO NOT NULL NUMBER(8) > TEXT NOT NULL VARCHAR2(132) Allan and/or Doug, could you please come up with a more suitable name for this table. If/when everybody agrees with the new name, this request will be approved. Thanks, Stephane -- ------------------------------------------------------------------ Stephane Zuzlewski University of California, Berkeley stephane@seismo.berkeley.edu Berkeley Seismological Laboratory Phone: 510-642-0073 215 McCone Hall # 4760 Fax: 510-643-5811 Berkeley, CA 94720-4760